Tag: mysql

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

mysqldump directly to another server, mysqldump redirect to scp

It’s not a big deal to perform mysqldump command, get your database as a file and transfer MySQL database to another server by moving the file to another server and import it, But what if there is no enough space on a disk to store the dump file? In this case it would be great …

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

Load more