[solved] Failed upgrade - mysqli access denied

Discussion in 'Installation/Configuration' started by bandit, Sep 7, 2023.

  1. bandit

    bandit New Member

    Hi, i dont know if this ever mention before.
    i never get this error on every update & upgrade. i can login manually with the same user and password to mysql (no change).

    This is multiserver setup and the error below from the server that hold the GUI. Everything is normal except for updating ispconfig.

    The Error:

    Code:
    >> Update
    Operating System: Ubuntu 22.04.3 LTS (Jammy Jellyfish)
    This application will update ISPConfig 3 on your server.
    
    Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]:
    
    Creating backup of "/usr/local/ispconfig" directory...
    Creating backup of "/etc" directory...
    Creating backup of "/etc/letsencrypt" directory...
    Checking MariaDB version 10.6.12 .. OK
    PHP Warning:  mysqli_connect(): (HY000/1045): Access denied for user ''@'localhost' (using password: YES) in /tmp/update_runner.sh.zXCCadrmYZ/install/lib/mysql.lib.php on line 112
    PHP Fatal error:  Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, bool given in /tmp/update_runner.sh.zXCCadrmYZ/install/lib/mysql.lib.php:113
    Stack trace:
    #0 /tmp/update_runner.sh.zXCCadrmYZ/install/lib/mysql.lib.php(113): mysqli_query()
    #1 /tmp/update_runner.sh.zXCCadrmYZ/install/update.php(287): db->setDBName()
    #2 {main}
      thrown in /tmp/update_runner.sh.zXCCadrmYZ/install/lib/mysql.lib.php on line 113
    
    Test Script Result

    Code:
    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] OS version is Ubuntu 22.04.3 LTS
     
    [INFO] uptime:  14:20:29 up  5:58,  2 users,  load average: 0.08, 0.05, 0.01
     
    [INFO] memory:
                   total        used        free      shared  buff/cache   available
    Mem:            15Gi       1.9Gi        12Gi        70Mi       1.5Gi        13Gi
    Swap:          4.0Gi          0B       4.0Gi
     
    [INFO] systemd failed services status:
      UNIT                                 LOAD   ACTIVE SUB    DESCRIPTION
    ● snap.lxd.activate.service            loaded failed failed Service for snap application lxd.activate
    ● systemd-networkd-wait-online.service loaded failed failed Wait for Network to be Configured
    
    LOAD   = Reflects whether the unit definition was properly loaded.
    ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
    SUB    = The low-level unit activation state, values depend on unit type.
    2 loaded units listed.
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.2.10p1
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 8.1.2-1ubuntu2.14
    [INFO] php-cgi (used for cgi php in default vhost!) is version 8.1.2
    
    ##### PORT CHECK #####
    
    [WARN] Port 143 (IMAP server) seems NOT to be listening
    [WARN] Port 993 (IMAP server SSL) seems NOT to be listening
    [WARN] Port 110 (POP3 server) seems NOT to be listening
    [WARN] Port 995 (POP3 server SSL) seems NOT to be listening
    [WARN] Port 465 (SMTP server SSL) seems NOT to be listening
    
    ##### MAIL SERVER CHECK #####
    
    [WARN] I found no "submission" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer port 587 for smtp connections you have to enable this.
    [WARN] I found no "smtps" entry in your postfix master.cf
    [INFO] this is not critical, but if you want to offer SSL for smtp (not TLS) connections you have to enable this.
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
        Apache 2 (PID 1326)
    [INFO] I found the following mail server(s):
        Postfix (PID 2096)
    [WARN] I could not determine which pop3 server is running.
    [WARN] I could not determine which imap server is running.
    [INFO] I found the following ftp server(s):
        PureFTP (PID 1668)
    
    ##### LISTENING PORTS #####
    (only        ()
    Local        (Address)
    ***.***.***.***:53        (930/systemd-resolve)
    [anywhere]:111        (1/init)
    [anywhere]:21        (1668/pure-ftpd)
    [anywhere]:22        (1018/sshd:)
    [anywhere]:2022        (1018/sshd:)
    [anywhere]:50679        (957/rpc.mountd)
    [anywhere]:33945        (-)
    [localhost]:6379        (978/redis-server)
    [anywhere]:2049        (-)
    [anywhere]:44515        (957/rpc.mountd)
    [anywhere]:3306        (1106/mariadbd)
    [anywhere]:45931        (957/rpc.mountd)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [localhost]:953        (1026/named)
    [anywhere]:45435        (1128/rpc.statd)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    ***.***.***.***:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:53        (1026/named)
    [localhost]:25        (2096/master)
    [localhost]:11211        (950/memcached)
    *:*:*:*::*:6379        (978/redis-server)
    *:*:*:*::*:443        (1326/apache2)
    [localhost]11        (1/init)
    *:*:*:*::*:80        (1326/apache2)
    *:*:*:*::*:21        (1668/pure-ftpd)
    *:*:*:*::*:22        (1018/sshd:)
    *:*:*:*::*:2022        (1018/sshd:)
    *:*:*:*::*:34297        (-)
    *:*:*:*::*:43315        (1128/rpc.statd)
    *:*:*:*::*:2049        (-)
    *:*:*:*::*:3306        (1106/mariadbd)
    *:*:*:*::*:53771        (957/rpc.mountd)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*92b1:1cff:fe2e:53        (1026/named)
    *:*:*:*::*:55129        (957/rpc.mountd)
    *:*:*:*::*:38229        (957/rpc.mountd)
    *:*:*:*::*:25        (2096/master)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:53        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:953        (1026/named)
    *:*:*:*::*:8080        (1326/apache2)
    *:*:*:*::*:8081        (1326/apache2)
    
    ##### IPTABLES #####
    Chain INPUT (policy DROP)
    target     prot opt source               destination       
    ufw-before-logging-input  all  --  [anywhere]/0            [anywhere]/0         
    ufw-before-input  all  --  [anywhere]/0            [anywhere]/0         
    ufw-after-input  all  --  [anywhere]/0            [anywhere]/0         
    ufw-after-logging-input  all  --  [anywhere]/0            [anywhere]/0         
    ufw-reject-input  all  --  [anywhere]/0            [anywhere]/0         
    ufw-track-input  all  --  [anywhere]/0            [anywhere]/0         
    
    Chain FORWARD (policy DROP)
    target     prot opt source               destination       
    ufw-before-logging-forward  all  --  [anywhere]/0            [anywhere]/0         
    ufw-before-forward  all  --  [anywhere]/0            [anywhere]/0         
    ufw-after-forward  all  --  [anywhere]/0            [anywhere]/0         
    ufw-after-logging-forward  all  --  [anywhere]/0            [anywhere]/0         
    ufw-reject-forward  all  --  [anywhere]/0            [anywhere]/0         
    ufw-track-forward  all  --  [anywhere]/0            [anywhere]/0         
    
    Chain OUTPUT (policy ACCEPT)
    target     prot opt source               destination       
    ufw-before-logging-output  all  --  [anywhere]/0            [anywhere]/0         
    ufw-before-output  all  --  [anywhere]/0            [anywhere]/0         
    ufw-after-output  all  --  [anywhere]/0            [anywhere]/0         
    ufw-after-logging-output  all  --  [anywhere]/0            [anywhere]/0         
    ufw-reject-output  all  --  [anywhere]/0            [anywhere]/0         
    ufw-track-output  all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-after-forward (1 references)
    target     prot opt source               destination       
    
    Chain ufw-after-input (1 references)
    target     prot opt source               destination       
    ufw-skip-to-policy-input  udp  --  [anywhere]/0            [anywhere]/0            udp dpt:137
    ufw-skip-to-policy-input  udp  --  [anywhere]/0            [anywhere]/0            udp dpt:138
    ufw-skip-to-policy-input  tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:139
    ufw-skip-to-policy-input  tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:445
    ufw-skip-to-policy-input  udp  --  [anywhere]/0            [anywhere]/0            udp dpt:67
    ufw-skip-to-policy-input  udp  --  [anywhere]/0            [anywhere]/0            udp dpt:68
    ufw-skip-to-policy-input  all  --  [anywhere]/0            [anywhere]/0            ADDRTYPE match dst-type BROADCAST
    
    Chain ufw-after-logging-forward (1 references)
    target     prot opt source               destination       
    LOG        all  --  [anywhere]/0            [anywhere]/0            limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] "
    
    Chain ufw-after-logging-input (1 references)
    target     prot opt source               destination       
    LOG        all  --  [anywhere]/0            [anywhere]/0            limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] "
    
    Chain ufw-after-logging-output (1 references)
    target     prot opt source               destination       
    
    Chain ufw-after-output (1 references)
    target     prot opt source               destination       
    
    Chain ufw-before-forward (1 references)
    target     prot opt source               destination       
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0            ctstate RELATED,ESTABLISHED
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 3
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 11
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 12
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 8
    ufw-user-forward  all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-before-input (1 references)
    target     prot opt source               destination       
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0         
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0            ctstate RELATED,ESTABLISHED
    ufw-logging-deny  all  --  [anywhere]/0            [anywhere]/0            ctstate INVALID
    DROP       all  --  [anywhere]/0            [anywhere]/0            ctstate INVALID
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 3
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 11
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 12
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 8
    ACCEPT     udp  --  [anywhere]/0            [anywhere]/0            udp spt:67 dpt:68
    ufw-not-local  all  --  [anywhere]/0            [anywhere]/0         
    ACCEPT     udp  --  [anywhere]/0            ***.***.***.***          udp dpt:5353
    ACCEPT     udp  --  [anywhere]/0            ***.***.***.***      udp dpt:1900
    ufw-user-input  all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-before-logging-forward (1 references)
    target     prot opt source               destination       
    
    Chain ufw-before-logging-input (1 references)
    target     prot opt source               destination       
    
    Chain ufw-before-logging-output (1 references)
    target     prot opt source               destination       
    
    Chain ufw-before-output (1 references)
    target     prot opt source               destination       
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0         
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0            ctstate RELATED,ESTABLISHED
    ufw-user-output  all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-logging-allow (0 references)
    target     prot opt source               destination       
    LOG        all  --  [anywhere]/0            [anywhere]/0            limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW ALLOW] "
    
    Chain ufw-logging-deny (2 references)
    target     prot opt source               destination       
    RETURN     all  --  [anywhere]/0            [anywhere]/0            ctstate INVALID limit: avg 3/min burst 10
    LOG        all  --  [anywhere]/0            [anywhere]/0            limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] "
    
    Chain ufw-not-local (1 references)
    target     prot opt source               destination       
    RETURN     all  --  [anywhere]/0            [anywhere]/0            ADDRTYPE match dst-type LOCAL
    RETURN     all  --  [anywhere]/0            [anywhere]/0            ADDRTYPE match dst-type MULTICAST
    RETURN     all  --  [anywhere]/0            [anywhere]/0            ADDRTYPE match dst-type BROADCAST
    ufw-logging-deny  all  --  [anywhere]/0            [anywhere]/0            limit: avg 3/min burst 10
    DROP       all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-reject-forward (1 references)
    target     prot opt source               destination       
    
    Chain ufw-reject-input (1 references)
    target     prot opt source               destination       
    
    Chain ufw-reject-output (1 references)
    target     prot opt source               destination       
    
    Chain ufw-skip-to-policy-forward (0 references)
    target     prot opt source               destination       
    DROP       all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-skip-to-policy-input (7 references)
    target     prot opt source               destination       
    DROP       all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-skip-to-policy-output (0 references)
    target     prot opt source               destination       
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-track-forward (1 references)
    target     prot opt source               destination       
    
    Chain ufw-track-input (1 references)
    target     prot opt source               destination       
    
    Chain ufw-track-output (1 references)
    target     prot opt source               destination       
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            ctstate NEW
    ACCEPT     udp  --  [anywhere]/0            [anywhere]/0            ctstate NEW
    
    Chain ufw-user-forward (1 references)
    target     prot opt source               destination       
    
    Chain ufw-user-input (1 references)
    target     prot opt source               destination       
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:80
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:443
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:8080
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:8081
    ACCEPT     tcp  --  ***.***.***.***/24       [anywhere]/0            tcp dpt:3306
    ACCEPT     tcp  --  ***.***.***.***/24       [anywhere]/0            tcp dpt:22
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:2022
    
    Chain ufw-user-limit (0 references)
    target     prot opt source               destination       
    LOG        all  --  [anywhere]/0            [anywhere]/0            limit: avg 3/min burst 5 LOG flags 0 level 4 prefix "[UFW LIMIT BLOCK] "
    REJECT     all  --  [anywhere]/0            [anywhere]/0            reject-with icmp-port-unreachable
    
    Chain ufw-user-limit-accept (0 references)
    target     prot opt source               destination       
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0         
    
    Chain ufw-user-logging-forward (0 references)
    target     prot opt source               destination       
    
    Chain ufw-user-logging-input (0 references)
    target     prot opt source               destination       
    
    Chain ufw-user-logging-output (0 references)
    target     prot opt source               destination       
    
    Chain ufw-user-output (1 references)
    target     prot opt source               destination       
    
    ##### LET'S ENCRYPT #####
    Certbot is installed in /usr/bin/letsencrypt
    
    thank you for your help
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Did you remove the user from the output, or is it really empty?

     
  3. bandit

    bandit New Member

    i didn't touch the script nor edit the output :) ... just like that the result
     
    Last edited: Sep 7, 2023
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Ok, so the issue seems to be that somehow there is no mysql user. Please check that the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf is there and contains a valid user (must be root) and correct password. then check that the file /usr/local/ispconfig/server/lib/config.inc.php is there and that it contains a valid user and password for mysql as well. the username for the local mariadb connection in this file is always 'ispconfig'.
     
  5. bandit

    bandit New Member

    yes, but the font color is dark blue from the top until demo config, seems like it has been marked as a comment, is this normal?

    /usr/local/ispconfig/server/lib/mysql_clientdb.conf : it's ok
    /usr/local/ispconfig/server/lib/config.inc.php (below)

    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'] = 'xxxxxxxxxxxxxxxx';
    $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']            = 'server-xxxxxxxx';
    $conf['dbmaster_port']            = '3306';
    $conf['dbmaster_database']        = 'dbispconfig';
    $conf['dbmaster_user']            = '';
    $conf['dbmaster_password']        = 'xxxxxxxxx';
    $conf['dbmaster_new_link']         = false;
    $conf['dbmaster_client_flags']     = 0;
    
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    That's not normal. But depending on your editor, it might be a fault in the syntax highlighting as well as //** is a one line comment but maybe your editor does see it as begin of a multiline comment. Try using a different editor to check the file and if it shows the source as commented out too, try to find where it has been commented out and remove that. It's likely the source of your issue.
     
  7. bandit

    bandit New Member

    yes, the syntax highlight is probably wrong. i checked other server too, it has the same color. i never touch that file unless "how to" direct me to :)

    config.inc.php
    Code:
    <?php
    /*
    Copyright (c) 2007 - 2013, Till Brehm, projektfarm Gmbh
    All rights reserved.
    
    Redistribution and use in source and binary forms, with or without modification,
    are permitted provided that the following conditions are met:
    
        * Redistributions of source code must retain the above copyright notice,
          this list of conditions and the following disclaimer.
        * Redistributions in binary form must reproduce the above copyright notice,
          this list of conditions and the following disclaimer in the documentation
          and/or other materials provided with the distribution.
        * Neither the name of ISPConfig nor the names of its contributors
          may be used to endorse or promote products derived from this software without
          specific prior written permission.
    
    THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
    ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
    WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED.
    IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT,
    INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
    BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
    DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY
    OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE,
    EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
    */
    
    //** Web-only
    if( !empty($_SERVER['DOCUMENT_ROOT']) ) {
    
            Header("Pragma: no-cache");
            Header("Cache-Control: no-store, no-cache, max-age=0, must-revalidate");
            Header("Content-Type: text/html; charset=utf-8");
    
            //** Set a few php.ini values
            ini_set('register_globals',0);
            ini_set('magic_quotes_gpc', 0);
    
            if (isset($_REQUEST['GLOBALS']) || isset($_FILES['GLOBALS']) || isset($_REQUEST['s']) || isset($_REQUEST['s_old']) || isset($_REQUEST['conf'])) {
                    die('Internal Error: var override attempt detected');
                    exit;
            }
    }
    
    //** Set a few php.ini values
    if(isset($app)) unset($app);
    if(isset($conf)) unset($conf);
    
    
    //** SVN Revision
    $svn_revision = '$Revision$';
    $revision = str_replace(array('Revision:','$',' '), '', $svn_revision);
    
    //** Application
    define('ISPC_APP_TITLE', 'ISPConfig');
    define('ISPC_APP_VERSION', '3.2.10p1');
    define('DEVSYSTEM', false);
    
    
    //** Database
    $conf['db_type'] = 'mysql';
    $conf['db_host'] = 'localhost';
    $conf['db_port'] = '3306';
    $conf['db_database'] = 'dbispconfig';
    $conf['db_user'] = 'ispconfig';
    $conf['db_password'] = 'xxxxxxxxxxxx';
    $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']                  = 'xxxxxxxxxxxxx';
    $conf['dbmaster_port']                  = '3306';
    $conf['dbmaster_database']              = 'dbispconfig';
    $conf['dbmaster_user']                  = '';
    $conf['dbmaster_password']              = 'xxxxxxxxxxxxx';
    $conf['dbmaster_new_link']              = false;
    $conf['dbmaster_client_flags']  = 0;
    
    //** Paths
    $conf['ispconfig_log_dir'] = '/var/log/ispconfig';
    define('ISPC_ROOT_PATH', realpath(dirname(__FILE__).'/../')); // Main ROOT is the parent directory to this file, ie interface/ or server/. NO trailing slashes.
    define('ISPC_LIB_PATH', ISPC_ROOT_PATH.'/lib');
    define('ISPC_CLASS_PATH', ISPC_ROOT_PATH.'/lib/classes');
    define('ISPC_WEB_PATH', ISPC_ROOT_PATH.'/web');
    define('ISPC_THEMES_PATH', ISPC_ROOT_PATH.'/web/themes');
    define('ISPC_WEB_TEMP_PATH', ISPC_WEB_PATH.'/temp'); // Path for downloads, accessible via browser
    define('ISPC_CACHE_PATH', ISPC_ROOT_PATH.'/cache');
    define('ISPC_LOG_PATH', $conf['ispconfig_log_dir']);
    
    //** Paths (Do not change!)
    $conf['rootpath'] = substr(dirname(__FILE__),0,-4);
    $conf['fs_div'] = '/'; // File system separator, "\\" on Windows and "/" on Linux and UNIX
    $conf['classpath'] = $conf['rootpath'].$conf['fs_div'].'lib'.$conf['fs_div'].'classes';
    $conf['temppath'] = $conf['rootpath'].$conf['fs_div'].'temp';
    $conf['logpath'] = ISPC_LOG_PATH; // Actually just a copy of $conf['ispconfig_log_dir'], might be removed in a later version
    
    define('FS_DIV',$conf['fs_div']);
    define('SERVER_ROOT',$conf['rootpath']);
    define('INCLUDE_ROOT',SERVER_ROOT.FS_DIV.'lib');
    define('CLASSES_ROOT',INCLUDE_ROOT.FS_DIV.'classes');
    
    
    //** Server
    $conf['app_title'] = ISPC_APP_TITLE;
    $conf['app_version'] = ISPC_APP_VERSION;
    $conf['app_link'] = 'https://www.ispconfig.org/';
    $conf['modules_available'] = 'dashboard,admin,mail,sites,monitor,client,dns,help';
    $conf['server_id'] = '1';
    $conf['init_scripts'] = '/etc/init.d';
    
    
    //** Interface
    $conf['interface_modules_enabled'] = 'dashboard,mail,sites,dns,tools,help';
    
    //** Demo mode
    /* The demo mode is an option to restrict certain actions in the interface like
    *  changing the password of users with sys_userid < 3 etc. to be
    *  able to run the ISPConfig interface as online demo. It does not
    *  affect the server part. The demo mode should be always set to false
    *  on every normal installation
    */
    
    other things, I changed default config (in main config) to new webserver. can this be the cause of the problem?

    Topology

    first setup:
    router
    |--gui/panel server (def web & db)
    |--mailserver1
    |--mailserver2 (mirror)

    current:
    router
    |--gui/panel server
    |--mailserver1
    |--mailserver2 (mirror)
    |--webserver (def web & db)
     
    Last edited: Sep 7, 2023
  8. bandit

    bandit New Member

    the problem still not solved, any clue or opinion on this would be very helpful and appreciated. thanks :)
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    No, this can not be the cause.

    The above config is from master server, right? It has server_id = 1 and that's always the master, so this should be the master server. On the master, the dbmaster_host should be empty:

    $conf['dbmaster_host'] = '';
     
    bandit and ahrasis like this.
  10. bandit

    bandit New Member


    Hi till,
    thank a lot. I have changed the configuration as it should & even though there was a warning as below, the update was successful.

     
    Last edited: Sep 11, 2023
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    The warning is ok, nothing to worry about.
     

Share This Page