(RADIATOR) radiator dies w/sql

[Tony Bunce]

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:   Trace   4    #Lower case RewriteUsername   tr/A-Z/a-z/   #Remove Spaces RewriteUsername          s/\s+//g     <ClientListSQL>                 DBSource DBI:Sybase:database=<DB>;server=<SRV>                 DBUsername <CUT>                 DBAuth <CUT>                 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 </ClientListSQL>   <SessionDatabase SQL>         DBSource dbi:mysql:radius:207.40.xxx.xx         DBUsername <CUT>         DBAuth  <CUT> </SessionDatabase>   <Log SQL>         DBSource dbi:mysql:radius:207.40.xxx.xx         DBUsername <CUT>         DBAuth  <CUT>           Table RADLOG </Log>  <AuthLog SQL>         Identifier AuthLogMySql         DBSource dbi:mysql:radius:207.40.xxx.xx         DBUsername <CUT>         DBAuth  <CUT>         Table AuthLog         FailureQuery INSERT into AuthLog (SeverityLevel, Username, SubmitedPassword, Reason, Date) VALUES (%0, '%U','%P',%1, '%Y-%m-%d %H:%M:%S')         LogFailure 1 </AuthLog>  <Handler Request-Type=Access-Request>         RewriteUsername s/^([^@]+).*/$1/           <AuthBy SQL>                 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 <CUT>                 DBAuth <CUT>                   AuthSelect AuthSelect '%n'                   AuthColumnDef 0, User-Password, check                 AuthColumnDef 1, Framed-IP-Address, reply                 AuthColumnDef 2, Framed-Netmask, reply                 AuthColumnDef 3, GENERIC, reply                 AuthColumnDef 4, GENERIC, check                   AddToReplyIfNotExist Framed-Routing=None,Service-Type=Framed-User,Framed-Protocol=PPP         </AuthBy SQL>         <AuthBy FILE>                 NoDefaultIfFound                 DefaultSimultaneousUse 2         </AuthBy FILE>         AuthLog AuthLogMySql </Handler>   And The Error Log:   Wed Aug 14 13:39:25 2002: ERR: do failed for 'delete from RADONLINE where NASIDENTIFIER='207.40.122.227' and NASPORT=020312': Lost  connection to MySQL server during query #THIS IS WHERE I RESTARTED IT b/c IT DIED Wed Aug 14 13:40:44 2002: DEBUG: Adding Clients from SQL database Wed Aug 14 13:40:44 2002: DEBUG: Query is: select NASIDENTIFIER,SECRET,IGNOREACCTSIGNATURE,DUPINTERVAL,DEFAULTREALM,NASTYPE,SNMPCOM   Wed Aug 14 13:40:44 2002: DEBUG: Reading users file /etc/radiator/users Wed Aug 14 13:40:44 2002: INFO: Server started: Radiator 3.0 on rad1.go-concepts.com   Thanks for the help   Thanks, Tony B, CCNA, Network+ Systems Administration GO Concepts, Inc. / www.go-concepts.com Are you on the GO yet? What about those you know, are they on the GO? 513.934.2800 1.888.ON.GO.YET