Hi Matthew, no change. freeradius is still not recognizing the client. ########## dynamic clients ########## client dynamic { ipaddr = 192.0.2.0/24 dynamic_clients = dynamic_clients lifetime = 3600 } server dynamic_clients { authorize { update control { &FreeRADIUS-Client-IP-Address = "%{Packet-Src-IP-Address}" &FreeRADIUS-Client-Require-MA = no &FreeRADIUS-Client-Secret = "testing123" &FreeRADIUS-Client-Shortname = "%{Packet-Src-IP-Address}" &FreeRADIUS-Client-NAS-Type = "other" &FreeRADIUS-Client-Virtual-Server = "something" } dynamic_clients if ("%{sql: SELECT nasname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}") { update control { &FreeRADIUS-Client-IP-Address = "%{Packet-Src-IP-Address}" &FreeRADIUS-Client-Shortname = "%{sql: SELECT shortname FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}" &FreeRADIUS-Client-Secret = "%{sql: SELECT secret FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}" &FreeRADIUS-Client-NAS-Type = "%{sql: SELECT type FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}" &FreeRADIUS-Client-Virtual-Server = "%{sql: SELECT server FROM nas WHERE nasname = '%{Packet-Src-IP-Address}'}" } } ok } } anything from in the conf? TIA .h
Am 30.11.2017 um 14:26 schrieb Matthew Newton-3 [via FreeRADIUS] <ml+s1045715n5748187h24@n5.nabble.com>:
On Thu, 2017-11-30 at 14:17 +0100, .h wrote:
after commenting the entry for localhost in the conf file and putting them into the nas table, reloading freenas, the connection from localhost is rejected.
...
Listening on auth address * port 1812 bound to server default Listening on acct address * port 1813 bound to server default Listening on auth address :: port 1812 bound to server default Listening on acct address :: port 1813 bound to server default Listening on auth address 127.0.0.1 port 18120 bound to server inner- tunnel Listening on proxy address * port 45483 Listening on proxy address :: port 52244 Ready to process requests Ignoring request to auth address * port 1812 bound to server default from unknown client 127.0.0.1 port 47933 proto udp Ready to process requests
any suggestions?
Enable the dynamic-clients virtual server in raddb/sites-enabled.
-- Matthew
- 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-tp5748186p5748187.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>