On Sep 13, 2019, at 9:06 AM, Bornemann, Hans <hans.bornemann@tu-dortmund.de> wrote:
the sql statement shows the correct output, i think.
SELECT id, username, attribute, value, op FROM radcheck WHERE username = '3c15c2e840fe' ORDER BY id;
| id | username | attribute | value | op |
| 1 | 3c15c2e840fe | Auth-Type | Accept | := | | 2 | 3c15c2e840fe | cisco-AVPair | psk-mode=ascii | == | | 3 | 3c15c2e840fe | cisco-AVPair | psk=abcdefgh | == |
The Cisco-AVPair checks aren't matching. And this does *not* match the "users" file entry you posted earlier: 3c15c2e840fe Auth-Type := Accept cisco-AVPair = "psk-mode=ascii", cisco-AVPair = "psk=abcdefgh" The cisco-avpair lines go into the *radreply* table. And use the "=" operator, not "==". The SQL documentation on the Wiki goes into this in detail. Alan DeKok.