Hi,
I'm testing Radiator with SQL (Oracle 8.1.6) and something strange happens.
After accessing DB (with <AutBy SQL> or <SessionDatabase SQL>), Radiator dies
and this message appears (in 10 seconds like say sessiondatabase tag below):
timeout at /usr/local/lib/perl5/site_perl/5.005/Radius/SqlDb.pm line 226
#######The logfile looks like:
*** Received from 127.0.0.1 port 61711 ....
Packet length = 79
Code: Access-Request
Identifier: 66
Authentic: 1234567890123456
Attributes:
User-Name = "NOVVISPA1"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
Framed-IP-Address = 255.255.255.254
User-Password = "<156>I<234><202><242><132><29><145>#N<222>D9%<208><12>"
Mon Nov 6 12:16:34 2000: DEBUG: Handling request with Handler 'Realm=DEFAULT'
Mon Nov 6 12:16:34 2000: DEBUG: SDB1 Deleting session for NOVVISPA1,
203.63.154.1, 1234
Mon Nov 6 12:16:34 2000: DEBUG: do query is: delete from RADONLINE where
NASIDENTIFIER='203.63.154.1' and NASPORT=01234
Mon Nov 6 12:16:34 2000: DEBUG: Handling with Radius::AuthFILE
Mon Nov 6 12:16:34 2000: DEBUG: Radius::AuthFILE looks for match with NOVVISPA1
Mon Nov 6 12:16:34 2000: DEBUG: Radius::AuthFILE ACCEPT:
Mon Nov 6 12:16:34 2000: DEBUG: Access accepted for NOVVISPA1
Mon Nov 6 12:16:34 2000: DEBUG: Packet dump:
*** Sending to 127.0.0.1 port 61711 ....
Code: Access-Accept
Identifier: 66
Authentic: 1234567890123456
Attributes:
#########And the config file:
<Realm DEFAULT>
<AuthBy FILE>
Filename %D/users
</AuthBy>
SessionDatabase SDB1
</Realm>
<Client localhost>
DupInterval 0
Secret xxxxxxx
StatusServerShowClientDetails
</Client>
<SessionDatabase SQL>
DBSource dbi:Oracle:radius
DBUsername xxxxxxxxx
DBAuth xxxxxxxxx
AddQuery insert into RADONLINE (USERNAME, NASIDENTIFIER, NASPORT,
ACCTSESSIONID, TIME_STAMP, FRAMEDIPADDRESS, NASPORTTYPE, SERVICETYPE, DNIS)
values ('%u', '%N', 0%{NAS-Port}, '%{Acct-Session-Id}', %{Timestamp},
'%{Framed-IP-Address}', '%{NAS-Port-Type}', '%{Service-Type}',
'%{Called-Station-Id}')
ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'
CountNasSessionsQuery select ACCTSESSIONID from RADONLINE where
NASIDENTIFIER='%N'
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE
where USERNAME='%n'
DeleteQuery delete from RADONLINE where NASIDENTIFIER='%N' and
NASPORT=0%{NAS-Port}
FailureBackoffTime 15
Identifier SDB1
Timeout 10
</SessionDatabase SQL>
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
