AutoFTP backup does not work in SolusVM: Could not connect to master server. Is the master online with port 5656 SSL open?

Have more questions? Submit a request

Applicable to:

  • SolusVM

Symptoms 

  • AutoFTP backup does not work in SolusVM:

    SVM_ERROR: Could not connect to master server. Is the master online with port 5656 SSL open?

  • In the log /var/log/svmstack-fpm8/error.log on Master node the following errors:

    CONFIG_TEXT: PHP message: PHP Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in /usr/local/solusvm/includes/database.php:417"
    Stack trace:"
    #0 /usr/local/solusvm/includes/database.php(417): mysqli_fetch_assoc(false)"
    #1 /usr/local/solusvm/includes/database.php(89): db_mysql->fetch_array(false)"
    #2 /usr/local/solusvm/includes/functions.php(2679): db_mysql->query('SELECT kvmtagpo...', true)"
    #3 /usr/local/solusvm/www/sysapi/rd.php(172): getKvmTagPoicy()"
    #4 {main}"
    thrown in /usr/local/solusvm/includes/database.php on line 417"

    Or/And

    CONFIG_TEXT: PHP message: PHP Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in /usr/local/solusvm/includes/database.php:422"
    Stack trace:"
    #0 /usr/local/solusvm/includes/database.php(422): mysqli_fetch_assoc(false)"
    #1 /usr/local/solusvm/www/sysapi/rd.php(162): db_mysql->fetchArray(false)"
    #2 {main}"
    thrown in /usr/local/solusvm/includes/database.php on line 422"

Cause

Missing columns in SolusVM database tables 'configuration' and 'secondaryhdd'

Resolution

  1. Connect to Master node via SSH
  2. Create SolusVM database
  3. Access SolusVM database
  4. Add the missing columns:

    MYSQL_LIN: ALTER TABLE configuration ADD COLUMN kvmtagpolicy int(1) NOT NULL DEFAULT '1';

    MYSQL_LIN: ALTER TABLE secondaryhdd ADD COLUMN resize_disk int(1) NOT NULL DEFAULT 0, ADD COLUMN storage_type varchar(50) NOT NULL, ADD COLUMN path varchar(500) NOT NULL, ADD COLUMN image_format varchar(50) NOT NULL, ADD COLUMN tag varchar(500) NOT NULL;

Articles in this section

Was this article helpful?
0 out of 0 found this helpful
Share

Comments

0 comments

Please sign in to leave a comment.