Freeradius 3 sql not working with nas entries in nas table

[.h]

Hi Alan,

i have three columns in the table
nasname, shortname and server.

what has to be put where?
where should the ip go?

tia
.h

> Am 30.11.2017 um 20:27 schrieb Alan DeKok-2 [via FreeRADIUS] <ml+s1045715n5748211h68 at n5.nabble.com>:
> 
> On Nov 30, 2017, at 2:20 PM, .h <[hidden email] <x-msg://26/user/SendEmail.jtp?type=node&node=5748211&i=0>> wrote: 
> > 
> > one step further… but still not working. 
> > 
> > rlm_sql (sql) in generate_sql_clients: query is SELECT id, nasname, shortname, type, secret, server FROM nas 
> > rlm_sql (sql): Reserved connection (0) 
> > rlm_sql (sql): Executing select query: SELECT id, nasname, shortname, type, secret, server FROM nas 
> > rlm_sql (sql): Adding client localhost (localhost) to 127.0.0.1 clients list 
> > Failed to find virtual server 127.0.0.1 
> 
>   You have "127.0.0.1" in the "server" column.  You need to put in the name of the virtual server for this client. 
> 
> > Failed to add client, possible duplicate? 
> > rlm_sql (sql): Released connection (0) 
> > 
> > where should the virtual server be defined? 
> 
>   raddb/sites-enabled/ 
> 
>   The "default" file defines a virtual server called "default".  See it's contents for more information. 
> 
>   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-tp5748186p5748211.html <http://freeradius.1045715.n5.nabble.com/Freeradius-3-sql-not-working-with-nas-entries-in-nas-table-tp5748186p5748211.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>