Squeezecenter problem

[matse]

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

[Cheeseboy]

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

[Ubi]

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.