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