search

cetic / helm-zabbix

Helm Chart For Zabbix
https://artifacthub.io/packages/helm/cetic/zabbix
Apache License 2.0
56 stars 57 forks source link

[cetic/zabbix] password authentication failed for user "zabbix" #46

Closed faustosm closed 2 years ago

faustosm commented 2 years ago

2022-03-04 14:14:37.300 GMT [1] LOG: pgaudit extension initialized 2022-03-04 14:14:37.306 GMT [1] LOG: starting PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit 2022-03-04 14:14:37.307 GMT [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2022-03-04 14:14:37.307 GMT [1] LOG: listening on IPv6 address "::", port 5432 2022-03-04 14:14:37.311 GMT [1] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2022-03-04 14:14:37.317 GMT [93] LOG: database system was shut down at 2022-03-04 14:01:27 GMT 2022-03-04 14:14:37.324 GMT [1] LOG: database system is ready to accept connections 2022-03-04 14:14:45.835 GMT [108] FATAL: password authentication failed for user "zabbix" 2022-03-04 14:14:45.835 GMT [108] DETAIL: Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5" 2022-03-04 14:14:48.235 GMT [109] FATAL: password authentication failed for user "zabbix" 2022-03-04 14:14:48.235 GMT [109] DETAIL: Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5"

Raph0773 commented 2 years ago

Hi,

I have the same issue :

postgresql 14:37:06.04  postgresql 14:37:06.04 Welcome to the Bitnami postgresql container postgresql 14:37:06.04 Subscribe to project updates by watching https://github.com/bitnami/bitnami-docker-postgresql postgresql 14:37:06.05 Submit issues and feature requests at https://github.com/bitnami/bitnami-docker-postgresql/issues postgresql 14:37:06.05  postgresql 14:37:06.07 INFO  ==> Starting PostgreSQL setup postgresql 14:37:06.12 INFO  ==> Validating settings in POSTGRESQL_* env vars.. postgresql 14:37:06.13 INFO  ==> Loading custom pre-init scripts... postgresql 14:37:06.13 INFO  ==> Initializing PostgreSQL database... postgresql 14:37:06.17 INFO  ==> pg_hba.conf file not detected. Generating it... postgresql 14:37:06.17 INFO  ==> Generating local authentication configuration postgresql 14:37:09.85 INFO  ==> Starting PostgreSQL in background... postgresql 14:37:16.34 INFO  ==> Changing password of postgres postgresql 14:37:16.37 INFO  ==> Creating user zabbix postgresql 14:37:16.40 INFO  ==> Granting access to "zabbix" to the database "zabbix" postgresql 14:37:16.45 INFO  ==> Setting ownership for the 'public' schema database "zabbix" to "zabbix" postgresql 14:37:16.50 INFO  ==> Configuring replication parameters postgresql 14:37:16.54 INFO  ==> Configuring synchronous_replication postgresql 14:37:16.54 INFO  ==> Configuring fsync postgresql 14:37:16.60 INFO  ==> Loading custom scripts... postgresql 14:37:16.61 INFO  ==> Enabling remote connections postgresql 14:37:16.63 INFO  ==> Stopping PostgreSQL... waiting for server to shut down........ done server stopped postgresql 14:37:21.36 INFO  ==> PostgreSQL setup finished! postgresql 14:37:21.40 INFO  ==> Starting PostgreSQL 2022-03-07 14:37:21.434 GMT [1] LOG: pgaudit extension initialized 2022-03-07 14:37:21.444 GMT [1] LOG: starting PostgreSQL 14.1 on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit 2022-03-07 14:37:21.445 GMT [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2022-03-07 14:37:21.445 GMT [1] LOG: listening on IPv6 address "::", port 5432 2022-03-07 14:37:21.450 GMT [1] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" 2022-03-07 14:37:21.474 GMT [163] LOG: database system was shut down at 2022-03-07 14:37:21 GMT 2022-03-07 14:37:21.489 GMT [1] LOG: database system is ready to accept connections 2022-03-07 14:37:27.916 GMT [177] FATAL: password authentication failed for user "zabbix" 2022-03-07 14:37:27.916 GMT [177] DETAIL: Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5" 2022-03-07 14:37:28.117 GMT [178] FATAL: password authentication failed for user "zabbix" 2022-03-07 14:37:28.117 GMT [178] DETAIL: Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5" 2022-03-07 14:37:33.005 GMT [179] FATAL: password authentication failed for user "zabbix" 2022-03-07 14:37:33.005 GMT [179] DETAIL: Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5" 2022-03-07 14:37:33.088 GMT [180] FATAL: password authentication failed for user "zabbix" 2022-03-07 14:37:33.088 GMT [180] DETAIL: Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5" 2022-03-07 14:37:33.208 GMT [181] FATAL: password authentication failed for user "zabbix" 2022-03-07 14:37:33.208 GMT [181] DETAIL: Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5" 2022-03-07 14:37:38.174 GMT [197] FATAL: password authentication failed for user "zabbix" 2022-03-07 14:37:38.174 GMT [197] DETAIL: Connection matched pg_hba.conf line 1: "host all all 0.0.0.0/0 md5"

Can you help me please ?

Thanks !

aeciopires commented 2 years ago

Hello @faustosm and @Raph0773!

The problem is the line 59 of values.yaml file.

The password must the same in parameters:

postgresql.auth.password
zabbixserver.POSTGRES_PASSWORD
zabbixweb.POSTGRES_PASSWORD

In this case, you need change only the postgresql.auth.password parameter to zabbix_pwd. See this PR https://github.com/cetic/helm-zabbix/pull/47 opened by @fmubaidien.