The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Database Discussions' started by SufaNet, Oct 23, 2014.

  1. SufaNet

    SufaNet Registered

    Joined:
    Oct 23, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    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
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. SufaNet

    SufaNet Registered

    Joined:
    Oct 23, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    DataCenter Provider

    How to check the error? And how to resolve?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  5. SufaNet

    SufaNet Registered

    Joined:
    Oct 23, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    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
    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 :

    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)
    root@iix1 [~]#

    where is the problem?
     
  6. dalem

    dalem Well-Known Member
    PartnerNOC

    Joined:
    Oct 24, 2003
    Messages:
    2,577
    Likes Received:
    40
    Trophy Points:
    48
    Location:
    SLC
    cPanel Access Level:
    DataCenter Provider
Loading...

Share This Page