I am using Scriptcase 9.10.023 (27)
and I am trying to connect to PostgreSQL 16.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 13.2.1_git20240309) 13.2.1 20240309, 64-bit
I get the following error when I test the connection:
Connection attempt failed: SQLSTATE[08006] [7] SCRAM authentication requires libpq version 10 or above
How can I solve this?
Thanks for the help
Scriptcase does not have drivers of it’s own, but relies on your database installation. Thus I suspect that you have issues in your Postgress installation. Scriptcase cannot find libpq.so or you have the wrong version. The SQLState message is a message from your database, not Scriptcase (php).
Thank you for your answer, but sriptcase is the only having problems connecting to the postgresql database. dbBeaver, grafana, php from the command line in several of my servers have connected succesfully without any problem.
Since I am using the V9-php7.3 environment under /opt/NetMake I assume this is some kind of php sandbox, I would like to know if that library is supposed to be installed in the /opt/NetMake/v9-php73/components/instantclient.
Or any other idea to solve the problem.
I found the explanation of the error in Stack overflow:
“Prior to version 10 of postgresql, the password_encryption was MD5 . As of version 10, you can configure either MD5 or scram-sha-256 (recommended). The error is telling you you are trying to connect to a version of postgresql using scram-sha-256 password encryption from a setup that supports only MD5 . (you need a newer version of libpq )”
Scriptcase does not offer a way to choose between MD5 and scram-sha-256. This could be the problem. Any ideas