View Issue Details

IDProjectCategoryView StatusLast Update
0000737Pgpool-IIBugpublic2022-02-05 17:06
Reporterbarry.cao@softtek.com Assigned Tot-ishii  
PriorityimmediateSeveritymajorReproducibilityalways
Status closedResolutionopen 
Summary0000737: failed to authenticate
Description2021-11-03 05:52:15: pid 1: ERROR: failed to authenticate
2021-11-03 05:52:15: pid 1: DETAIL: Invalid Username specified. Please check the Username and retry connection. The Username should be in <username@hostname> format.
2021-11-03 05:52:15: pid 1: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 0
2021-11-03 05:52:15: pid 1: ERROR: failed to authenticate
2021-11-03 05:52:15: pid 1: DETAIL: Invalid Username specified. Please check the Username and retry connection. The Username should be in <username@hostname> format.
2021-11-03 05:52:15: pid 1: LOG: find_primary_node: make_persistent_db_connection_noerror failed on node 1
Steps To ReproduceAn error is reported when pgpool is connected to azure postgre master-slave cluster startup. pool_password is as follows:
azure_pg_postgres@odoo-master:md5ac9979bf50400e6eb7aabad486379f1b

Configured username@hostname User name in the format of, but pgpool doesn't seem to recognize it@

Try to use %40 instead of @, but this error is also reported

how can i do?
TagsNo tags attached.

Activities

t-ishii

2021-11-05 17:47

developer   ~0003952

I think this is a similar issue to :https://www.pgpool.net/mantisbt/view.php?id=699
The bottom line is, Azure only supports clear text authentication. Please use clear text password instead in pool_passwd.

t-ishii

2021-11-11 17:15

developer   ~0003954

May I close this issue?

t-ishii

2021-12-08 19:46

developer   ~0003964

No feedback from the report almost 1 month. I am going to close this.

Issue History

Date Modified Username Field Change
2021-11-04 10:24 barry.cao@softtek.com New Issue
2021-11-05 17:47 t-ishii Note Added: 0003952
2021-11-05 17:47 t-ishii Assigned To => t-ishii
2021-11-05 17:47 t-ishii Status new => feedback
2021-11-11 17:15 t-ishii Note Added: 0003954
2021-12-08 19:46 t-ishii Note Added: 0003964
2022-02-05 17:06 t-ishii Status feedback => closed