Freeradius 3 sql not working with nas entries in nas table

[Alan DeKok]

On Nov 30, 2017, at 2:20 PM, .h <h at alf.world> 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.