Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20284

Exclamation mark for password field, docker containers

    XMLWordPrintable

Details

    • Problem report
    • Status: Confirmed
    • Minor
    • Resolution: Unresolved
    • 5.0.17
    • None
    • Documentation (D)
    • None

    Description

      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 '[email protected]#efgh';
      CREATE USER 'zabbix_b'@'%' IDENTIFIED BY '[email protected]!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="[email protected]#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="[email protected]!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.

      Attachments

        Activity

          People

            zabbix.dev Zabbix Development Team
            aigars.kadikis Aigars Kadikis
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: