How upgrade major version mariadb 5.5.65 to 10.0 or higher in Sangoma Distrib?

I upgrade a FreePBX distro 14 with Asterisk 13 to FreepPBX15.
Also I need to shrink size files of DB (asteriskcdrdb: cdr and cel) after deleting old call history.

[root@asterisk3]$ ll -h /var/lib/mysql/
total 1.7G
drwx------. 2 mysql mysql  16K Jun 27 16:33 asterisk
drwx------. 2 mysql mysql   50 Jun 28 10:12 asteriskcdrdb
-rw-rw----. 1 mysql mysql 1.7G Jun 30 11:22 ibdata1
-rw-rw----. 1 mysql mysql 5.0M Jun 30 11:22 ib_logfile0
-rw-rw----. 1 mysql mysql 5.0M Jun 30 11:23 ib_logfile1

But mariadb 5.5.65 cannot execute the OPTIMIZE TABLE INNODB function, because it does not have such a function. This feature is available in the next major version - 10.1.
But I can’t install it - due to limitations of the FREEPBX distribution.

Recommendations for updating mariadb

  • Modify the repository configuration
  • Set innodb_fast_shutdown to 0
  • Stop MariaDB
  • Uninstall the old version of MariaDB
  • Install the new version of MariaDB
  • Start MariaDB
  • Run mysql_upgrade

But when i try to uninstall mariadb

[root@asterisk3]$ yum remove mariadb-server
Loaded plugins: fastestmirror, versionlock
Resolving Dependencies
--> Running transaction check
---> Package mariadb-server.x86_64 1:5.5.65-1.el7 will be erased
--> Processing Dependency: mariadb-server for package: freepbx-14.1-1.sng7.noarch
--> Running transaction check
---> Package freepbx.noarch 0:14.1-1.sng7 will be erased
--> Processing Dependency: freepbx for package: sangoma-pbx-2203-2.sng7.noarch
--> Running transaction check
---> Package sangoma-pbx.noarch 0:2203-2.sng7 will be erased
--> Finished Dependency Resolution
Error: Trying to remove "sangoma-pbx", which is protected

Tell me, please, what are the ways to solve my problem?

The short answer is you do not.

This is not a piecemeal system where you do what you want.

The FreePBX Distro is a wholistic system. You use it as it is provided or don’t use the Distro.

2 Likes

Recent related thread: Ibdata1 filling up disk space - #8 by bksales

1 Like

I just edited the linked post to document exactly what the fix was.

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.