Salut Gildas -
On Tue, 03 Oct 2000, Gildas PERROT wrote:
> Sorry I meant a receipe ;-)))) I would like to know which configuration
> directive I need to put a new "update RADPOOL" query at each Stop packets
> which allows to free the state of the IP corresponding to the callingID (I
> will create a callingID column in RADPOOL and I suppose that there is one
> session by callingID).
>
<SessionDatabase SQL>
DBSource ....
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-IP-Address}', '%{Port-Type}', '%{Service-Type}')
CountQuery select NASIDENTIFIER, NASPORT, ACCTSESSIONID from RADONLINE \
where USERNAME='%n'
DeleteQuery delete from RADONLINE where USERNAME='%n' and \
NASIDENTIFIER='%N' and NASPORT=%{NAS-Port}
</SessionDatabase>
You will need to adjust the AddQuery, CountQuery and DeleteQuery above to use
the CallingID table with the Calling-Station-Id attribute in whatever fashion
is appropriate for your requirements.
Have a look at section 6.7 in the Radiator 2.16.3 reference manual.
hth
Hugh
--
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.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
