Zabbix 3.4.4 + MySQL 5.7.20 - Problems during installation

[hcaldeira]

Hi, I'm building a monitoring server for a Retail platform and the provided infra for this server at my company is:

• CentOS Linux release 7.4.1708 (Core)
• MySQL Community Server 5.7.20
• PHP Version 5.6.32

I've created the DB and User for the Zabbix application in MySQL with the following commands:

CREATE DATABASE zabbixdb CHARACTER SET utf8 COLLATE utf8_bin;

GRANT ALL PRIVILEGES ON zabbixdb.* TO zabbix@localhost IDENTIFIED BY "zabbix";

However when accessing the zabbix installation page, I receive a "can't connect to the database" error, but I'm able to connect to MySQL, by command line and phpMyAdmin.

Is that some kind of problem with the Zabbix 3.4.4 and MySQL 5.7.20 or possibly PHP module that are missing?

That the first time that I'm installing Zabbix . I'm very familiarised with Nagios management.

Tks!

[kloczek]

However when accessing the zabbix installation page, I receive a "can't connect to the database" error, but I'm able to connect to MySQL, by command line and phpMyAdmin.

Are you using zabbix db account from localhost like it is in your GRANT line?

Is that some kind of problem with the Zabbix 3.4.4 and MySQL 5.7.20 or possibly PHP module that are missing?

That the first time that I'm installing Zabbix . I'm very familiarised with Nagios management.

I'm have two zabbixs 3.4.4 with mysql 5.7.2o and everything is working,

[hcaldeira]

Are you using zabbix db account from localhost like it is in your GRANT line?

Yes, and I've also tried to use root account. Does Zabbix have any kind of log that I can check whats is going on during the installation?

[glebs.ivanovskis]

Have you imported database schema?

[hcaldeira]

Have you imported database schema?

I've managed to import the schema following the Zabbix doc's, however now I having an error when trying to start the zabbix server, bellow is the log file:

 12249:20171226:081141.839 Starting Zabbix Server. Zabbix 3.4.4 (revision 74338).
 12249:20171226:081141.839 ****** Enabled features ******
 12249:20171226:081141.839 SNMP monitoring:           YES
 12249:20171226:081141.839 IPMI monitoring:           YES
 12249:20171226:081141.839 Web monitoring:            YES
 12249:20171226:081141.839 VMware monitoring:         YES
 12249:20171226:081141.839 SMTP authentication:       YES
 12249:20171226:081141.839 Jabber notifications:      YES
 12249:20171226:081141.839 Ez Texting notifications:  YES
 12249:20171226:081141.839 ODBC:                      YES
 12249:20171226:081141.839 SSH2 support:              YES
 12249:20171226:081141.839 IPv6 support:              YES
 12249:20171226:081141.839 TLS support:               YES
 12249:20171226:081141.839 ******************************
 12249:20171226:081141.839 using configuration file: /etc/zabbix/zabbix_server.conf
 12249:20171226:081141.839 cannot set resource limit: [13] Permission denied
 12249:20171226:081141.839 cannot disable core dump, exiting...
 12259:20171226:081152.088 Starting Zabbix Server. Zabbix 3.4.4 (revision 74338).
 12259:20171226:081152.088 ****** Enabled features ******
 12259:20171226:081152.088 SNMP monitoring:           YES
 12259:20171226:081152.088 IPMI monitoring:           YES
 12259:20171226:081152.088 Web monitoring:            YES
 12259:20171226:081152.089 VMware monitoring:         YES
 12259:20171226:081152.089 SMTP authentication:       YES
 12259:20171226:081152.089 Jabber notifications:      YES
 12259:20171226:081152.089 Ez Texting notifications:  YES
 12259:20171226:081152.089 ODBC:                      YES
 12259:20171226:081152.089 SSH2 support:              YES
 12259:20171226:081152.089 IPv6 support:              YES
 12259:20171226:081152.089 TLS support:               YES
 12259:20171226:081152.089 ******************************
 12259:20171226:081152.089 using configuration file: /etc/zabbix/zabbix_server.conf
 12259:20171226:081152.089 cannot set resource limit: [13] Permission denied
 12259:20171226:081152.089 cannot disable core dump, exiting...

I just solved this error. The SELinux on my CentOS was disabled however I did the command 'setenforce 0' and the daemon for zabbix server started properly.

Thanks all you guys for helping me.