From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: meedhos@gmail.com
Subject: BUG #17933: pgAgent - password doesn't work
Date: Mon, 15 May 2023 12:33:13 +0000
Message-ID: <17933-bda691ab4157ed56@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17933
Logged by: Luiz Carlos G. P. C. Branco
Email address: meedhos@gmail.com
PostgreSQL version: 15.2
Operating system: CentOS 9
Description:
I can connect with psql (local connection, network connection, using ldap
accounts, using internal postresql passwords) but pgAgent can't connect
(tryed pgagent as command line with "-l 2" to debug alway give me error, my
pg_hba was:
local all postgres md5
host all postgres 0.0.0.0/0 md5
host all usr_fdw 0.0.0.0/0 md5
host all all 0.0.0.0/0 ldap
ldapserver=<my_dc>
ldapbasedn="<distinguishedname_of_the_OU_whereis_my_users>"
ldapbinddn="<user_to_connect>@<my_domain>" ldapbindpasswd="<my_password>"
ldapsearchfilter="(&(objectClass=user)(sAMAccountName=$username)(memberOf=<distinguishedname_of_my_ldap_group>))"
I tryed (a lot) and discovered that pgAgent ONLY connect if I added in
pg_hba the first line "host all postgres
127.0.0.1/32 trust". For security reasons I totally disagre about
permit connections as postgres without password... So, basicly, the pgAgent
code need some correction about the use of password.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, meedhos@gmail.com
Subject: Re: BUG #17933: pgAgent - password doesn't work
In-Reply-To: <17933-bda691ab4157ed56@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox