Installation/Setup problems

[hellslide]

Hello everyone,

Today I wanted to install Zabbix on a Raspberry Pi, and have been following this guide:
https://www.zabbix.com/download?zabb...ysql&ws=apache

But it seems to me that the guide is not working correctly.

I first got an error when I ran this command:

zcat /usr/share/zabbix-sql-scripts/mysql/server.sql.gz | mysql --default-character-set=utf8mb4 -uzabbix -p zabbix

Should this really be in the utf8mb4 character-set, why not just utf8?

I have followed the rest of the guide, until I finally came to configuring the rest of the frontend, until I ran into the following error:

Cannot connect to the database.

  	Access denied for user 'zabbix'@'localhost' (using password: NO)

I also become the error (using password: YES) when I do set a password in the config /etc/zabbix/zabbix_server.conf




Any idea how I could resolve this issue? I spent the entire afternoon searching for a solution or even understanding the problem that's causing it.

I suppose it has something to do with the wrong permissions?!

Any help is greatly appreciated.

[mihailo74]

I've got the same problems, anyone out there that can help?

[azyla]

Hi,

Yes, it looks like the issue is caused either by password mismatch or lack of privileges.

During the initial setup of database, did you change the 'password' part of below line?

mysql> create user zabbix@localhost identified by 'password';

If yes, make sure the same password is set as a value for DBPassword in /etc/zabbix/zabbix_server.conf
If not, value of the configuration should be just the password instead.

Also this line is important during the setup to grant newly created user all necessary privileges:

mysql> grant all privileges on zabbix.* to zabbix@localhost;

Last thing that comes to my mind would be restarting zabbix processes to make sure all configurations get loaded properly:

systemctl restart zabbix-server zabbix-agent apache2

Hope it helps.

Regards,
Arkadiusz