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.
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 |