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

UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctAuthentic

Get Dell PowerConnect W Clearpass 100 Software PDF manuals and user guides View all Dell PowerConnect W Clearpass 100 Software manuals
Add to My Manuals
Save this manual to your list of manuals

Page 44 highlights

rlm_sql_postgresql: affected rows = 1 rlm_sql (sql): Released sql socket id: 2 Sending Access-Accept of id 150 to 10.0.20.166 port 1027 Class = 0x616d69676f706f64 Idle-Timeout = 300 rad_recv: Accounting-Request packet from host 10.0.20.166:1027, id=194, length=145 Service-Type = Call-Check NAS-Identifier = "dsa-3600" NAS-Port = 1 NAS-Port-Id = "Controlled" NAS-Port-Type = Wireless-802.11 NAS-IP-Address = 10.0.20.166 User-Name = "cam" Acct-Status-Type = Start Acct-Session-Id = "1260795282" 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('1260795282', '8e38d415724e4fe1', 'cam', '', '10.0.20.166', ??'Controlled', 'Wireless-802.11', ('2009-12-10 15:04:28'::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 194 to 10.0.20.166 port 1027 CONFIDENTIAL 44

  • 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
44
rlm_sql_postgresql: affected rows = 1
rlm_sql (sql): Released sql socket id: 2
Sending Access-Accept of id 150 to 10.0.20.166 port 1027
Class = 0x616d69676f706f64
Idle-Timeout = 300
rad_recv: Accounting-Request packet from host 10.0.20.166:1027, id=194, length=145
Service-Type = Call-Check
NAS-Identifier = "dsa-3600"
NAS-Port = 1
NAS-Port-Id = "Controlled"
NAS-Port-Type = Wireless-802.11
NAS-IP-Address = 10.0.20.166
User-Name = "cam"
Acct-Status-Type = Start
Acct-Session-Id = "1260795282"
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('1260795282', '8e38d415724e4fe1',
'cam', '', '10.0.20.166', ??'Controlled', 'Wireless-802.11', ('2009-12-10
15:04:28'::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 194 to 10.0.20.166 port 1027