Dell PowerConnect W Clearpass 100 Software RADIUS Troubleshooting TechNote - Page 7

rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE

Page 7 highlights

Tech Note - RADIUS Troubleshooting Version 0.9 Reply-Message = "Guest" Session-Timeout = 795 Correct password - Incorrect shared secret - PAP rad_recv: Access-Request packet from host 192.168.2.3:2442, id=5, length=75 User-Name = "[email protected]" User-Password = "\365\336\267\236\253\243F= Jt\251\317\272`R" Calling-Station-Id = "00-17-31-57-d8-78" rlm_sql (sql): Reserving sql socket id: 1 rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username='[email protected]' 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 = '[email protected]' 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='[email protected]' 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 = '[email protected]' 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: 1 rlm_sql (sql): No matching entry in the database for request from user [[email protected]] Login incorrect: [[email protected]] (from client hydra port 0 cli 00-17-31-57-d8-78) Sending Access-Reject of id 5 to 192.168.2.3 port 2442 Incorrect password - Correct shared secret - CHAP rad_recv: Access-Request packet from host 192.168.2.3:2495, id=7, length=76 User-Name = "[email protected]" CHAP-Password = 0x069b51c50ccfd0c103623a0cae7952b9ca Calling-Station-Id = "00-17-31-57-d8-78" rlm_chap: Setting 'Auth-Type := CHAP' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username='[email protected]' 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 = '[email protected]' 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='[email protected]' 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 = '[email protected]' 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: 4 rlm_chap: login attempt by "[email protected]" with CHAP password rlm_chap: Using clear text password password for user [email protected] authentication. rlm_chap: Pasword check failed Login incorrect (rlm_chap: Wrong user password): [[email protected]] (from client hydra port 0 cli 00-17-31-57-d8-78) Sending Access-Reject of id 7 to 192.168.2.3 port 2495 Incorrect password - Correct shared secret - PAP rad_recv: Access-Request packet from host 192.168.2.3:2514, id=8, length=75 User-Name = "[email protected]" User-Password = "incorrect" Calling-Station-Id = "00-17-31-57-d8-78" rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username='[email protected]' ORDER BY id rlm_sql_postgresql: Status: PGRES_TUPLES_OK CONFIDENTIAL 7

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9

Tech Note – RADIUS Troubleshooting
Version 0.9
CONFIDENTIAL
7
Reply-Message = "Guest"
Session-Timeout = 795
////////////////////////////////////////////////////////////////////////////
// Correct password - Incorrect shared secret - PAP
rad_recv: Access-Request packet from host 192.168.2.3:2442, id=5, length=75
User-Name = "[email protected]"
User-Password = "\365\336\267\236\253\243F= Jt\251\317\272`R"
Calling-Station-Id = "00-17-31-57-d8-78"
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE
Username='[email protected]' 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 = '[email protected]' 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='[email protected]' 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 = '[email protected]' 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: 1
rlm_sql (sql): No matching entry in the database for request from user [[email protected]]
Login incorrect: [[email protected]] (from client hydra port 0 cli 00-17-31-57-d8-78)
Sending Access-Reject of id 5 to 192.168.2.3 port 2442
////////////////////////////////////////////////////////////////////////////
// Incorrect password - Correct shared secret - CHAP
rad_recv: Access-Request packet from host 192.168.2.3:2495, id=7, length=76
User-Name = "[email protected]"
CHAP-Password = 0x069b51c50ccfd0c103623a0cae7952b9ca
Calling-Station-Id = "00-17-31-57-d8-78"
rlm_chap: Setting 'Auth-Type := CHAP'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE
Username='[email protected]' 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 = '[email protected]' 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='[email protected]' 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 = '[email protected]' 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: 4
rlm_chap: login attempt by "[email protected]" with CHAP password
rlm_chap: Using clear text password password for user [email protected] authentication.
rlm_chap: Pasword check failed
Login incorrect (rlm_chap: Wrong user password): [[email protected]] (from client hydra port 0
cli 00-17-31-57-d8-78)
Sending Access-Reject of id 7 to 192.168.2.3 port 2495
////////////////////////////////////////////////////////////////////////////
// Incorrect password - Correct shared secret - PAP
rad_recv: Access-Request packet from host 192.168.2.3:2514, id=8, length=75
User-Name = "[email protected]"
User-Password = "incorrect"
Calling-Station-Id = "00-17-31-57-d8-78"
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE
Username='[email protected]' ORDER BY id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK