Tag: MariaDB

MariaDB fails to start: Aria engine is not enabled or did not start

After low space condition once happened on a server MariaDB failed to start with :

In /var/log/messages:

Continue reading

Clean and reduce size of Zabbix database

zabbix-reduce-database-size

After some time you may find that you Zabbix database become enormously big and consumes significant amount of disk space. Among really usefull data there is data that may be cleaned up and optimized in Zabbix database in order to reduce size of Zabbix database.

Continue reading

MariaDB error InnoDB: Upgrade after a crash is not supported

Here is a crash I experienced while upgrading MariaDB from 10.4 to 10.5

Continue reading

mysql_secure_installation: command not found

You have just installed MariaDB and as usual want to perform initial configuration by running mysql_secure_installation script but the error is: mariadb_secure_installation: command not found For MariaDB set ups you should use the following:

Continue reading

How to Enable the Slow Query Log in MySQL/MariaDB

Enabling the Slow Query Log for MySQL or MariaDB can be a useful tool to diagnose performance and efficiency issues affecting your server such as MySQL high CPU load. By identifying queries that are particularly slow in their execution, you can address them by restructuring the application that triggers your queries. You can also rebuild …

Continue reading

Vicidial error: Code Expects Different Schema

Vicidial-warning-code-expects-different-schema

After database dump restoration taken from older Vicibox to the latest Vicibox 9.0.1 I got the following error in Admin -> System Settings section: WARNING: Code expects different schema: 1585 It’s not possible to change or save any setting. The reason is obvious: Vicibox 9 has new and altered tables and functions so you will …

Continue reading

FlexiSip installation and configuration on Debian 9

flexisip-scheme

Flexisip is a complete, modular and scalable SIP server suite written in C++11, comprising proxy, presence and group chat functions. Flexisip offers an easy-to-install SIP server solution, offering all the features required to deploy your own SIP service tuned for mobile or desktop applications, “out of the box”. Flexisip can be integrated into your SIP …

Continue reading

Flexisip error Failed to find shared library for backend mysql

I installed Flexisip using official documentation , installed additional components like MariaDB (MySQL) and Redis, performed initial setup of configuration files, created database and DB user. I started flexisip services with

and by looking in /var/opt/belledonne-communications/log/flexisip/flexisip-conference.log I noticed the following error:

Continue reading

Asterisk crashes on res_odbc.so load

asterisk-invalid-pointer

While loading res_odbc.so Asterisk crashes with “invalid pointer” error like in the backtrace below: Loading res_odbc.so.

Continue reading

How to reset MySQL/MariaDB root password

Start session ssh (using root if possible). Edit my.cnf file using. sudo vi /etc/my.cnf Add line to [mysqld] block:

Continue reading

Load more