(RADIATOR) Session database SQL

[mhobbs]

I have set up a session database using the following

<SessionDatabase SQL>
  DBSource    dbi:mysql:RADONLINE
  DBUsername  xxxx
  DBAuth      xxxxxxxx

AddQuery insert into RADONLINE (FRAMEDIPADDRESS, USERNAME, NASIDENTIFIER,
NASPORT, PASSWORD) values ('%{Framed-Address}', '%U', '%N', 0%{NAS-Port},
'%{User-Password}')

DeleteQuery delete from RADONLINE where NASIDENTIFIER='%1' and NASPORT=0%2
ClearNasQuery delete from RADONLINE where NASIDENTIFIER='%N'

CountQuery
FailureBackoffTime 5
</SessionDatabase>

All work wells accept the getting the user's password details. I have also
tried "%P" but it just inserts nothing into the database how do I get this
to work ?

Also in the manual it says
"If CountQuery is defined as an empty string, then the query will not be
executed, and the current session count will be fixed at 0."

So what is the syntax for this ?

Thanks
Matthew Hobbs
Speedlink

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