Debug: rlm_sqlcounter: No integer found in string ""

[JennyBlunt]

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
required.

Thanks

--
View this message in context: http://freeradius.1045715.n5.nabble.com/Debug-rlm-sqlcounter-No-integer-found-in-string-tp4923257p4923257.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.