View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000526 | Pgpool-II | Bug | public | 2019-07-07 17:53 | 2019-07-23 11:29 |
| Reporter | van | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 4.0.2 | ||||
| Summary | 0000526: pgpool authentication | ||||
| Description | Hi, Regarding pgpool authentication Configuration are pgpool.conf enable_pool_hba = on pool_hba.conf host all all all md5 local all all md5 pool_passwd postgres: "someValue" mpspostgres: "someValue" When i tried to connection to pgpool (with password as "someValue") root@ubuntu:~# psql -U mpsroot -p 5432 -h 192.168.1.233 mpsdb Password for user mpsroot: I am successfully able to connection even though password for mpsroot user is not present in pool_passwd file. | ||||
| Tags | No tags attached. | ||||
|
|
If you want to do md5 authentication, you need to set md5 authentication at both of Pgpool-II and backend. See more about Pgpool-II authentication: https://pgpool.net/mediawiki/index.php/FAQ#I_created_pool_hba.conf_and_pool_passwd_to_enable_md5_authentication_through_pgpool-II_but_it_does_not_work._Why.3F https://pgpool.net/mediawiki/index.php/FAQ#How_does_pgpool-II_handle_md5_authentication.3F |
|
|
Hi pengbo, what if we want authentication at back-end (DB) node only , not at pgpool In that case pgpool send a password from pool_passswd file or whatever the password client passes in connection string |
|
|
Hi pengbo, According to doc pg_hba.conf pool_hba.conf pool_passwd result trust md5 no "MD5" authentication with pgpool failed for user "XX" My case is same pool_hba.conf contain md5 pool_passwd doesn't contain password for mpsroot still i am able to successfully login with user mpsroot attaching the conf files |
|
|
> root@ubuntu:~# psql -U mpsroot -p 5432 -h 192.168.1.233 mpsdb Is "5432" port of Pgpool-II or PostgreSQL server? Could you share your pgpool.conf? |
|
|
If you have resovled this issue, may I close this issue? |
|
|
Yes please, thanks for the help |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-07-07 17:53 | van | New Issue | |
| 2019-07-08 14:10 | pengbo | Assigned To | => pengbo |
| 2019-07-08 14:10 | pengbo | Status | new => assigned |
| 2019-07-08 17:00 | pengbo | Note Added: 0002696 | |
| 2019-07-08 17:50 | van | Note Added: 0002697 | |
| 2019-07-08 18:29 | van | File Added: pool_passwd | |
| 2019-07-08 18:29 | van | File Added: pool_hba.conf | |
| 2019-07-08 18:29 | van | File Added: pg_hba.conf | |
| 2019-07-08 18:29 | van | Note Added: 0002698 | |
| 2019-07-10 14:46 | pengbo | Note Added: 0002699 | |
| 2019-07-22 14:16 | pengbo | Note Added: 0002734 | |
| 2019-07-22 16:49 | van | Note Added: 0002736 | |
| 2019-07-23 11:29 | pengbo | Status | assigned => closed |
