NAS info + MySQL

[Edgars]

Marcin,

you should configure your radiusd.conf file so that clients.conf would 
not be used at all, otherwise - yes, there should be at least one symbol 
in that file to run the radius.
You should use the proper schema for the NAS table in order to get 
everything to work. Refer to /src/modules/rlm_sql/drivers/rlm_sql_xxx 
for that.

Regards,

Edgars



Marcin Jessa wrote:

>Hi Edgars.
>
>
>On Wed, 01 Jun 2005 16:41:15 +0300
>Edgars <edzix19 at inbox.lv> wrote:
>
>  
>
>>in the slq conf file set readclients=yes and make sure that nas_table=nas.
>>    
>>
>
>In the first email I said I had that enabled.
>So you mean nas table is properly used by freeradius and reads the hosts stored in it with the secret for the NAS?
>What about the clients.conf file? What should I keep there? It needs at least one host definition or radius will not start.
>
>
>
>
>
>  
>
>>Marcin Jessa wrote:
>>
>>    
>>
>>>Hi guys.
>>>
>>>I was wondering if the information read from the nas table is in any way used by freeradius or maybe I misread/misconfigured something?
>>>The sql.conf file has set readclients = yes but freeradius is ignoring the information stored in sql using only the one from clients.conf.
>>>The clients.conf itself has to be included in the radiusd.conf as well and the clients.conf needs at least one valid client info stored in it.
>>>
>>>Example of my nas table:
>>>
>>>mysql> select * from nas;
>>>+----+-------------------+-----------+----------+-------+----------+-----------+----------------------------------+
>>>| id | nasname           | shortname | type     | ports | secret   | community | description                      |
>>>+----+-------------------+-----------+----------+-------+----------+-----------+----------------------------------+
>>>|  1 | localhost         | Localhost | mikrotik |  1812 | xxxyyyzz | whatever  | Localhost Radius Server  |
>>>|  4 | demo.domain.com | demo     | mikrotik |  1812 | xxxyyzz | whatever  | Demo Radius Server      |
>>>+----+-------------------+-----------+----------+-------+----------+-----------+----------------------------------+
>>>
>>>The hosts in nasname have their corresponding IP's stored in /etc/hosts or a local DNS server.
>>>
>>>Regards,
>>>Marcin Jessa.
>>>- 
>>>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>>
>>>
>>> 
>>>
>>>      
>>>
>>- 
>>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>>    
>>
>
>
>  
>