Re: Please help: PHP4/postgres db woes

Hello Danny,
I can't go through your whole script but I recommend you use Pear::DB
as an abstraction layer for the pgsql connection and interaction.
This will give you more power with the debug and you can keep
everything simple IMHO.

More info at
http://pear.php.net/manual/en/package.database.php#package.database.db

It is default on PHP, so you don't even need to install anything.

Cheers
Regards,
David Costa, PHP-PostgreSQL Advocacy team     http://postgresql.org
david at postgresql ddoot org                 gurugeek att php dot net
$dsn = 'pgsql://world:most_advanced@localhost/open_source_database';



On Mar 9, 2004, at 4:45 PM, Danny O'Brien wrote:

>>>
>>> packages for Woody that we also use in some situations:
>>>
>>> deb http://people.debian.org/~elphick/debian/ stable main
>>>
>>> It seems most likely to me that your webserver is attempting to
>>> authenticate as www-data using 127.0.0.1 (rather than 'local' - i.e.
>>> no
>>> host spec in pg_connect) and that you are not allowing that in your
>>> pg_hba.conf, but the notes below do not give a lot of information to
>>> work from.
>>>
>>> Perhaps send the auth.php (with usernames / passwords munged), a
>>> "select
>>> * from pg_user" (ditto)
>>>
>>> Cheers,
>>>                     Andrew McMillan
>>
>>
>> Hi Andrew,
>>
>> Thanks for your response. Below is the contents of auth.php, per your
>> suggestion, if you feel like vetting the code. I'm not a PHP
>> programmer.
>> I'm responsible for getting the site
>> running. I've been able to do it before, under RedHat, but no