Не удаётся настроить сбор статистики

[Slavenin]

Здравствуйте!
Помогите пожалуйста разобраться. Прикручиваю ваше решение к zabbix (который вчера увидел первый раз :) ). Вроде всё получилось, но ничего не работает. Застрял на шаге:

mamonsu bootstrap -U mamonsu -d mamonsu --host localhost

Query:

CREATE TABLE IF NOT EXISTS public.mamonsu_config (
version text,
inserted_at timestamp DEFAULT NOW()
);
error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "mamonsu"', u'auth.c', u'307', u'auth_failed', u'', u'')

вот такое мне пишет консоль.
/etc/postgresql/9.6/main/pg_hba.conf:

local   all             postgres                                md5
host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5
local    all             zabbix                                  md5
local    all             mamonsu                                 md5

/etc/mamonsu/agent.conf:

[postgres]
enabled = True
user = mamonsu
password = dbpass
database = mamonsu
host = localhost
port = 5432
application_name = mamonsu
query_timeout = 10

[system]
enabled = True

[sender]
queue = 300

[agent]
enabled = True
host = 127.0.0.1
port = 10052

[plugins]
enabled = False
directory = /etc/mamonsu/plugins

[zabbix]
enabled = True
client = postgreDb
address = 127.0.0.1
port = 10050

[metric_log]
enabled = False
directory = /var/log/mamonsu
max_size_mb = 1024

[log]
file = /var/log/mamonsu/agent.log
level = INFO
format = [%(levelname)s] %(asctime)s - %(name)s -       %(message)s

[health]
max_memory_usage = 41943040

[databases]
bloat_scale = 0.2
min_rows = 50

[pghealth]
uptime = 600
cache = 80

[xlog]
lag_more_then_in_sec = 300

[checkpoint]
max_checkpoint_by_wal_in_hour = 12

[oldest]
max_xid_age = 18000000
max_query_time = 18000

[cfs]
force_enable = False

[disksizes]
vfs_percent_free = 10
vfs_inode_percent_free = 10

[systemuptime]
uptime = 300

Настройки в zabbix

В логе /var/log/mamonsu/agent.log

INFO] 2016-11-29 10:32:25,296 - BGWRITER	-	started ...
[INFO] 2016-11-29 10:32:25,296 - CONNECTIONS	-	started ...
[INFO] 2016-11-29 10:32:25,296 - DATABASES	-	started ...
[INFO] 2016-11-29 10:32:25,297 - PGHEALTH	-	started ...
[INFO] 2016-11-29 10:32:25,297 - INSTANCE	-	started ...
[INFO] 2016-11-29 10:32:25,297 - XLOG	-	started ...
[INFO] 2016-11-29 10:32:25,297 - PGSTATSTATEMENT	-	started ...
[INFO] 2016-11-29 10:32:25,298 - PGBUFFERCACHE	-	started ...
[INFO] 2016-11-29 10:32:25,298 - PGWAITSAMPLING	-	started ...
[INFO] 2016-11-29 10:32:25,298 - CHECKPOINT	-	started ...
[INFO] 2016-11-29 10:32:25,299 - OLDEST	-	started ...
[INFO] 2016-11-29 10:32:25,299 - PGLOCKS	-	started ...
[ERROR] 2016-11-29 10:32:25,301 - BGWRITER	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,301 - BGWRITER	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,319 - CONNECTIONS	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,319 - CONNECTIONS	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,329 - DATABASES	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,329 - DATABASES	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,331 - PGHEALTH	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,331 - PGHEALTH	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,340 - INSTANCE	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,340 - INSTANCE	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,358 - XLOG	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,358 - XLOG	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,360 - PGSTATSTATEMENT	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,360 - PGSTATSTATEMENT	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,370 - PGBUFFERCACHE	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,370 - PGBUFFERCACHE	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,379 - PGWAITSAMPLING	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,379 - PGWAITSAMPLING	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,389 - CHECKPOINT	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,389 - CHECKPOINT	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,398 - OLDEST	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,398 - OLDEST	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:25,407 - PGLOCKS	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:25,407 - PGLOCKS	-	hint: enable debug level to full exception trace
[INFO] 2016-11-29 10:32:35,301 - BGWRITER	-	started ...
[INFO] 2016-11-29 10:32:35,301 - CONNECTIONS	-	started ...
[INFO] 2016-11-29 10:32:35,301 - DATABASES	-	started ...
[INFO] 2016-11-29 10:32:35,301 - PGHEALTH	-	started ...
[INFO] 2016-11-29 10:32:35,301 - INSTANCE	-	started ...
[INFO] 2016-11-29 10:32:35,302 - XLOG	-	started ...
[INFO] 2016-11-29 10:32:35,302 - PGSTATSTATEMENT	-	started ...
[INFO] 2016-11-29 10:32:35,302 - PGBUFFERCACHE	-	started ...
[INFO] 2016-11-29 10:32:35,302 - PGWAITSAMPLING	-	started ...
[INFO] 2016-11-29 10:32:35,303 - CHECKPOINT	-	started ...
[INFO] 2016-11-29 10:32:35,303 - OLDEST	-	started ...
[INFO] 2016-11-29 10:32:35,303 - PGLOCKS	-	started ...
[ERROR] 2016-11-29 10:32:35,308 - BGWRITER	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,308 - BGWRITER	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,318 - CONNECTIONS	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,318 - CONNECTIONS	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,327 - DATABASES	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,327 - DATABASES	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,338 - PGHEALTH	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,338 - PGHEALTH	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,347 - INSTANCE	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,347 - INSTANCE	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,357 - XLOG	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,357 - XLOG	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,367 - PGSTATSTATEMENT	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,367 - PGSTATSTATEMENT	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,376 - PGBUFFERCACHE	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,376 - PGBUFFERCACHE	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,386 - PGWAITSAMPLING	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,386 - PGWAITSAMPLING	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,396 - CHECKPOINT	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,397 - CHECKPOINT	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,406 - OLDEST	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,406 - OLDEST	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:35,416 - PGLOCKS	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:35,416 - PGLOCKS	-	hint: enable debug level to full exception trace
[INFO] 2016-11-29 10:32:45,305 - BGWRITER	-	started ...
[INFO] 2016-11-29 10:32:45,306 - CONNECTIONS	-	started ...
[INFO] 2016-11-29 10:32:45,306 - DATABASES	-	started ...
[INFO] 2016-11-29 10:32:45,306 - PGHEALTH	-	started ...
[INFO] 2016-11-29 10:32:45,306 - INSTANCE	-	started ...
[INFO] 2016-11-29 10:32:45,307 - XLOG	-	started ...
[INFO] 2016-11-29 10:32:45,307 - PGSTATSTATEMENT	-	started ...
[INFO] 2016-11-29 10:32:45,307 - PGBUFFERCACHE	-	started ...
[INFO] 2016-11-29 10:32:45,308 - PGWAITSAMPLING	-	started ...
[INFO] 2016-11-29 10:32:45,308 - CHECKPOINT	-	started ...
[INFO] 2016-11-29 10:32:45,308 - OLDEST	-	started ...
[INFO] 2016-11-29 10:32:45,308 - PGLOCKS	-	started ...
[ERROR] 2016-11-29 10:32:45,318 - BGWRITER	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,318 - BGWRITER	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,327 - CONNECTIONS	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,328 - CONNECTIONS	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,338 - DATABASES	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,339 - DATABASES	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,348 - PGHEALTH	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,348 - PGHEALTH	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,358 - INSTANCE	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,358 - INSTANCE	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,368 - XLOG	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,368 - XLOG	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,387 - PGSTATSTATEMENT	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,387 - PGSTATSTATEMENT	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,397 - PGBUFFERCACHE	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,397 - PGBUFFERCACHE	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,407 - PGWAITSAMPLING	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,407 - PGWAITSAMPLING	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,417 - CHECKPOINT	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,417 - CHECKPOINT	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,426 - OLDEST	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,427 - OLDEST	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:45,436 - PGLOCKS	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:45,436 - PGLOCKS	-	hint: enable debug level to full exception trace
[INFO] 2016-11-29 10:32:55,316 - BGWRITER	-	started ...
[INFO] 2016-11-29 10:32:55,317 - CONNECTIONS	-	started ...
[INFO] 2016-11-29 10:32:55,317 - DATABASES	-	started ...
[INFO] 2016-11-29 10:32:55,317 - PGHEALTH	-	started ...
[INFO] 2016-11-29 10:32:55,317 - INSTANCE	-	started ...
[INFO] 2016-11-29 10:32:55,318 - XLOG	-	started ...
[INFO] 2016-11-29 10:32:55,318 - PGSTATSTATEMENT	-	started ...
[INFO] 2016-11-29 10:32:55,318 - PGBUFFERCACHE	-	started ...
[INFO] 2016-11-29 10:32:55,319 - PGWAITSAMPLING	-	started ...
[INFO] 2016-11-29 10:32:55,319 - CHECKPOINT	-	started ...
[INFO] 2016-11-29 10:32:55,319 - OLDEST	-	started ...
[INFO] 2016-11-29 10:32:55,319 - PGLOCKS	-	started ...
[ERROR] 2016-11-29 10:32:55,330 - ZBX-zabbix.server.ip:10051	-	catch error: [Errno -2] Name or service not known
[INFO] 2016-11-29 10:32:55,330 - ZBX-zabbix.server.ip:10051	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,339 - BGWRITER	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,339 - BGWRITER	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,349 - CONNECTIONS	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,349 - CONNECTIONS	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,359 - DATABASES	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,359 - DATABASES	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,368 - PGHEALTH	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,368 - PGHEALTH	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,378 - INSTANCE	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,378 - INSTANCE	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,387 - XLOG	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,387 - XLOG	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,396 - PGSTATSTATEMENT	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,396 - PGSTATSTATEMENT	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,405 - PGBUFFERCACHE	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,405 - PGBUFFERCACHE	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,415 - PGWAITSAMPLING	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,415 - PGWAITSAMPLING	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,425 - CHECKPOINT	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,425 - CHECKPOINT	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,434 - OLDEST	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,435 - OLDEST	-	hint: enable debug level to full exception trace
[ERROR] 2016-11-29 10:32:55,444 - PGLOCKS	-	catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 10:32:55,445 - PGLOCKS	-	hint: enable debug level to full exception trace

Что совсем странно, так как откуда-то вылез юзер postgres.

Помогите пожалуйста разобраться.

[vadv]

привет!

1. mamonsu bootstrap -U mamonsu -d mamonsu --host localhost - бутстрапить надо под суперпользователем, поэтому необходимо указать -U postgres. Если вы не забутстрапите то необходимо дать права суперпользователя пользователю mamonsu.

2. catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'') а рестартили mamonsu после того как в конфиге прописали db-пользователя mamonsu (кстати в pg_hba можно ident прописать)?

[Slavenin]

а рестартили mamonsu после этого?

да

необходимо указать -U postgres

тоже самое

postgres_user@postgreDb:/usr/share/zabbix/conf$ mamonsu bootstrap -U postgres -d mamonsu --host localhost
Query:

CREATE TABLE IF NOT EXISTS public.mamonsu_config (
  version text,
  inserted_at timestamp DEFAULT NOW()
);
error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')

Причём явное указание пароля через аргумент -W ничего не даёт

[vadv]

-W PASSWORD, --password=PASSWORD

[vadv]

укажите при бутстрапе пароль postgres или запускайте под unix-пользователем postgres.

[vadv]

можно ли увидеть: ps axufwww | grep mamonsu

[Slavenin]

-W PASSWORD, --password=PASSWORD
укажите при бутстрапе пароль postgres или запускайте под unix-пользователем postgres.

указание пароля для пользователя не даёт результата

можно ли увидеть: ps axufwww | grep mamonsu

[vadv]

1. попробуйте вместо localhost использовать 127.0.0.1
2. прошу закрыть nano и рестартануть mamonsu

[Slavenin]

Полностью перезагрузил сервер. Уровень лога установил в debug

mamonsu bootstrap -U postgres -d mamonsu --host 127.0.0.1 --password=****

[ERROR] 2016-11-29 15:39:54,642 - PGLOCKS       -       catch error: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')
[INFO] 2016-11-29 15:39:54,642 - PGLOCKS        -       hint: enable debug level to full exception trace
[DEBUG] 2016-11-29 15:39:54,642 - PGLOCKS       -       Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/mamonsu/lib/plugin.py", line 140, in _loop
    self.run(self.sender)
  File "/usr/lib/python2.7/dist-packages/mamonsu/plugins/pgsql/pg_locks.py", line 41, in run
    """)
  File "/usr/lib/python2.7/dist-packages/mamonsu/plugins/pgsql/driver/pool.py", line 60, in query
    return self._connections[db].query(query)
  File "/usr/lib/python2.7/dist-packages/mamonsu/plugins/pgsql/driver/connection.py", line 63, in query
    raise ProgrammingError(error_text)
ProgrammingError: (u'FATAL', u'FATAL', u'28P01', u'password authentication failed for user "postgres"', u'auth.c', u'307', u'auth_failed', u'', u'')

Возможно, чего-то не хватает в настройке самого posgresql? Содержимое pg_hba.conf есть выше

[Slavenin]

в общем проблему я локализовал: если вывести данные подключения в /usr/lib/python2.7/dist-packages/mamonsu/plugins/pgsql/driver/connection.py, то, неожиданно, вылезает вот такое:

127.0.0.1 postgres postgres mamonsu

т.е переданные данные были просто проигнорированы! В #63 было что-то похожее

[vadv]

в #63 Password: psql: FATAL: password authentication failed for user "zabbix"
это вообще сообщение от консольной команды psql, а не от mamonsu.

[vadv]

чем связано ваше сломавшаяся авторизация - не понятно. вы ставили сначала что-то через pip?

[Slavenin]

нет, я ставил из deb пакета

> curl -s https://packagecloud.io/install/repositories/postgrespro/mamonsu/script.deb.sh | sudo bash
> sudo apt-get install mamonsu=2.2.8-1

[Slavenin]

дальнейший дебаг привёл в файл https://github.com/postgrespro/mamonsu/blob/master/mamonsu/plugins/pgsql/driver/connection.py
если вывести там информацию

def __init__(self, connection_hash={}):
        print '=========='
        print connection_hash.get('passwd')
        print os.environ.get('PGPASSWORD')
        print '========='

, то можно увидеть следующую картину:

==========
None <- правильно
mypass <- правильно
=========
==========
mamonsu <- текущий юзер из параметра -U
mypass <- правильно
=========
==========
mamonsu <- текущий юзер из параметра -U
mypass <- правильно
=========

т.е пароль где-то теряется!
есть подозрение, что проблема в https://github.com/postgrespro/mamonsu/blob/master/mamonsu/lib/default_config.py#L16 default_pgpassword, но может и нет

[Slavenin]

в общем подправил файлик https://github.com/postgrespro/mamonsu/blob/master/mamonsu/plugins/pgsql/driver/connection.py , чтобы пароль всегда брался из env, что не правильно, но помогло.
Теперь в логах другая ошибка.
[ERROR] 2016-11-30 10:55:02,775 - ZBX-127.0.0.1:10050 - On request:

{
   "data":[
      {
         "host":"postgre_graph",
         "value":"2",
         "key":"pgsql.wal.count[]",
         "clock":1480503301
      },
      {
         "host":"postgre_graph",
         "value":"739.278688525",
         "key":"pgsql.wal.write[]",
         "clock":1480503301
      },
      {
         "host":"postgre_graph",
         "value":"688128",
         "key":"pgsql.buffers[dirty]",
         "clock":1480503301
      },
      {
         "host":"postgre_graph",
         "value":"20062208",
         "key":"pgsql.buffers[twice_used]",
         "clock":1480503301
      },
      {
         "host":"postgre_graph",
         "value":"134217728",
         "key":"pgsql.buffers[size]",
         "clock":1480503301
      },
      {
         "host":"postgre_graph",
         "value":"26",
         "key":"pgsql.connections[total]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.connections[idle_in_transaction]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"25.0",
         "key":"pgsql.connections[idle]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"1.0",
         "key":"pgsql.connections[active]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.oldest[query_time]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0",
         "key":"pgsql.oldest[xid_age]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"99",
         "key":"pgsql.cache[hit]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"67194",
         "key":"pgsql.uptime[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.172901153564",
         "key":"pgsql.ping[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.616666666667",
         "key":"pgsql.tuples[updated]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"2081.28333333",
         "key":"pgsql.tuples[returned]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"1.01666666667",
         "key":"pgsql.tuples[inserted]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"776.133333333",
         "key":"pgsql.tuples[fetched]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.tuples[deleted]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.temp[files]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.temp[bytes]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"1.0",
         "key":"pgsql.events[xact_rollback]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.events[deadlocks]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.events[conflicts]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0166666666667",
         "key":"pgsql.blocks[read]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"1240.28333333",
         "key":"pgsql.blocks[hit]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"13.7",
         "key":"pgsql.transactions[total]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0",
         "key":"pgsql.pg_locks[accessexclusive]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"1",
         "key":"pgsql.pg_locks[exclusive]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0",
         "key":"pgsql.pg_locks[sharerowexclusive]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0",
         "key":"pgsql.pg_locks[share]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0",
         "key":"pgsql.pg_locks[shareupdateexclusive]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0",
         "key":"pgsql.pg_locks[rowexclusive]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0",
         "key":"pgsql.pg_locks[rowshare]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"1",
         "key":"pgsql.pg_locks[accessshare]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.bgwriter[buffers_alloc]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.bgwriter[buffers_backend_fsync]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.bgwriter[buffers_backend]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.bgwriter[maxwritten_clean]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.bgwriter[buffers_clean]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"pgsql.bgwriter[buffers_checkpoint]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"{\"data\": [{\"{#MOUNTPOINT}\": \"/\"}, {\"{#MOUNTPOINT}\": \"/mnt\"}]}",
         "key":"system.vfs.discovery[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"99.9995422363",
         "key":"system.vfs.percent_inode_free[/mnt]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"99.8801091353",
         "key":"system.vfs.percent_free[/mnt]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"41954775040",
         "key":"system.vfs.free[/mnt]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"50360320",
         "key":"system.vfs.used[/mnt]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"97.0242069851",
         "key":"system.vfs.percent_inode_free[/]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"77.8760880143",
         "key":"system.vfs.percent_free[/]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"23600726016",
         "key":"system.vfs.free[/]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"6704758784",
         "key":"system.vfs.used[/]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.44",
         "key":"system.la[1]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"{\"data\": [{\"{#NETDEVICE}\": \"eth0\"}]}",
         "key":"system.net.discovery[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.net.tx_drop[eth0]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.net.tx_errs[eth0]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"5195.23333333",
         "key":"system.net.tx_bytes[eth0]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.net.rx_drop[eth0]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.net.rx_errs[eth0]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"3504.93333333",
         "key":"system.net.rx_bytes[eth0]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"2432",
         "key":"system.open_files[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"69562",
         "key":"system.uptime[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"160751616",
         "key":"system.memory[buffers]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"161808384",
         "key":"system.memory[slab]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0",
         "key":"system.memory[vmalloc_used]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"30052352",
         "key":"system.memory[page_tables]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"1697681408",
         "key":"system.memory[committed]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"286720",
         "key":"system.memory[swap]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"354123776",
         "key":"system.memory[inactive]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"722415616",
         "key":"system.memory[active]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"396038144",
         "key":"system.memory[unused]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"323219456",
         "key":"system.memory[apps]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"127467520",
         "key":"system.memory[mapped]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"683335680",
         "key":"system.memory[cached]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"90112",
         "key":"system.memory[swap_cache]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"{\"data\": [{\"{#BLOCKDEVICE}\": \"sda\"}, {\"{#BLOCKDEVICE}\": \"sdb\"}]}",
         "key":"system.disk.discovery[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"17817.6",
         "key":"system.disk.all_write_b[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"750.933333333",
         "key":"system.disk.all_read_b[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"3.0",
         "key":"system.disk.all_write[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.1",
         "key":"system.disk.all_read[]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.disk.utilization[sdb]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.disk.write_b[sdb]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.disk.read_b[sdb]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.disk.write[sdb]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.0",
         "key":"system.disk.read[sdb]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"2.26666666667",
         "key":"system.disk.utilization[sda]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"17817.6",
         "key":"system.disk.write_b[sda]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"750.933333333",
         "key":"system.disk.read_b[sda]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"3.0",
         "key":"system.disk.write[sda]",
         "clock":1480503300
      },
      {
         "host":"postgre_graph",
         "value":"0.1",
         "key":"system.disk.read[sda]",
         "clock":1480503300
      }
   ],
   "request":"sender data",
   "clock":1480503302
}

get response with failed items:
ZBX_NOTSUPPORTEDInvalid item key format.

/etc/mamonsu/agent.conf

[postgres]
enabled = True
user = postgres
password = mf@aFDm234rj5kv*29sha
database = mamonsu
host = 127.0.0.1
port = 5432
application_name = mamonsu
query_timeout = 10

[system]
enabled = True

[sender]
queue = 300

[agent]
enabled = True
host = 127.0.0.1
port = 10052

[plugins]
enabled = False
directory = /etc/mamonsu/plugins

[zabbix]
enabled = True
#client = postgreDb
client = postgre_graph
address = 127.0.0.1
port = 10050

Что-то не так с моей конфигурацией?

[vadv]

@Slavenin спасибо огромное, проблему нашли: https://github.com/postgrespro/mamonsu/blob/2.2.8/mamonsu/plugins/pgsql/driver/connection.py#L32 !
ее поправит @gsmol и выпустит 2.2.9, ждите.