Any possible updates on this? It seems at some point the man pages changed from using INSERTs and UPDATEs to only using INSERTS. On 14/03/2012, at 3:52 PM, Aidan Rowe wrote:
Hi Chrstiaan,
It's because there is no SQL statement configured for Interim-Update by default, you need to create a query to be associated with it in modules/sql_log.
A poor example:
Interim-Update = "UPDATE ${acct_table} \ SET FramedIPAddress = '%{Framed-IP-Address}', \ AcctSessionTime = '%{Acct-Session-Time}', \ AcctInputOctets = '%{Acct-Input-Octets}', \ AcctOutputOctets = '%{Acct-Output-Octets}' \ WHERE AcctSessionId = '%{Acct-Session-Id}' \ AND UserName = '%{User-Name}';"
While you've got this question posted, does anyone mind sharing their sql_log config? The default only talks about inserting a new row for start, stop and alive and nothing about doing updates on stop and interim-update. Is it still acceptable to use updates on stop/interim-update?
On 14/03/2012, at 4:34 AM, Christiaan Rademan wrote:
Greetings Everyone,
I am using FreeRadius + mySQL + SQLIPPOOL. FreeRADIUS Version 2.1.11.
The start and stop accounting records work fine.
My issue is I keep getting the following in the logs: Tue Mar 13 22:18:33 2012 : Info: [sql_log] Couldn't find an entry Interim-Update in the config section.
Any idea why the interim-updates not working? I have looked through the configuration, I cant find what config section it refers too?
I mean the stuff should all be configured as per default for interim update sql query etc is still in raddb/sql/mysql/dialup.conf
what special configuration do I have todo? Or where can I go read about it?
Please advice! Many thanks!
-- Christiaan Rademan - JNCIE #661
Mobile: +27 83 419 2078 E-mail: christiaan.rademan@gmail.com
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html