(RADIATOR) Session database SQL

[Hugh Irvine]

Hello Matthew -

On Wed, 30 Jan 2002 13:56, mhobbs wrote:
> 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 ?
>

You will have to check a trace 4 debug to see what is happening.

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

Your configuration already has the correct syntax.

	CountQuery

regards

Hugh


-- 
Radiator: the most portable, flexible and configurable RADIUS server
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.