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:



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