I am running Freeradius 1.0.1 on Fedora Core 3 and authenticating
wireless users with PEAP. I am trying to get accounting to work, but I don't
understand the results that I am getting. The first entry has the MAC
address as the UserName, no realm, and the AcctAtthentic is Local.
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('00000000-00000002',
'cb6600bfed39629d', '0080c813ae30', '', '127.0.0.1', '1', 'Wireless-802.11',
'2005-02-04 17:28:36', '0', '0', 'Local', 'CONNECT 11Mbps 802.11b', '', '0',
'0', '00-11-95-8C-D5-BE:OGWN', '00-80-C8-13-AE-30', '', '', '', '', '',
'0');
Next comes authentication:
INSERT into radpostauth (id, user, pass, reply, date) values ('',
'DI107079-3800=5C=5Ctom', 'Chap-Password', 'Access-Accept', NOW());
INSERT into radpostauth (id, user, pass, reply, date) values ('',
'DI107079-3800=5C=5Ctom', 'Chap-Password', 'Access-Accept', NOW());
Next comes the Accounting-Start, and that's where the questions start.
Here we have the Stripped-UserName, the domain, and the AcctAtthentic is
Radius.
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('00000000-00000002',
'3ccf0ee5ef643776', 'tom', 'DI107079-3800', '127.0.0.1', '1',
'Wireless-802.11', '2005-02-04 17:28:36', '0', '0', 'RADIUS', 'CONNECT
11Mbps 802.11b', '', '0', '0', '00-11-95-8C-D5-BE:OGWN',
'00-80-C8-13-AE-30', '', '', '', '', '', '0');
Is this supposed to be an update of the record above?
The Accounting-Stop updates the first record by matching the MAC address.
How do I get the second record closed if the Stripped-UserName is not
passed? Can I take the UserName out of the update?
UPDATE radacct SET AcctStopTime = '2005-02-04 17:39:46', AcctSessionTime =
'669', AcctInputOctets = '', AcctOutputOctets = '', AcctTerminateCause = '',
AcctStopDelay = '', ConnectInfo_stop = 'CONNECT 11Mbps 802.11b' WHERE
AcctSessionId = '00000000-00000002' AND UserName = '0080c813ae30' AND
NASIPAddress = '127.0.0.1';
Sorry for the long post. Thanks in advance for any help.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
