[Cacti] bug mysql on debian

[sunfun]

Hello all,

I try to install cacti 0.8.6j on Debian 3.0 with kernel 2.6.12-2-686
I follow step by step thanks to this site :
http://www.debianhelp.co.uk/cactifromsource.htm

Nevertheless, I'm blocked at this step : I can't connect to mysql database.

I joined you what i see :

root@phoenix:/var/lib/mysql# mysqladmin --user=root create cacti
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

There is something strange because mysql-server-5.0 processus ID is lauched, as you can see :

root@phoenix:/var/lib/mysql# ps aux |grep mysql
root 27130 0.0 0.1 2748 1248 pts/0 S 19:36 0:00 /bin/sh /usr/bin/mysqld_safe --datadir=/u0/databases --pid-file=/var/run/mysqld/mysqld.pid
mysql 27175 0.0 1.4 126040 15384 pts/0 Sl 19:36 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/u0/databases --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root 27176 0.0 0.0 1876 556 pts/0 S 19:36 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
root 27797 0.0 0.0 1956 632 pts/0 R+ 19:45 0:00 grep mysql
root@phoenix:/var/lib/mysql#

I don't understand what the problem is.
I've installed also php4 and apache2.

Can you help me please ?

Thank you by advance.

Sunfun

[sunfun]

Hello all,

I've found the solution.
In fact, I have to make a symbolic link with the file located in the directory /var/run/mysqld/mysqld.sock, like this :

ln -s /var/run/mysqld.sock /tmp/mysql.sock

So now, i can use cacti 0.8.6j with mysql-server-5.0, php5 and apache2
Moreover, you have to load php5 module in the /etc/apache2/httpd.conf file, because php5 modules aren't loaded by default.

You have to put this line in the file :

LoadModule php5_module /usr/lib/apache2/modules/libphp5.so

Anyway, thank you by advance of your help.

Sunfun

[forumuser]

Hi,

Will you please let me know , where t find 'include/config.php' in Debian linux. I could not find it.

Thank you in advance
Forumuser

[williemerwe]

/usr/share/cacti/site/inlude/config.php