Bug 15781 - Squeezebox Server starts before MySQL
: Squeezebox Server starts before MySQL
Status: UNCONFIRMED
Product: Logitech Media Server
Classification: Unclassified
Component: Database
: 7.4.2
: Macintosh MacOS X 10.5
: -- normal (vote)
: ---
Assigned To: Unassigned bug - please assign me!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2010-02-25 12:07 UTC by Jonathan Nichols
Modified: 2010-02-25 13:37 UTC (History)
0 users

See Also:
Category: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jonathan Nichols 2010-02-25 12:07:24 UTC
Environment:
Mac OS X Server 10.5.8 with the included MySQL instance.

Problem:
I have set Squeezebox Server to use my own MySQL instance and databases. If I have to reboot the server for any reason, Squeezebox Server tries to start up before MySQL is up and available and as a result, it will fail with a database connection error and does not seem to retry. It's possible that the included MySQL version is just slow.

If I set Squeezebox Server to "Never start automatically" and I log in and start it manually after a reboot, it works as expected but I would like to avoid having to do this if at all possible.

Possible Solutions:
* Have Squeezebox Server attempt a MySQL connection 30 seconds after initial failure.
* User configurable option to delay Squeezebox Server from starting up. Might be useful for those that know they have a slow MySQL database.


Can I just add something like this to slimserver.pl?

$num = 30;
while($num--){
    sleep(1);
}
Comment 1 Jonathan Nichols 2010-02-25 13:37:10 UTC
*** Bug 15783 has been marked as a duplicate of this bug. ***