Hi Scott,
Thanks very much for your response. Please see my responses below.
On Mar 5, 2004, at 1:47 PM, scott.marlowe wrote:
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?
I don't know. There's an auth.php file, which would lead me to conclude
the latter.
do you mean apache / web site authentication, or pgsql authentication
is
failing?
My feeling is that either the site is not "seeing" the database, or,
more likely, the database itself is not properly set up.
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.
I took this suggestion -- login still fails.
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.
After following the above suggestion, the URL based on the above
returns a comprehensive PHP configuration info page.
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.
The site returns only the standard error contained in the auth.php:
"We're sorry but that is incorrect. Please try again."
Thanks again for your help.
--
Danny O'Brien
