[solved] error DB connection after upgrade debian 11 to 12 and ispconfig

hello ,

i've just upgraded a system from 11 to 12 ( as other 10 ) but just one , the master drove me mad .

the log continues to report error on authentication on DB , i've tested all credentials via php scripts , mysql cli etc everything worked , but just cron script not .

After hours of debug i've found this line in app.inc.php that causes errors on DB connection
line 85
if($conf['dbmaster_host'] != '' && ($conf['dbmaster_host'] != $conf['db_host'] || ($conf['dbmaster_host'] == $conf['db_host'] && ($conf['dbmaster_database'] != $conf['db_database'] || $conf['dbmaster_port'] != $conf['db_port'])))) {

i've replaced with the orignal from 3.11.p2 and the cron scripts ( cron.sh and server.sh ) restart working .

debian 12
mariadb 10.11.6
php 8.2.20
multiserver setup

hope this help debug

 

@till yes that was the problem , let me explain during the historic installation I've leaved port field empty ( for as default configuration ) , but as you said after valorised the field and fallback to original app.inc.php the scritps restart working .
thanks for explaination

 

Thanks this was also my problem after update some servers that have been running for years and updated to debian 12, and today updated to ispconfig 3.2.12.

changing
From:
$conf['dbmaster_port'] = '';
To:

Code:

$conf['dbmaster_port']            = '3306';

 

only the dbmaster as emty, this is from my backup on my master node (multi server):

Code:

//** Database
$conf['db_type'] = 'mysql';
$conf['db_host'] = 'localhost';
$conf['db_port'] = '3306';
$conf['db_database'] = 'dbispconfig';
$conf['db_user'] = 'ispconfig';
$conf['db_password'] = '***';
$conf['db_charset'] = 'utf8'; // same charset as html-charset - (HTML --> MYSQL: "utf-8" --> "utf8", "iso-8859-1" --> "latin1")
$conf['db_new_link'] = false;
$conf['db_client_flags'] = 0;

define('DB_TYPE',$conf['db_type']);
define('DB_HOST',$conf['db_host']);
define('DB_PORT',$conf['db_port']);
define('DB_DATABASE',$conf['db_database']);
define('DB_USER',$conf['db_user']);
define('DB_PASSWORD',$conf['db_password']);
define('DB_CHARSET',$conf['db_charset']);


//** Database settings for the master DB. This setting is only used in multiserver setups
$conf['dbmaster_type']                  = 'mysql';
$conf['dbmaster_host']                  = 'localhost';
$conf['dbmaster_port']                  = '';
$conf['dbmaster_database']              = 'dbispconfig';
$conf['dbmaster_user']                  = '';
$conf['dbmaster_password']              = '***';
$conf['dbmaster_new_link']              = false;
$conf['dbmaster_client_flags']  = 0;