sql accounting - no records - 2.0.1 RESOLVED

[JB]

Hi Andrew,

in mysql.conf, there should be another file included:
$INCLUDE sql/${database}/dialup.conf
So, in your case that would be $INCLUDE sql/mysql/dialup.conf
There you should find several accounting queries.

JB

Andrew Long (30.01.2008 15:49):

> I expected to see some traffic too soon, now it's coming...
> but where are the accounting queries?
>
> Andrew
>
>
> On Jan 30, 2008 8:52 AM, Andrew Long <fursink at gmail.com> wrote:
>> I've just installed 2.0.1 on CentOS 5 with MySQL 5.x. I can get the
>> clients to authenticate and I see accounting requests come in, also I
>> see the accounting query as it should be updated to mysql, i.e.,
>> "expand: UPDATE radacct...". I also see the accounting response
>> returned to the client, but no accounting records are being updated  
>> in
>> radacct table. There are no errors in debug mode relevent to mysql:
>>
>> rlm_sql (sql): received Acct On/Off packet
>>        expand: %{Acct-Delay-Time} -> 0
>>        expand:           UPDATE radacct           SET
>> acctstoptime       =  '%S',              acctsessiontime    =
>> unix_timestamp('%S') -
>> unix_timestamp(acctstarttime),              acctterminatecause =
>> '%{Acct-Terminate-Cause}',              acctstopdelay      =
>> %{%{Acct-Delay-Time}:-0}           WHERE acctsessiontime =  0
>> AND acctstoptime      =  NULL           AND nasipaddress      =
>> '%{NAS-IP-Address}'           AND acctstarttime     <= '%S' ->
>>  UPDATE radacct           SET              acctstoptime       =
>> '2008-01-30 07:45:06',              acctsessiontime    =
>> unix_timestamp('2008-01-30 07:45:06') -
>>    unix_timestamp(acctstarttime),              acctterminatecause =
>> '',              acctstopdelay      =  0           WHERE
>> acctsessiontime =  0           AND acctstoptime      =  NULL
>> AND nasipaddress      =  '141.xxx.xxx.xxx'           AND  
>> acctstarttime
>>    <= '2008-01-30 07:45:06'
>> rlm_sql (sql): Reserving sql socket id: 2
>> rlm_sql (sql): Released sql socket id: 2
>> ++[sql] returns ok
>>        expand: %{User-Name} -> elmaroma_cn3000
>> attr_filter: Matched entry DEFAULT at line 12
>> ++[attr_filter.accounting_response] returns updated
>> Sending Accounting-Response of id 33 to 141.xxx.xxx.xxx port 1025
>>
>> I have tried this with 2 different clients and get the same NULL
>> result. Authentication is fine, but any features relying on data in
>> radacct clearly won't work, ie session-timout...
>>
>> I've checked the "default" config, and all accounting is set to sql.
>> The one oddity I notice is that "default" has:
>>        #  See "Accounting queries" in sql.conf
>>        sql
>>
>> But I can see no accounting queries anywhere in the provided  
>> sql.conf ??
>>
>> Thank You.
>>
>> Andrew Long
>> EWS Solutions
>>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html