daloRADIUS / Bugs / #47 Radius refuses to start within VM installation

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/

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

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.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

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

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
- Anonymous
  
  Add attachments
  Cancel
  You seem to have CSS turned off. Please don't fill out this field.
  
  You seem to have CSS turned off. Please don't fill out this field.

Radius refuses to start within VM installation - citing SQL errors

RADIUS web management application

Group

Searches

Help

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

Discussion