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

Got problems with your B2 or B3? Share and get helped!
Post Reply
matse
Posts: 48
Joined: 12 Aug 2008, 15:55

Squeezecenter problem

Post by 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
Posts: 789
Joined: 08 Apr 2007, 12:16

Re: Squeezecenter problem

Post by 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
Posts: 1549
Joined: 17 Jul 2007, 09:01

Re: Squeezecenter problem

Post by 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.
Post Reply