Hello Tony -
You should probably upgrade to Radiator 3.2 and try this again while
running radiusd from the console so you can see the Perl error message
that is causing the crash (or use restartWrapper).
When you have the Perl error message, please send it to me so I can see
what is happening.
regards
Hugh
On Tuesday, August 20, 2002, at 06:52 AM, Tony Bunce wrote:
> We have been running radiator for a long time now and have not had any
> problems, but have one issue
>
> I have the conf file such that if our AuthBy SQL ignores the request
> then it goes to AuthBy File. This way if the sql server dies users can
> still authenticate on the flat file
>
> We have never had problems with the sql server (MySql) but I was trying
> to test the authby file by stopping the sql server. Radiator looses
> it's connection then dies w/o logging anything
>
> Here is conf:
>
> #Foreground
> #LogStdout
> LogDir /var/log/radius
> DbDir /etc/radiator
> DictionaryFile %D/dictionary
>
>
>
> # it to 4 or 5 for debugging, or use the -trace flag to radiusd
> Trace 4
>
> #AuthPort 2900
> #AcctPort 2901
>
> #Lower case
> RewriteUsername tr/A-Z/a-z/
>
> #Remove Spaces
> RewriteUsername s/\s+//g
>
>
> #DateFormat '%Y-%M-%d %T'
>
>
> DBSource DBI:Sybase:database=bill2;server=GO19
> DBUsername
> DBAuth
> GetClientQuery select
> NASIDENTIFIER,SECRET,IGNOREACCTSIGNATURE,DUPINTERVAL,DEFAULTREALM,NASTYPE,
>
>SNMPCOMMUNITY,LIVINGSTONOFFS,LIVINGSTONHOLE,FRAMEDGROUPBASEADDRESS,FRAMEDGROUPMAXPORTSPERCLASSC,
>
> REWRITEUSERNAME,NOIGNOREDUPLICATES,PREHANDLERHOOK,NULL,NULL,NULL,NULL,NULL,
> NULL,NULL,NULL,FLAGS from NASClients
> #UseOldAscendPasswords
>
>
>
>
> DBSource dbi:mysql:radius:207.40.xxx.xx
> DBUsername
> DBAuth
>
>
>
> DBSource dbi:mysql:radius:207.40.xxx.xx
> DBUsername
> DBAuth
>
> Table RADLOG
>
>
>
> Identifier AuthLogMySql
> DBSource dbi:mysql:radius:207.40.xxx.xx
> DBUsername
> DBAuth
> Table AuthLog
> FailureQuery INSERT into AuthLog (SeverityLevel, Username,
> SubmitedPassword, Reason, Date) VALUES (%0, '%U','%P',%1, '%Y-%m-%d
> %H:%M:%S')
> LogFailure 1
>
>
>
>
>
> RewriteUsername s/^([^@]+).*/$1/
> #PasswordLogFileName %L/password.log
>
>
> Timeout 10
> NoDefaultIfFound
> DefaultSimultaneousUse 1
> CaseInsensitivePasswords
> RejectEmptyPassword
>
> Identifier GOCsql
> DefaultReply Ascend-Shared-Profile-
> Enable=0,Service-Type=Framed-User,Framed-Protocol=PPP,Framed-
> Routing=None,Ascend-Base-Channel-Count=1,Ascend-Minimum-
> Channels=1,Ascend-Maximum-Channels=1,Ascend-Assign-IP-
> Pool=1,Ascend-Multicast-Client=Multicast-Yes
>
> DBSource DBI:Sybase:database=bill2;server=GO19
> DBUsername
> DBAuth
>
> AuthSelect AuthSelect '%n'
>
> AuthColumnDef 0, User-Password, check
> AuthColumnDef 1, Framed-IP-Address, reply
> AuthColumnDef 2, Framed-Netmask, reply
> #AuthColumnDef 3, Ascend-Maximum-Channels, reply
> AuthColumnDef 3, GENERIC, reply
> AuthColumnDef 4, GENERIC, check
>
>
> #AddToReplyIfNotExist User-Service=Framed-
> User,Framed-Protocol=PPP,Framed-Routing=None,Ascend-Base-Channel-
> Count=1,Ascend-Minimum-Channels=1,Ascend-Maximum-
> Channels=1,Ascend-Assign-IP-Pool=1,Ascend-Multicast-Client=Multicast-Yes
> AddToReplyIfNotExist Framed-Routing=None,Service-
> Type=Framed-User,Framed-Protocol=PPP
>
>
> NoDefaultIfFound
> DefaultSimultaneousUse 2
>
> AuthLog AuthLogMySql
>
>
>
>
>
> DateFormat %Y-%m-%d %T
> Identifier MySQL
> DBSource dbi:mysql:radius:207.40.xxx.xx
> DBUsername
> DBAuth
>
>
> AuthSelect
>
> AccountingTable Accounting%{Acct-Status-Type}
> #AccountingTable Accounting
> AcctColumnDef Username,%U,formatted
> AcctColumnDef TIME_STAMP,Timestamp,integer
> AcctColumnDef AcctStatusType,Acct-Status-Type
> AcctColumnDef SessionID,Acct-Session-Id
> AcctColumnDef SessionTime,Acct-Session-Time,integer
> AcctColumnDef DisconnectCause,Ascend-Disconnect-
> Cause,integer
> AcctCo