how to transfer from "users file to sql"
aland at deployingradius.com
Fri Sep 13 15:21:28 CEST 2019
On Sep 13, 2019, at 9:06 AM, Bornemann, Hans <hans.bornemann at 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.
More information about the Freeradius-Users