Dell PowerConnect W Clearpass 100 Software HP ProCurve MSM Integration Guide - Page 39
rlm_sql_postgresql: Status: PGRES_COMMAND_OK
View all Dell PowerConnect W Clearpass 100 Software manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 39 highlights
rad_recv: Accounting-Request packet from host 10.0.20.25:32771, id=198, length=142 User-Name = "[email protected]" NAS-Port = 1 NAS-Port-Type = Wireless-802.11 NAS-Identifier = "MSM710" NAS-IP-Address = 10.0.20.25 Acct-Status-Type = Start Calling-Station-Id = "00-0A-E4-04-68-FD" Called-Station-Id = "00-03-52-09-14-C5" Event-Timestamp = "Aug 25 2009 13:28:20 EST" Acct-Delay-Time = 0 Acct-Session-Id = "0f5b51ca" Acct-Authentic = RADIUS Framed-IP-Address = 192.168.1.52 rlm_sql (sql): Reserving sql socket id: 1 rlm_sql_postgresql: query: INSERT INTO radacct ??(AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctAuthentic, ??ConnectInfo_start, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, RoleName) ??VALUES('0f5b51ca', '3215f3890fa69871', '[email protected]', '', '10.0.20.25', ??'1', 'Wireless-802.11', ('2009-08-25 13:28:19'::timestamp - '0'::interval), 'RADIUS', '', ??'00-03-52-09-14-C5', '00-0A-E404-68-FD 192.168.1.52', '0', (SELECT roledef.name FROM useraccount LEFT JOIN roledef ON useraccount.role_id=roledef.id WHERE useraccount.username='[email protected]')) rlm_sql_postgresql: Status: PGRES_COMMAND_OK rlm_sql_postgresql: affected rows = 1 rlm_sql (sql): Released sql socket id: 1 Sending Accounting-Response of id 198 to 10.0.20.25 port 32771 CONFIDENTIAL 39