Zabbix Installation Concern

[vnoc]

Hi Team,

I have deployed Zabbix 3.2 version in one of the Redhat7.2.

As 3.2 is the old version I tried to install 3.4 version by removing all the configuration files and restarting the server.

And after that i tried to again started deploying Zabbix 3.4 ver but i am getting the below error .

Error connecting to database: Access denied for user 'zabbix'@'localhost' (using password: YES)

Please help me in fixing this as I am trying to fix this from last 2week which didn't work

[allexpetrov]

Hi,

As you can see - the error is that you can't connect to the database. Troubleshoot step Nr. one - check the zabbix_server.conf and fin the DBPassword. Try to connect to the database with the user and password specified in the config.

Try something like this:

mysql -uzabbix -p zabbix

Regards,
Aleksejs!

[vnoc]

Tried it but it is not working getting below error
ERROR 1045 (28000): Access denied for user 'zabbixuser'@'localhost' (using password: YES)


And please find the zabbix_server.conf file attahced

Below is the command
mysql -uzabbixuser -p zabbixdb

[allexpetrov]

Reset the password to the user or create another one. Also you can compare what you have in the config file with the one you have in the */etc/zabbix/web/zabbix.conf.php*

There is no magic out there.

Regards,
Alex!

[vnoc]

I changed the password but there is not luck .

Can some one please help me. If possible can you ping me over skype

akhilesh.y2 is my skypeid

[kaspars.mednis]

You can try to connect to mysql as root, simply typing mysql in root console, then recreate zabbix user

[root@zabbix ~]# mysql

MariaDB [(none)]> drop user zabbix@localhost;
Query OK, 0 rows affected (0.01 sec)
MariaDB [(none)]> grant all privileges on zabbix.* to zabbix identified by '<password>';
Query OK, 0 rows affected (0.00 sec)

[vnoc]

All these steps were performed previously after which I have posted in the forum

[allexpetrov]

Sorry, but in such case visit Zabbix Support page and ask professionals to help you. Your problem is the misconfiguration.

Link: https://www.zabbix.com/services

Or again - double check that you can connect to the mysql database from the Zabbix Server machine. Issue mysql -u<zabbixuser> -p <zabbixdbname> and if it is working, then open your server config file, change the DB* parameters and restart the Zabbix server.

Please note: if you running DB on a different node, then your user needs to be like zabbix@<hostip/dns>, otherwise DB will drop your connection.

Regards,
Aleksejs!

[Nehemoth]

Sorry, but in such case visit Zabbix Support page and ask professionals to help you. Your problem is the misconfiguration.

Link: https://www.zabbix.com/services

Or again - double check that you can connect to the mysql database from the Zabbix Server machine. Issue mysql -u<zabbixuser> -p <zabbixdbname> and if it is working, then open your server config file, change the DB* parameters and restart the Zabbix server.

Please note: if you running DB on a different node, then your user needs to be like zabbix@<hostip/dns>, otherwise DB will drop your connection.

Regards,
Aleksejs!

Just registered here because the problem lies in the documentation

This is the command as per zabbix documentation

zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix

The problem lies in the bold part above, everybody believes that the password should be there but of course it's not the password, is the database name that is expected, as @allexpetrov indicates previously.

What a waste of time in something so simple. Which waste of time I'm talking about the 'whole' internet with this issue.
The zabbix documentation should differentiate the user from the database name from the password instead of using the same zabbix name for everything.

Hope this help