Hello Daniel -
Mike has put the patches up in the download area. You will need both radiusd
and SqlDb.pm. Please let us know how you get on.
regards
Hugh
> >
> > 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>
> >
--
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald,
Platypus, Freeside, Interbiller, TACACS+, PAM, external, etc, etc.
Available on Unix, Linux, FreeBSD, Windows 95/98/2000, NT, MacOS X.
===
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.
