(RADIATOR) Session Database

[Hugh Irvine]

Hello Kyle -

I will also need to see a copy of the configuration file (no secrets).

thanks

Hugh


At 11:56 AM -0400 6/28/01, Kitabjian, Dave wrote:
>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.

-- 

NB: I am travelling this week, so there may be delays in our correspondence.

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.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.