Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#47 Radius refuses to start within VM installation - citing SQL errors

all
open
nobody
None
1
2014-08-22
2012-11-02
Anonymous
No

Fresh install using the VM from this site. I have only been using it for a few hours. I made only a few changes, changed a user and changed the shared secret.
Radius server now fails to restart.
Radius logs show :
Fri Nov 2 12:10:34 2012 : Error: Failed to load virtual server
Fri Nov 2 12:10:34 2012 : Error: /etc/freeradius/sites-enabled/default[62]: Errors parsing authorize section.
Fri Nov 2 12:10:34 2012 : Error: /etc/freeradius/sites-enabled/default[165]: Failed to load module "sql".
Fri Nov 2 12:10:34 2012 : Error: /etc/freeradius/sql.conf[22]: Instantiation failed for module "sql"
Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 0
Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 1
Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 2
Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 3
Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 4
Fri Nov 2 12:10:34 2012 : Error: Failed to load clients from SQL.
Fri Nov 2 12:10:34 2012 : Error: Failed to add duplicate client localhost

Tried deleting the user to no avail.
Service Status says Radius is Disabled and Mysql is Enabled.

Discussion

  • Krzysztof
    Krzysztof
    2012-11-02

    Well you obviously have some error in your sql.conf file.
    Check for missing brackets and/or missing or extra commas.

    K

    On 02/11/12 12:13, Ticket 47 wrote:


    bugs:47 Radius refuses to start within VM installation - citing SQL
    errors

    Status: open Created: Fri Nov 02, 2012 12:13 PM UTC by Anonymous
    Last Updated: Fri Nov 02, 2012 12:13 PM UTC Owner: nobody

    Fresh install using the VM from this site. I have only been using it
    for a few hours. I made only a few changes, changed a user and changed
    the shared secret.
    Radius server now fails to restart.
    Radius logs show :
    Fri Nov 2 12:10:34 2012 : Error: Failed to load virtual server
    Fri Nov 2 12:10:34 2012 : Error:
    /etc/freeradius/sites-enabled/default62: Errors parsing authorize section.
    Fri Nov 2 12:10:34 2012 : Error:
    /etc/freeradius/sites-enabled/default165: Failed to load module "sql".
    Fri Nov 2 12:10:34 2012 : Error: /etc/freeradius/sql.conf22:
    Instantiation failed for module "sql"
    Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 0
    Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 1
    Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 2
    Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 3
    Fri Nov 2 12:10:34 2012 : Info: rlm_sql (sql): Closing sqlsocket 4
    Fri Nov 2 12:10:34 2012 : Error: Failed to load clients from SQL.
    Fri Nov 2 12:10:34 2012 : Error: Failed to add duplicate client localhost

    Tried deleting the user to no avail.
    Service Status says Radius is Disabled and Mysql is Enabled.


    Sent from sourceforge.net because you indicated interest in
    https://sourceforge.net/p/daloradius/bugs/47/

    To unsubscribe from further messages, please visit
    https://sourceforge.net/auth/prefs/

     

  • Anonymous
    2012-11-02

    Funny thing is - I have not altered it at all. I download the VM appliance and run it. I don't alter any of the files at all - but after a few restarts it stops working.
    I swear I have not touched the sql.conf at all (not directly - although perhaps Daloradius may).

    I delete the VM, redownload it and run it and it works fine again. After a few changes (like changing the shared secret password, adding hot spots etc.) it stops working again.

     

  • Anonymous
    2013-04-08

    The problem is due to client.conf where the NAS localhost is listed,
    and this same host also exist on the nas table in MySQL so you have to delete one of them

     


Anonymous


Cancel   Add attachments