RE: Decreasing connection time (Session-Timeout)

24 Oct 2006

      ...
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
}
I tried this and freeRadius hangs at startup and says "my-sql-acct: Unknown
Module". I added everything just like you said... 

(If I can manage to add this previous section) Modifying directly in
chillispot is maybe a good choice. I'll give it a try...

Cheers,

mico

"The only way to get rid of a temptation is to yield to it."
(Oscar Wilde)
...
-----Original Message-----
From: freeradius-users-bounces+micobros=gmail.com@lists.freeradius.org
[mailto:freeradius-users-bounces+micobros=gmail.com@lists.freeradius.org]
On Behalf Of Thibault Le Meur
Sent: mardi 24 octobre 2006 9:56
To: 'FreeRadius users mailing list'
Subject: RE : Decreasing connection time (Session-Timeout)
...
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