Re: Please help: PHP4/postgres db woes - Mailing list pgsql-php

On Sat, 2004-03-06 at 07:18, Danny O'Brien wrote:
> 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.

We run heaps of PHP based sites on this codebase.  If you want to
upgrade to 7.4.1, Oliver Elphick (the Debian maintainer) has produced
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
>
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053,  Manners St,  Wellington
WEB: http://catalyst.net.nz/             PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201       MOB: +64(21)635-694      OFFICE: +64(4)499-2267
It is truth which you cannot contradict; you can without any difficulty
                      contradict Socrates. - Plato
-------------------------------------------------------------------------