Freeradius 3 sql not working with nas entries in nas table

[Alan Buxey]

Server is the default virtual server to use. Eg default in a basic install.
Do you have a virtual server named localhost ??

alan

On 1 Dec 2017 4:24 am, ".h" <h at alf.world> wrote:

> 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=aEBhbGYud29ybGR8Mjc0MDY5MnwxMD
> IzMzk2NTk3>.
> > 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>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/
> list/users.html