Upgrade of ISPCOnfig --- Nothing working

hi

htf_report.txt is attached for review as well. I'm running Ispconfig on port 8091

I have had upgraded the ISPConfig to latest release 3. ( there is no any alert on the ISPConfig interface for a latest update available )

Since then, I have been facing some weird issues like the changes are not updated and the Update ( red Circle ) on top-Right is continuously blinking ( even after 3 days )

I had previously changed the password for root and ispconfig DB users and since then I'm facing this issue.
What I dont remember which files I edited and which I didn't to update the mysql root and ispconfig user's passwords, the only thing I remember is that I changed the password strings where ever I could find the mysql related iformation --

Criticality, this is a production server and I can't afford a re-installation or the drop-down of the server.
Emails are working fine, with Websites, but nothing new is updated -- half-broken?

Code:

/usr/local/ispconfig/server/server.sh

is eternally giving these errors

Code:

Thu Jan 3 14:48:18 PKT 2019 PHP Stack trace:
Thu Jan 3 14:48:18 PKT 2019 PHP   1. {main}() /usr/local/ispconfig/server/cron.php:0
Thu Jan 3 14:48:18 PKT 2019 PHP   2. cronjob->run() /usr/local/ispconfig/server/cron.php:99
Thu Jan 3 14:48:18 PKT 2019 PHP   3. cronjob_backup->onPrepare() /usr/local/ispconfig/server/lib/classes/cronjob.inc.php:84
Thu Jan 3 14:48:18 PKT 2019 PHP   4. cronjob->onPrepare() /usr/local/ispconfig/server/lib/classes/cron.d/500-backup.inc.php:40
Thu Jan 3 14:48:18 PKT 2019 PHP   5. db->queryOneRecord() /usr/local/ispconfig/server/lib/classes/cronjob.inc.php:103
Thu Jan 3 14:48:18 PKT 2019 PHP   6. call_user_func_array:{/usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:282}() /usr/local/ispconfig/server/lib/classes/db_my
sql.inc.php:282
Thu Jan 3 14:48:18 PKT 2019 PHP   7. db->query() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:282
Thu Jan 3 14:48:18 PKT 2019 PHP   8. call_user_func_array:{/usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:263}() /usr/local/ispconfig/server/lib/classes/db_my
sql.inc.php:263
Thu Jan 3 14:48:18 PKT 2019 PHP   9. db->_query() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:263
Thu Jan 3 14:48:18 PKT 2019 PHP  10. mysqli_ping() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:196
Thu Jan 3 14:48:18 PKT 2019 PHP Warning:  mysqli_query() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on lin
e 180
Thu Jan 3 14:48:18 PKT 2019 PHP Stack trace:
Thu Jan 3 14:48:18 PKT 2019 PHP   1. {main}() /usr/local/ispconfig/server/cron.php:0
Thu Jan 3 14:48:18 PKT 2019 PHP   2. cronjob->run() /usr/local/ispconfig/server/cron.php:99
Thu Jan 3 14:48:18 PKT 2019 PHP   3. cronjob_backup->onPrepare() /usr/local/ispconfig/server/lib/classes/cronjob.inc.php:84
Thu Jan 3 14:48:18 PKT 2019 PHP   4. cronjob->onPrepare() /usr/local/ispconfig/server/lib/classes/cron.d/500-backup.inc.php:40
Thu Jan 3 14:48:18 PKT 2019 PHP   5. db->queryOneRecord() /usr/local/ispconfig/server/lib/classes/cronjob.inc.php:103
Thu Jan 3 14:48:18 PKT 2019 PHP   6. call_user_func_array:{/usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:282}() /usr/local/ispconfig/server/lib/classes/db_my
sql.inc.php:282
Thu Jan 3 14:48:18 PKT 2019 PHP   7. db->query() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:282
Thu Jan 3 14:48:18 PKT 2019 PHP   8. call_user_func_array:{/usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:263}() /usr/local/ispconfig/server/lib/classes/db_my
sql.inc.php:263

 

thanks for your response
I have correct mysql root password in /usr/local/ispconfig/server/lib/mysql_clientdb.conf --- OK
in file /usr/local/ispconfig/interface/lib/config.inc.php
the ispconfig user's password is something like a string instead of the password,
can I update the string or change the password from mysql.user table and update the file -- how should I change the password then -- please suggest.

 

I followed all steps mentioned in the your post,
but I'm still getting below given output when I run the cronjob process

Code:

/usr/local/ispconfig/server/server.sh

Code:

PHP Warning:  mysqli_ping() expects parameter 1 to be mysqli, null given in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 196
PHP Stack trace:
PHP   1. {main}() /usr/local/ispconfig/server/server.php:0
PHP   2. db->queryOneRecord() /usr/local/ispconfig/server/server.php:65
PHP   3. call_user_func_array:{/usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:282}() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:282
PHP   4. db->query() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:282
PHP   5. call_user_func_array:{/usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:263}() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:263
PHP   6. db->_query() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:263
PHP   7. mysqli_ping() /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php:196

PHP Warning: mysqli_real_connect(): (28000/1045): Access denied for user 'ispconfig'@'localhost' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 198

this file /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php

does't have any parameters populated -- is it valid?

Code:

class db
{
    /**#@+
     * @access private
     */
    private $_iQueryId;
    private $_iConnId;

    private $dbHost = '';  // hostname of the MySQL server
    private $dbPort = '';  // port of the MySQL server
    private $dbName = '';  // logical database name on that server
    private $dbUser = '';  // database authorized user
    private $dbPass = '';  // user's password
    private $dbCharset = 'utf8';// Database charset
    private $dbNewLink = false; // Return a new linkID when connect is called again
    private $dbClientFlags = 0; // MySQL Client falgs
    /**#@-*/

please suggest

 

I was taking user ispconfig's password as literal hash , which it is a cleartext -- so just copied the password from the old archive or ISPConfig, updated with

Code:

update user set password=PASSWORD("35df293c84d7eerasd36ba1dfwcsd7d912ae4d3171dfa0") where User='ispconfig';

updated the

Code:

/usr/local/ispconfig/server/lib/config.inc.php

then

Code:

cd /tmp
wget http://www.ispconfig.org/downloads/ISPConfig-3.1.13.tar.gz
tar xvfz ISPConfig-3.1.13.tar.gz
cd ispconfig3_install/install
php -q update.php

it worked --- thanks a lot 'till'