Freeradius 3 sql not working with nas entries in nas table

[.h]

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 at 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-nas-entries-in-nas-table-tp5748186p5748187.html <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>