Welcome! Log In Create A New Profile

Advanced

Postgres Connector - Client layer DLLs

Posted by Gus 
Gus
Postgres Connector - Client layer DLLs
May 23, 2021 07:44PM
Hello:
I'm trying to make work WebDev with PostgreSQL v,13 and after installing the Windev Native PostgreSQL connector, I"m running tests but I can't make it work....

Documentation is not very complete IMO, as it says that Postgres Client Layer DLLs should be copies into both the WenDev setup directory (root or programs/Framework/Win64_x86 where the native dll resides?) and the executable directory of the application... It also mentions Visual Runtime, etc.

My question is what DLLs need to be copied? It mentions libpq.dll and its dependencies...but what other DLLs exactly?

Did someone made this work? It would be good if a more detailed directions are provided to follow. I would appreciate it..

Thanks
Gus
Update:

I was able to connect to the DB copying the client DLLs to the EXE directory but I'm now getting this error:

"authentication method 10 not supported"

Any idea?

Thanks
Gus
Re: Postgres Connector - Client layer DLLs
May 25, 2021 06:25PM
These are my notes on the subject:
Authentication method not supported (Received: 10)
[stackoverflow.com]

in C:\Program Files\PostgreSQL\13\data\pg_hba.conf

changed Method from MD5 to trust -- makes it wide open for any user with any password, so not viable

Fix #1:
1. change encryption method to md5 in C:\Program Files\PostgreSQL\13\data\postgresql.conf
password_encryption = md5 # md5 or scram-sha-256

2. and be sure md5 is set in C:\Program Files\PostgreSQL\13\data\pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all scram-sha-256
# IPv4 local connections:
#host all all 127.0.0.1/32 scram-sha-256
#allows incoming from anywhere ipv4
host all all 0.0.0.0/0 md5
#ljw 2011/07/02 added begin**********************************************
# IPv6 local connections:
#host all all ::1/128 scram-sha-256
#ljw 2011/07/02 added begin**********************************************

#allows incoming from anywhere ipv6
host all all ::/0 md5

#ljw 2011/07/02 added end************************************************
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all scram-sha-256
host replication all 127.0.0.1/32 scram-sha-256
host replication all ::1/128 scram-sha-256

3. Then in pgadmin4 change the password so it is reencrypted using md5
good writeup:
[forum.pcsoft.fr]
Gus
Re: Postgres Connector - Client layer DLLs
June 02, 2021 04:42PM
Hello ljwilson:

Thank you for the notes!

I appreciate it.

Gus
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: