pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Danny O'Brien <dannyo@steinrogan.com>
To: pgsql-php@postgresql.org
Subject: Please help: PHP4/postgres db woes
Date: Fri, 5 Mar 2004 13:18:47 -0500
Message-ID: <8B7737C2-6ED1-11D8-98CD-0050E466B453@steinrogan.com> (raw)

Any postgre experts out there? We have a PHP4 site that worked fine 
under a previous RedHat build, but we just can't get it working on this 
Debian build.

Here's what we're running:

Debian 3.0r1 "woody"
Kernel 2.4.18-bf2.4
Apache 1.3.26-0woo
postgres 7.2.1-2wood
php 4.1.2-6wood

We've applied a script sent to us by the original programmers, that 
installed several logins and passwords.
But when we go to login to our PHP site, our login is rejected.

I've taken the following actions:

1) Checked to see that the database (called "ourdb") is in fact 
available by entering "psql ourdb." The database opens up to an "ourdb" 
prompt.

2) Made sure that postgresql is running by outputting ps ax:

   xxx ?        S      0:00 /usr/lib/postgresql/bin/postmaster
   xxx ?        S      0:00 postgres: stats buffer process
   xxx ?        S      0:00 postgres: stats collector process

3) Altered the pg_hba.conf (located in /etc/postgresql) to reflect the 
following, and re-started postgre:

#local        all                                           ident 
sameuser
local        all                                           trust
host         all         127.0.0.1     255.0.0.0           ident 
sameuser
host         all         0.0.0.0       0.0.0.0             reject

4) Made sure that the php4-pgsql module is present  -- I did an 
"apt-get" for this last week

5) Examined the postgres.log for clues -- the log file is empty, 
indicating that no login attempts have been made -- I suppose because 
the auth.php has not found the DB?

6) pg_exec call deprecated under PHP 4.2.0 and replaced with pg_query: 
since we're using php 4.1.2-6wood, it seems that this does not apply to 
our setup. Correct?

All suggestions welcome. Solution guaranteed posted to the list.

- Danny O'Brien




view thread (12+ messages)  latest in thread

Message-ID: <8B7737C2-6ED1-11D8-98CD-0050E466B453@steinrogan.com>
Permalink:  ../8B7737C2-6ED1-11D8-98CD-0050E466B453@steinrogan.com/
Also on:    postgresql.org/message-id/8B7737C2-6ED1-11D8-98CD-0050E466B453@steinrogan.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: dannyo@steinrogan.com
  Subject: Re: Please help: PHP4/postgres db woes
  In-Reply-To: <8B7737C2-6ED1-11D8-98CD-0050E466B453@steinrogan.com>
  References: <8B7737C2-6ED1-11D8-98CD-0050E466B453@steinrogan.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