Dell PowerConnect W Clearpass 100 Software D-Link DSA-3600 Integration Guide - Page 31

rlm_sql_postgresql: Status: PGRES_COMMAND_OK

Page 31 highlights

Acct-Delay-Time = 0 Acct-Authentic = RADIUS Called-Station-Id = "00-15-E9-DB-22-0B" Calling-Station-Id = "00-13-D4-09-D3-F9" Framed-IP-Address = 192.168.1.41 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('1260793628', 'd065a0a421bdf720', 'cam', '', '10.0.20.166', ??'Controlled', 'Wireless-802.11', ('2009-12-10 14:36:46'::timestamp - '0'::interval), 'RADIUS', '', ??'00-15-E9-DB-22-0B', '00-13-D409-D3-F9', 'Call-Check', '', ??'192.168.1.41', '0', (SELECT roledef.name FROM useraccount LEFT JOIN roledef ON useraccount.role_id=roledef.id WHERE useraccount.username='cam')) 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 124 to 10.0.20.166 port 1027 CONFIDENTIAL 31

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52

CONFIDENTIAL
31
Acct-Delay-Time = 0
Acct-Authentic = RADIUS
Called-Station-Id = "00-15-E9-DB-22-0B"
Calling-Station-Id = "00-13-D4-09-D3-F9"
Framed-IP-Address = 192.168.1.41
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('1260793628', 'd065a0a421bdf720',
'cam', '', '10.0.20.166', ??'Controlled', 'Wireless-802.11', ('2009-12-10
14:36:46'::timestamp - '0'::interval), 'RADIUS', '', ??'00-15-E9-DB-22-0B', '00-13-D4-
09-D3-F9', 'Call-Check', '', ??'192.168.1.41', '0', (SELECT roledef.name FROM
useraccount LEFT JOIN roledef ON useraccount.role_id=roledef.id WHERE
useraccount.username='cam'))
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 124 to 10.0.20.166 port 1027