Ad Widget

Collapse

External checks on MYSQL dbhost execution issues

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • TrebuszeQ
    Junior Member
    • Jul 2023
    • 1

    #1

    External checks on MYSQL dbhost execution issues

    Zabbix host - rocky 9,
    zabbix version: Zabbix 6.0 LTS,
    type: external check
    key: database_status_external[macro1]
    selinux: permissive
    "script":
    #!/bin/bash
    mysql --login-path=macro1 --protocol=TCP --port=3306 -e "show status"

    ​error: ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)

    DB host - Centos Stream 9
    db: MySQL Community Server 8.0.34
    agent: zabbix-agent2-6.0.19
    selinux: permissive

    Hello,
    I have following issue when setting up external check for dbhost with agent2 passive. When I run a test it seems the password from --login-path is not provided. Also when I provide password inline it doesn't go through.
    When I do this through terminal with mysql or ssh it's read.

    Any advice?

    Kind regards
Working...