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'
ClientListSQL
DBSource DBI:Sybase:database=bill2;server=GO19
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/
#PasswordLogFileName %L/password.log
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, 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
/AuthBy SQL
AuthBy FILE
NoDefaultIfFound
DefaultSimultaneousUse 2
/AuthBy FILE
AuthLog AuthLogMySql
/Handler
Handler Request-Type=Accounting-Request
AuthBy SQL
DateFormat %Y-%m-%d %T
Identifier MySQL
DBSource dbi:mysql:radius:207.40.xxx.xx