[Emerald Digest]

emerald-digest-request@iea-software.com
Thu, 2 Jul 1998 00:00:01 -0700

Message 1: Limit column access
from "Bill Bongiorno" <bill@systec.com>

Message 2: ServU Setup .dll
from "Kelly Wright" <kelly@buz.net>

Message 3: Re: Database Transfer
from "Richard Sensale" <richards@visitus.net>

Message 4: Re: Calls Online Problems
from "Richard Sensale" <richards@visitus.net>

Message 5: Re: SERV-U dll
from "Josh Hillman" <admin-maillist@talstar.com>

Message 6: Can Not Run Consolidation
from "Alan D. Criado" <ACriado@elink.net>

Message 7: Re: Can Not Run Consolidation
from Dale Reed <daler@iea-software.com>

Message 8: no call history
from "Paul Smith" <pjsmith@microtech.co.gg>

Message 9: Re: ServU Setup .dll
from Dale Reed <daler@iea-software.com>

Message 10: Re: Limit column access
from Dale Reed <daler@iea-software.com>

Message 11: Re: Can Not Run Consolidation
from "Alan D. Criado" <ACriado@elink.net>

Message 12: Re: Can Not Run Consolidation
from "Alan D. Criado" <ACriado@elink.net>

Message 13: RE: Limit column access
from "Bill Bongiorno" <bill@systec.com>

Message 14: Calls Online
from "Alan D. Criado" <ACriado@elink.net>

Message 15: Re: Database Transfer
from Victor Alba <victor@webjogger.net>

Message 16: Emerald from workstation
from "Alan D. Criado" <ACriado@elink.net>

Message 17: Re: Database Transfer
from Dale Reed <daler@iea-software.com>

Message 18: Re: Emerald from workstation
from Michael Whisenant <mwhisen@airnet.net>

Message 19: Dale or other 2.1.11 experts,
from "Ed and Kathy Tate" <tatee@onlinemac.com>

Message 20: RE: Emerald from workstation
from Greg Dobinson <gregd@kenora.com>

Message 21: Re: Dale or other 2.1.11 experts,
from Dale Reed <daler@iea-software.com>

Message 22: Re: Emerald from workstation
from Dale Reed <daler@iea-software.com>

Message 23: Re: Calls Online
from Dale Reed <daler@iea-software.com>

Message 24: Re: Can Not Run Consolidation
from Dale Reed <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Limit column access
From: "Bill Bongiorno" <bill@systec.com>
Date: Wed, 1 Jul 1998 08:52:33 -0400

I am trying to access the limit column of the Master Billing Record using
CR6.0 and Emerald 2.2.38. It does not appear in the list of columns. Does
anyone know why? Thanks.

Bill Bongiorno
SysTec Computer Associates, Inc.

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 2 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: ServU Setup .dll
From: "Kelly Wright" <kelly@buz.net>
Date: Wed, 1 Jul 1998 09:19:54 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_0005_01BDA4D1.68BA4580
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Is there a setup procedure for using the emerauth.dll? Right now I am =
using the emer_su.dll. I would like to switch for obvious reasons. I =
am tired of having to reset the dll everytime we have a problem.

Thanks,

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

------=_NextPart_000_0005_01BDA4D1.68BA4580
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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

Is there a setup procedure for using =the=20emerauth.dll?  Right now I am using the emer_su.dll.  I would =like to=20switch for obvious reasons.  I am tired of having to reset the dll=20everytime we have a problem.
 
Thanks,

Kelly Wright (kelly@buz.net)
BuzNet =Communications
http://www.buz.net
972-644-0440=
------=_NextPart_000_0005_01BDA4D1.68BA4580--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Database TransferFrom: "Richard Sensale" Date: Wed, 1 Jul 1998 10:55:47 -0700Im not sure if this will work, but did you try using SQL backup to create abackup of the entire database on another hard disk on your network and thenrestoring it to the new machine?Richard SensaleNetwork AdministratorVisitUs Internet, Inc.5468 Schaefer RoadDearborn, MI 48126 USA(313) 945-5588(313) 945-0202 faxhttp://www.visitus.netrichards@visitus.net-----Original Message-----From: Victor Alba To: emerald@iea-software.com Date: Tuesday, June 30, 1998 9:10 AMSubject: Database Transfer>I've searched the archives before daring to ask this question but all I>could find were brief descriptions as to what to do in EM while trying to>transfer the emerald database. I already know how to do that and actually>this morning I did transfer the Emerald Database onto our new machine but>when EM finished said "there were some errors that occured while>transfering the database" then when I went and check emerald on the new>machine I couldn't access any record at all, the names of the users are>there but as soon as I try editing the record, everything is empty.>>SQL is showing these errors in it's log file:>>------------------------------------------------>::Error::>In file NS.Emerald.DR1 in statement on line 302>Transfer Status: Creating DRI on destination database>Attempting to define PRIMARY KEY constraint on nullable column in table>'ServerAccess'.>>::Error::>In file NS.Emerald.DR1 in statement on line 302>Transfer Status: Creating DRI on destination database>Unable to create constraint. See previous errors.>>::Error::>In file NS.Emerald.FKY in statement on line 251>Transfer Status: Creating Foreign Keys on destination database>data exists in table 'dbo.Invoices', database 'Emerald', that violates>FOREIGN KEY constraint 'FK__Invoices__Type__465D7A27' being added. ALTER>command has been aborted.>>::Error::>In file NS.Emerald.FKY in statement on line 251>Transfer Status: Creating Foreign Keys on destination database>Unable to create constraint. See previous errors.>>::Error::>In file NS.Emerald.TRG in statement on line 1>Transfer Status: Creating Triggers on destination database>Invalid column name 'login'.>--------------------------------------------->>>Anyone knows the 'appropiate' steps to follow to transfer Emerald from one>machine to another one?>>Regards,>Victor>>..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls Online ProblemsFrom: "Richard Sensale" Date: Wed, 1 Jul 1998 11:00:20 -0700I know that there is a memory leak of sorts in the Max's. This usually onlyaffects ISDN users since they are using MPP to bind both ISDN channels.With the leak, you sometimes have to manually reboot the max to free up andrelease IPs and channels. Im not sure if this is the same problem but itsounds like it may be related. There was a notice on it on the Ascendwebsite under the release notes for the new COMOS 6.0xRichard SensaleNetwork AdministratorVisitUs Internet, Inc.5468 Schaefer RoadDearborn, MI 48126 USA(313) 945-5588(313) 945-0202 faxhttp://www.visitus.netrichards@visitus.net-----Original Message-----From: Ed Miller To: emerald@iea-software.com Date: Tuesday, June 30, 1998 10:34 AMSubject: Re: Calls Online Problems>Dale,>> We are trying out MPP with Multi-Channels under Win98. We can get>hooked up with 2 channels with good rates even on bad lines, but after we>disconnect we start getting ghost logins. Using an Ascend Max4000. wehave>Auth Timeout set at 14. The Radius set up> User-Service = Framed-User> Framed-Protocal = MPP> Idle-Timeout = 600> Port-Limit = 2> Ascend-Maximum-Channels = 2> Ascend-Idle-Limit = 600> (we use both Max4000's and PM3's)>> Any idea why ghost is showing up.>>>>..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: SERV-U dllFrom: "Josh Hillman" Date: Wed, 1 Jul 1998 11:33:47 -0400>From: Derrick Young >Question for anyone using the SERV-U dll.>I have it installd and it appears to initialize ok however when I connect>as a user it rejects the password.>The client software(cute FTP) reports user name ok then invalid password.If you're using SQL as your db back-end, was it started before Serv-U wasstarted? If the Serv-U service runs before SQL is finished loading, you'llget authentication problems until you stop/restart Serv-U.Also, if you're using an older version of the dll file, the user won't beable to authenticate past his/her expiration date (regardless of whatevergrace-period is set (MasterAccounts.OverDue)) unless a value is entered infor the MasterAccounts.Extension (temporary extension). The .dll file fromDecember 97 fixes this glitch and now recognizes both the grace period andtemp extension.>I thought It might have to do with home directories defined in Emerald.>I have tried using full UNC in emerald for path as well as typed as the>local path on the FTP server (ie d:\ftpusers) but to no availI have my directory paths displayed like: \\servername\users\whoever \\servername\domains\whateverJosh Hillmanhillman@talstar.com..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Can Not Run ConsolidationFrom: "Alan D. Criado" Date: Wed, 01 Jul 1998 12:20:41 -0400To Dale or whomever can help.We're running Emerald 2.2.38, just purchased it this past week.We are trying to run the consolidation but every time we try, we get thefollowing error message: Error executing Consolidation Proceedure!As you can see the error message is not very descriptive, so I don't knowwhat is going wrong. Perhaps someone here knows the answer from pastexperience and can give me a hand.Thank you.Alan D. Criado..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Can Not Run ConsolidationFrom: Dale Reed Date: Wed, 01 Jul 1998 10:57:42 -0700Alan D. Criado wrote:> > We are trying to run the consolidation but every time we try, we get the> following error message:> > Error executing Consolidation Proceedure!> > As you can see the error message is not very descriptive, so I don't know> what is going wrong. Perhaps someone here knows the answer from past> experience and can give me a hand.Run the consol.sql script (in /emerald/beta) against your database using isql_w. Then you should be able to login as sa (unless youset permissions for others to execute the consolidation/deletecallsprocs) and run a consolidation.-- 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: no call historyFrom: "Paul Smith" Date: Wed, 1 Jul 1998 19:05:35 +0100I had a problem with RadiusNT reporting it cannot connect to the ODBC datasource, although this is not true because I've looked in the calls table andall the information is being added.When I go into the master record and look at the service call history, thereare no calls listed.Any ideas why?Regards, Paul Smith..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: ServU Setup .dllFrom: Dale Reed Date: Wed, 01 Jul 1998 11:14:46 -0700> Kelly Wright wrote:> > Is there a setup procedure for using the emerauth.dll? Right now I am> using the emer_su.dll. I would like to switch for obvious reasons. I> am tired of having to reset the dll everytime we have a problem.I'm working on a final install of EmerAuth that will be includedin the RadiusNT or Emerald installations (you choose the options youwant). It will also include an Admin (like the RadiusNT Admin) toeasily configure it.-- 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: Limit column accessFrom: Dale Reed Date: Wed, 01 Jul 1998 11:16:00 -0700Bill Bongiorno wrote:> > I am trying to access the limit column of the Master Billing Record using> CR6.0 and Emerald 2.2.38. It does not appear in the list of columns. Does> anyone know why? Thanks.Which limit? Extension is the temp extend, OverDue is the Permextend and LoginLimit (from the SuBAccounts) is the concurrencycontrol.-- 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: Can Not Run ConsolidationFrom: "Alan D. Criado" Date: Wed, 01 Jul 1998 14:29:41 -0400Hello Dale.I did as you said below and got the following results: "This command did not return data, and it did not return any rows"I went into Emerald and tried to consolidate and got the eror executingmessage again. So I went back into isql_w and ran the console.sql scriptagain. This time I got this result: "Msg 2729, Level 16, State 1 Object 'Consolidation' group number 1 already exists in the database. Choose another procedure name Msg 2729, Level 16, State 1 Object 'DeleteCalls' group number 1 already exists in the database. Choose another procedure name"I went back into Emerald again and tried to run the consolidation and thistime it seem to work ok. It said it ran successfully. However, I don'tunderstand the above results from running the script and if they have anyimplications to my situation that I should be concern about.Thanks.AlanAt 10:57 AM 7/1/98 -0700, Dale Reed wrote:>Alan D. Criado wrote:>> >> We are trying to run the consolidation but every time we try, we get the>> following error message:>> >> Error executing Consolidation Proceedure!>> >> As you can see the error message is not very descriptive, so I don't know>> what is going wrong. Perhaps someone here knows the answer from past>> experience and can give me a hand.>>Run the consol.sql script (in /emerald/beta) against your database >using isql_w. Then you should be able to login as sa (unless you>set permissions for others to execute the consolidation/deletecalls>procs) and run a consolidation.>>-- >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: Can Not Run ConsolidationFrom: "Alan D. Criado" Date: Wed, 01 Jul 1998 14:29:41 -0400Hello Dale.I did as you said below and got the following results: "This command did not return data, and it did not return any rows"I went into Emerald and tried to consolidate and got the eror executingmessage again. So I went back into isql_w and ran the console.sql scriptagain. This time I got this result: "Msg 2729, Level 16, State 1 Object 'Consolidation' group number 1 already exists in the database. Choose another procedure name Msg 2729, Level 16, State 1 Object 'DeleteCalls' group number 1 already exists in the database. Choose another procedure name"I went back into Emerald again and tried to run the consolidation and thistime it seem to work ok. It said it ran successfully. However, I don'tunderstand the above results from running the script and if they have anyimplications to my situation that I should be concern about.Thanks.AlanAt 10:57 AM 7/1/98 -0700, Dale Reed wrote:>Alan D. Criado wrote:>> >> We are trying to run the consolidation but every time we try, we get the>> following error message:>> >> Error executing Consolidation Proceedure!>> >> As you can see the error message is not very descriptive, so I don't know>> what is going wrong. Perhaps someone here knows the answer from past>> experience and can give me a hand.>>Run the consol.sql script (in /emerald/beta) against your database >using isql_w. Then you should be able to login as sa (unless you>set permissions for others to execute the consolidation/deletecalls>procs) and run a consolidation.>>-- >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: RE: Limit column accessFrom: "Bill Bongiorno" Date: Wed, 1 Jul 1998 14:30:44 -0400I was looking for the Perm extend (Limit on the Billing window). I did notrealize it is called OverDue in the data base. Thanks.Bill BongiornoSysTec Computer Associates, Inc.> -----Original Message-----> From: emerald-request@iea-software.com> [mailto:emerald-request@iea-software.com]On Behalf Of Dale Reed> Sent: Wednesday, July 01, 1998 2:16 PM> To: emerald@iea-software.com> Subject: Re: Limit column access>>> Bill Bongiorno wrote:> >> > I am trying to access the limit column of the Master Billing> Record using> > CR6.0 and Emerald 2.2.38. It does not appear in the list of> columns. Does> > anyone know why? Thanks.>> Which limit? Extension is the temp extend, OverDue is the Perm> extend and LoginLimit (from the SuBAccounts) is the concurrency> control.>> --> 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 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Calls OnlineFrom: "Alan D. Criado" Date: Wed, 01 Jul 1998 14:46:02 -0400Hello Dale.I'm using Emerald 2.2.38 and Radius NT 2.5When I go into Emerald and click on the ON-LINE tab, it does not show whois currently online. I'll click in the UPDATE button, but nothing shows.The Radius NT Manual says:"Manual Calls Update" RadiusNT will manually update the calls onlineview. This is only needed for databases which do not have trigger supportThis is not needed with Emerald/SQL Server or an active database which canupdate the calls online view automatically.I don't have the Manual Calls Update check.Any ideas as to what could be wrong?Thank you.Alan..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Database TransferFrom: Victor Alba Date: Wed, 01 Jul 1998 15:23:34 -0400At 10:55 AM 7/1/98 -0700, you wrote:>Im not sure if this will work, but did you try using SQL backup to create a>backup of the entire database on another hard disk on your network and then>restoring it to the new machine?I tried that too but all I get is an error telling me that the Database I'mtrying to restore was sorted in a different order and therefore it cannotbe restored.Any other ideas...Regards,-VictorP.S. As far as we can tell the only information that doesn't appear isthe info displyed for services and also all the amounts appear in poundsinstead of dlls. ..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 16 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Emerald from workstationFrom: "Alan D. Criado" Date: Wed, 01 Jul 1998 16:39:35 -0400Hello Dale.I'm running Emerald 2.2.38 and Radius NT 2.5 on the NT Server.I'm unable to get Emerald to work successfully from a workstation andaccess the server. I don't believe Emerald is listed in the ODBC driverswithin the Control Panel. SQL Client utilities are installed.I would appreciate your assistance in getting the workstation configuredcorrectly to be able to access the Emerald database on the NT server.Thank you.Alan D. Criado..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 17 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Database TransferFrom: Dale Reed Date: Wed, 01 Jul 1998 15:28:40 -0700Victor Alba wrote:> > I've searched the archives before daring to ask this question but all I> could find were brief descriptions as to what to do in EM while trying to> transfer the emerald database. I already know how to do that and actually> this morning I did transfer the Emerald Database onto our new machine but> when EM finished said "there were some errors that occured while> transfering the database" then when I went and check emerald on the new> machine I couldn't access any record at all, the names of the users are> there but as soon as I try editing the record, everything is empty.> > SQL is showing these errors in it's log file:> > ------------------------------------------------> ::Error::> In file NS.Emerald.DR1 in statement on line 302> Transfer Status: Creating DRI on destination database> Attempting to define PRIMARY KEY constraint on nullable column in table> 'ServerAccess'.The ServerAccess table in Emerald 2.1 is bad. The RadiusNT 2.5update replaces it. You can ignore this error on a transfer.> ::Error::> In file NS.Emerald.DR1 in statement on line 302> Transfer Status: Creating DRI on destination database> Unable to create constraint. See previous errors.This is a result of the above failure. > ::Error::> In file NS.Emerald.FKY in statement on line 251> Transfer Status: Creating Foreign Keys on destination database> data exists in table 'dbo.Invoices', database 'Emerald', that violates> FOREIGN KEY constraint 'FK__Invoices__Type__465D7A27' being added. ALTER> command has been aborted.This means you have an InvoiceType entry in your InvoicesTable thatdoesn't match an entry in the InvoiceTypes table. Its not a show stopperbut should be looked at. I don't think InvoiceTypes are even usedin pre 2.5 releases. > ::Error::> In file NS.Emerald.FKY in statement on line 251> Transfer Status: Creating Foreign Keys on destination database> Unable to create constraint. See previous errors.Result of above. > ::Error::> In file NS.Emerald.TRG in statement on line 1> Transfer Status: Creating Triggers on destination database> Invalid column name 'login'.> ---------------------------------------------This is most likely the Calls table trigger. Only the SubAccountstable has a login field. You can just re-run the insttrig.sqlscript on the new box to correct this. > Anyone knows the 'appropiate' steps to follow to transfer Emerald from one> machine to another one?Actually it looks like everything did tranfer OK.-- 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 18 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Emerald from workstationFrom: Michael Whisenant Date: Wed, 01 Jul 1998 18:01:07 -0500Alan, Go into control panel and select ODBC32. Then select the system DSN taband create a DSN called Emerald, pointing the server to your SQL server andthe database to Emerald. You can edit the client configs to allow TCP/IPor Named Pipes (the default) as how to address the SQL server. >I'm unable to get Emerald to work successfully from a workstation and>access the server. I don't believe Emerald is listed in the ODBC drivers>within the Control Panel. SQL Client utilities are installed.>>I would appreciate your assistance in getting the workstation configured>correctly to be able to access the Emerald database on the NT server.>>Thank you.>>Alan D. Criado> Michael J. WhisenantVice-President, OperationsAIRnet Internet Services, Inc.ph: (256) 704-4692 fax: (256) 704-2329..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 19 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Dale or other 2.1.11 experts,From: "Ed and Kathy Tate" Date: Wed, 1 Jul 1998 16:20:44 -0700Dale or other 2.1.11 experts,We are running Emerald 2.1.11 and are preparing to start Radiusauthentication. We have set the 'overdue' field in all of the masteraccount records to '30'. Is it correct that Radius will allow for 30 extradays of service beyond the 'maexpiredate' before the account is shut off?Your response or recommendations would be appreciated before we turn this onand find out the hard way.Thanks.Kathy TateOnlineMacMcMinnville, Oregon..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 20 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Emerald from workstationFrom: Greg Dobinson Date: Wed, 1 Jul 1998 22:00:38 -0500Don't forget to establish an IPC connection after you have completed the following instructions. That means either logging onto the domain or mapping a drive to the server running SQL.> Alan,>> Go into control panel and select ODBC32. Then select the system DSN tab> and create a DSN called Emerald, pointing the server to your SQL server and> the database to Emerald. You can edit the client configs to allow TCP/IP> or Named Pipes (the default) as how to address the SQL server.> >I'm unable to get Emerald to work successfully from a workstation and> >access the server. I don't believe Emerald is listed in the ODBC drivers> >within the Control Panel. SQL Client utilities are installed.> >> >I would appreciate your assistance in getting the workstation configured> >correctly to be able to access the Emerald database on the NT server.> >> >Thank you.> >> >Alan D. Criado> >> Michael J. Whisenant> Vice-President, Operations> AIRnet Internet Services, Inc.> ph: (256) 704-4692 fax: (256) 704-2329..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 21 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Dale or other 2.1.11 experts,From: Dale Reed Date: Wed, 01 Jul 1998 21:31:29 -0700Ed and Kathy Tate wrote:> > Dale or other 2.1.11 experts,> > We are running Emerald 2.1.11 and are preparing to start Radius> authentication. We have set the 'overdue' field in all of the master> account records to '30'. Is it correct that Radius will allow for 30 extra> days of service beyond the 'maexpiredate' before the account is shut off?> > Your response or recommendations would be appreciated before we turn this on> and find out the hard way.Yes. THere is a temporary extension (in Emerald 2.1) and a temp/permextension (in Emerald 2.2) that RadiusNT will use.-- 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 from workstationFrom: Dale Reed Date: Wed, 01 Jul 1998 22:54:38 -0700Alan D. Criado wrote:> > I'm running Emerald 2.2.38 and Radius NT 2.5 on the NT Server.> > I'm unable to get Emerald to work successfully from a workstation and> access the server. I don't believe Emerald is listed in the ODBC drivers> within the Control Panel. SQL Client utilities are installed.Emerald itself does not use ODBC (only the print engine does). Doublecheck your SQL Client configuration utility and make sure Named Pipesif the default protocol and that you do not have any entries listedin the Advanced section. You should be abled to brwose the shareson your SQL Server (IOW, you have credentials to talk to the machine). -- 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 23 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Calls OnlineFrom: Dale Reed Date: Wed, 01 Jul 1998 23:36:30 -0700Alan D. Criado wrote:> > When I go into Emerald and click on the ON-LINE tab, it does not show who> is currently online. I'll click in the UPDATE button, but nothing shows.> > The Radius NT Manual says:> > "Manual Calls Update" RadiusNT will manually update the calls online> view. This is only needed for databases which do not have trigger support> This is not needed with Emerald/SQL Server or an active database which can> update the calls online view automatically.> > I don't have the Manual Calls Update check.> > Any ideas as to what could be wrong?Most likely the problem is with your Server Ports configuration. Whatkindof terminal server are you using? You can run RadiusNT in -x15 debug tosee what style of NAS-Port numbers it is using and add those to theServer in the Server Ports tab.-- 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 24 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Can Not Run ConsolidationFrom: Dale Reed Date: Wed, 01 Jul 1998 23:42:52 -0700Alan D. Criado wrote:> > I did as you said below and got the following results:> > "This command did not return data, and it did not return any rows"> > I went into Emerald and tried to consolidate and got the eror executing> message again. So I went back into isql_w and ran the console.sql script> again. This time I got this result:> > "Msg 2729, Level 16, State 1> Object 'Consolidation' group number 1 already exists in the database.> Choose another procedure name> Msg 2729, Level 16, State 1> Object 'DeleteCalls' group number 1 already exists in the database.> Choose another procedure name"This is normal, since you already added the procs above. > I went back into Emerald again and tried to run the consolidation and this> time it seem to work ok. It said it ran successfully. However, I don't> understand the above results from running the script and if they have any> implications to my situation that I should be concern about.The other issue we are seeing is that if your tempdb is too small, theconsolidation proc will fail. You can run a "consolidation x" (where xis the first number in the summary box) in isql_w to see what the erroritself is. If you are getting a out of space error, expand your tempdb.Somewhere around 10mb should work for most systems less than 1000 users.-- 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