I've designed my config file to work even if the database goes down.
I don't want our users to suffer if we have a database outage, so I've tried
to make it so that <AuthBy TEST> goes into effect if the request to the
database is ignored. When I rebooted our database, radiator just sits there
doing nothing and not replying to auth/acct requests. When the database
comes back up, it begins to function again. Is there anything I can do to
make this work better? I was observing this on my linux box. I've included
a copy of the config file from my NT box (it runs the same config except
for NT specific options).
John Kicklighter
Internet 2xtreme
========= Radiator v2.13 w/patched handler.pm ==========
LogStdout
LogDir .
DbDir .
Trace 4
AuthPort 1645
AcctPort 1646
DictionaryFile /programs/radiator/dictionary.2xtreme
RewriteUsername tr/-A-Za-z0-9\.\@//cd
RewriteUsername tr/A-Z/a-z/
<Client pm.2xtreme.net>
Secret XXXXXXXX
DupInterval 0
NasType Livingston
</Client>
# Allow Multiple Logins for the Test account
<Handler User-Name=test>
<AuthBy EMERALD>
DBSource dbi:ODBC:Platypus2
DBUsername xxxx
DBAuth xxxx
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef CallDate,Timestamp,integer-date
AcctColumnDef AcctStatusType,Acct-Status-Type,integer
AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef AcctSessionId,Acct-Session-Id
AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
AcctColumnDef AcctTerminateCause,Acct_Terminate-Cause
AcctColumnDef NASIdentifier,Client-Id
AcctColumnDef NASPort,NAS-Port,integer
AcctColumnDef FramedAddress,Framed-Address
AddToReply Idle-Timeout = "1200"
</AuthBy>
</Handler>
<Handler>
MaxSessions 1
AuthByPolicy ContinueWhileIgnore
PasswordLogFileName %L/logins/%m%d%Y-password.log
AcctLogFileName %L/logs/%m%d%Y.log
<AuthBy GROUP>
AuthByPolicy ContinueWhileAccept
# Apply some pre-database "Time" checks
<AuthBy FILE>
Filename /ftpusers/radiator/users
AcceptIfMissing
</AuthBy>
<AuthBy EMERALD>
DBSource dbi:ODBC:Platypus2
DBUsername xxxx
DBAuth xxxx
AccountingTable Calls
AcctColumnDef UserName,User-Name
AcctColumnDef CallDate,Timestamp,integer-date
AcctColumnDef AcctStatusType,Acct-Status-Type,integer
AcctColumnDef AcctDelayTime,Acct-Delay-Time,integer
AcctColumnDef AcctInputOctets,Acct-Input-Octets,integer
AcctColumnDef AcctOutputOctets,Acct-Output-Octets,integer
AcctColumnDef AcctSessionId,Acct-Session-Id
AcctColumnDef AcctSessionTime,Acct-Session-Time,integer
AcctColumnDef AcctTerminateCause,Acct_Terminate-Cause
AcctColumnDef NASIdentifier,Client-Id
AcctColumnDef NASPort,NAS-Port,integer
AcctColumnDef FramedAddress,Framed-Address
AddToReply Idle-Timeout = "1200"
</AuthBy>
</AuthBy>
<AuthBy TEST>
</AuthBy>
</Handler>
<SessionDatabase SQL>
DBSource dbi:ODBC:xxxx
DBUsername xxxx
DBAuth xxxx
AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE) values
('%n', '%N', %{NAS-Port}, '%{Acct-Session-Id}', %{Timestamp}, '%{Framed-Address}',
'%{NAS-Port-Type}', '%{User-Service}')
</SessionDatabase SQL>
===
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.