Freeradius 3 sql not working with nas entries in nas table

[Alan DeKok]

> On Nov 30, 2017, at 9:26 AM, .h <h at alf.world> 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.