Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Jun 7 '11 at 4:04

This question came from our site for professional and enthusiast programmers.

2  
Please post the relevant lines from the log. –  Emil Vikström Jun 6 '11 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. –  ypercube Jun 6 '11 at 20:17
    
@Emil Vikström: Which log would that be? –  Cheeky Jun 6 '11 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 '11 at 20:49
1  
This belongs on superuser.com –  Ex Umbris Jun 6 '11 at 21:17
show 5 more comments

1 Answer 1

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.