User-Password

[Alan DeKok]

> On Jun 24, 2018, at 10:37 AM, Javier Escalante <Javier.Escalante at bwireless.eu> wrote:
> 
> Hello,
> 
> Could it be correct? http://freeradius.1045715.n5.nabble.com/ISSUE-Authentication-will-fail-unless-a-quot-known-good-quot-password-is-available-td5750133.html
> 
> 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.