Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

eximstats and mysql (5.0.27-standard) down. please help.

Discussion in 'General Discussion' started by honghong, Nov 19, 2007.

  1. honghong

    honghong Member

    Joined:
    Sep 6, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    am having the eximstats and mysql (5.0.27-standard) down for 3 days since i moved to new server by using WHM transfer multiple account from another server .

    is any solution i can get them up ? because mysql down are making alot of trouble .....

    below is a screen shot


    Screen Shot when i try to restart the server, and i get this msg

    http://www.bmteochew.org/files/server_002.jpg

    Screen shot for services status

    http://www.bmteochew.org/files/server_001.jpg
     
    #1 honghong, Nov 19, 2007
    Last edited by a moderator: Nov 21, 2007
  2. honghong

    honghong Member

    Joined:
    Sep 6, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Dear All Seniors,

    Anybody to help ? ><

    :(:(:(:(:(:(:(:(
     
  3. Amit Deshmukh

    Amit Deshmukh Well-Known Member

    Joined:
    Jul 1, 2007
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    56
    Hi

    My friend will update the post soon. Please be online.


    Regards,
    Amit
     
  4. madan.cpanelnet

    madan.cpanelnet Well-Known Member

    Joined:
    Apr 1, 2006
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    INDIA
    Hello,


    Please make a backup of your my.cnf and use the following.....


    [mysqld]
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    #old_passwords=1

    skip-innodb
    max_connections = 600
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 1800
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid


    # mv /etc/my.cnf /etc/my.cnf.orig
    # vi /etc/my.cnf and add the above lines.
    # touch /var/log/mysqld.log
    # chown mysql.root /var/log/mysqld.log
    # chmod 660 /var/log/mysqld.log




    Then try to restart your mysql service
    # /etc/init.d/mysql restart


    If problem persist.. please post the following.....

    # tail -50 /var/log/mysqld.log


    Also .. make sure that /var or /tmp partition is not full.. please post output of the following...


    # df -h

    Also post output of ...

    # ls -lhd /var/lib/mysql

    #ls -lhd /tmp
     
    #4 madan.cpanelnet, Nov 20, 2007
    Last edited: Nov 21, 2007
  5. honghong

    honghong Member

    Joined:
    Sep 6, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Thanks for the helping me, madan.cpanelnet & Amit Deshmukh,
    but i really a beginner for it.

    may i ask how i going to backup the my.cnf with ssh?
    hope can a help wit step by step.
    Thanks A lot

    Regards
    HongHong
     
  6. Amit Deshmukh

    Amit Deshmukh Well-Known Member

    Joined:
    Jul 1, 2007
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    56
    HongHong

    # mv /etc/my.cnf /etc/my.cnf.orig
    # vi mv /etc/my.cnf and add the following lines.


    [mysqld]
    socket=/var/lib/mysql/mysql.sock
    # Default to using old password format for compatibility with mysql 3.x
    # clients (those using the mysqlclient10 compatibility package).
    #old_passwords=1

    skip-innodb
    max_connections = 600
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 1024
    thread_cache_size = 64
    wait_timeout = 1800
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [mysqld_safe]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid






    # touch /var/log/mysqld.log
    # chown mysql.root /var/log/mysqld.log
    # chmod 660 /var/log/mysqld.log




    Then try to restart your mysql service
    # /etc/init.d/mysql restart


    If problem persist.. please post the following.....

    # tail -50 /var/log/mysqld.log


    Also .. make sure that /var or /tmp partition is not full.. please post output of the following...


    # df -h

    Also post output of ...

    # ls -lhd /var/lib/mysql

    #ls -lhd /tmp


    If you are unable to fix it. we can fix the error for you. Join us on yohoo messanger at gossip_land@yahoo.com after 4 hrs. Online free support.

    Regards,
    Amit & MT
     
  7. honghong

    honghong Member

    Joined:
    Sep 6, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Thanks again to Amit Deshmukh & madan.cpanelnet,

    now the eximstats, and mysql was up,

    but i face another problem with database,
    that is
    my exiting client, which is using php and mysql
    get error code like below


    Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'kongjoo_kjpro'@'localhost' (using password: YES) in /home/kongjoo/public_html/product/common/class.dbconnect.php(1) : eval()'d code on line 8

    Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/kongjoo/public_html/product/common/class.dbconnect.php(1) : eval()'d code on line 9

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/kongjoo/public_html/product/common/class.item.php(1) : eval()'d code on line 46

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kongjoo/public_html/product/common/include.php(1) : eval()'d code on line 53

    Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/kongjoo/public_html/product/common/include.php(1) : eval()'d code on line 54

    Warning: include_once(/home/kongjoo/public_html/product/common/language/) [function.include-once]: failed to open stream: Permission denied in /home/kongjoo/public_html/product/common/include.php(1) : eval()'d code on line 57

    Warning: include_once() [function.include]: Failed opening '/home/kongjoo/public_html/product/common/language/' for inclusion (include_path='.') in /home/kongjoo/public_html/product/common/include.php(1) : eval()'d code on line 57

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/kongjoo/public_html/product/common/class.component.php(1) : eval()'d code on line 12

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kongjoo/public_html/product/common/include.php(1) : eval()'d code on line 62

    Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/kongjoo/public_html/product/common/include.php(1) : eval()'d code on line 71

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/kongjoo/public_html/product/common/class.system.php(1) : eval()'d code on line 11

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kongjoo/public_html/product/common/class.system.php(1) : eval()'d code on line 12

    Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/kongjoo/public_html/product/common/class.system.php(1) : eval()'d code on line 13

    Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/kongjoo/public_html/product/common/class.dbconnect.php(1) : eval()'d code:8) in /home/kongjoo/public_html/product/common/session.php on line 9

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/kongjoo/public_html/product/common/class.dbconnect.php(1) : eval()'d code:8) in /home/kongjoo/public_html/product/common/session.php on line 9

    Warning: Cannot modify header information - headers already sent by (output started at /home/kongjoo/public_html/product/common/class.dbconnect.php(1) : eval()'d code:8) in /home/kongjoo/public_html/product/common/session.php on line 10

    Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/kongjoo/public_html/product/common/class.system.php(1) : eval()'d code on line 11

    Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/kongjoo/public_html/product/common/class.system.php(1) : eval()'d code on line 12

    Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/kongjoo/public_html/product/common/class.system.php(1) : eval()'d code on line 13


    from 2 of exprirence senior, attually what is the problem of this error code?

    thanks for read my topic and opinion


    cheers
    honghong
     
  8. honghong

    honghong Member

    Joined:
    Sep 6, 2006
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    Problem Sloved... :D

    Thanks again to Amit Deshmukh & madan.cpanelnet,

    so glad to meet u 2 here :D


    Cheers
    HOngHong
     
  9. madan.cpanelnet

    madan.cpanelnet Well-Known Member

    Joined:
    Apr 1, 2006
    Messages:
    69
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    INDIA
  10. Amit Deshmukh

    Amit Deshmukh Well-Known Member

    Joined:
    Jul 1, 2007
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    56
    Cool

    We are glade to assist you.


    Regards,
    Amit ;)
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice