Re: Possible bug in rlm_sqlcounter examples

2012-02-22 Thread Phil Mayers
On 02/21/2012 11:04 PM, Tim White wrote: Following on from my previous email, I've checked an x86 machine as well, and get the same behaviour. I should hope so; SQL is not architecture specific! Your original solution was correct as far as I could see; if there's any chance a column might be

Re: Possible bug in rlm_sqlcounter examples

2012-02-21 Thread Tim White
Following on from my previous email, I've checked an x86 machine as well, and get the same behaviour. Debug logs follow, the first being the initial login for the day, showing sqlcounter not finding an integer and hence returning noop. The second being after an initial login where a correct in

Possible bug in rlm_sqlcounter examples

2012-02-20 Thread Tim White
Hi All. I am using the following SQL in sqlcounter for a MySQL database in the Grase Hotspot project, as part of daily/hourly/monthly counters. query = "SELECT SUM(acctsessiontime - \ GREATEST((%b - UNIX_TIMESTAMP(acctstarttime)), 0)) \ FROM radacct WH