View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000786 | Pgpool-II | Enhancement | public | 2023-02-21 07:12 | 2023-03-09 20:03 |
| Reporter | Cidy Long | Assigned To | t-ishii | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Platform | Linux | OS | Centos Stream | OS Version | 9 |
| Product Version | 4.4.1 | ||||
| Summary | 0000786: ERROR: pid xxxx: AES encryption is not supported by this build | ||||
| Description | Installed pgpool-II 4.4.2 from source compile with PostgreSQL 15.2 (compile and install from source as well) support. Following pgpool-II document (https://www.pgpool.net/docs/44/en/html/example-cluster.html) to configure pgpool-II. when went to [8.2.6.9. Client Authentication Configuration] run [pg_enc -m -k ~/.pgpoolkey -u pgpool -p] Response as: [ [postgres@centos9gateway ~]$ pg_enc -m -k ~/.pgpoolkey -u pgpool -p db password: trying to read key from file /usr/local/pgsql/.pgpoolkey ERROR: pid 7462: AES encryption is not supported by this build ] | ||||
| Steps To Reproduce | Installed pgpool-II 4.4.2 from source compile with PostgreSQL 15.2 (compile and install from source as well) support. Following pgpool-II document (https://www.pgpool.net/docs/44/en/html/example-cluster.html) to configure pgpool-II. when went to [8.2.6.9. Client Authentication Configuration] run [pg_enc -m -k ~/.pgpoolkey -u pgpool -p] Response as: [ [postgres@centos9gateway ~]$ pg_enc -m -k ~/.pgpoolkey -u pgpool -p db password: trying to read key from file /usr/local/pgsql/.pgpoolkey ERROR: pid 7462: AES encryption is not supported by this build ] | ||||
| Additional Information | in my understanding. command pg_enc will read pgpoolkey from ~./pgpoolkey and accept keyboard input password for user pgpool then use pre-defined AES algorithm to generate encrypted password. | ||||
| Tags | No tags attached. | ||||
|
|
Have you built Pgpool-II with "--with-openssl"? The AES encryption feature needs OpenSSL support. |
|
|
Thank you for your advice. I will try it later. BTW, does --with-memcached=path necessary? and how? |
|
|
If you don't have a plan to use memcached, you don't need to specify it. If you do plan, the path should point to the install directory of libmemcached. In my case (Ubuntu 20), it's "/usr". i.e. --with-memcached=/usr |
|
|
Thank you! |
|
|
May I close this issue? |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-02-21 07:12 | Cidy Long | New Issue | |
| 2023-02-21 07:29 | t-ishii | Note Added: 0004279 | |
| 2023-02-21 07:59 | t-ishii | Assigned To | => t-ishii |
| 2023-02-21 07:59 | t-ishii | Status | new => feedback |
| 2023-02-21 10:23 | Cidy Long | Note Added: 0004280 | |
| 2023-02-21 10:23 | Cidy Long | Status | feedback => assigned |
| 2023-02-21 10:31 | t-ishii | Note Added: 0004281 | |
| 2023-02-21 10:50 | Cidy Long | Note Added: 0004282 | |
| 2023-03-09 20:03 | t-ishii | Note Added: 0004303 | |
| 2023-03-09 20:03 | t-ishii | Status | assigned => feedback |
