Database error for the past 4 days

[savanna96]

Hey on my host that I am a root admin of but don't own but have full access MYSQL keeps disconnecting every couple hours and every night when I sleep it has the error I keep resetting the MYSQL but I need to know what I need to fix to stop this from happening because it's going to drive clients away. What test can I run to attempt to fix this error

Thanks,
Savanna

 

[JaredR.]

What is the error?

 

[savanna96]

Error establising to database

 

[savanna96]

Can'r access error log

when I try to check the log on both User "Root" and my root account I get Permission Denied so I can't even check what is wrong and I opened another topic got 1 reply all day so I haven't been able to fix it

 

[JaredR.]

Re: Can'r access error log

Which log are you trying to access? Apache, cPanel, or something else?

How, exactly, are you trying to access it? Are you logging into the shell as root?

 

[savanna96]

I'm trying to access the /var/lib/mysql/hostname.err and yes as Root because I'm trying to get the error fixed as I have to keep resetting the SQL Part every couple of hours

 

[cPanelMichael]

Hello

Could you let us know the specific command you are attempting to use? For example, have you tried using "cat" or "tail -f" before the log file name? Are you logged in via SSH?

Thank you.

 

[savanna96]

I was just doing /var/lib/mysql/hostname.err but I just did tail -f and this is all I got


130215 20:31:09 InnoDB: Completed initialization of buffer pool
130215 20:31:09 InnoDB: highest supported file format is Barracuda.
130215 20:31:09 InnoDB: Waiting for the background threads to start
130215 20:31:10 InnoDB: 1.1.8 started; log sequence number 306804440
130215 20:31:10 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130215 20:31:10 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130215 20:31:10 [Note] Server socket created on IP: '0.0.0.0'.
130215 20:31:10 [Note] Event Scheduler: Loaded 0 events
130215 20:31:10 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.28-cll' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)

 

[savanna96]

Ok the Database just failed which I needed to get the correct error log:

130216 1:34:02 [ERROR] /usr/sbin/mysqld: Can't open file: './whmsonic/sch.frm' (errno: 24)
130216 1:34:15 [ERROR] /usr/sbin/mysqld: Can't open file: './cphulkd/auths.frm' (errno: 24)
130216 1:34:15 [ERROR] /usr/sbin/mysqld: Can't open file: './cphulkd/auths.frm' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.fr m' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/defers.f rm' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/failures .frm' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.fr m' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/defers.f rm' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.fr m' (errno: 24)
130216 1:34:20 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/failures .frm' (errno: 24)