pg_connect cannot connect to pgsql db
Posted: Tue Nov 12, 2002 11:22 pm
being new to php and pgsql i was hoping somone could help with this:
utilizing the string:
pg_connect("dbname=test1");
i get the error saying that user apache cannot connect to database
changing it to:
pg_connect("dbname=test1 user=user1")
i get the error saying that authentication failed for user user1
but the kicker is that i can su - user1 from root and psql just fine to the databases and do any query.
any advice or ideas on where to go next?
thanx
sean
utilizing the string:
pg_connect("dbname=test1");
i get the error saying that user apache cannot connect to database
changing it to:
pg_connect("dbname=test1 user=user1")
i get the error saying that authentication failed for user user1
but the kicker is that i can su - user1 from root and psql just fine to the databases and do any query.
any advice or ideas on where to go next?
thanx
sean