[Emerald Digest]

emerald-digest-request@iea-software.com
Fri, 26 Jun 1998 00:00:00 -0700

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Dale Reed: "Re: Backup Radius Server"
Next message: Waldemar Born: "RE: Optimize MS SQL & Emerald"

Message 1: Re: Help Please - Emerald Client logging into the SQL Database
from "Graeme Slogrove" <graeme@fdd.net>

Message 2: Crystal Report
from "Olivier Astier (Echoweb)" <astier@echoweb.net>

Message 3: over billing
from "Sean Cook" <scook@centramedia.com>

Message 4: Re: over billing
from Dale Reed <daler@iea-software.com>

Message 5: Optimize MS SQL & Emerald
from John Lange <radadmin@palacenet.net>

Message 6: RE: Optimize MS SQL & Emerald
from "Robert H. Clugston" <robert@csnsys.com>

Message 7: Re: Optimize MS SQL & Emerald
from list_rx@qcom.net

Message 8: Re: Optimize MS SQL & Emerald
from "Richard Sensale" <richards@visitus.net>

Message 9: Sql error 1060
from Phil Blancett <phil@oakweb.com>

Message 10: Re: Optimize MS SQL & Emerald
from John Lange <radadmin@palacenet.net>

Message 11: Re: Optimize MS SQL & Emerald
from "Pat Augustine" <ereth@ilnk.com>

Message 12: Backup Radius Server
from "Mike Roberts" <mike@datawest.net>

Message 13: Re: Backup Radius Server
from "Greg Dobinson" <gregd@kenora.com>

Message 14: RE: Backup Radius Server
from "Richard Lachance" <richard@vircom.com>

Message 15: Re: Backup Radius Server
from Dale Reed <daler@iea-software.com>

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.
| Message 1 |
'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'
Subject: Re: Help Please - Emerald Client logging into the SQL Database
From: "Graeme Slogrove" <graeme@fdd.net>
Date: Thu, 25 Jun 1998 09:00:34 +0200

On 24 Jun 98 at 18:46, Andrew Tadros (Kober Enterpri wrote:

> I the emerald clients running on Win95 and windows Nt machines in my
> office . On a dedicated connection to the internet. After a few
> days, I am unable to connect to the database, the only way I can
> correct this is to stop and start SQL Server and then I am okay
> again for another few days.

Try increasing the number of logins allowed on the SQL server. This
may help.

> I am running NT 4.0 and SQl 6.5 both with service pack 3 , I do
> realize this is probrally a SQL problem.

The latest SQL service pack is 4

Regards,
Graeme

---Graeme Slogrove, BSc (Eng) Elec (Wits)FastLight Data Distribution cchttp://www.fdd.netTel: +27-(0)11-706-0212 Fax: +27-(0)11-706-0812

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 2 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Crystal ReportFrom: "Olivier Astier (Echoweb)" <astier@echoweb.net>Date: Thu, 25 Jun 1998 10:24:27 -0700

Hi all,In order to detect modems failures I wrote an SQL query that shows, for theNAS Port that are currently unused, the last time the port was used (thelast time someone logged off)I would like to create a Crystal Reports that displays the same results (Iuse Crystal Reports 4.6) but I can't figure out how to do the "SELECTMAX(CallDate)" through CR.There may be a way to do the query differently so that it would be easier toimport in CRAny help would be really appreciated.Thank you for your attention.

Oliver EchoWeb LLC.

The query is :SELECT c1.NasIdentifier, c1.NasPort, MAX(c1.CallDate)FROM Calls c1, Calls c2WHERE c1.AcctStatusType=2 AND c2.AcctStatusType=1 AND c1.NasIdentifier=c2.NasIdentifier AND c1.NasPort=c2.NasPortGROUP BY c1.NasIdentifier, c1.NasPort HAVING MAX(c1.CallDate)>MAX(c2.CallDate)ORDER BY c1.NasIdentifier DESC, c1.NasPort

..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 3 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: over billingFrom: "Sean Cook" <scook@centramedia.com>Date: Thu, 25 Jun 1998 12:37:49 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_000B_01BDA036.10645190Content-Type: text/plain; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

I am having some problems with over billing. If I understand correctly, =I would use Standard to set the number of hours the account would be =able to log on. If I have 'Allow Overtime' checked, the account should =be able to log on to the system and use the Internet past the defined =hours in Standard. I should enter the overtime rate in 'Over Charge.'=20

The following is a sample bill invoiced and sent out.

LOGIN DESCRIPTION = AMOUNT-------------------------------------------------------------------------=--------------------------------------=20ZZZZZZ PPP Dialup 25 Hours = $ 16.18 May 98 usage of 5 hours = $ 74.75 Jun 98 usage of 3 hours = $ 44.85

The service type has a base cost of 14.95. The amounts charged, 5 * =14.95 =3D $74.75 ; and 3 * 14.95 =3D $44.85 should be more around $4.95 =and $2.97. Why is emerald charging the base cost for every hour? What do =I have configured incorrectly? Any help would be greatly appreciated.

Thank you in advance,

Sean CookTechnical Support, Centramedia Incorporatedtechsppt@centramedia.net or scook@centramedia.net806-665-0106

------=_NextPart_000_000B_01BDA036.10645190Content-Type: text/html; charset="iso-8859-1"Content-Transfer-Encoding: quoted-printable

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

I am having some problems with over billing. If I =understand=20correctly, I would use Standard to set the number of hours the account =would be=20able to log on. If I have 'Allow Overtime' checked, the account should =be able=20to log on to the system and use the Internet past the defined hours in =Standard.=20I should enter the overtime rate in 'Over Charge.'

The following is a sample bill invoiced and sent=20out.

----------------------------------------------------------------=-----------------------------------------------

ZZZZZZ &nbs=p; =; =20PPP Dialup 25=20Hours &n=bsp; &nb=sp; =20$ 16.18

&nbs=p; =; ==20May 98 usage of 5=20hours &n=bsp; =20$ 74.75

&n=bsp; &nb=sp; &nbs=p; =20Jun 98 usage of 3=20hours &n=bsp; =20$ 44.85

The service type has a base cost of 14.95. The =amounts=20charged, 5 * 14.95 =3D $74.75 ; and 3 * 14.95 =3D $44.85 should be =more around=20$4.95 and $2.97. Why is emerald charging the base cost for every hour? =What do I=20have configured incorrectly? Any help would be greatly =appreciated.

Thank you in advance,

Sean Cook
Technical Support, =Centramedia=20Incorporated
techsppt@centramedia.net or =scook@centramedia.net
806-66=5-0106

------=_NextPart_000_000B_01BDA036.10645190--..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 4 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: over billingFrom: Dale Reed Date: Thu, 25 Jun 1998 10:53:05 -0700> Sean Cook wrote:> > I am having some problems with over billing. If I understand> correctly, I would use Standard to set the number of hours the account> would be able to log on. If I have 'Allow Overtime' checked, the> account should be able to log on to the system and use the Internet> past the defined hours in Standard. I should enter the overtime rate> in 'Over Charge.'You need to set the standard charge (which is the per-hour charge forusage below the standard hours setting) to 0 if you are not charginga per-hour cost. For example, if you ive 10 hours free, you shouldset standard hours to 10 and standard charge to 0. The Service basecost (which is not the same as usage charges) is configured in theservice configuration, not the rate configuration.> ZZZZZZ PPP Dialup 25> Hours $ 16.18> May 98 usage of 5> hours $ 74.75> Jun 98 usage of 3> hours $ 44.85> > The service type has a base cost of 14.95. The amounts charged, 5 *> 14.95 = $74.75 ; and 3 * 14.95 = $44.85 should be more around $4.95> and $2.97. Why is emerald charging the base cost for every hour? What> do I have configured incorrectly? Any help would be greatly> appreciated.Mainly, because you told it to. :) Change standard cost to 0 and itshould do what you want it to do.-- 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 5 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Optimize MS SQL & EmeraldFrom: John Lange Date: Thu, 25 Jun 1998 14:34:49 -0500HII need some advise on this topic...Please read before you flame me for having such a slow server. That is thereason for this eMail.Currently our SQL Server is the following:NT 4.0 sp3MS SQL 6.5Intel P13396 MB Ram3GB Ultra DMA IDEThis machine was fine when we only had 500 users, now with 1300 we arefinding that it isn't filling our needs. We need to optimize our serverfor one specific reason.1. Running checkdb, nightly maint, truncate, delete start records, andother SQL intensive process takes FOOOOOREVER!!! Like 3 hours each.It auths just fine, reports go OK, and 95% of the time it is overkill,because it just sits there at about 5 - 10% utilization.(Un)-fortunatly, we run SQLMAINT.exe and do a datadump and other process's,every night about 3AM and no one can log in during the next 3 hours becausethe server is so busy it won't auth. I have thought about running a textfile version on the secondary radius server, but I am afraid the text filewill not get run EVERY night, so new users will not be able to log in.Is there a way to optimize the servers memory or do something to speed upthis process. The server is only using about 50MB of the available ram.Will increasing it's SQL usage help much?Our datadumps get to about 300MB before we delete the start records andtruncate. Will it help to have more ram? More ram alocatted to SQL?HELP!JOhn :}John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 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 6 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Optimize MS SQL & EmeraldFrom: "Robert H. Clugston" Date: Thu, 25 Jun 1998 13:00:15 -0700I run my Radius/SQL server on a PII-300 with an Adaptec (1mb) raid-5controller with 3 UWSCSI hard drives. I also have 128mB of ram. This workspretty good, expect I wish I bought a DPT card instead of an Adapteccontroller. This setup cost me 7 bills a year ago 1 of which was for therack mount case.If you run SQL on the same machine as your Radius you may want to separatethem and give the better hardware to the radius server.Before this machine I ran the same exact setup as you p133, 96mb of ram, 3gbhard drive, and NT SP3 SQL 6.5. Also it turned out the majority of the slowon this machine was bad ram. I found this out when I used the ram on a Linuxmail server it was dog slow and it was eating the ram.-----Original Message-----From: emerald-request@iea-software.com[mailto:emerald-request@iea-software.com] On Behalf Of John LangeSent: Thursday, June 25, 1998 12:35 PMTo: emerald@iea-software.comSubject: Optimize MS SQL & EmeraldHII need some advise on this topic...Please read before you flame me for having such a slow server. That is thereason for this eMail.Currently our SQL Server is the following:NT 4.0 sp3MS SQL 6.5Intel P13396 MB Ram3GB Ultra DMA IDEThis machine was fine when we only had 500 users, now with 1300 we arefinding that it isn't filling our needs. We need to optimize our serverfor one specific reason.1. Running checkdb, nightly maint, truncate, delete start records, andother SQL intensive process takes FOOOOOREVER!!! Like 3 hours each.It auths just fine, reports go OK, and 95% of the time it is overkill,because it just sits there at about 5 - 10% utilization.(Un)-fortunatly, we run SQLMAINT.exe and do a datadump and other process's,every night about 3AM and no one can log in during the next 3 hours becausethe server is so busy it won't auth. I have thought about running a textfile version on the secondary radius server, but I am afraid the text filewill not get run EVERY night, so new users will not be able to log in.Is there a way to optimize the servers memory or do something to speed upthis process. The server is only using about 50MB of the available ram.Will increasing it's SQL usage help much?Our datadumps get to about 300MB before we delete the start records andtruncate. Will it help to have more ram? More ram alocatted to SQL?HELP!JOhn :}John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 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 7 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Optimize MS SQL & EmeraldFrom: list_rx@qcom.netDate: Thu, 25 Jun 1998 14:56:16 +0000>>Currently our SQL Server is the following:>NT 4.0 sp3>MS SQL 6.5>Intel P133 <- Buy a chip.>96 MB Ram <- Increase RAM>3GB Ultra DMA IDE <- GO SCSI!>SWAP FILE SIZE <- ImportantThe phrase - mo=betta applies here...------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 8 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Optimize MS SQL & EmeraldFrom: "Richard Sensale" Date: Thu, 25 Jun 1998 16:04:52 -0700We run our SQL and Radius on the same box.PII 233 128MB RAM, Adaptec Ultra Wide SCSI with a High End Seagate SCSIdrive. We use SQL 6.5 and the radius 2.2. On NT 4.0 SP3, Our responsetimes are pretty good. I would suggest upgrading your CPU, and RAM and SCSIdoes help. Also make sure you have a decent swap file size. ALso try not torun too much else on the same box. The more the merrier is very applicableto this box.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: John Lange To: emerald@iea-software.com Date: Thursday, June 25, 1998 7:31 AMSubject: Optimize MS SQL & Emerald>HI>>I need some advise on this topic...>>Please read before you flame me for having such a slow server. That is the>reason for this eMail.>>Currently our SQL Server is the following:>NT 4.0 sp3>MS SQL 6.5>Intel P133>96 MB Ram>3GB Ultra DMA IDE>>This machine was fine when we only had 500 users, now with 1300 we are>finding that it isn't filling our needs. We need to optimize our server>for one specific reason.>>1. Running checkdb, nightly maint, truncate, delete start records, and>other SQL intensive process takes FOOOOOREVER!!! Like 3 hours each.>>It auths just fine, reports go OK, and 95% of the time it is overkill,>because it just sits there at about 5 - 10% utilization.>>(Un)-fortunatly, we run SQLMAINT.exe and do a datadump and other process's,>every night about 3AM and no one can log in during the next 3 hours because>the server is so busy it won't auth. I have thought about running a text>file version on the secondary radius server, but I am afraid the text file>will not get run EVERY night, so new users will not be able to log in.>>Is there a way to optimize the servers memory or do something to speed up>this process. The server is only using about 50MB of the available ram.>Will increasing it's SQL usage help much?>>Our datadumps get to about 300MB before we delete the start records and>truncate. Will it help to have more ram? More ram alocatted to SQL?>>HELP!>JOhn :}>>>John C. Lange, Sr. PALACE dot NET, INC.>microjl@palacenet.net MICRO-TECH Computers, Inc.>608.742.1601 & 6980 2800 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> --- (_)/ (_)>..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 9 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Sql error 1060From: Phil Blancett Date: Thu, 25 Jun 1998 13:33:26 -0700Hello All, We tried to do call consolidation on our server today. Lasttime we did it was about 4 weeks ago. After about 30 minuteswe tried to back out of it by restarting the server. At that timewe tried to restart SQL and Radius and we get this error on theSEM server:Error 1060 - (The specified service does not exist as a installedservice) occurred while performing this service operation on theMSSQL service.Is there anyway I can get back in and try to rerun call consolidation?TIA..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 10 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Optimize MS SQL & EmeraldFrom: John Lange Date: Thu, 25 Jun 1998 15:42:00 -0500HIThis machine I can afford.How long does Dale's checkdb.sql take to run on your system and how muchdata do you have?Our Secondary Radius Server sometimes looses it's connection while runningthese process, so unloading radius from the SQL server probably won't help.JOhn :}At 04:04 PM 6/25/1998 -0700, you wrote:>We run our SQL and Radius on the same box.>PII 233 128MB RAM, Adaptec Ultra Wide SCSI with a High End Seagate SCSI>drive. We use SQL 6.5 and the radius 2.2. On NT 4.0 SP3, Our response>times are pretty good. I would suggest upgrading your CPU, and RAM and SCSI>does help. Also make sure you have a decent swap file size. ALso try not to>run too much else on the same box. The more the merrier is very applicable>to this box.>>Richard Sensale>Network Administrator>VisitUs Internet, Inc.>5468 Schaefer Road>Dearborn, MI 48126 USA>(313) 945-5588>(313) 945-0202 fax>http://www.visitus.net>richards@visitus.net>-----Original Message----->From: John Lange >To: emerald@iea-software.com >Date: Thursday, June 25, 1998 7:31 AM>Subject: Optimize MS SQL & Emerald>>>>HI>>>>I need some advise on this topic...>>>>Please read before you flame me for having such a slow server. That is the>>reason for this eMail.>>>>Currently our SQL Server is the following:>>NT 4.0 sp3>>MS SQL 6.5>>Intel P133>>96 MB Ram>>3GB Ultra DMA IDE>>>>This machine was fine when we only had 500 users, now with 1300 we are>>finding that it isn't filling our needs. We need to optimize our server>>for one specific reason.>>>>1. Running checkdb, nightly maint, truncate, delete start records, and>>other SQL intensive process takes FOOOOOREVER!!! Like 3 hours each.>>>>It auths just fine, reports go OK, and 95% of the time it is overkill,>>because it just sits there at about 5 - 10% utilization.>>>>(Un)-fortunatly, we run SQLMAINT.exe and do a datadump and other process's,>>every night about 3AM and no one can log in during the next 3 hours because>>the server is so busy it won't auth. I have thought about running a text>>file version on the secondary radius server, but I am afraid the text file>>will not get run EVERY night, so new users will not be able to log in.>>>>Is there a way to optimize the servers memory or do something to speed up>>this process. The server is only using about 50MB of the available ram.>>Will increasing it's SQL usage help much?>>>>Our datadumps get to about 300MB before we delete the start records and>>truncate. Will it help to have more ram? More ram alocatted to SQL?>>>>HELP!>>JOhn :}>>>>>>John C. Lange, Sr. PALACE dot NET, INC.>>microjl@palacenet.net MICRO-TECH Computers, Inc.>>608.742.1601 & 6980 2800 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>> --- (_)/ (_)>>>>>John C. Lange, Sr. PALACE dot NET, INC.microjl@palacenet.net MICRO-TECH Computers, Inc.608.742.1601 & 6980 2800 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 11 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Optimize MS SQL & EmeraldFrom: "Pat Augustine" Date: Thu, 25 Jun 1998 16:48:11 -0400 When we had a slower machine we would always generate a new Users file justbefore consolidation, and restart radius in Text Only mode on the backupserver with that new Users file. Once consolidation finished, we'd restartRadius on the primary in ODBC mode, but we basically had to do it by hand soas to not interfere with logins. We also scheduled those heavy events tohappen less frequently and during the day when I could make changes likerestarting Radius, instead of at night automatically. Now that we have a P2300, however, it runs in the background and doesn't prevent logins.Pat AugustineInterlink America-----Original Message-----From: John Lange To: emerald@iea-software.com Date: Thursday, June 25, 1998 4:39 PMSubject: Re: Optimize MS SQL & Emerald>HI>>This machine I can afford.>>How long does Dale's checkdb.sql take to run on your system and how much>data do you have?>>Our Secondary Radius Server sometimes looses it's connection while running>these process, so unloading radius from the SQL server probably won't help.>>JOhn :}>>At 04:04 PM 6/25/1998 -0700, you wrote:>>We run our SQL and Radius on the same box.>>PII 233 128MB RAM, Adaptec Ultra Wide SCSI with a High End Seagate SCSI>>drive. We use SQL 6.5 and the radius 2.2. On NT 4.0 SP3, Our response>>times are pretty good. I would suggest upgrading your CPU, and RAM andSCSI>>does help. Also make sure you have a decent swap file size. ALso try notto>>run too much else on the same box. The more the merrier is veryapplicable>>to this box.>>>>Richard Sensale>>Network Administrator>>VisitUs Internet, Inc.>>5468 Schaefer Road>>Dearborn, MI 48126 USA>>(313) 945-5588>>(313) 945-0202 fax>>http://www.visitus.net>>richards@visitus.net>>-----Original Message----->>From: John Lange >>To: emerald@iea-software.com >>Date: Thursday, June 25, 1998 7:31 AM>>Subject: Optimize MS SQL & Emerald>>>>>>>HI>>>>>>I need some advise on this topic...>>>>>>Please read before you flame me for having such a slow server. That isthe>>>reason for this eMail.>>>>>>Currently our SQL Server is the following:>>>NT 4.0 sp3>>>MS SQL 6.5>>>Intel P133>>>96 MB Ram>>>3GB Ultra DMA IDE>>>>>>This machine was fine when we only had 500 users, now with 1300 we are>>>finding that it isn't filling our needs. We need to optimize our server>>>for one specific reason.>>>>>>1. Running checkdb, nightly maint, truncate, delete start records, and>>>other SQL intensive process takes FOOOOOREVER!!! Like 3 hours each.>>>>>>It auths just fine, reports go OK, and 95% of the time it is overkill,>>>because it just sits there at about 5 - 10% utilization.>>>>>>(Un)-fortunatly, we run SQLMAINT.exe and do a datadump and otherprocess's,>>>every night about 3AM and no one can log in during the next 3 hoursbecause>>>the server is so busy it won't auth. I have thought about running a text>>>file version on the secondary radius server, but I am afraid the textfile>>>will not get run EVERY night, so new users will not be able to log in.>>>>>>Is there a way to optimize the servers memory or do something to speed up>>>this process. The server is only using about 50MB of the available ram.>>>Will increasing it's SQL usage help much?>>>>>>Our datadumps get to about 300MB before we delete the start records and>>>truncate. Will it help to have more ram? More ram alocatted to SQL?>>>>>>HELP!>>>JOhn :}>>>>>>>>>John C. Lange, Sr. PALACE dot NET, INC.>>>microjl@palacenet.net MICRO-TECH Computers, Inc.>>>608.742.1601 & 6980 2800 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>>> --- (_)/ (_)>>>>>>>>>>>John C. Lange, Sr. PALACE dot NET, INC.>microjl@palacenet.net MICRO-TECH Computers, Inc.>608.742.1601 & 6980 2800 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> --- (_)/ (_)>..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 12 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Backup Radius ServerFrom: "Mike Roberts" Date: Thu, 25 Jun 1998 16:54:00 -0600What are the options for running a primary and secondary Emerald/RADIUSsetup? I need to have a fairly synchronized redundant secondary RADIUSserver before I commit to the Emerald product.How are others doing it?*Mike Roberts*DataWest Internet, LLC*Colorado Springs - http://www.datawest.net*(719) 633-5804 - ICQ 387413..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 13 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Backup Radius ServerFrom: "Greg Dobinson" Date: Thu, 25 Jun 1998 19:22:19 -0500We are running a secondary Radius server in text mode as a backup. We justexport a Radius users file every time a number of accounts have been added. It seems to work very well and we have not had a problem with it(even asfar as not knowing when our primary was down!) This option however (as faras I know) doesn't allow you to log the accounting info to your SQLdatabase. The other option would be to have a secondary Radius serverrunning with a backup SQL server handling the accounting info. This alsoworks well but requires to to setup replication between primary and backupSQL servers.Hope this helps.Some other list members will probably be able to expand/add to this aswell.> > What are the options for running a primary and secondary Emerald/RADIUS> setup? I need to have a fairly synchronized redundant secondary RADIUS> server before I commit to the Emerald product.> > How are others doing it?> > *Mike Roberts> *DataWest Internet, LLC> *Colorado Springs - http://www.datawest.net> *(719) 633-5804 - ICQ 387413..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 14 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: RE: Backup Radius ServerFrom: "Richard Lachance" Date: Thu, 25 Jun 1998 21:30:15 -0400> What are the options for running a primary and secondary Emerald/RADIUS> setup? I need to have a fairly synchronized redundant secondary RADIUS> server before I commit to the Emerald product.You should take a look at our Proxy & Roaming RADIUS Server (PRRS). In itsproxy mode, the PRRS is simply a packet dispatcher between the NAS'es andthe RADIUS server, caching every reply received from the RADIUS server inthe process. If it goes down, the PRRS replies from its cache and if theuser is not in the cache, the PRRS can also build a "default" authenticationreply, based on the business rules configured in the PRRS.While the RADIUS server is down, the PRRS acknowledges accounting packetsand stores them in a chronological queue until the RADIUS server returns, atwhich point they are forwarded. This way, ISPs using online time to dobilling don't lose revenues this way.The PRRS also has a watchdog engine that monitors its state and restarts theservice if it fails, so it is very unlikely the PRRS will fail to reply fora period longer than 20 seconds.This redundancy has a few advantages over using the "secondary server"method.You can see more details on the product at http://www.vircom.com/prrs/..------ ------ ------ ------ ------ ------ ------ ------ ------ ------.| Message 15 |'------ ------ ------ ------ ------ ------ ------ ------ ------ ------'Subject: Re: Backup Radius ServerFrom: Dale Reed Date: Thu, 25 Jun 1998 22:14:10 -0700Mike Roberts wrote:> > What are the options for running a primary and secondary Emerald/RADIUS> setup? I need to have a fairly synchronized redundant secondary RADIUS> server before I commit to the Emerald product.> > How are others doing it?There are many ways, with the most popular being to use a second text only instance of RadiusNT. We are working on a better way of doing this, by having RadiusNT itself maintain the textfile so that you don't have to have two different implementationsof RadiusNT (just two the same).-- 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 Reed: "Re: Backup Radius Server"
Next message: Waldemar Born: "RE: Optimize MS SQL & Emerald"