(RADIATOR) Re:radiator stop without a reason
Hugh Irvine
hugh at open.com.au
Wed Sep 4 22:21:31 CDT 2002
Hello Paulo -
I suspect a problem either with the DBI/DBD modules, or the database
itself.
Have you checked the MSSQL log to see what is happening?
regards
Hugh
On Thursday, September 5, 2002, at 12:01 PM, Paulo Sousa wrote:
> Hi Hugh,
>
> First, thank you for help me! :)
>
> Hardware: K6-2 400 with 64 RAM.
> Software: Debian GNU/Linux 3.0 woody
> Radiator: Version 3.3
>
> PS: This problem started with version 3.1. I've updated for 3.3 but
> still
> have problems.
>
> I'm using MSSQL for authentication.
>
>
>
> ##### radius.cfg ######
>
> LogDir /usr/local/radiator
> DbDir /usr/local/radiator
> DictionaryFile /usr/local/radiator/dictionary
>
> # Default trace = 3
> Trace 3
>
> #
> AuthPort 1645
> AcctPort 1646
>
>
> # Rescreve o username
>
> RewriteUsername s/^([^@]+)@[a-z.]+$/$1/
> RewriteUsername tr/A-Z/a-z/
> RewriteUsername s/ppp ppp/ppp/
> RewriteUsername s/\s+$//
> RewriteUsername s/^(.*) ppp$/$1/
> RewriteUsername s/^(.*)%ppp$/$1/
>
> <SessionDatabase DBM>
> Identifier SDB
> </SessionDatabase>
>
>
> # This clause defines a single client to listen to
> # You will probably want to change this to suit your site.
> <Client DEFAULT>
> Secret :)
> IgnoreAcctSignature yes
> </Client>
>
>
> #########################################################################
> #######################
> # Handlers para accounting
> #########################################################################
> #######################
>
> <Handler Acct-Status-Type = Start>
>
> AcctLogFileName /usr/local/radiator/detail/%m%d-detail
> <AuthBy SQL>
>
> Identifier ACCTSTART
> AuthSelect
>
> DBSource dbi:Sybase:server=sql;database=xxx
> DBUsername xxx
> DBAuth xxx
> Timeout 0
>
> AcctSQLStatement \
> ABRE_SESSAO \
> '%{User-Name}', \
> '%{NAS-Identifier}',\
> '%{NAS-Port}', \
> '%{Acct-Session-Id}', \
> '%{Timestamp}', \
> '%{Framed-IP-Address}', \
> '%{Service-Type}', \
> '%{Called-Station-Id}', \
> '%{Calling-Station-Id}', \
> '%{Ascend-Data-Rate}', \
> '%{Ascend-Xmit-Rate}'
> </AuthBy>
>
> </Handler>
>
> <Handler Acct-Status-Type = Stop>
>
> AcctLogFileName /usr/local/radiator/detail/%m%d-detail
> <AuthBy SQL>
>
> Identifier ACCTSTOP
> AuthSelect
>
> DBSource dbi:Sybase:server=sql;database=xxx
> DBUsername xxx
> DBAuth xxx
> Timeout 0
>
>
> AcctSQLStatement \
> FECHA_SESSAO \
> '%{Acct-Session-Id}', \
> '%{Ascend-Disconnect-Cause}', \
> '%{Acct-Delay-Time}', \
> '%{Timestamp}', \
> '%{Acct-Session-Time}', \
> '%{User-Name}', \
> '%{NAS-Identifier}',\
> '%{NAS-Port}', \
> '%{Framed-IP-Address}', \
> '%{Service-Type}', \
> '%{Called-Station-Id}', \
> '%{Calling-Station-Id}', \
> '%{Ascend-Data-Rate}', \
> '%{Ascend-Xmit-Rate}'
>
> </AuthBy>
> </Handler>
>
>
> #########################################################################
> #######################
> # Handlers para autenticacao
> #########################################################################
> #######################
>
> # Autentica Global-One
> ######################################################################
>
> <Handler NAS-Port-Type = Async,NAS-Identifier=/global-one.net$/>
>
> <AuthBy SQL>
> Identifier AsyncGO
> DynamicReply User-Name
> NoDefault
>
> DBSource dbi:Sybase:server=sql;database=xxx
> DBUsername xxx
> DBAuth xxx
> Timeout 0
>
> AuthSelect \
> \
> autentica '%n', 'Async'
>
> EncryptedPassword
>
> AddToReply Service-Type = Framed-User,\
> Framed-Protocol = PPP,\
> Framed-IP-Netmask = 255.255.255.254,\
> Framed-MTU = 1500
>
> </AuthBy>
>
> </Handler>
>
> # Autentica Intelig e AT&T (normal users)
> ##################################################
>
> <Handler NAS-Port-Type = Async>
>
> <AuthBy SQL>
> Identifier Async
> DynamicReply User-Name
> NoDefault
>
> DBSource dbi:Sybase:server=sql;database=xxx
> DBUsername xxx
> DBAuth xxx
> Timeout 0
>
> AuthSelect \
> \
> autentica '%n', 'Async'
>
> EncryptedPassword
>
> AddToReply Service-Type = Framed-User,\
> Framed-Protocol = PPP,\
> Framed-IP-Netmask = 255.255.255.254,\
> Framed-MTU = 1500
>
> </AuthBy>
>
> </Handler>
>
> # Autentica Intelig e AT&T (DVI)
> ##########################################################
>
> <Handler NAS-Port-Type = ISDN-Sync>
>
> <AuthBy SQL>
> Identifier ISDN_DVI
> DynamicReply User-Name
> NoDefault
>
> DBSource dbi:Sybase:server=sql;database=xxxx
> DBUsername xxxx
> DBAuth xxxx
> Timeout 0
>
> AuthSelect \
> \
> autentica '%n', 'ISDN-Sync'
>
> EncryptedPassword
>
> AddToReply Service-Type = Framed-User,\
> Framed-Protocol = PPP,\
> Framed-IP-Netmask = 255.255.255.254,\
> Framed-MTU = 1500
>
> </AuthBy>
>
> </Handler>
>
> # Autentica IPass
> #########################################################################
> ###
>
> <Handler NAS-Identifier = "i-Pass VNAS">
>
> <AuthBy SQL>
> Identifier IPass
> DynamicReply User-Name
> NoDefault
>
> DBSource dbi:Sybase:server=sql;database=xxx
> DBUsername xxx
> DBAuth xxx
> Timeout 0
>
> AuthSelect \
> \
> autentica '%n', 'Async'
>
> EncryptedPassword
>
> AddToReply Service-Type = Framed-User,\
> Framed-Protocol = PPP,\
> Framed-IP-Netmask = 255.255.255.254,\
> Framed-MTU = 1500
>
> </AuthBy>
>
> </Handler>
>
>
>
>
>
> ##### Debug level 4
>
> Wed Sep 4 12:22:48 2002: DEBUG: Packet dump:
> *** Received from 200.184.26.5 port 61784 ....
> Code: Access-Request
> Identifier: 226
> Authentic: s<3><127>l|<213>2Eq<26>$<249>$Y<251>k
> Attributes:
> User-Password =
> "{<209><248>\L<133><202>tF<18><134><209>k<182><254><25>"
> NAS-Identifier = "1"
> User-Name = "fnlij"
> Called-Station-Id = "34601144"
> Calling-Station-Id = "02122153366"
> NAS-Port = 16643
> NAS-Port-Type = Async
> Framed-Protocol = PPP
> Service-Type = Framed-User
>
> Wed Sep 4 12:22:48 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:48 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:48 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:48 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:48 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:48 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:48 2002: DEBUG: Handling request with Handler
> 'NAS-Port-Type = Async'
> Wed Sep 4 12:22:48 2002: DEBUG: SDB Deleting session for fnlij,
> 200.184.26.5, 16643
> Wed Sep 4 12:22:48 2002: DEBUG: Handling with Radius::AuthSQL
> Wed Sep 4 12:22:48 2002: DEBUG: Handling with Radius::AuthSQL: Async
> Wed Sep 4 12:22:48 2002: DEBUG: Query is: autentica 'fnlij', 'Async'
>
> Wed Sep 4 12:22:48 2002: DEBUG: Radius::AuthSQL looks for match with
> fnlij
> Wed Sep 4 12:22:48 2002: DEBUG: Radius::AuthSQL ACCEPT:
> Wed Sep 4 12:22:48 2002: DEBUG: Access accepted for fnlij
> Wed Sep 4 12:22:48 2002: DEBUG: Packet dump:
> *** Sending to 200.184.26.5 port 61784 ....
> Code: Access-Accept
> Identifier: 226
> Authentic: s<3><127>l|<213>2Eq<26>$<249>$Y<251>k
> Attributes:
> Service-Type = Framed-User
> Framed-Protocol = PPP
> Framed-IP-Netmask = 255.255.255.254
> Framed-MTU = 1500
>
> Wed Sep 4 12:22:49 2002: DEBUG: Packet dump:
> *** Received from 200.184.26.7 port 35010 ....
> Code: Accounting-Request
> Identifier: 253
> Authentic: zP<202><7><162><168><155><127>c)<158>)<23><17><129><10>
> Attributes:
> Acct-Status-Type = Start
> NAS-Identifier = "1"
> CVX-SS7-Session-ID-Type = 808464432
> Service-Type = Framed-User
> NAS-Port = 16643
> NAS-Port-Type = Async
> Called-Station-Id = "34601144"
> Calling-Station-Id = "02122153366"
> Acct-Delay-Time = 0
> Framed-IP-Address = 200.157.162.198
> User-Name = "fnlij"
> Framed-Protocol = PPP
> Acct-Session-Id = "00033752"
> Acct-Authentic = RADIUS
> Acct-Link-Count = 1
> Login-IP-Host = 0.0.0.0
> Login-Service = PortMaster
> Login-TCP-Port = 0
> Ascend-Modem-PortNo = 262146
> Ascend-Modem-SlotNo = 11
> Ascend-Data-Rate = 31200
> Ascend-Xmit-Rate = 33600
> Ascend-PreSession-Time = 46
>
> Wed Sep 4 12:22:49 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:49 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:49 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:49 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:49 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:49 2002: DEBUG: Rewrote user name to fnlij
> Wed Sep 4 12:22:49 2002: DEBUG: Handling request with Handler
> 'Acct-Status-Type = Start'
> Wed Sep 4 12:22:49 2002: DEBUG: SDB Adding session for fnlij,
> 200.184.26.7, 16643
> Wed Sep 4 12:22:49 2002: DEBUG: Handling with Radius::AuthSQL
> Wed Sep 4 12:22:49 2002: DEBUG: Handling accounting with
> Radius::AuthSQL
> Wed Sep 4 12:22:49 2002: DEBUG: do query is: ABRE_SESSAO 'fnlij',
> '1','16643', '00033752', '1031152969', '200.157.162.198', 'Framed-User',
> '34601144', '02122153366', '312
> 00', '33600'
>
> Wed Sep 4 12:22:49 2002: DEBUG: Accounting accepted
> Wed Sep 4 12:22:49 2002: DEBUG: Packet dump:
> *** Sending to 200.184.26.7 port 35010 ....
> Code: Accounting-Response
> Identifier: 253
> Authentic: zP<202><7><162><168><155><127>c)<158>)<23><17><129><10>
> Attributes:
>
> Wed Sep 4 12:22:50 2002: DEBUG: Packet dump:
> *** Received from 200.192.16.71 port 1646 ....
> Code: Accounting-Request
> Identifier: 159
> Authentic: B<211>Ps<186><236><229><1>u<172><233>h^<224><164>R
> Attributes:
> NAS-IP-Address = 200.192.16.71
> NAS-Port = 227
> NAS-Port-Type = Async
> User-Name = "symmetria ppp"
> Called-Station-Id = "6133"
> Calling-Station-Id = "24421825"
> Acct-Status-Type = Stop
> Acct-Authentic = RADIUS
> Service-Type = Framed-User
> Acct-Session-Id = "0001529C"
> Framed-Protocol = PPP
> Framed-IP-Address = 200.192.20.36
> Ascend-Disconnect-Cause = pppRcvTerminate
> Ascend-Pre-Input-Octets = 107
> Ascend-Pre-Output-Octets = 100
> Ascend-Pre-Input-Packets = 4
> Ascend-Pre-Output-Packets = 5
> Acct-Input-Octets = 79570
> Acct-Output-Octets = 505536
> Acct-Input-Packets = 841
> Acct-Output-Packets = 1065
> Ascend-PreSession-Time = 5
> Acct-Session-Time = 534
> Ascend-Data-Rate = 31200
> Ascend-Xmit-Rate = 48000
> Acct-Delay-Time = 0
>
> Wed Sep 4 12:22:50 2002: DEBUG: Rewrote user name to symmetria ppp
> Wed Sep 4 12:22:50 2002: DEBUG: Rewrote user name to symmetria ppp
> Wed Sep 4 12:22:50 2002: DEBUG: Rewrote user name to symmetria ppp
> Wed Sep 4 12:22:50 2002: DEBUG: Rewrote user name to symmetria ppp
> Wed Sep 4 12:22:50 2002: DEBUG: Rewrote user name to symmetria
> Wed Sep 4 12:22:50 2002: DEBUG: Rewrote user name to symmetria
> Wed Sep 4 12:22:50 2002: DEBUG: Handling request with Handler
> 'Acct-Status-Type = Stop'
> Wed Sep 4 12:22:50 2002: DEBUG: SDB Deleting session for symmetria ppp,
> 200.192.16.71, 227
> Wed Sep 4 12:22:50 2002: DEBUG: Handling with Radius::AuthSQL
> Wed Sep 4 12:22:50 2002: DEBUG: Handling accounting with
> Radius::AuthSQL
> Wed Sep 4 12:22:50 2002: DEBUG: do query is: FECHA_SESSAO '0001529C',
> 'pppRcvTerminate', '0', '1031152970', '534', 'symmetria', '','227',
> '200.192.20.36', 'Framed-User', '6133'
> , '24421825', '31200', '48000'
>
> Wed Sep 4 12:22:50 2002: DEBUG: Accounting accepted
> Wed Sep 4 12:22:50 2002: DEBUG: Packet dump:
> *** Sending to 200.192.16.71 port 1646 ....
> Code: Accounting-Response
> Identifier: 159
> Authentic: B<211>Ps<186><236><229><1>u<172><233>h^<224><164>R
> Attributes:
>
> Wed Sep 4 12:22:53 2002: DEBUG: Packet dump:
> *** Received from 200.184.26.5 port 61784 ....
> Code: Access-Request
> Identifier: 244
> Authentic: d<237>A<175>RS<242><22>i<185><204><209>`<255>-~
> Attributes:
> User-Password = "<23><181>
> <169><134>~<128>LSO<8><249>z<25><241><176>"
> NAS-Identifier = "1"
> User-Name = "duque ppp"
> Called-Station-Id = "34601144"
> Calling-Station-Id = "02125375169"
> NAS-Port = 1180
> NAS-Port-Type = Async
> Framed-Protocol = PPP
> Service-Type = Framed-User
>
> Wed Sep 4 12:22:53 2002: DEBUG: Rewrote user name to duque ppp
> Wed Sep 4 12:22:53 2002: DEBUG: Rewrote user name to duque ppp
> Wed Sep 4 12:22:53 2002: DEBUG: Rewrote user name to duque ppp
> Wed Sep 4 12:22:53 2002: DEBUG: Rewrote user name to duque ppp
> Wed Sep 4 12:22:53 2002: DEBUG: Rewrote user name to duque
> Wed Sep 4 12:22:53 2002: DEBUG: Rewrote user name to duque
> Wed Sep 4 12:22:53 2002: DEBUG: Handling request with Handler
> 'NAS-Port-Type = Async'
> Wed Sep 4 12:22:53 2002: DEBUG: SDB Deleting session for duque ppp,
> 200.184.26.5, 1180
> Wed Sep 4 12:22:53 2002: DEBUG: Handling with Radius::AuthSQL
> Wed Sep 4 12:22:53 2002: DEBUG: Handling with Radius::AuthSQL: Async
> Wed Sep 4 12:22:53 2002: DEBUG: Query is: autentica 'duque', 'Async'
>
>
>
> At this point, my radiator stop... My machine still alive and fine... I
> kill radiator pid and start it again...
>
>
> Thank you
>
> Paulo Sousa
>
>
>>
>> Hello Paul -
>>
>> I will need to know what hardware/sorftware platform you are using
>> and I
>> will need to see a copy of your configuration file (no secrets)
>> together
>> with a trace 4 debug showing what is happening. I will also need to
>> know
>> what version of Radiator you are running.
>>
>> regards
>>
>> Hugh
>>
>>
>> On Thursday, September 5, 2002, at 03:36 AM, Paulo Sousa wrote:
>>
>>>
>>> Hi
>>>
>>> I hava a strange problem... Radiator works fine but after 4 or 5 days
>>> running (maybe on 3rd day) its stop without a reason... Proccess still
>>> running but no autentication is made.
>>>
>>> When its happen I just restart and its came back ok.
>>>
>>> Anyone knows why its occour???
>>>
>>> Thanks
>>>
>>> Paulo Sousa
>>>
>>>
>>> ===
>>> Archive at http://www.open.com.au/archives/radiator/
>>> Announcements on radiator-announce at open.com.au
>>> To unsubscribe, email 'majordomo at open.com.au' with
>>> 'unsubscribe radiator' in the body of the message.
>>>
>>>
>>
>> --
>> Radiator: the most portable, flexible and configurable RADIUS server
>> anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
>> -
>> Nets: internetwork inventory and management - graphical, extensible,
>> flexible with hardware, software, platform and database independence.
>>
>> ===
>> Archive at http://www.open.com.au/archives/radiator/
>> Announcements on radiator-announce at open.com.au
>> To unsubscribe, email 'majordomo at open.com.au' with
>> 'unsubscribe radiator' in the body of the message.
>>
>
>
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
>
>
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.
More information about the radiator
mailing list