Re: sql accounting - no records - 2.0.1 RESOLVED
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@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
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@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
participants (2)
-
Andrew Long -
JB