troubles connecting to PostgreSQL...

Quevas

This is the error:
Warning: Unable to connect to PostgreSQL server: fe_sendauth: authentication type 5 not supported in /home/test.php on line 26

This is my connection string:

$db=pg_connect("host=192.168.10.104 port=5432 dbname=test user=username password=mypassword");

If I use "trust" in pg_hba.conf there're no problems, but using "md5" the browser shows this error.

I guess is a pg_hba.conf configuration problem...any ideas?
Thanks. 🙂

Quevas

....mhhhh, do I use ODBC to connect?

edit:
No I don't, PostgreSQL not support ODBC...just read from online documentation.

ultraslacker

More details please. Post pg_hba.conf

Are you running on a win32 platform?

Quevas

Thanks for replay...

My pg_hba.conf is:

TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGOMENT

local all trust
host test 127.0.0.1 255.255.255.255 md5
admin test 192.168.10.102 255.255.255.255 trust
host test 192.168.10.102 255.255.255.255 md5
host test 192.168.10.104 255.255.255.0 trust

...and I'm running under Linux Red Hat 7.2.
The database is on 192.168.10.104 and I'm trying to connect from 192.168.10.102.

ultraslacker

I do not recognize the type of 'admin'. I suggest removing that line.

The error suggests that encryption is not supported - either in the environment or by the application.

Quevas

Ok, I supposed was something like that...

Anyway, to avoid issues, I'll use jsp to connect to the database.

Thanks 🙂

Sxooter

First point, Postgresql DOES support ODBC. Just use the --enable-odbc switch when building it.

Second point, PHP doesn't support md5 password authentication in postgresql yet. I think you could set the type of connection from trust or md5 to password and set the passwords as plaintext in the database and you'd be ok.