Hi All,
I'm using FreeRadius with an ACME NetNet SD. I can see the accounting requests arrive at free radius and it seems to be writing to the MySQL with an UPDATE method yet I never see any information get into the DB. An Example from radius -X rad_recv: Accounting-Request packet from host 10.57.19.30:1103, id=0, length=105 Acct-Status-Type = Accounting-On NAS-IP-Address = 192.168.1.10 NAS-Port = 0 Acct-Session-Id = "SiphonLab#788" Acme-Firmware-Version = "SC6.1.0 MR-1 Patch 4 (Build 348)" Acme-CDR-Sequence-Number = 3938 Processing the preacct section of radiusd.conf modcall: entering group preacct for request 3 modcall[preacct]: module "preprocess" returns noop for request 3 rlm_acct_unique: WARNING: Attribute User-Name was not found in request, unique ID MAY be inconsistent rlm_acct_unique: Hashing 'NAS-Port = 0,Client-IP-Address = 10.57.19.30,NAS-IP-Address = 192.168.1.10,Acct-Session-Id = "SiphonLab#788",' rlm_acct_unique: Acct-Unique-Session-ID = "4ba5092db9c79961". modcall[preacct]: module "acct_unique" returns ok for request 3 rlm_realm: Proxy reply, or no User-Name. Ignoring. modcall[preacct]: module "suffix" returns noop for request 3 modcall[preacct]: module "files" returns noop for request 3 modcall: leaving group preacct (returns ok) for request 3 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 3 radius_xlat: '/var/log/radius/radacct/10.57.19.30/detail' rlm_detail: %A/%{Client-IP-Address}/detail expands to /var/log/radius/radacct/10.57.19.30/detail modcall[accounting]: module "detail" returns ok for request 3 modcall[accounting]: module "unix" returns noop for request 3 radius_xlat: '/var/log/radius/radutmp' rlm_radutmp: NAS 192.168.1.10 restarted (Accounting-On packet seen) modcall[accounting]: module "radutmp" returns ok for request 3 rlm_sql (sql): received Acct On/Off packet radius_xlat: 'UPDATE radacct SET AcctStopTime='2010-03-19 14:10:15', AcctSessionTime=unix_timestamp('2010-03-19 14:10:15') - unix_timestamp(AcctStartTime), AcctTerminateCause='', AcctStopDelay = '' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '192.168.1.10' AND AcctStartTime <= '2010-03-19 14:10:15'' radius_xlat: '/var/log/radius/sqltrace.sql' rlm_sql (sql): Reserving sql socket id: 0 rlm_sql_mysql: query: UPDATE radacct SET AcctStopTime='2010-03-19 14:10:15', AcctSessionTime=unix_timestamp('2010-03-19 14:10:15') - unix_timestamp(AcctStartTime), AcctTerminateCause='', AcctStopDelay = '' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '192.168.1.10' AND AcctStartTime <= '2010-03-19 14:10:15' rlm_sql (sql): Released sql socket id: 0 modcall[accounting]: module "sql" returns ok for request 3 modcall: leaving group accounting (returns ok) for request 3 Sending Accounting-Response of id 0 to 10.57.19.30 port 1103 However no data is getting to the DB mysql> select * from radacct; Empty set (0.00 sec) If I try the update in MySQL it does not populate mysql> UPDATE radacct SET AcctStopTime='2010-03-19 11:55:14', AcctSessionTime=unix_timestamp('2010-03-19 11:55:14') - unix_timestamp(AcctStartTime), AcctTerminateCause='', AcctStopDelay = '' WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '192.168.1.10' AND AcctStartTime <= '2010-03-19 11:55:14'; Query OK, 0 rows affected (0.00 sec) Rows matched: 0 Changed: 0 Warnings: 0 Anyone seen this problem? Any help much appreciated Regards Steve P
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html