The following tutorial discusses upgrading PHP and MariaDb whilst updating to the latest version of SVM. The following video details step by step, with a copy of the instructions below;
https://www.youtube.com/watch?v=GoZcFx_wQFc
Backup Existing Databases;
mysqldump ca | gzip > ca.sql.gz
mysqldump ca_CstID | gzip > ca_CstID.sql.gz (Replace CstID with Customer Number)
mysqldump --all-databases | gzip > complete.sql.gz
Perform the PHP Upgrade;
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm
rpm -Uvh http://rpms.remirepo.net/enterprise/remi-release-7.rpm
yum install -y yum-utils
yum-config-manager --enable remi-php72
yum update -y (commit changes)
Perform the MariaDb Upgrade;
systemctl stop mariadb
yum remove mariadb-server mariadb mariadb-libs (This will remove SVM/CSI RPM)
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -s -- --mariadbserver-version="mariadb-10.3"
yum update -y (to commit the changes to the MariaDB Repo)
yum clean all
Install SVM Pre-requisites;
yum -y install curl httpd MariaDB-server MariaDB-client ntp perl-Compress-Zlib php php-gd php-ldap php-mysqlnd php-pecl-zip php-xml rpm-build policycoreutils-python haproxy yum-cron
Sample entry for /etc/my.cnf
The following is based on 16Gb RAM and 3,500 hosts. Please consult with Flexera Support for the correct settings for your environment. There are other files that need to be modified, the requirement is the ‘[mysqld]’ statement and the ‘sql_mode’ setting.
[mysqld]
sql_mode = 'ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_autoinc_lock_mode = 2
innodb_flush_method = O_DIRECT
innodb_buffer_pool_size = 2G
table_open_cache = 4500
max_heap_table_size = 32M
tmp_table_size = 32M
key_buffer_size = 150M
max_connections = 1200
open_files_limit = 7000
thread_cache_size = 130
query_cache_size = 100M
query_cache_type= ON
query_cache_limit= 512K
# innodb_force_recovery=1
innodb_purge_threads=0
Related Articles
How to manually upgrade the Software Vulnerability Manager On-Premises Linux box/CentOS SVM Virtual Applicance from php 7.… 5Number of Views Unable to update the SVM on-premise Virtual Appliance to latest version 8Number of Views Latest version and latest approved version rules for Beacon upgrade can conflict causing a failure of upgrade 4Number of Views Upgrade to the Latest Version of InstallShield or InstallAnywhere 5Number of Views Upgrade to the Latest Version of InstallShield or InstallAnywhere 3Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago