(RADIATOR) Session Database

[Kyle]

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.