Slave not syncronising

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

  1. Alexander Foti

    Alexander Foti Member HowtoForge Supporter

    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 Well-Known Member HowtoForge Supporter

    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 Member HowtoForge Supporter

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

Share This Page