Info: rlm_sql (sql): There are no DB handles to use! skipped 0,	tried to connect 0
    Ivan Kalik 
    tnt at kalik.net
       
    Mon Oct 12 16:32:14 CEST 2009
    
    
  
> accounting {
>                if (Acct-Status-Type == Start) {
>                        update reply {
>                              Tmp-String-0 =
> "%{exec:/etc/freeradius/SCRIPT/userlogin.py %{User-Name}}"
>                         }
>                 }
>                 if (Acct-Status-Type == Stop) {
>                         update reply {
>                              Tmp-String-0 =
> "%{exec:/etc/freeradius/SCRIPT/userlogout.py %{User-Name}}"
>                         }
>                }
You can replace call to exec module by call to sql:
Tmp-String-0 = "%{sql:UPDATE whatever}"
Current server versions should support UPDATEs and INSERTs as well as
SELECTs which vere only ones supported in early 2.x versions.
> I need to launch a script with after login and logout.
>
> Maybe this script cause some problems? It's a simple python script that
> update a field in db (online/offiline flag).
Do you need that at all? Instead of calling the database to see if the
flag (wherever you are using it) is set you can make a query that checks
if user is online.
Ivan Kalik
Kalik Informatika ISP
    
    
More information about the Freeradius-Users
mailing list