Dell PowerConnect W Clearpass 100 Software RADIUS Troubleshooting TechNote - Page 6
rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op FROM radreply WHERE
![]() |
View all Dell PowerConnect W Clearpass 100 Software manuals
Add to My Manuals
Save this manual to your list of manuals |
Page 6 highlights
Tech Note - RADIUS Troubleshooting Version 0.9 rad_recv: Access-Request packet from host 192.168.2.3:2406, id=2, length=75 User-Name = "[email protected]" User-Password = "password" 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 Exec-Program: /usr/bin/php /opt/amigopod/www/amigopod_request.php 2 1 Exec-Program-Wait: value-pairs: Reply-Message = "Guest", Session-Timeout = 823, Exec-Program: returned: 0 Login OK: [[email protected]] (from client hydra port 0 cli 00-17-31-57-d8-78) rlm_sql (sql): Processing sql_postauth rlm_sql (sql): Reserving sql socket id: 0 rlm_sql_postgresql: query: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('[email protected]', 'password', 'Access-Accept', NOW()) rlm_sql_postgresql: Status: PGRES_COMMAND_OK rlm_sql_postgresql: affected rows = 1 rlm_sql (sql): Released sql socket id: 0 Sending Access-Accept of id 2 to 192.168.2.3 port 2406 Reply-Message = "Guest" Session-Timeout = 823 Correct password - Incorrect shared secret - CHAP rad_recv: Access-Request packet from host 192.168.2.3:2423, id=3, length=76 User-Name = "[email protected]" CHAP-Password = 0x75a9b8959bf829fb06d916af17fc60e0e7 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: chap user [email protected] authenticated succesfully Exec-Program: /usr/bin/php /opt/amigopod/www/amigopod_request.php 2 1 Exec-Program-Wait: value-pairs: Reply-Message = "Guest", Session-Timeout = 795, Exec-Program: returned: 0 Login OK: [[email protected]] (from client hydra port 0 cli 00-17-31-57-d8-78) rlm_sql (sql): Processing sql_postauth rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_postgresql: query: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('[email protected]', 'Chap-Password', 'Access-Accept', NOW()) rlm_sql_postgresql: Status: PGRES_COMMAND_OK rlm_sql_postgresql: affected rows = 1 rlm_sql (sql): Released sql socket id: 3 Sending Access-Accept of id 3 to 192.168.2.3 port 2423 CONFIDENTIAL 6
![](/manual_guide/products/dell-powerconnect-w-clearpass-100-software-radius-troubleshooting-technote-cb227b8/6.png)