Page 1 of 1

Album Database Error

Posted: 24 Nov 2010, 16:22
by scoobynz
Hello,

I cannot get the album to work, I get the error

A Database Error Occurred
Unable to connect to your database server using the provided settings.


Having read other forum items on this I have tried,as per this thead http://forum.excito.net/viewtopic.php?f ... rred#p8614

including removing the bubba backend and reinstalling. No apparent errors.

I assume that the problem may be that I could have change mysql password, but I cannot remember doing this and all other database applications seem to be fine.

ekaterina@ekaterina-laptop:~$ mysql --user=root --pass mysql
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)


Does anyone have any ideas how I can get the album working again.

Many thanks in advance,

Re: Album Database Error

Posted: 25 Nov 2010, 03:06
by Ubi
try

Code: Select all

/etc/init.d/mysql start

Re: Album Database Error

Posted: 25 Nov 2010, 07:31
by scoobynz
Thanks for the reply,

This returns,
Starting MySQL database server: mysqld already running.
with no other error message.

Seems to be a bit of an odd one?

Re: Album Database Error

Posted: 25 Nov 2010, 07:39
by Ubi
interesting :)

so for some reason the daemon is present but you cannot get to the socket. You can give a "/etc/init.d/mysql stop" and then a "start" again to force a cycle. You can also check if you can connect to the IP interface, but for starters I'd reboot and see if mysql comes back up.

Re: Album Database Error

Posted: 25 Nov 2010, 08:17
by scoobynz
now at least we get some clues!

Stopped and restarted and got the following on restart.

Starting MySQL database server: mysqld ..
Checking for corrupt, not cleanly closed and upgrade needing tables..


I have previously rebooted bubba to attempt to fix this. Am at work at the moment so may try a full shutdown / depower etc, rather than through the interface.

Thanks for your help.
C

Re: Album Database Error

Posted: 25 Nov 2010, 09:22
by Ubi
so it restarted and checking for corruption. That doesn't really mean anything
The real question whether you could access the socket again.