Re: Please help: PHP4/postgres db woes

On Fri, 5 Mar 2004, 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.
>
> 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

If you can upgrade the above to the latest, that would be a good thing.
Especially postgresql. At the very least, upgrade postgresql to 7.2.5 or
whatever the last version of 7.2 was.

> 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.

How are logins handled, via apache authentication, or custom PHP code?

do you mean apache / web site authentication, or pgsql authentication is
failing?

> I've taken the following actions:
...
> 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

You might want to try setting it to just trust on local and host
127.0.0.1/255.0.0.0 for testing to see if that lets you in.

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

If you make a simple page that has this in it:

<?php
phpinfo();
?>

what do you get (look in the apache httpd.conf file for the extensions
php is setup to handle. you may need to edit this and restart apache.

> 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?

If auth.php is not finding the db, what kind of error is it giving.
More details make it easier to troubleshoot your problem.

> 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?

Not a problem. While the function name is deprecate, it is still
supported, at least through php 4.3.4, which I'm running on my
workstation:

$ php -v
PHP 4.3.4 (cli) (built: Dec 4 2003 11:34:30)
Copyright (c) 1997-2003 The PHP Group
Zend Engine v1.3.0, Copyright (c) 1998-2003 Zend Technologies
$ php -q
<?php
pg_exec();
?>
PHP Warning: Wrong parameter count for pg_exec() in - on line 2

Warning: Wrong parameter count for pg_exec() in - on line 2

So it sees it as a valid command.

> All suggestions welcome. Solution guaranteed posted to the list.

Post your error messages.