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

Confidential

Page 30 highlights

User-Name = "cam" User-Password = "wireless" Called-Station-Id = "00-15-E9-DB-22-0B" Calling-Station-Id = "00-13-D4-09-D3-F9" rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username='cam' ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql_postgresql: query: SELECT radgroupcheck.id, radgroupcheck.GroupName, radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op ??FROM radgroupcheck, usergroup WHERE usergroup.Username = 'cam' AND usergroup.GroupName = radgroupcheck.GroupName ??ORDER BY radgroupcheck.id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radreply WHERE Username='cam' ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql_postgresql: query: SELECT radgroupreply.id, radgroupreply.GroupName, radgroupreply.Attribute, radgroupreply.Value, radgroupreply.Op ??FROM radgroupreply,usergroup WHERE usergroup.Username = 'cam' AND usergroup.GroupName = radgroupreply.GroupName ??ORDER BY radgroupreply.id rlm_sql_postgresql: Status: PGRES_TUPLES_OK rlm_sql_postgresql: affected rows = rlm_sql (sql): Released sql socket id: 3 Exec-Program: /usr/bin/php /opt/amigopod/www/amigopod_request.php 2 4 Exec-Program-Wait: value-pairs: Reply-Message = "Employee", Exec-Program: returned: 0 Login OK: [cam] (from client DSA-3600 port 1 cli 00-13-D4-09-D3-F9) rlm_sql (sql): Processing sql_postauth rlm_sql (sql): Reserving sql socket id: 2 rlm_sql_postgresql: query: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('cam', 'wireless', 'Access-Accept', NOW()) rlm_sql_postgresql: Status: PGRES_COMMAND_OK rlm_sql_postgresql: affected rows = 1 rlm_sql (sql): Released sql socket id: 2 Sending Access-Accept of id 80 to 10.0.20.166 port 1027 Reply-Message = "Employee" rad_recv: Accounting-Request packet from host 10.0.20.166:1027, id=124, 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 = "1260793628" CONFIDENTIAL 30

  • 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
30
User-Name = "cam"
User-Password = "wireless"
Called-Station-Id = "00-15-E9-DB-22-0B"
Calling-Station-Id = "00-13-D4-09-D3-F9"
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck
WHERE Username='cam' ORDER BY id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: query: SELECT radgroupcheck.id, radgroupcheck.GroupName,
radgroupcheck.Attribute, radgroupcheck.Value,radgroupcheck.Op ??FROM radgroupcheck,
usergroup WHERE usergroup.Username = 'cam' AND usergroup.GroupName =
radgroupcheck.GroupName ??ORDER BY radgroupcheck.id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radreply
WHERE Username='cam' ORDER BY id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
rlm_sql_postgresql: query: SELECT radgroupreply.id, radgroupreply.GroupName,
radgroupreply.Attribute, radgroupreply.Value, radgroupreply.Op ??FROM
radgroupreply,usergroup WHERE usergroup.Username = 'cam' AND usergroup.GroupName =
radgroupreply.GroupName ??ORDER BY radgroupreply.id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
rlm_sql (sql): Released sql socket id: 3
Exec-Program: /usr/bin/php /opt/amigopod/www/amigopod_request.php 2 4
Exec-Program-Wait: value-pairs: Reply-Message = "Employee",
Exec-Program: returned: 0
Login OK: [cam] (from client DSA-3600 port 1 cli 00-13-D4-09-D3-F9)
rlm_sql (sql): Processing sql_postauth
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql_postgresql: query: INSERT INTO radpostauth (username, pass, reply, authdate)
VALUES ('cam', 'wireless', 'Access-Accept', NOW())
rlm_sql_postgresql: Status: PGRES_COMMAND_OK
rlm_sql_postgresql: affected rows = 1
rlm_sql (sql): Released sql socket id: 2
Sending Access-Accept of id 80 to 10.0.20.166 port 1027
Reply-Message = "Employee"
rad_recv: Accounting-Request packet from host 10.0.20.166:1027, id=124, 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 = "1260793628"