net stop radiusnt
cd c:\sql60\binn
isql -E -Q "load database emerald from emeraldremdump"
net start radiusnt
Worst case scenario, we have to re-enter the current days new customers.
The portmasters are set with primary auth and accounting but only secondary
accounting. Since we don't do any accounting on the secondary, there's not
an issue with someone being online from the last database dump.
We have about 5,000 users in this database and it has worked well during
crashes and maintenenance.
----------
> From: Greg Lowthian <gregr@isat.com>
> To: RadiusNT@iea-software.com
> Subject: Re: backup server
> Date: Wednesday, February 25, 1998 10:00 AM
>
> >We're relatively new to Emerald/RADIUSNT and are in the process of
trying
> >to bring up a backup RADIUS server. We're using SQL Server, and
everything
> >now runs on one machine.
> >
> >How do the rest of you handle this? Try to maintain a seperate server
and
> >somehow synchronize the databases? (there's several different ways to do
> >this that we can think of)
> >
> >Is it possible to write the SQL database to a RADIUS text file and use
that
> >on the backup machine?
> >
>
> We run 3 radius server
> Server1 does Primary authentication for all boxes and backup accounting
for
> all
> Server2 does backup authentication for 4 boxes(local) and primary
> accounting for all
> Server3 does backup authentication for 3 boxes(remote)
>
> Server1 authenticates off of ODBC/SQL
> Server2 & 3 authenticate from there user files (text mode)
> If the SQL server or main Radius server dumps in the middle of
> the night no problem.
> We run this batch file from server1 twice an hour.
> We keep drives mapped to both server2 & 3.
> The server file has the IP of the server you will login to
> using radlogin. "radusers" dumps the SQL database as
> pointed to in our case by the datasource "radius" and is
> redirected to the users file >users. *reload* is a user
> you create in Emerald that causes the user file to reload
> when a login is attempted.
>
> c:
> cd \radius
> REM updates the user file from the ODBC database
> radusers radius >users
> REM copy the user file to server 2
> copy c:\radius\users u:\radius\users
> REM copy the user file to server 3
> copy c:\radius\users v:\radius\users
> REM copy server2 IP address to the server file
> copy server8 server
> REM login to server2 with user *reload* (reloads user file)
> radlogin *reload* ????????? 1
> REM copy server3 IP address to the server file
> copy server10 server
> REM login to server3 with user *reload* (reloads user file)
> radlogin *reload* ????????? 1
> REM copies default server file back
> copy server0 server
> REM copies default user file back
> copy users1 users
>
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> If at first you don't succeed then sky diving is not for you.
>
> ---------ISAT------Internet Services and Training---------
> Greg Lowthian greg@isat.com 619-574-4832 www.isat.com
> Director of operations
> ---------NT&C------Network Training and Consulting---------
> Novell CNE certification classes 619-679-2143 www.nt-c.com
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com