Freeradius - MySQL Update problem

[tnt at kalik.co.yu]

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 at mtn.co.ug" <musoket at 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
>
>