SQL_LOG Interim Update missing "partial" config error? huh?

[Aidan Rowe]

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 at gmail.com
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html