Hello Alan, Thanks, I added the user test in radusergroup, and the result is exactly the same. The tutorial you comment, is the same I followed. Any clue? Thanks in advance BR Javier Escalante Business Development Manager Javier.escalante@bwireless.eu 00 34 626 785 675 00 34 93 141 56 36 00 41 78 689 85 69 Skype: fruiz002 Do you know our IoT solutions? Have a look here: www.bsmart.global http://www.bwireless.eu Le informamos que, de conformidad con la Ley Orgánica 15/1999, de 13 de diciembre, de Protección de Datos de Carácter Personal, se informa que todos los datos personales que nos ha facilitado serán incorporados y tratados en los ficheros de B’W & TAKACS TELECOM, S.L. para las finalidades de su e-mail. Puede ejercer sus derechos de acceso, rectificación, cancelación y oposición mediante una comunicación a B’W & TAKACS TELECOM, S.L. con domicilio en Camil Oliveras, 26, 08032 Barcelona (España), o bien mediante una comunicación a la dirección de correo electrónico info@bwireless.eu. En ambos casos, deberá acompañar una copia de su documento nacional de identidad o documento válido que lo identifique. -----Original Message----- From: Freeradius-Users [mailto:freeradius-users-bounces+javier.escalante=bwireless.eu@lists.freeradius.org] On Behalf Of Alan DeKok Sent: lunes, 25 de junio de 2018 0:48 To: FreeRadius users mailing list Subject: Re: User-Password
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 -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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html