Hi,
Since a couple of days, my Squeezebox cannot connect to Squeezecenter on Bubba. I have made no changes on the server. Reviewing the /var/log/squeezecenter/server.log file suggested there was an issue with the database. I figered, maybe there had been a power cut or something leaving the database in a corrupted state. I ran a database drop, and also an apt-get install --reinstall squeezecenter, but this apparently didn't fix it (no new Squeezecenter database has been created.)
Your advice highly appreciated!
Mats
New user's registration have been closed due to high spamming and low trafic on this forum. Please contact forum admins directly if you need an account. Thanks !
Squeezecenter problem
Re: Squeezecenter problem
Hi Matse,
I haven't done this for Squeeze, but I did try similar action for mediatomb some time ago for some user on the forum who had similar problems with mediatomb.
I found I had to manually drop the database, then create it, then grant permissions for the process owner before the install script would recreate the actual tables.
http://forum.excito.net/viewtopic.php?f ... rop#p14850
Perhaps easier to purge/install?
Anyway, the mysql logs will probably tell you why it fails.
Just an idea...
Good luck!
/Cheeseboy
I haven't done this for Squeeze, but I did try similar action for mediatomb some time ago for some user on the forum who had similar problems with mediatomb.
I found I had to manually drop the database, then create it, then grant permissions for the process owner before the install script would recreate the actual tables.
http://forum.excito.net/viewtopic.php?f ... rop#p14850
Perhaps easier to purge/install?
Anyway, the mysql logs will probably tell you why it fails.
Just an idea...
Good luck!
/Cheeseboy
Re: Squeezecenter problem
mysql only tells you sql problems if you enable the query logging. http://dev.mysql.com/doc/refman/5.0/en/query-log.html
be sure to turn it off afterwards or else your disk will fill up with a big logfile.
be sure to turn it off afterwards or else your disk will fill up with a big logfile.