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
- Connect to Master node via SSH
- Create SolusVM database
- Access SolusVM database
- 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;
Comments
0 commentsPlease sign in to leave a comment.