Hi Alan, i have three columns in the table nasname, shortname and server. what has to be put where? where should the ip go? tia .h
Am 30.11.2017 um 20:27 schrieb Alan DeKok-2 [via FreeRADIUS] <ml+s1045715n5748211h68@n5.nabble.com>:
On Nov 30, 2017, at 2:20 PM, .h <[hidden email] <x-msg://26/user/SendEmail.jtp?type=node&node=5748211&i=0>> 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.
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html <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... <http://freeradius.1045715.n5.nabble.com/Freeradius-3-sql-not-working-with-nas-entries-in-nas-table-tp5748186p5748211.html> To unsubscribe from FreeRADIUS, click here <http://freeradius.1045715.n5.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=2740692&code=aEBhbGYud29ybGR8Mjc0MDY5MnwxMDIzMzk2NTk3>. NAML <http://freeradius.1045715.n5.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>