Freshly built Server won't start

[mike13a]

I have been following the instructions to install Zabbix 4.4 onCentOS 7 with MySQL.
I have gotten down to step f to start the server and agent.
In addition, I have been following Wim DeCorte's (from Soliant Consulting) white paper on how to configure from scratch.
he added steps to confirm the server is running.
I can tell its not because I get a failure when I run this command:
sudo systemctl status zabbix-server

and the failure is below:

[centos@ip-172-31-33-112 ~]$ sudo systemctl status -l zabbix-server.service

● zabbix-server.service - Zabbix Server
Loaded: loaded (/usr/lib/systemd/system/zabbix-server.service; enabled; vendor preset: disabled)
Active: activating (auto-restart) (Result: exit-code) since Mon 2020-04-06 19:00:42 UTC; 6s ago
Process: 5843 ExecStop=/bin/kill -SIGTERM $MAINPID (code=exited, status=1/FAILURE)
Process: 5840 ExecStart=/usr/sbin/zabbix_server -c $CONFFILE (code=exited, status=0/SUCCESS)
Main PID: 5842 (code=exited, status=1/FAILURE)
Apr 06 19:00:42 ip-172-31-33-112.ec2.internal systemd[1]: zabbix-server.service: control process exited, code=exited status=1
Apr 06 19:00:42 ip-172-31-33-112.ec2.internal systemd[1]: Unit zabbix-server.service entered failed state.
Apr 06 19:00:42 ip-172-31-33-112.ec2.internal systemd[1]: zabbix-server.service failed.

Any assistance would be greatly appreciated as Unix Command line is definitely not my first language.

THanks,
Mike

[sigafoos]

Have you checked the zabbix server log at /var/log/zabbix/zabbix_server.log ?

[mike13a]

Yes, I see this line.
5041:20200406:183613.725 [Z3001] connection to database 'zabbix' failed: [2059] Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory

It says the shared object is missing. Is that authentication plugin or something else it is referring to?

Also, I see this when trying to use the GUI.

[mike13a]

UPDATE: I spun up a brand new AWS CentOS instance and started over. I go through all the steps posted and I get the same result. Server will not start. Is there anybody on these forums who knows the Unix side of things that can tell me why this error is coming up and how I might resolve it?
Any assistance would be helpful.
Thanks

[tim.mooney]

Your MySQL database is using a newer authentication plugin, probably it's the default for the install, see: https://dev.mysql.com/doc/refman/8.0...ntication.html

You need to figure out what package provides that plugin, install it, and then restart mysql. If your database is also on the same CentOS system, then you can probably do

yum whatprovides /usr/lib64/mysql/plugin/caching_sha2_password.so

as root. Assuming the "whatprovides" returns a package name, then you just install that package (yum install <some_package_name>).

Alternately, there may be a way to use MySQL user management commands to alter or recreate the user to not use the new auth plugin, instead sticking with the older auth method.

[mike13a]

Tim,
got a message "No Matches found". (Figures the easy fix doesn't exist)
Would you be able to assist me with the process to get it to use the older auth method?
This is an area that I am not well versed in at the moment and would not know where to even begin.

Thanks in advance,

[mike13a]

I figured out how to resolve the problem I was having...
In case anyone else gets stuck at this point, I had to go in and DROP the user and then recreate the Zabbix user and explicitly tell it to use the mysql_native password.
Not being a native MySQL user, it took me some hunting to find the solution.
ie:
CREATE USER zabbix@localhost IDENTIFIED WITH mysql_native_password BY 'YourPasswordHere'

[mike13a]

Well I got past that hurdle and now its still not loading.
I see this error in the Zabbix_server.log. any ideas why I would get this?
connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)

[Atsushi]

Did you set the password for accessing the database at DBPassword in Zabbix server configuration file? (ex. /etc/zabbix/zabbix_server.conf)

[mike13a]

yes I did that.
I confirmed it was the password I set in the create user step.
Going to start over with a brand new CentOS 7 server and try to install Zabbix 5, hopefully that is more user friendly.
Unless there is something else I should try?

[Atsushi]

Let me check one point.

connection to database 'zabbix' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: YES)

The output of this error indicates that the Zabbix server cannot access the database 'zabbix' using the user 'zabbix'@'localhost'. If the password is correct, do you run the grant command so that user 'zabbix'@'localhost' can access database 'zabbix'?

If you have a new environment and want to challenge your Zabbix 5.0 environment, I recommend using CentOS 8 instead of CentOS 7. CentOS 7 has an old PHP version, so special steps are required.

[mike13a]

I did not run the grant command. Let me look that up. I was following a build document that didn't have that. thanks for your replies!

[mike13a]

@atushi. Success! I finally got the whole thing up and running. Mostly self inflicted issues. thanks for your help!