Problem with dailycounter

[Frederic Fichter]

Hello all,

Can't understand why my dailycounter is always empty ?
See message below "dailycounter: No integer found in result string """
The radacct table in MySQL is correctly updated.

My freeradius is :
radiusd: FreeRADIUS Version 3.0.11, for host armv7l-unknown-linux-gnu, built on Jul 15 2016 at 22:02:47

What additional information should I give here ? Here's an extract of freeradius debug :

(5) dailycounter: EXPAND %{User-Name}
(5) dailycounter:    --> test01
(5) dailycounter: SQL-User-Name set to 'test01'
rlm_sql (sql): Reserved connection (11)
(5) dailycounter: Executing select query: SELECT SUM(acctsessiontime - GREATEST((1471730400 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = 'test01' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1471730400'
(5) dailycounter: NULL value in first column of result
rlm_sql (sql): Released connection (11)
(5) dailycounter: EXPAND %{sql:SELECT SUM(acctsessiontime - GREATEST((1471730400 - UNIX_TIMESTAMP(acctstarttime)), 0)) FROM radacct WHERE username = '%{User-Name}' AND UNIX_TIMESTAMP(acctstarttime) + acctsessiontime > '1471730400'}
(5) dailycounter:    --> 
(5) dailycounter: No integer found in result string "".  May be first session, setting counter to 0
(5) dailycounter: Allowing user, &control:Max-Daily-Session value (3600) is greater than counter value (0)
(5) dailycounter: Setting &reply:Session-Timeout value to 3600
(5)     [dailycounter] = ok
(5)     [expiration] = noop


Thanks much for your help ;)

Best,

Fred