CcactiEZ Slow Response + Cannot Connect to localhost Error

[atifnoor]

Hi All,

We have installed CactiEZ as a virtual machine on HP DL 380 G6 Server having CentOS installed.
All-thing was working fine then suddenly we found the Error in Internet Explorer Browser:

FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'

when we viewed the Cacti Logs we have found the following errors:

LINK NSM1-Core-Switch, target: /var/www/html/rra/edget6-msl-116-2_traffic_in_771.rrd on config line 107 of /var/www/html/plugins/weathermap/configs/Mushaf-R1.conf had no valid data, according to WeatherMapDataSource_rrd
05/23/2011 07:55:04 AM - WEATHERMAP: Poller[0] WARNING: [Map 7] Mushaf-R1.conf: Target /var/www/html/rra/edget6-msl-116-2_traffic_in_771.rrd doesn't exist. Is it a file? [WMRRD06]
05/23/2011 07:55:04 AM - WEATHERMAP: Poller[0] WARNING: [Map 7] Mushaf-R1.conf: ReadData: LINK NSM2-Core-Switch, target: /var/www/html/rra/edget6-msl-116-2_traffic_in_771.rrd on config line 114 of /var/www/html/plugins/weathermap/configs/Mushaf-R1.conf had no valid data, according to WeatherMapDataSource_rrd
05/23/2011 07:55:04 AM - WEATHERMAP: Poller[0] WARNING: [Map 7] Mushaf-R1.conf: Target /var/www/html/rra/edget6-msl-116-2_traffic_in_771.rrd doesn't exist. Is it a file? [WMRRD06]


When we check the mysqld service status it gives the follwoing status:

service mysqld status
mysqld dead but subsys locked

in the console interface it shows the:

in the consol interface it shows
Error 2002 cant connect to local mysql through socket /var/lib/mysql/mysql.sock


Every time we have to restart the mysql service or reboot the Cacti Virtual machine in order to resolve the issue.

here is our my.cnf file settings:

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

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

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

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

we also has added the following files in our my.cnf file:

skip-locking
skip-innodb
skip-bdb

But no improvement.
We are also facing the slow response on CactiEZ machine. it goes hanged and the cpu utilization on main server DL 380 G6 Server goes to 70-80 Percent and we are unable to do any thing.
Your kind help is required in this regard.

Regards,
Atif

[gandalf]

The my.cnf looks fine. This is definitively a mysql issue, not cacti.
You may want to "repair table ..."; there's a cli script for that.
Then, please watch mysql logs for anything unusual
R.