Skip to main content

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

SufaNet
[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

Comments

5 comments

Date Votes
  • cPanelMichael
    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.
    0
  • SufaNet
    ]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?
    0
  • cPanelMichael
    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.
    0
  • SufaNet
    hello, this is the error :
    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 root@iix1 [~]#
    i try to restart from console now up again, but it can down again some time. this is log after i restart mysql :
    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) root@iix1 [~]#
    where is the problem?
    0
  • dalem
    Error in accept: Too many open files
    (errno: 24)
    [url=http://www.solomonson.com/content/how-fix-errno-24-mysql]How to Fix an (errno: 24) in MySQL | solomonson.com
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post