Last Seen para proxy sempre em Never | Zabbix 5.2

[leobezerram]

Operating System: CentOS Stream 8
Zabbix 5.2
SElinux desabilitado em todas as máquinas


Meu telnet para a porta 10050 (conection refused) não funciona a 10051 funciona normalmente, mesmo eu tendo adicionando as portas ao firewall, tentei até por iptables. Já tentei fazer tudo do zero novamente, mas não obtive sucesso. Todas as minhas VMs pingam entre si, estão com data e hora corretas (instalei o Chrony).


Na interface do Zabbix, o proxy o proxy está sempre no estado "Never". O erro verificado no log foi:

45973:20220404:112228.462 [Z3001] connection to database 'zabbix_proxy' failed: [1045] Access denied for user 'zabbix'@'localhost' (using password: NO)

45973:20220404:112256.340 Cannot connect to the database. Exiting...

-----

O usuário zabbix já encontra-se com todas as permissões inseridas (firewall todo configurado, e versões do server e proxy iguais, mesmo não vindo ao caso), simplesmente não estou conseguindo resolver (mesmo após consulta no google). Pode me ajudar por favor?

[root@labzabbixproxy ~]# mysql -u zabbix -h localhost --database=zabbix -p
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 342
Server version: 8.0.26 Source distribution

Copyright (c) 2000, 2021, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

-----

[root@labzabbixproxy ~]# firewall-cmd --list-all

public

target: default

icmp-block-inversion: no

interfaces:

sources:

services: cockpit dhcpv6-client ssh

ports: 10050/tcp 10051/tcp

protocols:

forward: no

masquerade: no

forward-ports:

source-ports:

icmp-blocks:

rich rules:

-----

[root@labzabbixproxy ~]# firewall-cmd --zone=public --permanent --add-port 10050/tcp

Warning: ALREADY_ENABLED: 10050:tcp

success

[root@labzabbixproxy ~]# firewall-cmd --zone=public --permanent --add-port 10051/tcp

Warning: ALREADY_ENABLED: 10051:tcp

success


A porta consta como closed, mesmo eu já tendo liberado por iptables ou pelo firewall.

[root@labzabbixproxy ~]# nmap -Pn -p10050 localhost

Starting Nmap 7.70 ( https://nmap.org ) at 2022-04-13 13:22 +07

Nmap scan report for localhost (127.0.0.1)

Host is up (0.000073s latency).

Other addresses for localhost (not scanned): ::1




PORT STATE SERVICE

10050/tcp closed zabbix-agent




Nmap done: 1 IP address (1 host up) scanned in 0.30 seconds

[mfortes]

Access denied for user 'zabbix'@'localhost' (using password: NO)
Quando você populou o database criado para o Zabbix, você usou o usuario root ou zabbix?

[leobezerram]

usei o usr zabbix...

[leobezerram]

[root@labzabbixproxy ~]# mysql -u zabbix -h localhost --database=zabbix -p Enter password:

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A




Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 32

Server version: 8.0.26 Source distribution




Copyright (c) 2000, 2021, Oracle and/or its affiliates.




Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.




Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.




mysql> quit

Bye