Dell PowerConnect W Clearpass 100 Software RADIUS Troubleshooting TechNote - Page 7
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE
View all Dell PowerConnect W Clearpass 100 Software manuals
Add to My Manuals
Save this manual to your list of manuals |
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