Admin login failed after upgrading to 3.0.5

Hi,

I upgraded ispconfig to version 3.0.5 and I had some problems. I'm running on Centos 5.
First I had to change /var/www/php-fcgi-scripts/ispconfig/.php-fcgi-starter the exec part to " exec /usr/bin/php-cgi -d magic_quotes_gpc=off

Ok fine I get an admin page again but when I tried to login it rejects my password. Euhm...?

Oke fine I click on Password Lost... I have to fill in a email adres and login. Oke the login is admin but I don't remember the email address. Is there a place in the database where I can look it up? Never filled the e-mail for a account...

What is a way to fix this?

 

Also other user also cannot login with the ispconfig contral panel.

No errors in /var/log/httpd/ log files...

 

/usr/lib/cgi-bin/php

Yes, no problems to login into the database.

 

Similar problem here. After upgrading from 3.0.5 RC to stable the loginpage of ISPC loads very slowly. I can not login anymore.
No problem to login via phpmyadmin, it loads very fast.

 

Oke! I thought my webserver was very busy but indeed also my inlog page loads very slowly.

 

I'm sorry but it is still slow and not working and I can't login with any user on the control panel.

 

Same here.

 

What's your PHP version?

 

PHP 5.2.10 (cli) (built: Nov 13 2009 11:44:05)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2009 Zend Technologies

 

Can you open /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php and replace

PHP:

  // constructor
  public function __construct($prefix = '') {
    global $conf;
    if($prefix != '') $prefix .= '_';
    $this->dbHost = $conf[$prefix.'db_host'];
    $this->dbName = $conf[$prefix.'db_database'];
    $this->dbUser = $conf[$prefix.'db_user'];
    $this->dbPass = $conf[$prefix.'db_password'];
    $this->dbCharset = $conf[$prefix.'db_charset'];
    $this->dbNewLink = $conf[$prefix.'db_new_link'];
    $this->dbClientFlags = $conf[$prefix.'db_client_flags'];
    parent::__construct($conf[$prefix.'db_host'], $conf[$prefix.'db_user'],$conf[$prefix.'db_password'],$conf[$prefix.'db_database']);
    $try = 0;
    while(!is_null($this->connect_error) && $try < 5) {
      if($try > 0) sleep(1);

      $try++;
      $this->updateError('DB::__construct');

      parent::__construct($conf[$prefix.'db_host'], $conf[$prefix.'db_user'],$conf[$prefix.'db_password'],$conf[$prefix.'db_database']);
    }

    if(is_null($this->connect_error)) $this->isConnected = true;
    else return false;

    $this->setCharacterEncoding();
  }

with

PHP:

  // constructor
  public function __construct($prefix = '') {
    global $conf;
    if($prefix != '') $prefix .= '_';
    $this->dbHost = $conf[$prefix.'db_host'];
    $this->dbName = $conf[$prefix.'db_database'];
    $this->dbUser = $conf[$prefix.'db_user'];
    $this->dbPass = $conf[$prefix.'db_password'];
    $this->dbCharset = $conf[$prefix.'db_charset'];
    $this->dbNewLink = $conf[$prefix.'db_new_link'];
    $this->dbClientFlags = $conf[$prefix.'db_client_flags'];
    parent::__construct($conf[$prefix.'db_host'], $conf[$prefix.'db_user'],$conf[$prefix.'db_password'],$conf[$prefix.'db_database']);
    $try = 0;
    //while(!is_null($this->connect_error) && $try < 5) {
    while(mysqli_connect_error() && $try < 5) {
      if($try > 0) sleep(1);
      
      $try++;
      $this->updateError('DB::__construct');
      
      parent::__construct($conf[$prefix.'db_host'], $conf[$prefix.'db_user'],$conf[$prefix.'db_password'],$conf[$prefix.'db_database']);
    }
    
    //if(is_null($this->connect_error)) $this->isConnected = true;
    //else return false;
    if(!mysqli_connect_error()) $this->isConnected = true;
    else return false;
    
    $this->setCharacterEncoding();
  }

as well as

PHP:

  // error handler
  public function updateError($location) {
    global $app;

    if(!is_null($this->connect_error)) {
      $this->errorNumber = $this->connect_errno;
      $this->errorMessage = $this->connect_error;
    } else {
      $this->errorNumber = $this->errno;
      $this->errorMessage = $this->error;
    }

    $this->errorLocation = $location;
    if($this->errorNumber) {
      $error_msg = $this->errorLocation .' '. $this->errorMessage;
      // This right here will allow us to use the samefile for server & interface
      if($this->show_error_messages) {
        echo $error_msg;
      } else if(is_object($app) && method_exists($app, 'log')) {
        $app->log($error_msg, LOGLEVEL_WARN);
      }
    }
  }

with

PHP:

  // error handler
  public function updateError($location) {
    global $app;

    /*
    if(!is_null($this->connect_error)) {
      $this->errorNumber = $this->connect_errno;
      $this->errorMessage = $this->connect_error;
    } else {
      $this->errorNumber = $this->errno;
      $this->errorMessage = $this->error;
    }
    */
    if(mysqli_connect_error()) {
      $this->errorNumber = mysqli_connect_errno();
      $this->errorMessage = mysqli_connect_error();
    } else {
      $this->errorNumber = mysqli_errno($this);
      $this->errorMessage = mysqli_error($this);
    }


    $this->errorLocation = $location;
    if($this->errorNumber) {
      $error_msg = $this->errorLocation .' '. $this->errorMessage;
      // This right here will allow us to use the samefile for server & interface
      if($this->show_error_messages) {
    echo $error_msg;
      } else if(is_object($app) && method_exists($app, 'log')) {
    $app->log($error_msg, LOGLEVEL_WARN);
      }
    }
  }

? Does it work then?

 

Yes, for me it works again.

Why was this the issue?

 

PHP 5.2 is too old for $this->connect_error (see http://www.php.net/manual/en/mysqli.construct.php ).

 

Ok. So I guess this is something to check before this version is applied or adjust the code so it can handle also PHP 5.2.

 

Ok cool! Nice job! And thanks for your help! Both of you!

 

Yes, this solves the problem on my server, running CentOs 5.9

 

What is your PHP version?