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
