Slave not syncronising

Discussion in 'Installation/Configuration' started by Alexander Foti, Aug 19, 2019.

  1. Alexander Foti

    Alexander Foti New Member

    Hi al
    I have a twin server ispconfig 3 setup (3.1.13p1)
    My slave is not syncronising, and items are remaining in the update queue.
    I have disabled the cron job on the slave, and the output of server.sh is:

    Code:
    PHP Warning:  mysqli_connect(): (HY000/2002): No route to host in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 79
    The db_mysql.inc.php seems to be missing its values:

    Code:
     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
            /**#@-*/
    
            public $show_error_messages = false; // false in server, true in interface
    
    Any idea if that is correct, and if so, where to find the values (For the slave).

    Many thanks.
     
  2. florian030

    florian030 ISPConfig Developer ISPConfig Developer

    the slave can not connect to the master. check
    Code:
    $conf['dbmaster_host']                  = '...';
    $conf['dbmaster_port']                  = '3306';
    $conf['dbmaster_database']              = 'dbispconfig';
    $conf['dbmaster_user']                  = 'ispcsrvX';
    $conf['dbmaster_password']              = '...';
    
    
    in /usr/local/ispconfig/server/lib/config.inc.php
     
  3. Alexander Foti

    Alexander Foti New Member

    Thank you, I was struggling to find the original source file for the bits.
     

Share This Page