v5.0.3 (revision 146855bff3) CentOs + Mysql 8: engine startup problem

[stephane.papin]

v5.0.3 (revision 146855bff3) CentOs + Mysql 8: engine startup problem

02-10-2020, 09:59
Hello.

I am in the process of setting up an integration environment in v5.0.3 separate on 3 VMs (1 engine, 1 frontend, 1 DB).
The DB server is functional and configured with bin + user zabbix scripts with all rights. I can connect to it through other servers.
password change in mysql_native_password mode
The frontend server is functional and configured with Zabbix binaries
The engine server is installed and configured. The engine server have mysql-client installed

Except that when I try to turn on the engine I have a knockout: (log level 4)

20845:20201002:094728.987 In DBconnect() flag:0
20845:20201002:094728.993 [Z3001] connection to database '[I]myDB[/I]' failed: [1044] Access denied for user 'zabbix'@'%' to database '[I]myDB[/I]'
20845:20201002:094728.993 Cannot connect to the database. Exiting...

(Partial) parameters of zabbix_server.conf:

DBHost=myDBip

### Option: DBName
# Database name.
#
# Mandatory: yes
# Default:
# DBName=

DBName=myDB

### Option: DBSchema
# Schema name. Used for PostgreSQL.
#
# Mandatory: no
# Default:
# DBSchema=

### Option: DBUser
# Database user.
#
# Mandatory: no
# Default:
# DBUser=

DBUser=zabbix

### Option: DBPassword
# Database password.
# Comment this line if no password is used.
#
# Mandatory: no
# Default:
# DBPassword=

DBPassword=myPWD

### Option: DBSocket
# Path to MySQL socket.
#
# Mandatory: no
# Default:
# DBSocket=

DBSocket=/database/mysql/myDB/myDB.sock


### Option: DBPort
# Database port when not using local socket.
#
# Mandatory: no
# Range: 1024-65535
# Default:
# DBPort=

DBPort=myport

Do you have an idea ? Because the log is not very explicit.

Thank you.

[stephane.papin]

Update : very strange...

• With the valide password with size more than 10 characters, I've this message got :
  • [Z3001] connection to database 'myDB' failed: [1044] Access denied for user 'zabbix'@'%' to database 'myDB'
• With wrong password short password (toto), I've this message :
  • [Z3001] connection to database 'myDB' failed: [1045] Access denied for user 'zabbix'@'myEngineSERVER' (using password: YES)
    and
  • database is down: reconnecting in 10 seconds

It's not logical. Look like do not find the DB server and trying in local, but DBHost=ipDBServer

I've tried from engine server mysql connection : success

[stephane.papin]

Solved... wrong DBname