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
> 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
> local all trust
> host all 127.0.0.1 255.0.0.0 ident
> 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
$ 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.
In response to
pgsql-php by date
|Next:||From: Andrew McMillan||Date: 2004-03-07 19:59:45|
|Subject: Re: Please help: PHP4/postgres db woes|
|Previous:||From: Danny O'Brien||Date: 2004-03-05 18:18:47|
|Subject: Please help: PHP4/postgres db woes|