Freeradius 3 sql not working with nas entries in nas table

[.h]

Hi Alan,

no worries, I know what a NAS is.
I’m using freeradius for quite a while, but not the sql version.

I was able to transfer every setting to sql except the clients.conf.

in the former config adding a new client was simple by adding a section to clients.conf, i.e.:

client client_xyz {
      ipaddr          = 10.0.0.1
      secret          = secret
}

Now adding a line into the nas table is not giving me the same result.
+----+-----------+-----------+-------+-------+------------+-----------+-----------+-------------------------+
| id | nasname   | shortname | type  | ports | secret     | server    | community | description             |
+----+-----------+-----------+-------+-------+------------+-----------+-----------+-------------------------+
|  1 | 127.0.0.1 | localhost | other |  NULL | testing123 | localhost | NULL      | localhost RADIUS Client |
+----+-----------+-----------+-------+-------+------------+-----------+-----------+-------------------------+

This is whats unclear to me.

what is the easiest way to transfer all clients from .conf to sql?

TIA
.h

> Am 30.11.2017 um 20:59 schrieb Alan DeKok-2 [via FreeRADIUS] <ml+s1045715n5748215h92 at n5.nabble.com>:
> 
> On Nov 30, 2017, at 2:52 PM, .h <[hidden email] <x-msg://5/user/SendEmail.jtp?type=node&node=5748215&i=0>> wrote: 
> > 
> > is there any documentation on this section? 
> 
>   On what section? 
> 
>   The queries.conf file describes what each column should contain. 
> 
> > do i have to add a virtual server for every nas that will be used? 
> 
>   You need to populate each column in the row. 
> 
>   Multiple rows can use "default" for the virtual server column... which then tells it to use the "default" virtual server. 
> 
>   The "nas" table in SQL defines a NAS.  With IP address, shared secret, and virtual server. 
> 
> 
>   I *did* point you to documentation.  Did you read it?  Because the question here makes it look like you don't know what a virtual server is, or what a NAS is, or what the purpose of each column is. 
> 
>   Alan DeKok. 
> 
> 
> - 
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html <http://www.freeradius.org/list/users.html> 
> 
> If you reply to this email, your message will be added to the discussion below:
> http://freeradius.1045715.n5.nabble.com/Freeradius-3-sql-not-working-with-nas-entries-in-nas-table-tp5748186p5748215.html <http://freeradius.1045715.n5.nabble.com/Freeradius-3-sql-not-working-with-nas-entries-in-nas-table-tp5748186p5748215.html>
> To unsubscribe from FreeRADIUS, click here <http://freeradius.1045715.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=2740692&code=aEBhbGYud29ybGR8Mjc0MDY5MnwxMDIzMzk2NTk3>.
> NAML <http://freeradius.1045715.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>