Album Database Error

[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,

[Ubi]

try

Code: Select all

/etc/init.d/mysql start

[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?

[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.

[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

[Ubi]

so it restarted and checking for corruption. That doesn't really mean anything
The real question whether you could access the socket again.