MySql Status "ON", But All Website "DOWN"

SufaNet

Registered
Oct 23, 2014
3
0
1
cPanel Access Level
DataCenter Provider
[Help]
MySql Status "ON", But All Website "DOWN"
When I access my website, Error shows that MySqli Script CANNOT Established the DATABASE!
This can be resolved by restarting mysql from WHM. It makes me tired, anyway.
Would you tell me where can I access "ERROR_LOG" in my WHM cPanel, I can't find "LOG" File for the error.

cat /var/log/mysql.log
cat: /var/log/mysql.log: No such file or directory

GNU nano 2.0.9 File: /etc/my.cnf
[mysqld]
default-storage-engine=MyISAM
innodb_file_per_table=1
max_allowed_packet=268435456

Please Help, thanks
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,216
363
Hello :)

The MySQL error log is located at:

/var/lib/mysql/$hostname.err

Replace "$hostname" with the actual hostname of your server. Note the error message you referenced shows "MySQLi". Have you verified that MySQLi was installed through EasyApache?

Thank you.
 

SufaNet

Registered
Oct 23, 2014
3
0
1
cPanel Access Level
DataCenter Provider
Hello :)

The MySQL error log is located at:

/var/lib/mysql/$hostname.err

Replace "$hostname" with the actual hostname of your server. Note the error message you referenced shows "MySQLi". Have you verified that MySQLi was installed through EasyApache?

Thank you.

How to check the error? And how to resolve?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,216
363
Try reviewing that error log when MySQL restarts to see if you notice any particular error messages. Also, have you checked to see if MySQL is running (e.g. using the "mysql" command)?

Thank you.
 

SufaNet

Registered
Oct 23, 2014
3
0
1
cPanel Access Level
DataCenter Provider
hello, this is the error :

Code:
141024  0:55:35 [Warning] IP address '50.117.38.138' could not be resolved: Temporary failure in name resolution
141024  0:55:36 [Warning] IP address '50.117.38.138' could not be resolved: Temporary failure in name resolution
141024  0:55:37 [Warning] IP address '50.117.38.138' could not be resolved: Temporary failure in name resolution
141024  0:55:40 [Warning] IP address '50.117.38.138' could not be resolved: Temporary failure in name resolution
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms1.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms2.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms3.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms4.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms5.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms6.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms7.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms8.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_terms9.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsa.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsb.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsc.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsd.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termse.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_links_termsf.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_taxonomy.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_taxonomy_map.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_terms.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_terms_common.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_tokens.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_tokens_aggregate.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_finder_types.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_languages.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_menu.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_menu_types.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_messages.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_messages_cfg.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_modules.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_modules_menu.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_newsfeeds.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_overrider.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_redirect_links.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_schemas.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_session.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_solusvm_vps.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_template_styles.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_update_categories.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_update_sites.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_update_sites_extensions.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_updates.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_user_notes.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_user_profiles.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_user_usergroup_map.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_usergroups.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_users.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_viewlevels.frm' (errno: 24)
141024  4:30:02 [ERROR] /usr/sbin/mysqld: Can't open file: './banter_joom548/jos_weblinks.frm' (errno: 24)
141024  5:10:10 [ERROR] /usr/sbin/mysqld: Can't open file: './sdn02jiw_jiwan/f0bpti_jabatan.frm' (errno: 24)
141024  5:13:42 [ERROR] /usr/sbin/mysqld: Can't open file: './sdn02jiw_jiwan/f0bpti_pengumuman.frm' (errno: 24)
141024  5:13:42 [ERROR] /usr/sbin/mysqld: Can't open file: './sdn02jiw_jiwan/f0bpti_agenda.frm' (errno: 24)
141024  5:15:01 [ERROR] Error in accept: Too many open files
141024  5:19:17 [ERROR] Error in accept: Too many open files
141024  5:23:33 [ERROR] Error in accept: Too many open files
141024  5:27:49 [ERROR] Error in accept: Too many open files
141024  5:32:05 [ERROR] Error in accept: Too many open files
141024  5:36:21 [ERROR] Error in accept: Too many open files
141024  5:40:37 [ERROR] Error in accept: Too many open files
141024  5:44:53 [ERROR] Error in accept: Too many open files
141024  5:49:09 [ERROR] Error in accept: Too many open files
141024  5:53:25 [ERROR] Error in accept: Too many open files
141024  5:57:41 [ERROR] Error in accept: Too many open files
141024  6:01:57 [ERROR] Error in accept: Too many open files
141024  6:06:13 [ERROR] Error in accept: Too many open files
141024  6:10:29 [ERROR] Error in accept: Too many open files
141024  6:14:45 [ERROR] Error in accept: Too many open files
141024  6:19:01 [ERROR] Error in accept: Too many open files
141024  6:23:17 [ERROR] Error in accept: Too many open files
141024  6:27:33 [ERROR] Error in accept: Too many open files
141024  6:31:49 [ERROR] Error in accept: Too many open files
141024  6:36:05 [ERROR] Error in accept: Too many open files
141024  6:40:21 [ERROR] Error in accept: Too many open files
141024  6:44:38 [ERROR] Error in accept: Too many open files
141024  6:48:54 [ERROR] Error in accept: Too many open files
141024  6:53:10 [ERROR] Error in accept: Too many open files
141024  6:57:26 [ERROR] Error in accept: Too many open files
141024  7:01:42 [ERROR] Error in accept: Too many open files
141024  7:05:58 [ERROR] Error in accept: Too many open files
141024  7:10:14 [ERROR] Error in accept: Too many open files
141024  7:14:30 [ERROR] Error in accept: Too many open files
141024  7:18:46 [ERROR] Error in accept: Too many open files
141024  7:23:02 [ERROR] Error in accept: Too many open files
141024  7:27:18 [ERROR] Error in accept: Too many open files
141024  7:31:34 [ERROR] Error in accept: Too many open files
141024  7:35:50 [ERROR] Error in accept: Too many open files
141024  7:40:06 [ERROR] Error in accept: Too many open files
141024  7:44:22 [ERROR] Error in accept: Too many open files
141024  7:48:38 [ERROR] Error in accept: Too many open files
141024  7:52:54 [ERROR] Error in accept: Too many open files
141024  7:57:10 [ERROR] Error in accept: Too many open files
141024  8:01:26 [ERROR] Error in accept: Too many open files
141024  8:05:42 [ERROR] Error in accept: Too many open files
141024  8:09:58 [ERROR] Error in accept: Too many open files
141024  8:14:14 [ERROR] Error in accept: Too many open files
141024  8:18:30 [ERROR] Error in accept: Too many open files
141024  8:22:46 [ERROR] Error in accept: Too many open files
141024  8:27:02 [ERROR] Error in accept: Too many open files
141024  8:31:18 [ERROR] Error in accept: Too many open files
141024  8:35:34 [ERROR] Error in accept: Too many open files
141024  8:39:50 [ERROR] Error in accept: Too many open files
141024  8:44:06 [ERROR] Error in accept: Too many open files
141024  8:48:22 [ERROR] Error in accept: Too many open files
141024  8:52:38 [ERROR] Error in accept: Too many open files
141024  8:56:54 [ERROR] Error in accept: Too many open files
141024  9:01:10 [ERROR] Error in accept: Too many open files
141024  9:05:26 [ERROR] Error in accept: Too many open files
141024  9:09:42 [ERROR] Error in accept: Too many open files
[email protected] [~]#
i try to restart from console now up again, but it can down again some time.

this is log after i restart mysql :

Code:
141024  8:56:54 [ERROR] Error in accept: Too many open files
141024  9:01:10 [ERROR] Error in accept: Too many open files
141024  9:05:26 [ERROR] Error in accept: Too many open files
141024  9:09:42 [ERROR] Error in accept: Too many open files
141024  9:14:20 [Note] /usr/sbin/mysqld: Normal shutdown

141024  9:14:20 [Note] Event Scheduler: Purging the queue. 0 events
141024  9:14:22 [Warning] /usr/sbin/mysqld: Forcing close of thread 1672  user: 'leechprotect'

141024  9:14:22  InnoDB: Starting shutdown...
141024  9:14:24  InnoDB: Shutdown completed; log sequence number 62739999
141024  9:14:24 [Note] /usr/sbin/mysqld: Shutdown complete

141024 09:14:24 mysqld_safe mysqld from pid file /var/lib/mysql/iix1.sufanet.com.pid ended
141024 09:14:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141024  9:14:24 [Note] Plugin 'FEDERATED' is disabled.
141024  9:14:24 InnoDB: The InnoDB memory heap is disabled
141024  9:14:24 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141024  9:14:24 InnoDB: Compressed tables use zlib 1.2.3
141024  9:14:24 InnoDB: Using Linux native AIO
141024  9:14:24 InnoDB: Initializing buffer pool, size = 128.0M
141024  9:14:24 InnoDB: Completed initialization of buffer pool
141024  9:14:24 InnoDB: highest supported file format is Barracuda.
141024  9:14:25  InnoDB: Waiting for the background threads to start
141024  9:14:26 InnoDB: 5.5.37 started; log sequence number 62739999
141024  9:14:26 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141024  9:14:26 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141024  9:14:26 [Note] Server socket created on IP: '0.0.0.0'.
141024  9:14:26 [Note] /usr/sbin/mysqld: Normal shutdown

141024  9:14:26 [Note] Event Scheduler: Loaded 0 events
141024  9:14:26 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
141024  9:14:26 [Note] Event Scheduler: Purging the queue. 0 events
141024  9:14:26  InnoDB: Starting shutdown...
141024  9:14:27  InnoDB: Shutdown completed; log sequence number 62739999
141024  9:14:27 [Note] /usr/sbin/mysqld: Shutdown complete

141024 09:14:27 mysqld_safe mysqld from pid file /var/lib/mysql/iix1.sufanet.com.pid ended
141024 09:14:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141024  9:14:28 [Note] Plugin 'FEDERATED' is disabled.
141024  9:14:28 InnoDB: The InnoDB memory heap is disabled
141024  9:14:28 InnoDB: Mutexes and rw_locks use GCC atomic builtins
141024  9:14:28 InnoDB: Compressed tables use zlib 1.2.3
141024  9:14:28 InnoDB: Using Linux native AIO
141024  9:14:28 InnoDB: Initializing buffer pool, size = 128.0M
141024  9:14:28 InnoDB: Completed initialization of buffer pool
141024  9:14:28 InnoDB: highest supported file format is Barracuda.
141024  9:14:28  InnoDB: Waiting for the background threads to start
141024  9:14:29 InnoDB: 5.5.37 started; log sequence number 62739999
141024  9:14:29 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
141024  9:14:29 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
141024  9:14:29 [Note] Server socket created on IP: '0.0.0.0'.
141024  9:14:29 [Note] Event Scheduler: Loaded 0 events
141024  9:14:29 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.37-cll'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
[email protected] [~]#

where is the problem?