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@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-na... To unsubscribe from FreeRADIUS, click here. NAML