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