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