On Jun 24, 2018, at 10:37 AM, Javier Escalante <Javier.Escalante@bwireless.eu> wrote:
Hello,
Could it be correct? http://freeradius.1045715.n5.nabble.com/ISSUE-Authentication-will-fail-unles...
If so? Where should I change it?
You need to add a "known good" password to SQL. Read this: https://wiki.freeradius.org/guide/SQL%20HOWTO
(0) sql: --> SELECT id, username, attribute, value, op FROM radcheck WHERE us ername = 'test' ORDER BY id (0) sql: Executing select query: SELECT id, username, attribute, value, op FROM radcheck WHERE username = 'test' ORDER BY id (0) sql: EXPAND SELECT groupname FROM radusergroup WHERE username = '%{SQL-User- Name}' ORDER BY priority (0) sql: --> SELECT groupname FROM radusergroup WHERE username = 'test' ORDER BY priority (0) sql: Executing select query: SELECT groupname FROM radusergroup WHERE userna me = 'test' ORDER BY priority (0) sql: User not found in any groups rlm_sql (sql): Released connection (0) Need 5 more connections to reach 10 spares rlm_sql (sql): Opening additional connection (5), 1 of 27 pending slots used (0) [sql] = notfound
The user wasn't found in the "radcheck" table. Follow the documentation. It *will* work. Alan DeKok.