Ad Widget

Collapse

New Zabbix install 4.0.7 using docker - Database error

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • samlake
    Junior Member
    • Jan 2019
    • 1

    #1

    New Zabbix install 4.0.7 using docker - Database error

    Hi,

    I am still trying out zabbix using the docker containers. I can successfully run 4.0.4 but any version higher than that I get the following error when I try to browse to the zabbix web login:

    I am started with a clean build each time i.e. delete all old containers and volumes and run from scratch.

    Error connecting to database: The server requested authentication method unknown to the client

    Docker compose file and logs below. Any help much appreciated!

    This is the docker-compose file I am using (that works OK with 4.0.4)

    version: '3.1'
    services:
    mysql-server: # The mysql Database Service
    image: mysql:8.0.15
    restart: always
    environment: # Username, password and database name variables
    MYSQL_USER: zabbixtest
    MYSQL_PASSWORD: dfersdfgtyg
    MYSQL_DATABASE: zabbixtest
    MYSQL_ROOT_PASSWORD: sedfvbghtyujh
    volumes:
    - mysql-storage:/var/lib/mysql


    zabbix-server: # The main Zabbix Server Software Service
    image: zabbix/zabbix-server-mysql:ubuntu-4.0.7
    restart: always
    environment: # The Postgres database value variable
    MYSQL_USER: zabbixtest
    MYSQL_PASSWORD: dfersdfgtyg
    MYSQL_DATABASE: zabbixtest
    ZBX_HISTORYSTORAGETYPES: log,text #Zabbix configuration variables
    ZBX_DEBUGLEVEL: 1
    ZBX_HOUSEKEEPINGFREQUENCY: 1
    ZBX_MAXHOUSEKEEPERDELETE: 5000
    depends_on:
    - mysql-server
    volumes: # Volumes for scripts and related files you can add
    - zabbix-storage:/usr/lib/zabbix/alertscripts



    zabbix-web: # The main Zabbix web UI or interface
    image: zabbix/zabbix-web-nginx-mysql:ubuntu-4.0.7
    restart: always
    environment: # Mysql database variables
    MYSQL_USER: zabbixtest
    MYSQL_PASSWORD: dfersdfgtyg
    MYSQL_DATABASE: zabbixtest
    ZBX_SERVER_HOST: zabbix-server # Zabbix related and Php variables
    ZBX_POSTMAXSIZE: 64M
    PHP_TZ: "Asia/bangkok"
    ZBX_MAXEXECUTIONTIME: 500
    depends_on:
    - mysql-server
    - zabbix-server
    volumes:
    - nginx-storage-conf:/etc/nginx/conf.d
    # ports: # Port where Zabbix UI is available
    # - 8080:80
    # - 443:443

    zabbix-agent: # Zabbix agent service that tracks usage and send to zabbix server
    image: zabbix/zabbix-agent:ubuntu-4.0.7
    privileged: true #access mode for allowing resource access
    network_mode: "host"
    restart: unless-stopped
    environment:
    - ZBX_SERVER_HOST=127.0.0.1 #the IP/Dns of Zabbix server

    # adminer: #Optional for accessing databases
    # image: adminer
    # restart: always
    # ports:
    # - 8080:8080

    grafana: #optional more functional and creative UI
    image: grafana/grafana:6.1.6
    # user: "472"
    volumes:
    - grafana-storage:/var/lib/grafana

    # ports:
    # - 3000:3000

    nginx-proxy: # We need a
    image: nginx
    volumes:
    - ./nginx-proxy-data:/etc/nginx/conf.d
    - ./nginx-proxy-certs:/etc/ssl
    depends_on:
    - grafana
    - zabbix-web
    ports:
    - 80:80
    - 443:443

    volumes:
    grafana-storage:
    nginx-storage-conf:
    zabbix-storage:
    mysql-storage:
    # nginx-proxy-data:
    # nginx-proxy-certs:



    This is the log output from the docker run.


    zabbix-agent_1 | ** Deploying Zabbix agent
    zabbix-agent_1 | ** Preparing the system
    zabbix-agent_1 | ** Preparing Zabbix agent
    zabbix-agent_1 | ** Preparing Zabbix agent configuration file
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "PidFile": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "LogType": 'console'... added
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "LogFile": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "LogFileSize": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "DebugLevel": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "SourceIP": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "EnableRemoteCommands": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "LogRemoteCommands": ''... removed
    zabbix-agent_1 | ** Using '127.0.0.1' servers for passive checks
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "Server": '127.0.0.1'... updated
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "ListenPort": ''... removed
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Starting Grafana" logger=server version=6.1.6 commit=cf9cb45 branch=HEAD compiled=2019-04-29T13:29:28+0000
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config loaded from" logger=settings file=/usr/share/grafana/conf/defaults.ini
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config loaded from" logger=settings file=/etc/grafana/grafana.ini
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.data=/var/lib/grafana"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.logs=/var/log/grafana"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.plugins=/var/lib/grafana/plugins"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.paths.provisioning=/etc/grafana/provisioning"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from command line" logger=settings arg="default.log.mode=console"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_DATA=/var/lib/grafana"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_LOGS=/var/log/grafana"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_PLUGINS=/var/lib/grafana/plugins"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Config overridden from Environment variable" logger=settings var="GF_PATHS_PROVISIONING=/etc/grafana/provisioning"
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Path Home" logger=settings path=/usr/share/grafana
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Path Data" logger=settings path=/var/lib/grafana
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Path Logs" logger=settings path=/var/log/grafana
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Path Plugins" logger=settings path=/var/lib/grafana/plugins
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Path Provisioning" logger=settings path=/etc/grafana/provisioning
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="App mode production" logger=settings
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Initializing HTTPServer" logger=server
    zabbix-server_1 | ** Deploying Zabbix server with mysql database
    zabbix-web_1 | ** Deploying Zabbix frontend (nginx) with mysql database
    zabbix-server_1 | ** Preparing the system
    zabbix-server_1 | ** Preparing Zabbix server
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Initializing SqlStore" logger=server
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Connecting to DB" logger=sqlstore dbtype=sqlite3
    grafana_1 | t=2019-05-01T22:48:07+0000 lvl=info msg="Starting DB migration" logger=migrator
    nginx-proxy_1 | 2019/05/01 22:48:13 [warn] 1#1: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/conf.d/grafana-proxy.conf:13
    nginx-proxy_1 | nginx: [warn] the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/conf.d/grafana-proxy.conf:13
    nginx-proxy_1 | 2019/05/01 22:48:13 [warn] 1#1: the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/conf.d/zabbix-proxy.conf:13
    nginx-proxy_1 | nginx: [warn] the "ssl" directive is deprecated, use the "listen ... ssl" directive instead in /etc/nginx/conf.d/zabbix-proxy.conf:13
    mysql-server_1 | Initializing database
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "ListenIP": ''... removed
    nginx-proxy_1 | 2019/05/01 22:48:13 [warn] 1#1: conflicting server name "" on 0.0.0.0:80, ignored
    nginx-proxy_1 | nginx: [warn] conflicting server name "" on 0.0.0.0:80, ignored
    zabbix-web_1 | ** Preparing the system
    zabbix-server_1 | ********************
    zabbix-server_1 | * DB_SERVER_HOST: mysql-server
    zabbix-server_1 | * DB_SERVER_PORT: 3306
    zabbix-server_1 | * DB_SERVER_DBNAME: zabbixtest
    zabbix-server_1 | * DB_SERVER_ZBX_USER: zabbixtest
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing InternalMetricsService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing SearchService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing PluginManager" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Starting plugin search" logger=plugins
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing RenderingService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing AlertingService" logger=server
    zabbix-web_1 | ** Preparing Zabbix web-interface
    zabbix-web_1 | ********************
    zabbix-web_1 | * DB_SERVER_HOST: mysql-server
    zabbix-web_1 | * DB_SERVER_PORT: 3306
    zabbix-web_1 | * DB_SERVER_DBNAME: zabbixtest
    zabbix-web_1 | * DB_SERVER_ZBX_USER: zabbixtest
    zabbix-web_1 | * DB_SERVER_ZBX_PASS: dfersdfgtyg
    zabbix-web_1 | ********************
    zabbix-web_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-web_1 | **** MySQL server is not available. Waiting 5 seconds...
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing DatasourceCacheService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing HooksService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing LoginService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing QuotaService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing RemoteCache" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing ServerLockService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing TracingService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing UsageStatsService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing UserAuthTokenService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing CleanUpService" logger=server
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing NotificationService" logger=server
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "StartAgents": ''... removed
    zabbix-agent_1 | ** Using '127.0.0.1:10051' servers for active checks
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing ProvisioningService" logger=server
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "ServerActive": '127.0.0.1:10051'... updated
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "Hostname": ''... removed
    zabbix-server_1 | * DB_SERVER_ZBX_PASS: dfersdfgtyg
    zabbix-server_1 | ********************
    zabbix-server_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "HostnameItem": ''... removed
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="Initializing Stream Manager"
    grafana_1 | t=2019-05-01T22:48:08+0000 lvl=info msg="HTTP Server Listen" logger=http.server address=0.0.0.0:3000 protocol=http subUrl= socket=
    zabbix-server_1 | **** MySQL server is not available. Waiting 5 seconds...
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "HostMetadata": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "HostMetadataItem": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "RefreshActiveChecks": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "BufferSend": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "BufferSize": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "MaxLinesPerSecond": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "Timeout": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "Include": '/etc/zabbix/zabbix_agentd.d/'... added first occurrence
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "UnsafeUserParameters": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "LoadModulePath": '/var/lib/zabbix/modules/'... added
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSConnect": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSAccept": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSCAFile": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSCRLFile": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSServerCertIssuer": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSServerCertSubject": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSCertFile": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSKeyFile": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSPSKIdentity": ''... removed
    zabbix-agent_1 | ** Updating '/etc/zabbix/zabbix_agentd.conf' parameter "TLSPSKFile": ''... removed
    zabbix-agent_1 | ** Cleaning the system
    zabbix-agent_1 | ################################################## ######
    zabbix-agent_1 | ** Starting Zabbix agent
    zabbix-agent_1 | Starting Zabbix Agent [Sams-Laptop]. Zabbix 4.0.7 (revision 92831).
    zabbix-agent_1 | Press Ctrl+C to exit.
    zabbix-agent_1 |
    zabbix-agent_1 | 55:20190501:224807.522 Starting Zabbix Agent [Sams-Laptop]. Zabbix 4.0.7 (revision 92831).
    zabbix-agent_1 | 55:20190501:224807.522 **** Enabled features ****
    zabbix-agent_1 | 55:20190501:224807.522 IPv6 support: YES
    zabbix-agent_1 | 55:20190501:224807.522 TLS support: YES
    zabbix-agent_1 | 55:20190501:224807.522 **************************
    zabbix-agent_1 | 55:20190501:224807.522 using configuration file: /etc/zabbix/zabbix_agentd.conf
    zabbix-agent_1 | 55:20190501:224807.544 agent #0 started [main process]
    zabbix-agent_1 | 56:20190501:224807.544 agent #1 started [collector]
    zabbix-agent_1 | 57:20190501:224807.546 agent #2 started[listener #1]
    zabbix-agent_1 | 58:20190501:224807.547 agent #3 started[listener #2]
    zabbix-agent_1 | 60:20190501:224807.548 agent #5 started [active checks #1]
    zabbix-agent_1 | 59:20190501:224807.548 agent #4 started[listener #3]
    zabbix-agent_1 | 60:20190501:224807.556 active check configuration update from [127.0.0.1:10051] started to fail (cannot connect to [[127.0.0.1]:10051]: [111] Connection refused)
    zabbix-server_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | **** MySQL server is not available. Waiting 5 seconds...
    mysql-server_1 | 2019-05-01T22:48:09.502593Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
    mysql-server_1 | 2019-05-01T22:48:09.503312Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.15) initializing of server in progress as process 29
    mysql-server_1 | 2019-05-01T22:48:17.073734Z 5 [Warning] [MY-010453] [Server] root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.
    zabbix-web_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-web_1 | **** MySQL server is not available. Waiting 5 seconds...
    mysql-server_1 | 2019-05-01T22:48:20.759337Z 0 [System] [MY-013170] [Server] /usr/sbin/mysqld (mysqld 8.0.15) initializing of server has completed
    zabbix-server_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | **** MySQL server is not available. Waiting 5 seconds...
    zabbix-web_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-web_1 | **** MySQL server is not available. Waiting 5 seconds...
    mysql-server_1 | Database initialized
    mysql-server_1 | MySQL init process in progress...
    mysql-server_1 | MySQL init process in progress...
    mysql-server_1 | mbind: Operation not permitted
    mysql-server_1 | 2019-05-01T22:48:22.892627Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
    mysql-server_1 | 2019-05-01T22:48:22.892780Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15) starting as process 80
    mysql-server_1 | 2019-05-01T22:48:23.734693Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
    mysql-server_1 | 2019-05-01T22:48:23.743045Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
    mysql-server_1 | 2019-05-01T22:48:23.787174Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15' socket: '/var/run/mysqld/mysqld.sock' port: 0 MySQL Community Server - GPL.
    mysql-server_1 | 2019-05-01T22:48:23.996574Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock'
    zabbix-server_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | **** MySQL server is not available. Waiting 5 seconds...
    mysql-server_1 | Warning: Unable to load '/usr/share/zoneinfo/iso3166.tab' as time zone. Skipping it.
    mysql-server_1 | Warning: Unable to load '/usr/share/zoneinfo/leap-seconds.list' as time zone. Skipping it.
    zabbix-web_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-web_1 | **** MySQL server is not available. Waiting 5 seconds...
    mysql-server_1 | Warning: Unable to load '/usr/share/zoneinfo/zone.tab' as time zone. Skipping it.
    mysql-server_1 | Warning: Unable to load '/usr/share/zoneinfo/zone1970.tab' as time zone. Skipping it.
    mysql-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | **** MySQL server is not available. Waiting 5 seconds...
    mysql-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    mysql-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    mysql-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    mysql-server_1 |
    zabbix-web_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-web_1 | **** MySQL server is not available. Waiting 5 seconds...
    mysql-server_1 | 2019-05-01T22:48:33.896391Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15) MySQL Community Server - GPL.
    mysql-server_1 |
    mysql-server_1 | MySQL init process done. Ready for start up.
    mysql-server_1 |
    mysql-server_1 | 2019-05-01T22:48:34.342764Z 0 [Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release.
    mysql-server_1 | 2019-05-01T22:48:34.342918Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15) starting as process 1
    mysql-server_1 | 2019-05-01T22:48:35.075219Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
    mysql-server_1 | 2019-05-01T22:48:35.082314Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
    mysql-server_1 | 2019-05-01T22:48:35.123085Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server - GPL.
    mysql-server_1 | 2019-05-01T22:48:35.158585Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
    zabbix-server_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | ** Creating 'zabbixtest' user in MySQL database
    zabbix-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | ERROR 1142 (42000) at line 1: SELECT command denied to user 'zabbixtest'@'172.18.0.4' for table 'user'
    zabbix-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | ERROR 1227 (42000) at line 1: Access denied; you need (at least one of) the CREATE USER privilege(s) for this operation
    zabbix-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | ERROR 1044 (42000) at line 1: Access denied for user 'zabbixtest'@'%' to database 'zabbixtest'
    zabbix-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | ** Database 'zabbixtest' already exists. Please be careful with database COLLATE!
    zabbix-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    zabbix-server_1 | ** Creating 'zabbixtest' schema in MySQL
    zabbix-server_1 | mysql: [Warning] Using a password on the command line interface can be insecure.
    zabbix-web_1 | mysqladmin: [Warning] Using a password on the command line interface can be insecure.
    zabbix-web_1 | ** Disable default vhosts
    zabbix-web_1 | ** Adding Zabbix virtual host (HTTP)
    zabbix-web_1 | **** Impossible to enable SSL support for Nginx. Certificates are missed.
    zabbix-web_1 | ** Preparing Zabbix frontend configuration file
    zabbix-web_1 | ** Updating '/etc/php/7.2/fpm/conf.d/99-zabbix.ini' parameter "max_execution_time": '500'... updated
    zabbix-web_1 | ** Updating '/etc/php/7.2/fpm/conf.d/99-zabbix.ini' parameter "memory_limit": '128M'... updated
    zabbix-web_1 | ** Updating '/etc/php/7.2/fpm/conf.d/99-zabbix.ini' parameter "post_max_size": '64M'... updated
    zabbix-web_1 | ** Updating '/etc/php/7.2/fpm/conf.d/99-zabbix.ini' parameter "upload_max_filesize": '2M'... updated
    zabbix-web_1 | ** Updating '/etc/php/7.2/fpm/conf.d/99-zabbix.ini' parameter "max_input_time": '300'... updated
    zabbix-web_1 | ** Updating '/etc/php/7.2/fpm/conf.d/99-zabbix.ini' parameter "date.timezone": 'Asia/bangkok'... added
    zabbix-web_1 | ** Cleaning the system
    zabbix-web_1 | ################################################## ######
    zabbix-web_1 | ** Executing supervisord
    zabbix-web_1 | 2019-05-01 22:48:37,939 CRIT Set uid to user 0
    zabbix-web_1 | 2019-05-01 22:48:37,939 CRIT Set uid to user 0
    zabbix-web_1 | 2019-05-01 22:48:37,939 INFO Included extra file "/etc/supervisor/conf.d/supervisord_zabbix.conf" during parsing
    zabbix-web_1 | 2019-05-01 22:48:37,939 INFO Included extra file "/etc/supervisor/conf.d/supervisord_zabbix.conf" during parsing
    zabbix-web_1 | 2019-05-01 22:48:37,960 INFO RPC interface 'supervisor' initialized
    zabbix-web_1 | 2019-05-01 22:48:37,960 INFO RPC interface 'supervisor' initialized
    zabbix-web_1 | 2019-05-01 22:48:37,961 INFO supervisord started with pid 1
    zabbix-web_1 | 2019-05-01 22:48:37,961 INFO supervisord started with pid 1
    zabbix-web_1 | 2019-05-01 22:48:38,964 INFO spawned: 'nginx' with pid 50
    zabbix-web_1 | 2019-05-01 22:48:38,964 INFO spawned: 'nginx' with pid 50
    zabbix-web_1 | 2019-05-01 22:48:38,968 INFO spawned: 'php-fpm7.2' with pid 51
    zabbix-web_1 | 2019-05-01 22:48:38,968 INFO spawned: 'php-fpm7.2' with pid 51
    zabbix-web_1 | [01-May-2019 22:48:39] NOTICE: fpm is running, pid 51
    zabbix-web_1 | [01-May-2019 22:48:39] NOTICE: ready to handle connections
    zabbix-web_1 | [01-May-2019 22:48:39] NOTICE: systemd monitor interval set to 10000ms
    zabbix-web_1 | 2019-05-01 22:48:41,260 INFO success: nginx entered RUNNING state, process has stayed up for > than 2 seconds (startsecs)
    zabbix-web_1 | 2019-05-01 22:48:41,260 INFO success: nginx entered RUNNING state, process has stayed up for > than 2 seconds (startsecs)
    zabbix-web_1 | 2019-05-01 22:48:41,261 INFO success: php-fpm7.2 entered RUNNING state, process has stayed up for > than 2 seconds (startsecs)
    zabbix-web_1 | 2019-05-01 22:48:41,261 INFO success: php-fpm7.2 entered RUNNING state, process has stayed up for > than 2 seconds (startsecs)
    zabbix-web_1 | 172.18.0.6 - - [01/May/2019:22:49:53 +0000] "GET / HTTP/1.1" 200 709 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:66.0) Gecko/20100101 Firefox/66.0" "172.18.0.1"
    zabbix-web_1 | 172.18.0.6 - - [01/May/2019:22:49:54 +0000] "GET /img/touch-icon-192x192.png HTTP/1.1" 499 0 "-" "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:66.0) Gecko/20100101 Firefox/66.0" "172.18.0.1"
    zabbix-server_1 | ** Preparing Zabbix server configuration file
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "ListenPort": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "SourceIP": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "LogType": 'console'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "LogFile": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "LogFileSize": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "PidFile": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "DebugLevel": '1'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBHost": 'mysql-server'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBName": 'zabbixtest'... updated
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBSchema": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBUser": 'zabbixtest'... updated
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBPort": '3306'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBPassword": 'dfersdfgtyg'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryStorageURL": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryStorageTypes": 'log,text'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryStorageDateIndex": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "DBSocket": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StatsAllowedIP": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartPollers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartIPMIPollers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartPollersUnreachable": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartTrappers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartPingers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartDiscoverers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartHTTPPollers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartPreprocessors": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartTimers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartEscalators": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartAlerters": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "JavaGateway": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "JavaGatewayPort": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartJavaPollers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartVMwareCollectors": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "VMwareFrequency": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "VMwarePerfFrequency": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "VMwareCacheSize": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "VMwareTimeout": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "SNMPTrapperFile": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartSNMPTrapper": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "HousekeepingFrequency": '1'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "MaxHousekeeperDelete": '5000'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "SenderFrequency": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "CacheSize": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "CacheUpdateFrequency": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartDBSyncers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryCacheSize": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "HistoryIndexCacheSize": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "TrendCacheSize": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "ValueCacheSize": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "Timeout": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "TrapperTimeout": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "UnreachablePeriod": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "UnavailableDelay": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "UnreachableDelay": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "AlertScriptsPath": '/usr/lib/zabbix/alertscripts'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "ExternalScripts": '/usr/lib/zabbix/externalscripts'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "FpingLocation": '/usr/bin/fping'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "Fping6Location": '/usr/bin/fping6'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "SSHKeyLocation": '/var/lib/zabbix/ssh_keys'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "LogSlowQueries": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "StartProxyPollers": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "ProxyConfigFrequency": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "ProxyDataFrequency": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "SSLCertLocation": '/var/lib/zabbix/ssl/certs/'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "SSLKeyLocation": '/var/lib/zabbix/ssl/keys/'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "SSLCALocation": '/var/lib/zabbix/ssl/ssl_ca/'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "LoadModulePath": '/var/lib/zabbix/modules/'... added
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCAFile": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCRLFile": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSCertFile": ''... removed
    zabbix-server_1 | ** Updating '/etc/zabbix/zabbix_server.conf' parameter "TLSKeyFile": ''... removed
    zabbix-server_1 | ** Cleaning the system
    zabbix-server_1 | ################################################## ######
    zabbix-server_1 | ** Starting Zabbix server
    zabbix-server_1 | Starting Zabbix Server. Zabbix 4.0.7 (revision 92831).
    zabbix-server_1 | Press Ctrl+C to exit.
    zabbix-server_1 |
    zabbix-server_1 | 157:20190501:225021.138 Starting Zabbix Server. Zabbix 4.0.7 (revision 92831).
    zabbix-server_1 | 157:20190501:225021.138 ****** Enabled features ******
    zabbix-server_1 | 157:20190501:225021.138 SNMP monitoring: YES
    zabbix-server_1 | 157:20190501:225021.138 IPMI monitoring: YES
    zabbix-server_1 | 157:20190501:225021.138 Web monitoring: YES
    zabbix-server_1 | 157:20190501:225021.138 VMware monitoring: YES
    zabbix-server_1 | 157:20190501:225021.138 SMTP authentication: YES
    zabbix-server_1 | 157:20190501:225021.138 Jabber notifications: YES
    zabbix-server_1 | 157:20190501:225021.138 Ez Texting notifications: YES
    zabbix-server_1 | 157:20190501:225021.138 ODBC: YES
    zabbix-server_1 | 157:20190501:225021.138 SSH2 support: YES
    zabbix-server_1 | 157:20190501:225021.138 IPv6 support: YES
    zabbix-server_1 | 157:20190501:225021.138 TLS support: YES
    zabbix-server_1 | 157:20190501:225021.138 ******************************
    zabbix-server_1 | 157:20190501:225021.138 using configuration file: /etc/zabbix/zabbix_server.conf
    mysql-server_1 | mbind: Operation not permitted
    zabbix-server_1 | 157:20190501:225021.239 current database version (mandatory/optional): 04000000/04000003
    zabbix-server_1 | 157:20190501:225021.239 required mandatory version: 04000000
    mysql-server_1 | mbind: Operation not permitted
    zabbix-server_1 | 157:20190501:225021.374 server #0 started [main process]
    zabbix-server_1 | 158:20190501:225021.375 server #1 started [configuration syncer #1]
    zabbix-server_1 | 159:20190501:225021.377 server #2 started [housekeeper #1]
    zabbix-server_1 | 160:20190501:225021.379 server #3 started [timer #1]
    zabbix-server_1 | 162:20190501:225021.381 server #5 started [discoverer #1]
    zabbix-server_1 | 163:20190501:225021.396 server #6 started [history syncer #1]
    zabbix-server_1 | 164:20190501:225021.397 server #7 started [history syncer #2]
    zabbix-server_1 | 166:20190501:225021.398 server #9 started [history syncer #4]
    zabbix-server_1 | 165:20190501:225021.399 server #8 started [history syncer #3]
    zabbix-server_1 | 167:20190501:225021.411 server #10 started [escalator #1]
    zabbix-server_1 | 169:20190501:225021.412 server #12 started [self-monitoring #1]
    zabbix-server_1 | 170:20190501:225021.412 server #13 started [task manager #1]
    zabbix-server_1 | 168:20190501:225021.417 server #11 started [proxy poller #1]
    zabbix-server_1 | 161:20190501:225021.418 server #4 started [http poller #1]
    zabbix-server_1 | 171:20190501:225021.420 server #14 started [poller #1]
    zabbix-server_1 | 172:20190501:225021.433 server #15 started [poller #2]
    zabbix-server_1 | 173:20190501:225021.435 server #16 started [poller #3]
    zabbix-server_1 | 178:20190501:225021.457 server #21 started [trapper #2]
    zabbix-server_1 | 175:20190501:225021.464 server #18 started [poller #5]
    zabbix-server_1 | 174:20190501:225021.469 server #17 started [poller #4]
    zabbix-server_1 | 180:20190501:225021.471 server #23 started [trapper #4]
    zabbix-server_1 | 176:20190501:225021.485 server #19 started [unreachable poller #1]
    zabbix-server_1 | 179:20190501:225021.487 server #22 started [trapper #3]
    zabbix-server_1 | 177:20190501:225021.491 server #20 started [trapper #1]
    zabbix-server_1 | 181:20190501:225021.563 server #24 started [trapper #5]
    zabbix-server_1 | 182:20190501:225021.569 server #25 started [icmp pinger #1]
    zabbix-server_1 | 183:20190501:225021.571 server #26 started [alert manager #1]
    zabbix-server_1 | 184:20190501:225021.593 server #27 started [alerter #1]
    zabbix-server_1 | 185:20190501:225021.594 server #28 started [alerter #2]
    zabbix-server_1 | 186:20190501:225021.599 server #29 started [alerter #3]
    zabbix-server_1 | 187:20190501:225021.606 server #30 started [preprocessing manager #1]
    zabbix-server_1 | 188:20190501:225021.608 server #31 started [preprocessing worker #1]
    zabbix-server_1 | 189:20190501:225021.614 server #32 started [preprocessing worker #2]
    zabbix-server_1 | 190:20190501:225021.631 server #33 started [preprocessing worker #3]
    zabbix-server_1 | Bad operator (INTEGER): At line 73 in /var/lib/snmp/mibs/ietf/SNMPv2-PDU
    zabbix-server_1 | Bad operator (INTEGER): At line 73 in /var/lib/snmp/mibs/ietf/SNMPv2-PDU
    zabbix-server_1 | Bad operator (INTEGER): At line 73 in /var/lib/snmp/mibs/ietf/SNMPv2-PDU
    zabbix-server_1 | Bad operator (INTEGER): At line 73 in /var/lib/snmp/mibs/ietf/SNMPv2-PDU
    zabbix-server_1 | Bad operator (INTEGER): At line 73 in /var/lib/snmp/mibs/ietf/SNMPv2-PDU
    zabbix-server_1 | Bad operator (INTEGER): At line 73 in /var/lib/snmp/mibs/ietf/SNMPv2-PDU
    zabbix-server_1 | Bad operator (INTEGER): At line 73 in /var/lib/snmp/mibs/ietf/SNMPv2-PDU
    mysql-server_1 | mbind: Operation not permitted


Working...