Accounting mysql

[Arran Cudbard-Bell]

> On 2 Sep 2015, at 08:02, Alan DeKok <aland at deployingradius.com> wrote:
> 
> On Sep 2, 2015, at 2:54 AM, nicolas.clo at ricoh-industrie.fr wrote:
>> I have a problem to log accounting informations to mysql,
>> 
>> rlm_sql_mysql: ERROR 1582 (Incorrect parameter count in the call to native function
>> 'FROM_UNIXTIME'): 42000
>> 
>> It seems to be that Freeradius can't retrieve "integer:Event-Timestamp" value.
> 
>  Because it isn't in the packet.
> 
>> FreeRADIUS Version 3.0.10 (git #f7065a7), for host i486-pc-linux-gnu, built on Sep  1 2015 at
>> 15:39:31 on Debian 7.8
>> Mysql 5.5.35
>> ...
> 
>  That isn't the full debug output.  And it's "-Xx", which isn't necessary.
> 
>  You can just add the Event-Timestamp if it doesn't already exist:
> 
> 	if (!Event-Timestamp) {
> 		update request {
> 			Event-Timestamp := "%l"
> 		}
> 	}

Or call preprocess (which does the same thing).

-Arran

Arran Cudbard-Bell <a.cudbardb at freeradius.org>
FreeRADIUS development team

FD31 3077 42EC 7FCD 32FE 5EE2 56CF 27F9 30A8 CAA2

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 872 bytes
Desc: Message signed with OpenPGP using GPGMail
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20150902/070e9448/attachment.sig>