DelphiXe2 + Postgresql 15

[albleo@gmail.com]

HI there

I am a delphi Xe2 user and in my project I use Zeos 7.2 with postgresql 11. Now I have to use postgresql 15 and I don't know what happened since I get this message in the connection:

SQL Error: authentication method 10 not supported.

I think I'm supposed to use Zeos 8 but I am not sure I've no idea how to update the libs. Can anyone help me?

Thanks in advance.

Leandro Almeida

[marsupilami]

Hello Leandro,

SQL Error: authentication method 10 not supported.

That looks like your libpq cannot authenticate to the new server because it is too old. Do you use a current libpq?

Best regards,

Jan

[albleo@gmail.com]

Hi, Jan

I don't know where I download this libpsql.dll . I can not find it anywhere. Can you help me to find it?

Thanks

Leandro

[albleo@gmail.com]

How about scram-sha-256 authentication method? Does it support?

How can I set it up?

Thanks

[marsupilami]

Hello,

I don't know which methods are supported by youor library and your server. If you use SSL encrypted connections, you can use plain text passwords. Otherwise you might want to try md5.

libpq is usually distributed alongside PostgreSQL. Unfortunately PostgreSQL only distributes a 64-Bit version. If you need a 32-Bit library you might want to try some builds that I have done in the past and distributed on the Zeoslib files section: https://sourceforge.net/projects/zeoslib/files/3rd%20party/libpq/.

I seem to remember that some builds from the PG16 builds had problems. You might need to try other versions too.

Best regards,

Jan

[albleo@gmail.com]

Hello Jam

Let me understand... Have you compiled those dll by yourself? If so I did not know it was possible. Anyway you've saved me and I appreciate that.

Further questions.
Doesn't Zeos Lib work with 64bit pg library?
If I change the compilation of delphi to a 64 bit EXE can I remain the same libs?

Wish you all the best and may God bless you

Leandro