- centos,
CentOS 7 64bit - database
replacing MariaDB with MySQL 5.7
cat fulldump.sql | mysql -u root -ppassw0rd –max-allowed-packet=1024M –force - cpu frequency, should get “performance” by following
cat /sys/devices/system/cpu/cpu*/cpufreq/scaling_governor - 2 cpu, 500G disk ?
Mirtapbx installation url:
http://www.mirtapbx.com/manual/index.php/Installing_MiRTA_PBX
ftp upload mirtapbx06 install script
hostnamectl set-hostname mirtapbx01 –static
yum -y install https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm (maybe mysql 5.7)
ftp upload file: /etc/yum.repos.d/mysql-community.repo
yum -y upgrade (this will upgrade mysql to 5.7)
ftp upload file: /etc/my.cnf (magic configuration file, otherwise, upgrade / utf8 get error);
ftp upload file: /etc/php.ini
ftp upload file: /var/www/html/pbx/include/db.inc.php
cd /var/www/html/pbx; php dodbupgrade.php
There will be some errors and notice, just ignore them. Now convert the database to UTF8
cd protected; php convert_to_utf8.php
upload and config /etc/odbcinst.ini
yum install yum-plugin-versionlock
yum -y downgrade mysql-connector-odbc-8.0.11-1.el7.x86_64
yum versionlock mysql-connector-odbc
cd /usr/local/src/dahdi-linux-complete-2.11.1+2.11.1
make install ; service dahdi restart
cd ../xtables-addons-2.10; make install
upgradeGeoIP.sh
Additional: How to upgrade asterisk version ?installAsterisk.sh
** very useful answers
http://www.mirtapbx.com/manual/index.php/FAQ