cacti can't connect to mysql (checked everything)

blacksun · Post by **blacksun** » Tue Dec 27, 2005 6:01 pm

The problem is that the log file says:
12/27/2005 11:45:07 PM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

This is what I did:
installed cacti with yast:
cp -rp /usr/share/cacti /srv/www/htdocs/cacti

php.ini
register_globals = On
register_argc_argv = On

config:
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "127.0.0.1";
$database_username = "root";
$database_password = "";

MYSQL:
mysql -u root
create database cacti
exit
mysql -u root cacti < /usr/share/cacti/cacti.sql
mysql -u root
use cacti
GRANT ALL PRIVILEGES ON cacti.* TO 'root'@'localhost' IDENTIFIED BY '';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '';
SHOW TABLES gives content.....
flush privileges;

I tried everything; $database_hostname = "localhost"; doesn't help either.
Very annoying; i do something wrong.... but what..

Post by **rony** » Tue Dec 27, 2005 6:10 pm

Does the web interface work?

blacksun · Post by **blacksun** » Tue Dec 27, 2005 6:16 pm

yes.
I'm following this http://www.cacti.net/downloads/docs/htm ... graph.html
tutorial to test.

I've installed rddtool and all other software.

Post by **rony** » Tue Dec 27, 2005 6:26 pm

What OS?

Are you running mysql in a chroot?

Is networking enabled for the mysql server?

blacksun · Post by **blacksun** » Tue Dec 27, 2005 6:35 pm

suse 10.0 both apache2 and mysql running.
(no not running in chroot)
yes.

JJX · Post by **JJX** » Wed Dec 28, 2005 4:06 am

are u running poller as root?

give us the output of ls -la /usr/share/cacti /srv/www/htdocs/cacti

also try 127.0.0.1 instead of localhost
(maybe /etc/hosts doesnt match localhost --> 127.0.0.1 for some reason)

blacksun · Post by **blacksun** » Wed Dec 28, 2005 5:37 am

peter@peter:~> cat /etc/hosts
127.0.0.1 localhost
# special IPv6 addresses
::1 localhost ipv6-localhost ipv6-loopback
fe00::0 ipv6-localnet
ff00::0 ipv6-mcastprefix
ff02::1 ipv6-allnodes
ff02::2 ipv6-allrouters
ff02::3 ipv6-allhosts
192.168.1.5 peter.x.nl peter

ls -al /srv/www/htdocs/cacti/poller.php
-rw-r--r-- 1 root root 9247 2005-09-09 20:54 /srv/www/htdocs/cacti/poller.php

ls -al /usr/share/cacti/poller.php
-rw-r--r-- 1 root root 9247 2005-09-09 20:54 /usr/share/cacti/poller.php

vim /etc/sysconfig/apache2
APACHE_MODULES="access actions alias auth autoindex cgi dir include log_config mime negotiation setenvif status userdir asis
imap php4 auth_mysql"

crontab -e as root:
*/5 * * * * root php /srv/www/htdocs/cacti/poller.php > /dev/null 2>&1

If i run as root php /srv/www/htdocs/cacti/poller.php it generates graphs..

blacksun · Post by **blacksun** » Thu Dec 29, 2005 12:30 pm

suggestions?
I've written a small php file which connects to the mysql database
and does a query.
it succeeds.
so it has something to do with the config.

/* make sure these values refect your actual database/host/user/password */
$database_type = "mysql";
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "root";
$database_password = "";

blacksun · Post by **blacksun** » Thu Dec 29, 2005 2:37 pm

please reply to this post; i'm willing to give you guys all the information you need.

blacksun · Post by **blacksun** » Fri Dec 30, 2005 10:04 am

well i solved it; apparently; something with user rights;
just leave the files in /usr/share/cacti; and everything works.\

Cacti

cacti can't connect to mysql (checked everything)

cacti can't connect to mysql (checked everything)

Who is online