Freeradius 3 sql not working with nas entries in nas table

[.h]

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
Failed to add client, possible duplicate?
rlm_sql (sql): Released connection (0)

where should the virtual server be defined?

tia
.h

> Am 30.11.2017 um 16:14 schrieb Alan DeKok-2 [via FreeRADIUS] <ml+s1045715n5748195h72 at n5.nabble.com>:
> 
> 
> > On Nov 30, 2017, at 9:26 AM, .h <[hidden email]> wrote: 
> > 
> > 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): No short name found for row 1 
> > rlm_sql (sql): Released connection (0) 
> 
>   That's the problem. 
> 
>   While there's a lot of information in the debug output, reading it *is* helpful.  Typically I just look for the things that are a problem... 
> 
>   e.g. problem reading clients from SQL?  Look for debug messages containing both "sql" and "clients".  Yup... there it is. 
> 
>   If you're running in a terminal, the debug output *should* print the "No short name found" line in red.  Which helps a lot in finding errors. 
> 
>   If it doesn't... upgrade to a newer version of the server. 
> 
>   Alan DeKok. 
> 
> 
> - 
> List info/subscribe/unsubscribe? See 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-tp5748186p5748195.html
> To unsubscribe from FreeRADIUS, click here.
> NAML