> freeRadius than calls accounting_stop_query located in
> sql.conf and UPDATES the radacct table and its attributes
> with all these new values.
>
> What I'd like to do now is to execute a personalised sql
> query right after this default accounting_stop_query so that
> I could save/modify all the info I want.
>
> Or maybe is there another way to grab this Acct-Session-Time
> and User-Name to update the correct user and modify his time left.
>
> Any ideas?
I don't know if it's possible to add any number of SQL queries to the sql
module: I let freeradius gurus the responsability to say...
However you can instantiate a new sql module in sql.conf:
sql my-sql-acct {
...
Accounting_stop_query =" MY Customized SQL query"
}
Then in you radiusd.conf accounting section:
accounting {
sql
my-sql-acct
}
You may also want to enable the 'my-sql-acct' only for your ChilliSpot NAS.
You can do so by playing with Acct-Type (see doc/Acct-Type):
* use acct_users to set Acct-Type:=custom-sql for your NAS-IP-Address
* use an accounting section as below:
Accouning {
sql
Acct-Type custom-sql {
my-sql-acct
}
}
HTH,
Thibault
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
