<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:12pt"><div><span>Thank you both for your answers.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span>I had forgotten to specify in my first mail that I've restarted the radiusd numerous times and that my sql.conf file contains</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span>readclients = yes<br>nas_table = "nas"</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style:
normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span>I've put a # in front of files because I wanted the radiusd to check the user's password only in MySQL</span></div><span>Alan, sorry but I didn't understand what you wrote in your last sentence, about that.<br>And how to enable MySQL only without clients.conf ?<br></span><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: HelveticaNeue,Helvetica Neue,Helvetica,Arial,Lucida Grande,sans-serif; background-color: transparent; font-style: normal;"><span>So I still have the problem and I don't understand what's
wrong</span></div><br>mysql> select * from nas;<br>+----+----------------+-----------+-------+-------+-----------+--------+-----------+-------------------+<br>| id | nasname | shortname | type | ports | secret | server | community | description |<br>+----+----------------+-----------+-------+-------+-----------+--------+-----------+-------------------+<br>| 1 | 192.168.0.1 | myNAS | other | NULL | mysecret | NULL | NULL | RADIUS Client |<br><br>When I start the server with the -X option<br>rlm_sql_mysql: query: SELECT id, nasname, shortname, type, secret, server FROM nas<br>rlm_sql (sql): Read entry nasname=192.168.0.1,shortname=myNAS,secret=mysecret<br>rlm_sql (sql): Adding client 192.168.0.1 (myNAS, server=<none>) to
clients list<br><br><div style="display: block;" class="yahoo_quoted"> <br> <br> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> Le Samedi 9 novembre 2013 13h02, "A.L.M.Buxey@lboro.ac.uk" <A.L.M.Buxey@lboro.ac.uk> a écrit :<br> </font> </div> <blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div class="y_msg_container">Hi,<br clear="none"><br clear="none">> I know that by default you configure your radius clients in the file<br clear="none">> /etc/raddb/clients.conf<br clear="none"><br clear="none">correct<br clear="none"><br clear="none">> However I would like them to be entered in MySQL<br
clear="none"><br clear="none">thats easy. add them to the NAS table in your MySQL DB and then simply read the<br clear="none">sql.conf file near the bottom and uncomment the readclients = yes line.<div class="yqt8170236017" id="yqtfd81153"><br clear="none"><br clear="none">> I have modified the file /etc/raddb/sites-enabled/default and I expect the<br clear="none">> Freeradius server to check the clients in MySQL instead of clients.conf<br clear="none">> authorize {<br clear="none">> sql<br clear="none">> #files</div><br clear="none">> }<br clear="none"><br clear="none">???? no. what you've done there is enable SQL in the authorise stage...so a<br clear="none">device attempting to use RADIUS will be checked against SQL. except that it wont<br clear="none">because the NAS trying to talk wont be allowed to talk (and commenting out<br clear="none">'files' means
that the users file wont work anymore....thats what that option does!)<br clear="none"><br clear="none">alan<div class="yqt8170236017" id="yqtfd08721"><br clear="none"><br clear="none"></div><br><br></div> </blockquote> </div> </div> </div> </div></body></html>