AW: how to transfer from "users file to sql"

[Bornemann, Hans]

Hi,

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   	| == |

-----Ursprüngliche Nachricht-----
Von: Freeradius-Users <freeradius-users-bounces+hans.bornemann=tu-dortmund.de at lists.freeradius.org> Im Auftrag von Alan DeKok
Gesendet: Freitag, 13. September 2019 14:52
An: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Betreff: Re: how to transfer from "users file to sql" 

On Sep 13, 2019, at 3:52 AM, Bornemann, Hans <hans.bornemann at tu-dortmund.de> wrote:
> 
> Thanks, but after fixing the sql module, it is the same: Auth-Type not fournd
> 
> (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = '3c15c2e840fe' ORDER BY id

  What does that show you?

  Odds are it doesn't include "Auth-Type := Accept".

  Alan DeKok.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6337 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20190913/a38bbbe4/attachment-0001.bin>