Freeradius - MySQL Update problem

[musoket at mtn.co.ug]

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