no graphs displayed, poller.php gives MySQL connect error.

[meee2]

I have something very strange going on.

Its a fresh install of FC3, MySQL, PHP, RRDTool 1.0.49 and Cacti 0.8.6c.

None the RRD files have been created. Graph Debug only says at the bottom the .rrd file is missing for the graph. I checked rra/ and its empty. rra/ belongs to the cacti user and group is cacti.

When manually run poller.php as the cacti user I get:
PHP warning: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /www/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 340

looking in /var/lib/mysql/ mysql.sock doesn't exist?

Looking at line 340 its just a simple mysql connect and config.php has all the correct info for connecting to mysql and MySQL is running. Manually logging into MySQL as the cacti user works. Any ideas?

[rony]

That is the local communications socket for Mysql. It should be ther unless disabled in the my.cnf. Alternatively you can use the network, just change you database server to 127.0.0.1.

[meee2]

I changed the server to 127.0.0.1 and that didn't change anything. I looked in my.cnf and /tmp is specified for mysql.sock Should I put a link to /tmp/mysql.sock in /var/lib/mysql???

I was also looking at http://forums.cacti.net/post-27336.html I tried the last config.php.dist listed in the post. It cleared the connect problem, but created another error not listed in that post:

Fatal error: Call to a member function SetFetchMode() on a non-object in /www/htdocs/cacti/lib/database.php on line 106

[rony]

I would set your sock to the default location, which is in /var/lib/mysql.

But my question is why are your client libaries not pointing to defined sock. If I remember correctly, you can alter the location of the sock in the my.cnf as well. There is the client and server sections in there. Make sure they match.

[meee2]

From the MySQL 4.1.10a distribution my-medium.cnf the default for the socket is /tmp/mysql.sock I built MySQL directly from the distribution and installed. I looked at some of the other my.cnf that come with the distribution and they all pointed to /tmp I went ahead and pointed the socket to the default /var/lib/mysql. Same result of:

Fatal error: Call to a member function SetFetchMode() on a non-object in /www/htdocs/cacti/lib/database.php on line 106

[meee2]

Changing my.cnf to direct the socket to /var/lib/mysql/mysql.sock breaks cacti and gives a mysql connect again...