Tag: MariaDB

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

Error Duplicate entry for key on query

On checking MySQL/MariaDB slave status we can see the following error:

There are a few ways how to treat such kind of errors.

Continue reading

Could not find target log during relay log initialization

While a setting up MariaDB slave I ran in the following issue: 180118 14:14:11 [ERROR] Failed to open the relay log ‘./-relay-bin’ (relay_log_pos 7654336) 071118 16:44:10 [ERROR] Could not find target log during relay log initialization 071118 16:44:10 [ERROR] Failed to initialize the master info structure

Continue reading

Load more