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@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-na... <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>