installtion of freeradius

[Matthew Newton]

On Thu, 2018-06-21 at 11:38 +0200, Javier Escalante wrote:
> Freeradius (3.0.16) authenticates correctly with files, but gives the
> following error when I use a user from the DB.

This part of the debug output is the bit you need to read:





This bit doesn't contain anything helpful:

> (2)     [logintime] = noop
> (2) pap: WARNING: No "known good" password found for the user.  Not
> setting
> Auth                                                                 
>                        -Type
> (2) pap: WARNING: Authentication will fail unless a "known good"
> password is
> ava                                                                  
>                       ilable
> (2)     [pap] = noop
> (2)   } # authorize = ok
> (2) ERROR: No Auth-Type found: rejecting the user via Post-Auth-Type
> = Reject
> (2) Failed to authenticate the user
> (2) Using Post-Auth-Type Reject
> (2) # Executing group from file /etc/freeradius/3.0/sites-
> enabled/default
> (2)   Post-Auth-Type REJECT {
> (2) sql: EXPAND .query
...


> Could somebody give me a clue of what is going on?


The SQL configuration looks like it's OK, because it succeeded on the
insert into radpostauth after the auth failure.

There's a reason https://wiki.freeradius.org/list-help says to post the
full debug output... the SQL search isn't coming back with anything,
but no idea why because we can't see it.

-- 
Matthew