Freeradius + MySQL At System Boot = Freeradius Failure

[James Duffy]

Marinko

This sounds like a race will take place between the two processes if there is no co-ordination. If (as you say) you are able to start mysqld after radiusd then I think if you look at tail of /var/log/radius/radius.log you will see something like:

Starting connect to MySQL server for #0
Couldn't connect socket to MySQL server root at 127.0.0.1:radius
Mysql error 'Can't connect to MySQL server on '127.0.0.1' (61)'
Failed to connect DB handle #0
Ready to process requests.

and then messages about radiusd managing to re-aquire the db handles later on - eg:

Trying to (re)connect unconnected handle 3..
Starting connect to MySQL server for #3
got socket 3 after skipping 0 unconnected handles

There needs to be a wait-on-mysql option for radiusd startup - surely?? What baffles me is that I'm a newbie here and surely all the veteran users have long since flushed this problem out into the open - or does nobody EVER use the NAS sql extensions??

JD




________________________________
From: Marinko Tarlac <mangia81 at gmail.com>
To: FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
Sent: Monday, September 7, 2009 9:54:04 PM
Subject: Re: Freeradius + MySQL At System Boot = Freeradius Failure

Well right now No but in this moment I don't have test server so I can't help you in this case...

Also, NAS table usually is not so big and I don't see any reason for slow start.

Is there anything in mysql logs ?

James Duffy wrote:
> Marinko
> 
> Do you use MySQL for NAS authentication? I have noticed that Freeradius can re-connect to the database for user authentication later in the process. However as NAS is only read during startup then if MySQL is not ready its understandable why Freeradius would bomb out.
> 
> JD
> 
> ------------------------------------------------------------------------
> *From:* Marinko Tarlac <mangia81 at gmail.com>
> *To:* FreeRadius users mailing list <freeradius-users at lists.freeradius.org>
> *Sent:* Sunday, September 6, 2009 6:28:19 PM
> *Subject:* Re: Freeradius + MySQL At System Boot = Freeradius Failure
> 
> same here... I never had similar problem when mysqld is started after
> radiusd
> 
> You should check your mysql logs to see is there any problem which
> causes slow start...
> 
> Alan Buxey wrote:
> > Hi,
> >
> > >> I would have thought that a simple option in freeradius that allows it to wait for mysql to startup would be nice. Am I missing something obvious here? Is there a REAL solution or does freeradius not actually work with mysql properly due to the fact its too quick to abandon it during bootup??
> >>   >
> > chkconfig mysqld on
> > chkconfig radiusd on
> >
> > thats all i've ever done and it works fine
> >
> > alan
> > -
> > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> >
> > 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
> 
> ------------------------------------------------------------------------
> 
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20090907/b4f0bacc/attachment.html>