Tag: mysql

Vicidial backup and restore guide

Vicidial

Suppose you need to migrate or duplicate Vicidial data (campaigns, leads, phones and so on) from one Vicibox server to another. In case two Vicidial boxes of the same versions the process will be simpler. In case the source server has older Vicibox version than the destination one you will have to perform additional steps …

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

How To Install And Configure Mailman On Ubuntu

In this tutorial I will configure a virtual host with the hostname lists.example.com where I will install Mailman. lists.example.com is also the right part of the mailing list email addresses that will be configured in Mailman, i.e., mails to a mailing list will have to be sent to the address <listname>@lists.example.com. As your hostname will …

Continue reading

Asterisk dynamic routing with MySQL database

For the next task we will need Asterisk dynamic routing using MySQL: some company has technical department that should provide emergency services on non-working hours. Based on time and date conditions, a call should be routed to a shared department’s extension (technicians) or be sent to a man on duty on non-working time and weekends. …

Continue reading

Upgrading MySQL 5.1 to 5.7 service failed to start

mysql-logo-image

After MySQL upgrade from 5.1 to 5.7 on Centos 6.8 the mysqld service failed to start. In /var/log/mysqld.log I got the following: 2017-01-14 17:19:33 2175 [ERROR] InnoDB: auto-extending data file ./ibdata1 is of a different size 640 pages (rounded down to MB) than specified in the .cnf file: initial 768 pages, max 0 (relevant if …

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

Load more