Cacti on FreeBSD6.2

[revlis]

uname -a
FreeBSD spider 6.2-RELEASE-p4 FreeBSD 6.2-RELEASE-p4

cacti-0.8.6j.3_2

php5-5.2.1_3 PHP Scripting Language (Apache Module and CLI)
php5-mysql-5.2.1_3 The mysql shared extension for php
php5-pcre-5.2.1_5 The pcre shared extension for php
php5-session-5.2.1_3 The session shared extension for php
php5-snmp-5.2.1_3 The snmp shared extension for php
php5-sockets-5.2.1_3 The sockets shared extension for php
php5-xml-5.2.1_3 The xml shared extension for php

mysql-client-5.0.27 Multithreaded SQL database (client)
mysql-server-5.0.37 Multithreaded SQL database (server)
php5-mysql-5.2.1_3 The mysql shared extension for php


все по ману:
mysqladmin --user=root create cacti
mysql cacti < cacti.sql
mysql --user=root mysql
GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'somepassword';
flush privileges;

Edit include/config.php

$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cactiuser";
$database_password = "somepassword";


php /usr/local/share/cacti/poller.php


07/05/2007 11:29:21 AM - CMDPHP: Poller[0] FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

Warning: array_merge(): Argument #2 is not an array in /usr/local/share/cacti/poller.php on line 61

Warning: Invalid argument supplied for foreach() in /usr/local/share/cacti/poller.php on line 115
07/05/2007 11:29:21 AM - SYSTEM STATS: Time:0.0033 Method:cmd.php Processes:1 Threads:N/A Hosts:0 HostsPerProcess:0 DataSources: RRDsProcessed:0
-: not found


mysql --user=cactiuser cacti -psomepassword
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 213 to server version: 5.0.37

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

[revlis]

http://forum.sysadmins.ru/viewtopic.php ... 05#7682205

[N3NCY]

You need to work on fixing this error:

Code: Select all

07/05/2007 11:29:21 AM - CMDPHP: Poller[0] FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.

You will not be able to get very far without getting the connection to MySQL working.

Please check your MySQL user permissions:
# Create a MySQL username and password for Cacti
mysql --user=root mysql

GRANT ALL ON cacti.* TO cactiuser@localhost IDENTIFIED BY 'cactipassword';
GRANT ALL ON cacti.* TO cactiuser@"%" IDENTIFIED BY 'cactipassword';
flush privileges;
exit

# Edit include/config.php and specify the MySQL user, password and database for your Cacti configuration
$database_default = "cacti";
$database_hostname = "localhost";
$database_username = "cactiuser";
$database_password = "cactipassword";


For my FreeBSD Cacti install instructions please see:
http://www.n3ncy.com/UNIX/FreeBSD/
and
http://www.nmsworld.com/UNIX/

[freakwind]

HOW TO CACTI IN FREEBSD

http://www.underdreams.net/modules.php? ... icle&sid=6