DB Connection Problem
I'd really appreciate some help from someone as I'm trying to get this implemented for work. Thanks in advance.
I'm running FreeBSD 6.2. I can't get zabbix to connect to the db for some reason. I keep getting the errors:
mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root'@'localhost' (using password: NO)[/usr/home/zabbix/public_html/include/db.inc.php:61]
mysql_select_db() [function.mysql-select-db]: Access denied for user 'root'@'localhost' (using password: NO)[/usr/home/zabbix/public_html/include/db.inc.php:62]
mysql_select_db() [function.mysql-select-db]: A link to the server could not be established[/usr/home/zabbix/public_html/include/db.inc.php:62]
mysql_query(): supplied argument is not a valid MySQL-Link resource[/usr/home/zabbix/public_html/include/db.inc.php:283]
Error in query [select * from nodes where nodeid=0] [Access denied for user 'root'@'localhost' (using password: NO)]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/home/zabbix/public_html/include/db.inc.php:410]
When I first created the database I did the following:
mysql -p -u root
create database zabbix;
quit;
cd create/schema
cat mysql.sql |mysql -u root -p zabbix (there is no schema.sql)
cd ..
cd data
cat data.sql |mysql -u root -p zabbix
cat images_mysql.sql |mysql -u root -p zabbix
./configure -enable-static -enable-server -enable-agent -with-mysql -with-net-snmp
I added my password to /etc/zabbix/zabbix_server.conf
I added the following to frontends/php/include/db.inc.php
$DB_TYPE ="MYSQL";
$DB_SERVER ="localhost";
$DB_DATABASE ="zabbix";
$DB_USER ="root";
$DB_PWD ="secret"; --> I actually added my password
I have since tried to redo the database creation portion using username zabbix instead of root, but it still shows up 'access denied for user root@localhost' Also, I forgot to install php4-mysql initially and installed it after Zabbix complained about it. I don't know if that's related or not. Hopefully I've provided enough info for someone to understand what the problem could be because I sure don't know. Anyone have any suggestions?
I'm running FreeBSD 6.2. I can't get zabbix to connect to the db for some reason. I keep getting the errors:
mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'root'@'localhost' (using password: NO)[/usr/home/zabbix/public_html/include/db.inc.php:61]
mysql_select_db() [function.mysql-select-db]: Access denied for user 'root'@'localhost' (using password: NO)[/usr/home/zabbix/public_html/include/db.inc.php:62]
mysql_select_db() [function.mysql-select-db]: A link to the server could not be established[/usr/home/zabbix/public_html/include/db.inc.php:62]
mysql_query(): supplied argument is not a valid MySQL-Link resource[/usr/home/zabbix/public_html/include/db.inc.php:283]
Error in query [select * from nodes where nodeid=0] [Access denied for user 'root'@'localhost' (using password: NO)]
mysql_fetch_array(): supplied argument is not a valid MySQL result resource[/usr/home/zabbix/public_html/include/db.inc.php:410]
When I first created the database I did the following:
mysql -p -u root
create database zabbix;
quit;
cd create/schema
cat mysql.sql |mysql -u root -p zabbix (there is no schema.sql)
cd ..
cd data
cat data.sql |mysql -u root -p zabbix
cat images_mysql.sql |mysql -u root -p zabbix
./configure -enable-static -enable-server -enable-agent -with-mysql -with-net-snmp
I added my password to /etc/zabbix/zabbix_server.conf
I added the following to frontends/php/include/db.inc.php
$DB_TYPE ="MYSQL";
$DB_SERVER ="localhost";
$DB_DATABASE ="zabbix";
$DB_USER ="root";
$DB_PWD ="secret"; --> I actually added my password
I have since tried to redo the database creation portion using username zabbix instead of root, but it still shows up 'access denied for user root@localhost' Also, I forgot to install php4-mysql initially and installed it after Zabbix complained about it. I don't know if that's related or not. Hopefully I've provided enough info for someone to understand what the problem could be because I sure don't know. Anyone have any suggestions?
Comment