Debug: rlm_sqlcounter: No integer found in string ""

JennyBlunt jennyshoehorn at
Fri Oct 21 01:56:55 CEST 2011

I'm having issues getting my dailycounter, hourlycounter etc. to work
properly. Max-All-Session is ok but there seems to be something wrong with
the others.

The error in debug is:

Info: [dailycounter] 	expand: %{sql:SELECT SUM(AcctSessionTime -
GREATEST((1319068800 -UNIX_TIMESTAMP(AcctStartTime)), 0)) FROM radacct WHERE
UserName='full' AND UNIX_TIMESTAMP(AcctStartTime) + AcctSessionTime >
'1319068800'} -> 
Debug: rlm_sqlcounter: No integer found in string ""
Info: ++[dailycounter] returns noop
Debug: rlm_sqlcounter: Entering module authorize code
Debug: rlm_sqlcounter: Could not find Check item value pair

If  run in mysql, I get value = NULL

If I remove Unix_timestamp, I get a value but this is incorrect and
obviously can't use.

Can anyone suggest what I need to do to fix this??

Am using meraki hardware to test but have coovachilli around to test if


View this message in context:
Sent from the FreeRadius - User mailing list archive at

More information about the Freeradius-Users mailing list