Page 1 of 1

php5 and PostgreSQL

Posted: Fri Aug 18, 2006 3:12 pm
by rembrandt
Hello,

I've got a CentOS 3.3 system, PSA 7.5.4 with this installed:

rh-postgresql-libs-7.3.15-2
rh-postgresql-devel-7.3.15-2
rh-postgresql-server-7.3.15-2
rh-postgresql-7.3.15-2

php-pgsql-5.0.4-13.rhel3.art
php-mysql-5.0.4-13.rhel3.art
php-pear-5.0.4-13.rhel3.art
php-imap-5.0.4-13.rhel3.art
php-5.0.4-13.rhel3.art
php-mbstring-5.0.4-13.rhel3.art

However, when my a customer wants to make a connection to PostgreSQL they get this: Fout: SQLError!! Could not login to database! The strangest thing is that from PSA is can connect to PostgreSQL with phpPgAdmin perfectly.

So: 1) should i tell the clientr he's doing something terribly wrong or 2) is there something wrong with php-pgsql-5.0.4? I'm a out of answers ...

Best regards

Posted: Fri Aug 18, 2006 3:48 pm
by scott
if phpPgAdmin works, then that would rule out php

Posted: Fri Aug 18, 2006 3:56 pm
by rembrandt
scott wrote:if phpPgAdmin works, then that would rule out php
Indeed, i thoughed the very same thing. But you know how some people can get and that got me doubting myself a little bit.

A little googling thoughed me that using host="" instead of host="localhost" should (or better: could) do the trick, so that's what i advised just now. Let's see what happens.