(RADIATOR) Session Database

[Kitabjian, Dave]

Hey.

1) Have you tested INSERTing to your DB from the command line to make sure
it's working? Perhaps from a Perl command line?

2) Put "Trace  4" in your config file, restart Radiator, try again, and then
let us know what shows up in your logfile. I'd like to know if it's even
TRYING to do the INSERT...

Dave

> -----Original Message-----
> From: Kyle [mailto:khultman at bnsi.net] 
> Sent: Thursday, June 28, 2001 5:51 AM
> To: radiator at open.com.au
> Subject: (RADIATOR) Session Database
> 
> 
> I've got this directive in my <Realm DEFAULT>. However, when 
> an user logs onto the system, and is authenticated by 
> Radiator, it fails to put an entry into the session table. 
> What am I doing wrong? Radiator-2.18.2 with RH-7.0 and mySql-3.23.38.
> 
> <SessionDatabase SQL>
> 
>   ## Set the database Identifier
>   Identifier SDB1
> 
>   ## Set the database source
>   DBSource          dbi:mysql:******
>   DBUsername        ******
>   DBAuth            ******
> 
>   AddQuery insert into RADONLINE (USERNAME, \
>   NASIDENTIFIER, NASPORT, \
>   ACCTSESSIONID, TIME_STAMP, FRAMEDADDRESS, PORTTYPE, \
>   SERVICETYPE) values ('%n','%N',%{NAS-Port}, \
>   '%{Acct-Session-Id}', %{Timestamp}, \
>   '%{Framed-Address}','%{Port-Type}','%{Service-Type}')
> 
>   DeleteQuery delete from RADONLINE where USERNAME='%n' and \
>   NASIDENTIFIER='%N' and NASPORT=%{NAS-Port}
> 
>   ClearNasQuery delete from RADONLINE where NASIDENTIFIER="%N'
>   CountQuery select NASIDENTIFIER,NASPORT,ACCTSESSIONID from \
>   RADONLINE where USERNAME='%n'
> 
> </SessionDatabase>
> ===
> 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.