[Phplib-users] showoff.php3 problems(using postgres)

[Brett D. <br...@cl...>]

I just installed both the latest PHP and phplib(7.2d) versions.  I'm 
using a very recent version of PostgreSQL.

I FINALLY managed to get it all to work, or so I thought.

The index file was working great, jumping up by 1 every reload; the 
session data showed up in the table, etc.

So I try showoff.php3.

I enter the user/pass "kris"/"test"...and get...absolutely nothing.

I just get returned right back to the login page, with not even a "no 
such user" message.  The user/password combo exist both in the 
regular and md5 auth sections.

This is what happens when I load index.php3:

[Tue Mar  5 02:09:37 2002] [error] PHP Warning:  Undefined property: 
Port in /var/www/php/db_pgsql.inc on line 45

(it appears to load just fine)

then, when I load showoff:

[Tue Mar  5 02:09:45 2002] [error] PHP Warning:  Undefined property: 
Port in /var/www/php/db_pgsql.inc on line 45
[Tue Mar  5 02:09:45 2002] [error] PHP Warning:  Undefined property: 
in in /var/www/php/auth.inc on line 52
[Tue Mar  5 02:09:45 2002] [error] PHP Warning:  Undefined index: 
uid in /var/www/php/auth.inc on line 235


line #45 of db_pgsql.inc the line about Port/port=

   function connect() {
           if ( 0 == $this->Link_ID ) {
                   $cstr = "dbname=".$this->Database.
                   $this->ifadd($this->Host, "host=").
                   $this->ifadd($this->Port, "port=").
                   $this->ifadd($this->User, "user=").
                   $this->ifadd($this->Password, "password=");
                   $this->Link_ID=pg_pconnect($cstr);
                   if (!$this->Link_ID) {
                           $this->halt("Link-ID == false, pconnect failed");
                   }


Line 52 of auth.inc is the first non-comment line here.  It is pretty 
much the first thing in function start().

     ## This is for performance, I guess but I'm not sure if it could
     ## be safely removed -- negro
     if (! $this->in) {
       $sess->register("auth");
       $this->in = true;
     }



Line #235 of auth.inc is the third line here:

   function is_authenticated() {
     if (
       $this->auth["uid"]
         &&
       (($this->lifetime <= 0) || (time() < $this->auth["exp"]))
     ) {


I was able to eliminate the port errors by adding:
   var $Port     = "5432";

after $host in class DB_Example in local.inc; the errors about line 
52 in auth.inc went away after I uncommented the whole if statement, 
but logins still won't work.

Brett
PS:the install docs on the website list the wrong address info for 
the mailing list.
--