NAS info + MySQL

[Edgars]

in the slq conf file set readclients=yes and make sure that nas_table=nas.

Regards,

Edgars



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