View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000123 | Pgpool-II | Bug | public | 2014-12-02 06:48 | 2018-07-06 13:38 |
| Reporter | ravazzolo | Assigned To | t-ishii | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| Platform | Linux | OS | Debian | OS Version | Debian 3.2.63-2 |
| Summary | 0000123: MD5 authentication is not requiring password. | ||||
| Description | MD5 authentication is not requiring password. It checks the user in pool_password file, but accepts null passwords and wrong passwords. Environment: Two servers PostgreSQL 9.1 and pgpool-II 3.4.0, running as MASTER/SLAVE mode and streaming replication. See configuration files attached. It was tested with pgpool-II 3.2.5 and 3.3.3, same problem occurs. I've been reviewing the configuration files and seems to be all right. I don't know if I'm missing something. Thanks! Ricardo Ravazzolo | ||||
| Steps To Reproduce | Create a user/password in PostgreSQL. Update pool_passwd file using pg_md5 and specifying the same user/password created in PostgreSQL. Add entries in pool_hba.conf and pg_hba.conf of md5 type. Reload PostgreSQL and pgpool. Try to connect using pgpool port, informing user without password. It works for me. | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Which IP is pgpool running on? It should match with the one specified in pg_hba.conf. |
|
|
Sorry, I'm using two servers, both running PostgreSQL and Pgpool. Pgpool is running in the same servers of PostgreSQL, IPs 10.10.1.35 and 10.10.1.36. HBA files are equal in both servers. |
|
|
Followings in pg_hba.conf allow pgpool to access PostgreSQL without password. host all all 10.10.1.35/32 trust host all all 10.10.1.36/32 trust |
|
|
Problem solved, pg_hba.conf was changed on both servers with the following entries for pgpool: host all all 10.10.1.35/32 md5 host all all 10.10.1.36/32 md5 Sorry about spending your time, I'm new with Pgpool and PostgreSQL. Thanks for agility in responding! Ricardo Ravazzolo |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2014-12-02 06:48 | ravazzolo | New Issue | |
| 2014-12-02 06:48 | ravazzolo | File Added: pgpool.zip | |
| 2014-12-02 08:13 | t-ishii | Assigned To | => t-ishii |
| 2014-12-02 08:13 | t-ishii | Status | new => feedback |
| 2014-12-02 08:13 | t-ishii | Steps to Reproduce Updated | |
| 2014-12-02 08:19 | t-ishii | Note Added: 0000498 | |
| 2014-12-02 23:46 | ravazzolo | Note Added: 0000500 | |
| 2014-12-02 23:46 | ravazzolo | Status | feedback => assigned |
| 2014-12-03 08:25 | t-ishii | Note Added: 0000501 | |
| 2014-12-08 22:09 | ravazzolo | Note Added: 0000502 | |
| 2018-07-06 13:38 | t-ishii | Status | assigned => resolved |
