View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000592 | Pgpool-II | Bug | public | 2020-03-05 18:38 | 2020-03-06 15:02 |
| Reporter | cyngate | Assigned To | hoshiai | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 4.1.1 | ||||
| Summary | 0000592: postgres 12 clustering using pgpool : unable to use password-less login | ||||
| Description | https://www.pgpool.net/docs/41/en/html/example-cluster.html i try to follow the cluster , when i install postgres 12. postgress user is created and the default home folder will be in "/var/lib/pgsql" so if i ssh-copy-id the public key the authhorized_key will be in "/var/lib/pgsql/.ssh/Authorized_key", when i login it will still prompt password. but if i create a normal user using useradd command ssh-copy-id will create the Authorized_key inside remote /home/remote/.ssh folder then it will not prompt password if i attempt to login. | ||||
| Steps To Reproduce | i try to follow the cluster , when i install postgres 12. postgress user is created and the default home folder will be in "/var/lib/pgsql" so if i ssh-copy-id the public key the authhorized_key will be in "/var/lib/pgsql/.ssh/Authorized_key", when i login it will still prompt password. but if i create a normal user using useradd command ssh-copy-id will create the Authorized_key inside remote /home/remote/.ssh folder then it will not prompt password if i attempt to login. | ||||
| Tags | pgpool-II, watchdog | ||||
|
|
sorry, i further check on superuser and found out that it was due to selinux limiting file permission i follow the solution from below https://superuser.com/questions/266530/ssh-without-password-doesnt-work-with-user-postgres please help to close this issue, sorry for the inconvenience |
|
|
Ok I closed this ticket. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-03-05 18:38 | cyngate | New Issue | |
| 2020-03-05 18:38 | cyngate | Tag Attached: pgpool-II | |
| 2020-03-05 18:38 | cyngate | Tag Attached: watchdog | |
| 2020-03-05 18:57 | cyngate | Note Added: 0003247 | |
| 2020-03-06 15:02 | hoshiai | Assigned To | => hoshiai |
| 2020-03-06 15:02 | hoshiai | Status | new => closed |
| 2020-03-06 15:02 | hoshiai | Resolution | open => fixed |
| 2020-03-06 15:02 | hoshiai | Note Added: 0003251 |
