how to transfer from "users file to sql"

[Alan DeKok]

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.

  Alan DeKok.