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

[honghong]

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

 

[honghong]

Dear All Seniors,

Anybody to help ? ><

 

[Amit Deshmukh]

Hi

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


Regards,
Amit

 

[madan.cpanelnet]

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

 

[honghong]

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

 

[Amit Deshmukh]

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 [email protected] after 4 hrs. Online free support.

Regards,
Amit & MT

 

[honghong]

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

 

[honghong]

Problem Sloved... :D

Thanks again to Amit Deshmukh & madan.cpanelnet,

so glad to meet u 2 here :D


Cheers
HOngHong

 

[madan.cpanelnet]

gr8 ... yw

 

[Amit Deshmukh]

Cool

We are glade to assist you.


Regards,
Amit