Tag: MariaDB

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

MySQL show connections with MyTOP

mytop-help

MyTOP is an utility for tracking performance and connections to MySQL/MariDB servers. The interface is very similar to top utility. Further examples is performed in CentOS 6 x64 operating system. First of all we need to plug Epel repository:

Continue reading

MariaDB(MySQL) Master-Master Replication

I’m going to develop my cluster further and create MariaDB(MySQL) geo-cluster by enabling MariaDB(MySQL) Master-Master Replication. I’ve already deployed MariaDB cluster in the second datacenter (nodes 4, 5 and 6) and now I need to configure Master-Master replication between two MariaDB clusters. The replication will take place between node 1 (first datacenter, we will name …

Continue reading

MariaDB Galera three nodes cluster on CentOS 6

Let’s build MariaDB Galera cluster with three nodes on CentOS x64 6.7 Minimal. On all nodes static IP adresses have been configured. Node1- 10.20.20.11 Node2 – 10.20.20.12 Node3 – 10.20.20.13 On all nodes we need to install necessary packages:

Continue reading

Load more