User-Password

[Javier Escalante]

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 at 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 at 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 at 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 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.


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html