installtion of freeradius

Javier Escalante Javier.Escalante at bwireless.eu
Thu Jun 21 12:03:59 CEST 2018


Hello,

Based on this tutorial: https://wiki.freeradius.org/guide/SQL-HOWTO#Populating_SQ I should add the line  $INCLUDE  sql.conf on /etc/freeradius/3.0/default.conf, but this file does not exist. 

Can anybody tell me where to find it?

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: Javier Escalante [mailto:Javier.Escalante at bwireless.eu] Sent: jueves, 21 de junio de 2018 11:38
To: 'FreeRadius users mailing list'
Subject: RE: installtion of freeradius

Hello,

Freeradius (3.0.16) authenticates correctly with files, but gives the following error when I use a user from the DB.

(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
(2) sql:    --> .query
(2) sql: Using query template 'query'
rlm_sql (sql): Reserved connection (9)
(2) sql: EXPAND %{User-Name}
(2) sql:    --> test
(2) sql: SQL-User-Name set to 'test'
(2) sql: EXPAND INSERT INTO radpostauth (username, pass, reply, authdate) VALUES                                                                                         ( '%{SQL-User-Name}', '%{%{User-Password}:-%{Chap-Password}}', '%{reply:Packet-                                                                                        Type}', '%S')
(2) sql:    --> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES                                                                                         ( 'test', 'test', 'Access-Reject', '2018-06-21 09:23:06')
(2) sql: Executing query: INSERT INTO radpostauth (username, pass, reply, authda                                                                                        te) VALUES ( 'test', 'test', 'Access-Reject', '2018-06-21 09:23:06')
(2) sql: SQL query returned: success
(2) sql: 1 record(s) updated
rlm_sql (sql): Released connection (9)
(2)     [sql] = ok
(2) attr_filter.access_reject: EXPAND %{User-Name}
(2) attr_filter.access_reject:    --> test
(2) attr_filter.access_reject: Matched entry DEFAULT at line 11
(2)     [attr_filter.access_reject] = updated
(2)     [eap] = noop
(2)     policy remove_reply_message_if_eap {
(2)       if (&reply:EAP-Message && &reply:Reply-Message) {
(2)       if (&reply:EAP-Message && &reply:Reply-Message)  -> FALSE
(2)       else {
(2)         [noop] = noop
(2)       } # else = noop
(2)     } # policy remove_reply_message_if_eap = noop
(2)   } # Post-Auth-Type REJECT = updated
(2) Delaying response for 1.000000 seconds Waking up in 0.3 seconds.
Waking up in 0.6 seconds.
(2) Sending delayed response
(2) Sent Access-Reject Id 200 from 127.0.0.1:1812 to 127.0.0.1:42877 length 20 Waking up in 3.9 seconds.
(2) Cleaning up request packet ID 200 with timestamp +2764 Ready to process requests
(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: WARNING: Authentication will fail unless a "known good" password is ava                                                                                        ilable


The user in radcheck below:

Full texts 	id 	username 	attribute 	op 	value
Edit Edit 	Copy Copy 	Delete Delete 	1173544 	test 	Cleartext-Password 	:= 	test



Could somebody give me a clue of what is going on?

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. 





More information about the Freeradius-Users mailing list