Tag: mysql

Asterisk crashes on res_odbc.so load


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

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: Be sociable 🙂 Share!

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. Be sociable 🙂 Share!

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 Be sociable 🙂 Share!

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


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 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:

Be sociable 🙂 Share!

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