RE: (RADIATOR) radiator dies w/sql
Finally got around to testing it with version 3.3... It doesn't die like it did w/3.1...so problem solved 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 -Original Message- From: Hugh Irvine [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 3:21 AM To: Tony Bunce Cc: [EMAIL PROTECTED] Subject: Re: (RADIATOR) radiator dies w/sql 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 &
Re: (RADIATOR) radiator dies w/sql
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
(RADIATOR) radiator dies w/sql
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
AcctColumnDef ConnectProgress,Ascend-Connect-Progress,integer
AcctColumnDef NASIdentifier,NAS-Identifier
AcctColumnDef NASPort,NAS-Port,integer
AcctColumnDef ModemPort,Ascend-Modem-PortNo,integer
AcctColumnDef ModemSlot,Ascend-Modem-SlotNo,integer
AcctColumnDef IPAddress,Framed-IP-Address
AcctColumnDef XmitRate,Ascend-Xmit-Rate
AcctColumnDef DataRate,Ascend-Data-Rate
AcctColumnDef Protocol,Framed-Protocol
AcctColumnDef CallerID,Caller-Id
AcctColumnDef Date,Timestamp,integer-date
And The Error Log:
Wed Aug
(RADIATOR) radiator dies w/sql
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 DBSource DBI:Sybase:database=;server= 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/ 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, GENERIC, reply AuthColumnDef 4, GENERIC, check AddToReplyIfNotExist Framed-Routing=None,Service-Type=Framed-User,Framed-Protocol=PPP NoDefaultIfFound DefaultSimultaneousUse 2 AuthLog AuthLogMySql 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
