pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: bruce <bedouglas@earthlink.net>
To: 'David Costa' <geeks@dotgeek.org>
To: 'Danny O'Brien' <dannyo@steinrogan.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Please help: PHP4/postgres db woes
Date: Tue, 9 Mar 2004 08:18:25 -0800
Message-ID: <01dc01c405f2$26eb5d00$0301a8c0@Mesa.com> (raw)
In-Reply-To: <0A26E2F5-71E3-11D8-ABD1-000A95EB456A@dotgeek.org>

good suggestion.. however, i would argue that danny should make sure he can
do a manual command, and that he can determine that he can actually manually
get the "php" sql command to work from the manual command line...

once he gets this, then the rest becomes fairly straight forward...

-bruce



-----Original Message-----
From: pgsql-php-owner@postgresql.org
[mailto:pgsql-php-owner@postgresql.org]On Behalf Of David Costa
Sent: Tuesday, March 09, 2004 8:02 AM
To: Danny O'Brien
Cc: pgsql-php@postgresql.org
Subject: Re: [PHP] 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




---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend




view thread (12+ messages)  latest in thread

Message-ID: <01dc01c405f2$26eb5d00$0301a8c0@Mesa.com>
Permalink:  ../01dc01c405f2$26eb5d00$0301a8c0@Mesa.com/
Also on:    postgresql.org/message-id/01dc01c405f2$26eb5d00$0301a8c0@Mesa.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: bedouglas@earthlink.net, geeks@dotgeek.org, dannyo@steinrogan.com
  Subject: Re: Please help: PHP4/postgres db woes
  In-Reply-To: <01dc01c405f2$26eb5d00$0301a8c0@Mesa.com>
  References: <0A26E2F5-71E3-11D8-ABD1-000A95EB456A@dotgeek.org> <01dc01c405f2$26eb5d00$0301a8c0@Mesa.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox