-
Problem report
-
Resolution: Unresolved
-
Minor
-
None
-
5.0.17
-
None
When creating a MySQL zabbix application user, which contains an exclamation mark in password field, then we cannot use character directly to connect to the container. For example, while creating one database with 2 users:
CREATE DATABASE newname CHARACTER SET utf8 COLLATE utf8_bin; CREATE USER 'zabbix_a'@'%' IDENTIFIED BY 'a@cd#efgh'; CREATE USER 'zabbix_b'@'%' IDENTIFIED BY 'a@cd!efgh'; GRANT SELECT, UPDATE, DELETE, INSERT, CREATE, DROP, ALTER, INDEX, REFERENCES ON newname.* TO 'zabbix_a'@'%'; GRANT SELECT, UPDATE, DELETE, INSERT, CREATE, DROP, ALTER, INDEX, REFERENCES ON newname.* TO 'zabbix_b'@'%'; FLUSH PRIVILEGES;
As a result, the user 'zabbix_a' will succeed to connect:
docker run --name z5017 -e TZ="Europe/Riga" \ -e DB_SERVER_HOST="10.133.80.228" \ -e MYSQL_USER="zabbix_a" \ -e MYSQL_PASSWORD="a@cd#efgh" \ -e MYSQL_DATABASE="newname" \ -e DB_SERVER_PORT="3306" \ -d zabbix/zabbix-server-mysql:ol-5.0.17
But user 'zabbix_b' will not be able to connect:
docker run --name z5017 -e TZ="Europe/Riga" \ -e DB_SERVER_HOST="10.133.80.228" \ -e MYSQL_USER="zabbix_b" \ -e MYSQL_PASSWORD="a@cd!efgh" \ -e MYSQL_DATABASE="newname" \ -e DB_SERVER_PORT="3306" \ -d zabbix/zabbix-server-mysql:ol-5.0.17
Output of none working case:
docker logs z5017 -f ** Preparing Zabbix server ** Using MYSQL_USER variable from ENV ******************** * DB_SERVER_HOST: 10.133.80.228 * DB_SERVER_PORT: 3306 * DB_SERVER_DBNAME: newname ******************** **** MySQL server is not available. Waiting 5 seconds... **** MySQL server is not available. Waiting 5 seconds...
Please document this exception.