mysql is down ???

[yatoula]

HI,
in my serveur mysql is down but in ssh when i test :

/etc/init.d/mysqld stop

The server say FAILED
and with START is good, but the mysql say for all website :

Database Error: Unable to connect to the database:Could not connect to MySQL

thanks, it's very important

 

[daveyw]

Please take a look in the logs

cat /var/lib/mysql/<hostname>.err

Replace <hostname> by your hostname (without < >)

 

[yatoula]

Hi, thanks, but i don't have a folder mysql in the folder lib.
But yesterday i have a problem with exim and email ...
I don't arrived to clean the email in suspend ..

Thanks

 

[daveyw]

Hi, thanks, but i don't have a folder mysqlin the folder lib

Which OS are you using?
CentOS/Fedora it should be /var/lib/mysql.

Could you also try

ps aux | grep mysql

rpm -qa | grep MySQL

 

[yatoula]

i used Debian Lenny

and wth the command i have :

ps aux | grep mysql
root 31274 0.0 0.0 3608 720 pts/0 S+ 16:56 0:00 grep mysql
rpm -qa | grep MySQL
-bash: rpm: command not found
nsxxxxxx:~#

 

[frankc420]

Try: locate hostname.err -- replace hostname with the hostname of your server.

Once that is done look in the found file and determine the cause of why MySQL is down. Most likely due to the mysql.sock file.

 

[daveyw]

Try: locate hostname.err -- replace hostname with the hostname of your server.

Before you can use 'locate' they can best do 'updatedb', when that's done do 'locate <hostname>.err'

 

[frankc420]

Before you can use 'locate' they can best do 'updatedb', when that's done do 'locate <hostname>.err'

There is usually a daily cronjob that runs the database updater for locate.

 

[nobaloney]

It depends. My CentOS installs from ISO do enable the database update in cron.daily, but a lot of VPS servers do not by default, since many admin's don't find they need it, and it does use resources.

Jeff

 

[yatoula]

hi,
smtalk help me for the server, but now i have a problem with all email account , unable to send or receive emails. I do not know what to do and my clients can not use their accounts.
Thank you

 

[yatoula]

it's not possible to reinstall systeme email ?
Thanks it's very important

 

[nobaloney]

email is a rather inclusive term. Since you don't show us any error methods or explain any symptoms, it's impossible to guess where to start.

Jeff

 

[yatoula]

I can neither send nor receive mail.
The trouble is that I do not know what smtalk did. I can not send or receive emails and I do not know where to look. Another person ran this server but no longer with us. I really have not much knowledge and my clients begin to howl.

 

[nobaloney]

I was unable to log into the forum for about a week. Suddenly I see your reference to smtalk. If he worked on something with your server, then you should probably contact him, as he knows what he did.

The first step in fixing your problem (if you still have it) is to understand what the problem is.

You can certainly reinstall Dovecot (or install it for the first time if you've never updated to using it), and certainly you can reinstall Exim. However it's very unlikely that the problem is in your core code; therefore it's very unlikely that either reinstall will fix your problem.

Unless your log files at /var/log/exim are completely empty there are lots of clues in those files as to what's wrong.

If you can't interpret them, then you may need to hire someone who can.

Jeff