BUG #17933: pgAgent - password doesn't work

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: meedhos(at)gmail(dot)com
Subject: BUG #17933: pgAgent - password doesn't work
Date: 2023-05-15 12:33:13
Message-ID: 17933-bda691ab4157ed56@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 17933
Logged by: Luiz Carlos G. P. C. Branco
Email address: meedhos(at)gmail(dot)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.

Browse pgsql-bugs by date

  From Date Subject
Next Message Jeff Davis 2023-05-15 22:04:21 Re: Possible to create a hidden collation
Previous Message Karina Litskevich 2023-05-15 12:05:45 Re: BUG #17731: Server doesn't start after abnormal shutdown while creating unlogged tables