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.

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:
    1
    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:
    1
    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:
    6
    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:
    6
    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:
    1
    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:
    6
    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:
    1
    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:
    1
    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:
    6
    Location:
    INDIA
  10. Amit Deshmukh

    Amit Deshmukh Well-Known Member

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

    We are glade to assist you.


    Regards,
    Amit ;)
     
Loading...

Share This Page