Mysql & Cacti Problems!

[Vlad]

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/cacti/lib/adodb/drivers/adodb-mysql.inc.php on line 339

Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.
=======================================================================
Checked mysql and followed all steps in the manual.
[root@NSKI0193 bin]# mysql -u cactusuzver -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 41 to server version: 4.1.13-standard

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

mysql> show databases;
+------------+
| Database |
+------------+
| cactusbaza |
| test |
+------------+
2 rows in set (0.19 sec)

mysql> use cactusbaza;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show tables;
+---------------------------+
| Tables_in_cactusbaza |
+---------------------------+
| cdef |
| cdef_items |
| colors |
| data_input |
| data_input_data |
| data_input_fields |
| data_local |
| data_template |
| data_template_data |
| data_template_data_rra |
| data_template_rrd |
| graph_local |
| graph_template_input |
| graph_template_input_defs |
| graph_templates |
| graph_templates_gprint |
| graph_templates_graph |
| graph_templates_item |
| graph_tree |
| graph_tree_items |
| host |
| host_graph |
| host_snmp_cache |
| host_snmp_query |
| host_template |
| host_template_graph |
| host_template_snmp_query |
| poller |
| poller_command |
| poller_item |
| poller_output |
| poller_reindex |
| poller_time |
| rra |
| rra_cf |
| settings |
| settings_graphs |
| settings_tree |
| snmp_query |
| snmp_query_graph |
| snmp_query_graph_rrd |
| snmp_query_graph_rrd_sv |
| snmp_query_graph_sv |
| user_auth |
| user_auth_perms |
| user_auth_realm |
| user_log |
| version |
+---------------------------+
48 rows in set (0.00 sec)
======================================================================
So, everything is created

Now, config.php:

$database_type = "mysql";
$database_default = "cactusbaza";
$database_hostname = "localhost";
$database_username = "cactusuzver";
$database_password = "MYPASSWORD";
=======================================================================

I granted permissions on cactusbaza in mysql.

At this point, i'm stuck, i badly need some advise.

Please, help!!!

[Vlad]

Completely forgot to specify my system specs:
OS: Red Hat Enterprise 3 ES (Kernel 2.4.21-4.ELsmp)
Apache: 2.0.54
PHP: 4.4.0
MySQL: 4.1.13

[Vlad]

I found solution:

http://forums.mysql.com/read.php?11,640 ... #msg-13076

[Tony Kandaya]

I think the problem is because there is another config.php being used by the syslog engine.

edit the .../cacti/plugins/haloe/config.php with the correct values for your database.

for instance ...
$haloedb_type = "mysql";
$haloedb_default = "cacti";
$haloedb_hostname = "localhost";
$haloedb_username = "cacti";
$haloedb_password = "cacti";

save config and you should be good to go.

Tony K.

[mjema]

Hello Guys,
I have done fresh installation of cactiEZ 0.7, also have done post installation - yum update to clear all issues of mysql password.
but now am getting error when trying to access server, below is the error:-

Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'cactiuser'@'localhost' (using password: YES) in /var/www/html/lib/adodb/drivers/adodb-mysqli.inc.php on line 83 Can not connect

checked passowrd - for from /include/config.php and mysql they are all fine.

can you please advise what to do

regards,
Ronald

[acharya]

There is a one more config file to edit for database username password :

/var/www/html/plugins/syslog/config.php

My Problem is solved after editing it

[PacoSS]

I have install ezcacti in a virtual machine at i receive the same errors.

First was solved setting the mysql user password from /root/mysqlpass in:
/var/www/html/include/config.php

I receive the second error, same than above post, so I set the password in
/var/www/html/plugins/syslog/config.php

And now ... when i try to log in the http://serverip it freezes during 30 or 40 seconds and then return me this error:
Warning: mysqli_real_connect(): (HY000/2003): Can't connect to MySQL server on 'cactiuser' (110) in /var/www/html/lib/adodb/drivers/adodb-mysqli.inc.php on line 83 Can not connect

I have install this:
yum install cactiez-0.7-fixes

The problem remains.

Does somebody tested the ezcacti 0.7 installation in a vmware virtual machine?

[jrossiter]

I had the same problem running in a VM as well, but I was just able to work around it. The auto generated password in my "/root/mysqlpass.txt" file looked suspect because it started with a "/". I changed it in the "/root/mysqlpass.txt" file and the following places:


/var/www/html/include/config.php
/var/www/html/plugins/syslog/config.php

Then, I changed the cactiuser password within my SQL to reflect these changes and rebooted the server. It worked for me, so hopefully you are having the same trouble. For completeness, because I'm no mysql guru, here's how I did the password change in mysql itself-->


1. Logged in as a root (the root password for mysql is in the "/root/mysqlpass.txt" file)-->

mysql -u root -p

2. Once you are logged into mysql, issue the following-->

use mysql;

3. it will indicate the db has changed. Then type in the following-->

SET PASSWORD FOR 'cactiuser'@'localhost' = PASSWORD('YOURCHANGEDPASSWORD');

4. It should indicate the query was OK, etc. Exit out and try logging in with the same password you just changed for cactiuser-->

mysql -u cactiuser -p


As long as you logged on, it should be good to go. Just do a reboot of the VM and it should come up. Good Luck!