[Emerald Digest]

emerald-digest-request@iea-software.com
Fri, 21 Aug 1998 00:00:04 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale E. Reed Jr.: "Re: Emerald Database"
Next message: Humberto Guzman: "Re: Emerald Database"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald Digest]"
Maybe reply: Dale E. Reed Jr.: "Re: [Emerald Digest]"

Message 1: Re: Emerald Database
from "Mohammed Ersan" <ersan@first.net.jo>

Message 2: Printing
from "Kelly Wright" <kelly@buz.net>

Message 3: Re: second eronal server in emerald?
from "Sikko de Graaf" <sikko@igr.nl>

Message 4: Re: Emerald Database
from "Humberto Guzman" <hguzman@sysop.com.mx>

Message 5: Re: Emerald Database
from Rick Knospler <rick@skylands.net>

Message 6: RE: Anyone succeded using ip port forwardingy
from "Robert H. Clugston" <robert@csnsys.com>

Message 7: Re: second eronal server in emerald?
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 8: RE: Why Me Why Me Why Me
from John Lange <radadmin@palacenet.net>

Message 9: Re: Printing
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 10: Re: Emerald Database
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 11: RE: Printing
from "Robert H. Clugston" <robert@csnsys.com>

Message 12: Re: Printing
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 13: Printing from W95 clients.
from "Lanham Rattan" <lanham@montrose.net>

Message 14: Emerald errors
from "Richard Sensale" <richards@visitus.net>

Message 15: Emerald Database
from "Humberto Guzman" <hguzman@sysop.com.mx>

Message 16: Re: Emerald Database
from John Lange <radadmin@palacenet.net>

Message 17: Re: Emerald Database
from "Humberto Guzman" <hguzman@sysop.com.mx>

Message 18: Re: Emerald errors
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 19: Re: Printing from W95 clients.
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 20: NT Mail doesn't authenticate if SQL server restarts
from "Scott Wilkerson" <scott@tcinternet.net>

Message 21: Re: Emerald Database
from "Dale E. Reed Jr." <daler@iea-software.com>

Message 22: Re: Emerald Database
from "Dale E. Reed Jr." <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Emerald Database
From: "Mohammed Ersan" <ersan@first.net.jo>
Date: Thu, 20 Aug 1998 09:36:23 +0300

you need to start the database in single user mode try closing the EM then make sure that nobody is logged in to the database even the services such as Radius and any other services that are using the database then execute this Query in the iSQL :

use emerald

sp_dboption 'Emerald','single user', TRUE

then close this iSQL connection

start the EM you'll notice a special icon next to the Emerald Database, indicating the single user mode.

to get it back to normal after changing what ever you want to change double click the emerald DB then un check the single user mode int the options menu.

At 04:23 PM 08/20/98 +1000, you wrote:

>Try deleting or renaming the Emerald.dat out of \mssql\data

>moored@romtech.com.au

>-----Original Message-----

>From: Humberto Guzman <<hguzman@sysop.com.mx>

>To: emerald@iea-software.com <<emerald@iea-software.com>

>Date: Friday, August 21, 1998 2:07 AM

>Subject: Emerald Database

>>Hello,

>>I just installed Emerald on our server, but we keep getting an error

>>message when trying to create the database, we had created it, but deleted

>>it in the Emeral Admin, now we can not create it again... We already tried

>>re installing emerald.

>>The message we get is:

>>Create Device Failed.

>>Please Check the Device Settings and Retry.

>>Any ideas?

>>Thanks!

>>Humberto G

<center>Mohammed Ersan

ersan@first.net.jo

firstnet

</center>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Printing
From: "Kelly Wright" <kelly@buz.net>
Date: Thu, 20 Aug 1998 05:13:51 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_0044_01BDCBF9.51DB1750
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

We have a workstation that cant print invoices. For some reason and =
can't find the printer. Is there somewhere in the settings that this is =
done. All other workstations work fine.

Kelly Wright (kelly@buz.net)
BuzNet Communications=20
http://www.buz.net
972-644-0440

------=_NextPart_000_0044_01BDCBF9.51DB1750
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

We have a workstation that cant =print=20invoices. For some reason and can't find the printer. Is =there=20somewhere in the settings that this is done. All other =workstations work=20fine.

Kelly Wright (kelly@buz.net)
BuzNet =Communications
http://www.buz.net
972-644-0440=

------=_NextPart_000_0044_01BDCBF9.51DB1750--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: second eronal server in emerald?From: "Sikko de Graaf" Date: Thu, 20 Aug 1998 15:12:46 +0000Sikko de Graaf wrote:> > We are having the following small problem.> > We installed a second terminal server for cable connections.> It will athenticate OK against radius.. the users get on-line no> problem. also the statitics of the user are running ok.> > However I am not able to get them showed in the call-online view from> emerald. The screen for the secondary terminal server stayes blank> > do you have any sugestions where to look forIf you look at the calls table, what is reported for the NAS-Port?when a cable logs in I will see in my attributes NAS-Port 1011003from radius (radius -x)What type did you select in the Emerald admin when you created theserver?starting with 0 and I did a report of the server sikko de graaf-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-= S.K. de Graaf IGR Internetdiensten bv, Rotterdam Tel 31-10-5010505-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald DatabaseFrom: "Humberto Guzman" Date: Thu, 20 Aug 1998 08:38:35 +0000Tried it...got the following message:Msg 911, Level 16, State 2Attempt to locate entry in Sysdatabases for database 'emerald' by namefailed -no entry found under that name. Make sure that name is entered properly.Msg 15010, Level 16, State 1The database 'Emerald' does not exist. Use sp_helpdb to show availabledatabases.=20Available databases: =20------------------------------=20master =20model =20msdb =20pubs =20tempdb =20At 09:36 AM 8/20/98 +0300, you wrote:=20>> you need to start the database in single user mode try closing the EM then> make sure that nobody is logged in to the database even the services such= as> Radius and any other services that are using the database then execute= this> Query in the iSQL :=20>> use emerald=20> go=20> sp_dboption 'Emerald','single user', TRUE=20> go=20>>> then close this iSQL connection=20>>> start the EM you'll notice a special icon next to the Emerald Database,> indicating the single user mode.=20> to get it back to normal after changing what ever you want to change= double> click the emerald DB then un check the single user mode int the optionsmenu.>>>>>>> At 04:23 PM 08/20/98 +1000, you wrote:=20> >Try deleting or renaming the Emerald.dat out of=A0 \mssql\data=20> >moored@romtech.com.au=20> >=20> >-----Original Message-----=20> >From: Humberto Guzman =20> >To: emerald@iea-software.com =20> >Date: Friday, August 21, 1998 2:07 AM=20> >Subject: Emerald Database=20> >=20> >=20> >>Hello,=20> >>=20> >>I just installed Emerald on our server, but we keep getting an error=20> >>message when trying to create the database, we had created it, butdeleted=20> >>it in the Emeral Admin, now we can not create it again...=A0 We alreadytried>> >>re installing emerald.=20> >>=20> >>The message we get is:=20> >>Create Device Failed.=20> >>Please Check the Device Settings and Retry.=20> >>=20> >>Any ideas?=20> >>Thanks!=20> >>Humberto G=20> >>=20> >=20> >=20> >=20> Mohammed Ersan=20> ersan@first.net.jo=20> firstnet=20>>________________________________________Servicio de Comunicacion En Linea SA de CV SysOp Interrnet Tel. 338-9424http://www.sysop.com.mx..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald DatabaseFrom: Rick Knospler Date: Sat, 20 Jun 1998 12:12:57 -0400--=====================_898373577==_Content-Type: text/plain; charset="us-ascii"Here is an example of the problem I am having.. RadiusNT 2.5 is running onthe SQL server itself.I logged in, and connected, then disconnected immediately.. There was astop record generated when I disconnected.. Then, I tried to reconnect andwas rejected because the stop record was not processed properly.. If youcan shed any light on this, I'd greatly appreciate it..-Rick--=====================_898373577==_Content-Type: text/plain; charset="us-ascii"Content-Disposition: attachment; filename="radiuslog.txt" Enterprise features enabled.RadiusNT (Emerald Standard) Initialized...radrecv: Request from host ce67006a code=1, id=149, length=111 User-Name = "rick" Password = "\256`\275\342\377%\350\236\001\307=\232\333n`\261" NAS-Identifier = 206.103.0.106 NAS-Port = 9 NAS-Port-Type = Async User-Service = Framed-User Framed-Protocol = PPP Connect-Info = "49333 LAPM/V42BIS" NAS-Port-DNIS = "1523" Caller-Id = "9738751444"rad_authenticate_ODBC() Password = "\256`\275\342\377%\350\236\001\307=\232\333n`\261" SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Extension+ma..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='rick' or sa.Shell='rick' or sa.Email='rick') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0 Decrypted Password: password Database Password: passwordChecking for duplicate logins. SQL Statement: RadCheckOnline 'rick' rick found on-line 0 time(s). SQL Statement: RadGetConfigs 13 User-Service = Framed-User (2) Framed-Protocol = PPP (1) Framed-Address = 206.103.0.20 (1)Sending Ack of id 149 to ce67006a (pm3.skylands.net) User-Service = Framed-User Framed-Protocol = PPP Framed-Address = 206.103.0.20Resp Time: 200 Auth: 1/0 -> 1 Acct: 0/0/0 -> 0radrecv: Request from host ce67006a code=4, id=150, length=127 Acct-Session-Id = "23000020" User-Name = "rick" NAS-Identifier = 206.103.0.106 NAS-Port = 9 NAS-Port-Type = Async Acct-Status-Type = Start Acct-Authentic = RADIUS Connect-Info = "49333 LAPM/V42BIS" NAS-Port-DNIS = "1523" Caller-Id = "9738751444" User-Service = Framed-User Framed-Protocol = PPP Framed-Address = 206.103.0.20 Acct-Delay-Time = 0 SQL Statement: UPDATE CallsOnline Set Username='rick',AcctStatusType=1, CallDate=GetDate(), FramedAddress='206.103.0.20' WHERE NASIdentifier='206.103.0.106' and NASPort=9 AND (DateAdd(Second, 0-1, GetDate()) >= CallDate OR CallDate IS NULL)Sending Accounting Ack of id 150 to ce67006a (pm3.skylands.net)Resp Time: 120 Auth: 1/0 -> 1 Acct: 1/0/0 -> 1radrecv: Request from host ce67006a code=4, id=151, length=186 Acct-Session-Id = "23000020" User-Name = "rick" NAS-Identifier = 206.103.0.106 NAS-Port = 9 NAS-Port-Type = Async Acct-Status-Type = Stop Acct-Session-Time = 3 Acct-Authentic = RADIUS Connect-Info = "49333 LAPM/V42BIS" Acct-Input-Octets = 167 Acct-Output-Octets = 130 NAS-Port-DNIS = "1523" Caller-Id = "9738751444" Acct-Terminate-Cause = User-Request Vendor-Specific = "" User-Service = Framed-User Framed-Protocol = PPP Framed-Address = 206.103.0.20 Acct-Delay-Time = 0 SQL Statement: INSERT INTO Calls (CallDate,AcctSessionId,UserName,NASIdentifier,NASPort,NASPortType,AcctStatusType,AcctSessionTime,ConnectInfo,AcctInputOctets,AcctOutputOctets,NASPortDNIS,CallerId,AcctTerminateCause,UserService,FramedProtocol,FramedAddress,AcctDelayTime) VALUES (GetDate(),'23000020','rick','206.103.0.106',9,0,2,3,'49333 LAPM/V42BIS',167,130,'1523','9738751444',1,2,1,'206.103.0.20',0)Sending Accounting Ack of id 121 to ce670069 (pm.skylands.net)Resp Time: 111 Auth: 2/0 -> 2 Acct: 3/0/0 -> 3radrecv: Request from host ce67006a code=1, id=152, length=111 User-Name = "rick" Password = "\342\212\243,\300\357\022\030\006J6\026\203\250j\330" NAS-Identifier = 206.103.0.106 NAS-Port = 9 NAS-Port-Type = Async User-Service = Framed-User Framed-Protocol = PPP Connect-Info = "49333 LAPM/V42BIS" NAS-Port-DNIS = "1523" Caller-Id = "9738751444"rad_authenticate_ODBC() Password = "\342\212\243,\300\357\022\030\006J6\026\203\250j\330" SQL Statement: Select DateDiff(Minute, GetDate(), DateAdd(Day, (ma.Extension+ma..OverDue+1), maExpireDate)), DateDiff(Minute, GetDate(), DateAdd(Day, sa.Extension+1, saExpireDate)), sa.AccountID, sa.AccountType, sa.Password, sa.Login, sa.Shell From MasterAccounts ma, SubAccounts sa Where (sa.Login='rick' or sa.Shell='rick' or sa.Email='rick') AND ma.CustomerID=sa.CustomerID and sa.Active<>0 and ma.Active<>0 Decrypted Password: password Database Password: passwordChecking for duplicate logins. SQL Statement: RadCheckOnline 'rick' rick found on-line 1 time(s).Sending Reject of id 152 to ce67006a (pm3.skylands.net)User: rick already logged onto system 1 time(s).User: rick already logged onto system 1 time(s). SQL Statement: INSERT INTO RadLogs(RadLogMsgID, LogDate, Username, Data) VALUES (14, GetDate(), 'rick', '1')Resp Time: 100 Auth: 2/1 -> 3 Acct: 3/0/0 -> 3^CC:\radius>--=====================_898373577==_Content-Type: text/plain; charset="us-ascii"--=====================_898373577==_--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Anyone succeded using ip port forwardingyFrom: "Robert H. Clugston" Date: Thu, 20 Aug 1998 10:53:37 -0700Dear List, You can stick T-1 cards in a Linux box. Linux Journal ran an article on howto do this a few months card. The manufacture of the card was Sangoma(http://www.sangoma.com/) This allows for full use of Linux routing andfirewall tools. A T-1 is a PPP device so your setup would basically be thesame as a modem connection (firewall wise.) A good book on firewalls if "Building Internet Firewalls" published byO'Reilly & Associates, but you guy probably already knew that. Also theHOWTO's are VERY help full. There is also a Debian package for IP accounting.....I forget what it'scalled though.-----Original Message-----From: Carlos Barros [mailto:cbf@redlider.com.uy]Sent: Thursday, August 20, 1998 12:28 AMTo: Allen AhoffmanCc: Debian ISP listSubject: Re: Anyone succeded using ip port forwardingyOn Wed, 19 Aug 1998, Allen Ahoffman wrote: > Along these lines I want to know if a fully filled T1 can be routed thrua > Linux box todo IP accounting, e.g. how many megs for each ip in each > direction. > And, then after that, can it be setup to allow 2 machines to back one > another up so if one goes down, little or no routing problems arise.To route throug a linux box(a), that box(a) must supportip-forwarding/firewalling(for acounting) to start.then the box a must have 2 interfaces, one of the incomming T1(wow!)and the other for connect to the rest of the boxes.Now the rest of the boxes must use as the gateway box a. ( not T1interface IP).The later configure the firewalling/masquerading/acounting of the boxa to do what you want/need...a back-up box ? MmmmDont know how to implement that, butMay be another box(b) has it own IP and constantly pinging box(a) andwhen box(a) does not respond configures an alias for box(a) interfaceand the route to act as it was box(a).Dont know how to do-it! :( anyone did it?Bye Carlos Barros.--To UNSUBSCRIBE, email to debian-isp-request@lists.debian.orgwith a subject of "unsubscribe". Trouble? Contactlistmaster@lists.debian.org..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: second eronal server in emerald?From: "Dale E. Reed Jr." Date: Thu, 20 Aug 1998 11:20:41 -0700Sikko de Graaf wrote:> > Sikko de Graaf wrote:> >> > We are having the following small problem.> >> > We installed a second terminal server for cable connections.> > It will athenticate OK against radius.. the users get on-line no> > problem. also the statitics of the user are running ok.> >> > However I am not able to get them showed in the call-online view from> > emerald. The screen for the secondary terminal server stayes blank> >> > do you have any sugestions where to look for> > If you look at the calls table, what is reported for the NAS-Port?> when a cable logs in I will see in my attributes NAS-Port 1011003> from radius (radius -x)You will need to manually add each of those ports to the ServerPortstable for that server. --Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Why Me Why Me Why MeFrom: John Lange Date: Thu, 20 Aug 1998 12:28:31 -0500HIDidn't help, the box has never been checked.What next?JOhn :}At 11:34 PM 8/19/1998 -0500, you wrote:>> On my 2 Computers "EVERY" time I open an MBR It Automatically opens the>> first Sub Account to the "General Tab".>>Click File | Preferences | and take the CHECK OFF Direct Edit (SA) and itwill no longer open the SubAccount (SA)>>>>John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 1918 New Pinery Roadhttp://www.palacenet.net/ Portage, WI 53901Visit our online store @ http://www.microt.com/Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html --- __o --- _-\<,_ Fastest Service in Town --- (_)/ (_)..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: PrintingFrom: "Dale E. Reed Jr." Date: Thu, 20 Aug 1998 11:32:14 -0700> Kelly Wright wrote:> > We have a workstation that cant print invoices. For some reason and> can't find the printer. Is there somewhere in the settings that this> is done. All other workstations work fine.Does the print preview window appear? If you go into the settings,printers, can you print a test page?--Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald DatabaseFrom: "Dale E. Reed Jr." Date: Thu, 20 Aug 1998 11:41:16 -0700Humberto Guzman wrote:> > Tried it...> > got the following message:> Msg 911, Level 16, State 2> Attempt to locate entry in Sysdatabases for database 'emerald' by name> failed -> no entry found under that name. Make sure that name is entered properly.> Msg 15010, Level 16, State 1> The database 'Emerald' does not exist. Use sp_helpdb to show available> databases.You need to delete the physical file on your disk. Its called Emerald.dat, and typically in your \mssql\data directory. --Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: PrintingFrom: "Robert H. Clugston" Date: Thu, 20 Aug 1998 11:49:14 -0700List, Don't you have to have a ODBC DNS to emerald on that workstations to print?-----Original Message-----From: emerald-request@iea-software.com[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.Sent: Thursday, August 20, 1998 11:32 AMTo: emerald@iea-software.comSubject: Re: Printing> Kelly Wright wrote:>> We have a workstation that cant print invoices. For some reason and> can't find the printer. Is there somewhere in the settings that this> is done. All other workstations work fine.Does the print preview window appear? If you go into the settings,printers, can you print a test page?--Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: PrintingFrom: "Dale E. Reed Jr." Date: Thu, 20 Aug 1998 13:20:52 -0700Robert H. Clugston wrote:> > List,> Don't you have to have a ODBC DNS to emerald on that workstations to print?Yes. Emerald itself does not require ODBC to work, just the printingdoes. If you do not have an ODBC DSN called "Emerald" configuredcorrectly and working, then printing will not work.> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.> Sent: Thursday, August 20, 1998 11:32 AM> To: emerald@iea-software.com> Subject: Re: Printing> > > Kelly Wright wrote:> >> > We have a workstation that cant print invoices. For some reason and> > can't find the printer. Is there somewhere in the settings that this> > is done. All other workstations work fine.> > Does the print preview window appear? If you go into the settings,> printers, can you print a test page?> > --> Dale E. Reed Jr. (daler@iea-software.com)> _________________________________________________________________> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs> Internet Solutions for Today | http://www.iea-software.com-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Printing from W95 clients.From: "Lanham Rattan" Date: Thu, 20 Aug 1998 16:40:12 -0600I am having difficulty getting print functions from my W95 emerald clients.I get the "Unable to connect: incorrect log on parameters" message. I triedinstalling an emerald User Data Source and System Data Source with nosuccess. The manual does not have any instructions for the W95 ODBC setup(at least I could not find them).Thanks,Lanham...------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald errorsFrom: "Richard Sensale" Date: Thu, 20 Aug 1998 18:55:46 -0400HiWe recently tightened our internal lan security and ever since, half theclients on our network, get an error 76 path not found when entering usersor editing someone. Although the users do seem to be created properlyanyways. Any ideas as to what would cause this?Richard SensaleNetwork AdministratorVisitUs Internet, Inc.5468 Schaefer RoadDearborn, MI 48126(313) 945-5588(313) 945-0202 faxrichards@visitus.nethttp://www.visitus.net..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald DatabaseFrom: "Humberto Guzman" Date: Thu, 20 Aug 1998 20:01:25 +0000Hi,When I try to Run Check Database in the Emerald Administrator I get all thefollowing error messages:Table Groups does not have the correct number of fieldsTable Invoices does not have the correct number of fieldsTable Radatributes does not have the correct number of fieldsTable Radvalues does not have the correct number of fieldsTable Scriptmaps does not have the correct number of fieldsTable Scripts does not have the correct number of fieldsTable TimeLimits does not have the correct number of fieldsTable Timeusage does not have the correct number of fieldsAnd if I try to Update Database I get:SQL Server Error: 2705 Column names in each table must be unique Columnname 'group id' in table 'account types' is specified more than once.State=2 Severity=16And tons of other messages like this one...Any ideas what should I do?ThanksHumberto G.________________________________________Servicio de Comunicacion En Linea SA de CV SysOp Interrnet Tel. 338-9424http://www.sysop.com.mx..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald DatabaseFrom: John Lange Date: Thu, 20 Aug 1998 19:08:53 -0500HILooks normal to me, the older versions did that. The question I would haveis...Is everything working OK?JOhn :}At 08:01 PM 8/20/1998 +0000, you wrote:>Hi,>>When I try to Run Check Database in the Emerald Administrator I get all the>following error messages:>Table Groups does not have the correct number of fields>Table Invoices does not have the correct number of fields>Table Radatributes does not have the correct number of fields>Table Radvalues does not have the correct number of fields>Table Scriptmaps does not have the correct number of fields>Table Scripts does not have the correct number of fields>Table TimeLimits does not have the correct number of fields>Table Timeusage does not have the correct number of fields>>And if I try to Update Database I get:>SQL Server Error: 2705 Column names in each table must be unique Column>name 'group id' in table 'account types' is specified more than once.>State=2 Severity=16>>And tons of other messages like this one...>>Any ideas what should I do?>Thanks>Humberto G.>>________________________________________>Servicio de Comunicacion En Linea SA de CV> SysOp Interrnet>> Tel. 338-9424>>http://www.sysop.com.mx>>>John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 1918 New Pinery Roadhttp://www.palacenet.net/ Portage, WI 53901Visit our online store @ http://www.microt.com/Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html --- __o --- _-\<,_ Fastest Service in Town --- (_)/ (_)..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald DatabaseFrom: "Humberto Guzman" Date: Thu, 20 Aug 1998 20:15:08 +0000Nope...If I run Radius in txt mode it does, but if I run it in ODBC mode I get thefollowing log:Thu Aug 20 18:58:18 1998: RadiusNT (Emerald Standard) Initialized...Thu Aug 20 19:08:09 1998: ODBC Error:37000:2812:[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure'RadGetConfigs' not found.Thu Aug 20 19:08:09 1998: ODBC Error:37000:2812:[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure'RadGetATConfigs' not found.Thu Aug 20 19:08:09 1998: prueba: Modem has no RADIUS default attributes.Thu Aug 20 19:08:09 1998: ODBC Error:S0022:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Data'.Thu Aug 20 19:08:36 1998: ODBC Error:37000:2812:[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure'RadGetConfigs' not found.Thu Aug 20 19:08:36 1998: ODBC Error:37000:2812:[Microsoft][ODBC SQL Server Driver][SQL Server]Stored procedure'RadGetATConfigs' not found.Thu Aug 20 19:08:36 1998: prueba: Modem has no RADIUS default attributes.Thu Aug 20 19:08:36 1998: ODBC Error:S0022:207:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Data'.Really ugly isn't it ? :)Thanks !Humberto GAt 07:08 PM 8/20/98 -0500, you wrote:>HI>>Looks normal to me, the older versions did that. The question I would have>is...>>Is everything working OK?>>JOhn :}>>At 08:01 PM 8/20/1998 +0000, you wrote:>>Hi,>>>>When I try to Run Check Database in the Emerald Administrator I get all the>>following error messages:>>Table Groups does not have the correct number of fields>>Table Invoices does not have the correct number of fields>>Table Radatributes does not have the correct number of fields>>Table Radvalues does not have the correct number of fields>>Table Scriptmaps does not have the correct number of fields>>Table Scripts does not have the correct number of fields>>Table TimeLimits does not have the correct number of fields>>Table Timeusage does not have the correct number of fields>>>>And if I try to Update Database I get:>>SQL Server Error: 2705 Column names in each table must be unique Column>>name 'group id' in table 'account types' is specified more than once.>>State=2 Severity=16>>>>And tons of other messages like this one...>>>>Any ideas what should I do?>>Thanks>>Humberto G.>>>>________________________________________>>Servicio de Comunicacion En Linea SA de CV>> SysOp Interrnet>>>> Tel. 338-9424>>>>http://www.sysop.com.mx>>>>>>>>John C. Lange, Sr. PALACE dot NET, INC.>microjl@palacenet.net MICRO-TECH Computers, Inc.>608.742.1601 & 6980 1918 New Pinery Road>http://www.palacenet.net/ Portage, WI 53901>Visit our online store @ http://www.microt.com/>Authorized iPSwitch WebVar @ http://www.microt.com/iPSwitch/index.html>> --- __o> --- _-\<,_ Fastest Service in Town> --- (_)/ (_)> ________________________________________Servicio de Comunicacion En Linea SA de CV SysOp Interrnet Tel. 338-9424http://www.sysop.com.mx..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald errorsFrom: "Dale E. Reed Jr." Date: Thu, 20 Aug 1998 21:52:03 -0700Richard Sensale wrote:> > We recently tightened our internal lan security and ever since, half the> clients on our network, get an error 76 path not found when entering users> or editing someone. Although the users do seem to be created properly> anyways. Any ideas as to what would cause this?Emerald is trying to verify the path in the user's home dir andis failing. Open a DOS prompt and make sure the user running Emerald can a do a dir of the UNC specified.--Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Printing from W95 clients.From: "Dale E. Reed Jr." Date: Thu, 20 Aug 1998 21:56:39 -0700Lanham Rattan wrote:> > I am having difficulty getting print functions from my W95 emerald clients.> I get the "Unable to connect: incorrect log on parameters" message. I tried> installing an emerald User Data Source and System Data Source with no> success. The manual does not have any instructions for the W95 ODBC setup> (at least I could not find them).ODBC doesn't different between NT and 95. What protocol areyou using as a default for SQL Server? Have you tried usingsomething like MS Query to verify that the stored proc isindeed working correctly?--Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 20 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: NT Mail doesn't authenticate if SQL server restartsFrom: "Scott Wilkerson" Date: Fri, 21 Aug 1998 00:50:13 -0500Here's a little problem we are having, if our SQL Server is restarted forany reason, (i.e. the machine it is on was rebooted) NT Mail will notauthenticate through Emerald database until we either stop/start NT Mail.Is this normal?Not a big deal if I know the SQL is stopping, but....Any Help? Scott Wilkerson scott@tcinternet.net Vice President Twin Cities Internet, Inc. http://www.tcinternet.net..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 21 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald DatabaseFrom: "Dale E. Reed Jr." Date: Thu, 20 Aug 1998 22:49:40 -0700Humberto Guzman wrote:> > Nope...> If I run Radius in txt mode it does, but if I run it in ODBC mode I get the> following log:You need to run the rad25_up2.sql script against your Emerald Databaseand then RadiusNT 2.5 should work. --Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 22 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald DatabaseFrom: "Dale E. Reed Jr." Date: Thu, 20 Aug 1998 22:50:44 -0700Humberto Guzman wrote:> > When I try to Run Check Database in the Emerald Administrator I get > all the following error messages:You can ignore both the check database and update database inEmerald 2.1/2.2. They are only for upgrading from Emerlad 2.0.--Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com

Previous message: Dale E. Reed Jr.: "Re: Emerald Database"
Next message: Humberto Guzman: "Re: Emerald Database"
Next in thread: Dale E. Reed Jr.: "Re: [Emerald Digest]"