1. Send debug with the Accounting-Request 2. Create an extra field for that attribute (IP address is varchar(15) type) to the radaact table and add the field and value to the query (so it's definitely different. Ivan Kalik Kalik Informatika ISP Dana 6/8/2007, "musoket@mtn.co.ug" <musoket@mtn.co.ug> piše:
Hello Ivan, Mon, 06 Aug 2007 09:07:22 +0100, you wrote:
You need to stop the server (killall radiusd) and restart in debug mode (radiusd -X).
Ivan Kalik Kalik Informatika ISP
This is some of the debug output indicating an INSERT statement:
modcall: entering group preacct for request 37 modcall[preacct]: module "preprocess" returns noop for request 37 rlm_acct_unique: Hashing 'NAS-Port = 0,Client-IP-Address = x.x.x.x,NAS-IP-Address = x.x.x.x,Acct-Session-Id = "0024B3B4",User-Name = "y.y.y.y"' rlm_acct_unique: Acct-Unique-Session-ID = "eb0fbc15b1bd7bca". modcall[preacct]: module "acct_unique" returns ok for request 37 rlm_realm: No '@' in User-Name = "y.y.y.y", looking up realm NULL rlm_realm: No such realm "NULL" modcall[preacct]: module "suffix" returns noop for request 37 modcall[preacct]: module "files" returns noop for request 37 modcall: leaving group preacct (returns ok) for request 37 Processing the accounting section of radiusd.conf modcall: entering group accounting for request 37 radius_xlat: '/var/log/radius/radacct/x.x.x.x/detail-20070806' rlm_detail: /var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/radius/radacct/x.x.x.x/detail-20070806 modcall[accounting]: module "detail" returns ok for request 37 modcall[accounting]: module "unix" returns ok for request 37 radius_xlat: '/var/log/radius/radutmp' radius_xlat: 'y.y.y.y' modcall[accounting]: module "radutmp" returns ok for request 37 radius_xlat: 'y.y.y.y' rlm_sql (sql): sql_set_user escaped user --> 'y.y.y.y' radius_xlat: 'INSERT into radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('0024B3B4', 'eb0fbc15b1bd7bca', 'y.y.y.y', '', 'x.x.x.x', 'ISDN 0/-1:D:0', 'Async', '2007-08-06 13:29:27', '0', '0', '0', '', '', '0', '0', '25612345678', '', '', '', '', '', '10', '0')' rlm_sql (sql): Reserving sql socket id: 2 rlm_sql (sql): Released sql socket id: 2 modcall[accounting]: module "sql" returns ok for request 37 modcall: leaving group accounting (returns ok) for request 37 Sending Accounting-Response of id 46 to x.x.x.x port 1646 Finished request 37
I hope this helps. The h323-remote-address value should be entered under ServiceType and FramedIPAddress as per my setup in sql.conf. As you can see, a blank is being entered instead. I have changed the IP addresses to x.x.x.x and y.y.y.y.
Regards
Timothy
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html