postgresql passwordcheck.so: undefined symbol : plain_crypt_verify

Question

i'm tring to add shared_preload_libraries='$libdir/passwordcheck' on postgresql.conf. the version is 9.2.13 and there's no passwordcheck module in this version. so i brought passwordcheck.so from 12 version to 9.2.13 verion in $libdir but when i try to restart server, there's a message below like this. could not load library "/usr/lib64/pgsql/passwordcheck.so": undefined symbol : plain_crypt_verify

how should i solve it? and when i checked by using "ldd passwordcheck.so" it was successful

also, i would like to compile againg after i get extensions from new verison. but the postgresql installed in server, it's not installed by source. it's installd by using command "sudo apt-get install postgresql" so i cannot recompile

$ ./pg_ctl -D /home/postgres/pgsql/data start
server starting
$ FATAL:  could not load library "/home/postgres/pgsq/lib/passwordcheck.so": /home/postgres/pgsq/lib/passwordcheck.so: undefined symbol: plain_crypt_verify

Laurenz Albe · Accepted Answer · 2023-11-02 07:09:15Z

0

You cannot use a PostgreSQL library with a different major version than what it was built for. You'd have to build the library for PostgreSQL 9.2.

But my advice is not to touch that software, except to update to 9.2.24 and to upgrade to a supported PostgreSQL release.

Note that the passwordcheck extension cannot be used to enforce password complexity rules, since the client can hash the password before sending it to the server.

answered Nov 2, 2023 at 7:09

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

are123 Over a year ago

thanks for help, i actually solved the problem. my postgresql was installled by ubuntu distribution and installed in offline environment. so i brought 9.2.13 source distiribution, and did configure & make. then, move to the contrib & passwordcheck folder and did make & make install. then i got passwordcheck.so file. and i move the file that i made to the $libdir of current postgresql and restarted server. and it successfully worked.

Collectives™ on Stack Overflow

postgresql passwordcheck.so: undefined symbol : plain_crypt_verify

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related