0

Over the last two nights, my MySQL service has just stopped on its own. I have had no issues before for the last year and there have been no database changes within the last two days. Could this be a hack? Can someone be stopping the service somehow by exploiting a possible weakpoint in my website? I would like to believe my system is pretty secure against things like SQL injection attacks, but perhaps there are other ways?

I am running MySQL 5.1.11 and Railo 3.2.1.000 final

Any advice would be greatly appreciated.

10
  • 2
    Please post the relevant lines from the log. Jun 6, 2011 at 20:15
  • 1
    Try looking into the mysql error log, perhaps at /var/log/mysql/mysqld.err. If it's not there, see the config file for the error log location. Jun 6, 2011 at 20:17
  • @Emil Vikström: Which log would that be?
    – Cheeky
    Jun 6, 2011 at 20:21
  • @ypercube: So I did a full search of my harddrive and found no file called mysqld.err?? Is that possible?
    – Cheeky
    Jun 6, 2011 at 20:49
  • 1
    This belongs on superuser.com
    – Ex Umbris
    Jun 6, 2011 at 21:17

1 Answer 1

0

check your mysql configuration for the log location. look for:

log_error=

if that isn't set, you can either add it to your my.cnf, or you can just set it at runtime. I haven't tried the later personally, but the docs indicate that it's doable under 5.1.x.

seems odd that you wouldn't have any logs, though. Try:

find /var/log -name mysql*

and then look in /var/log/messages and /var/log/syslog, and check your crontab entries to make sure they're not doing something unexpected; MySQL won't die without making a lot of noise. Your question is unfortunately impossible to answer without more information.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .