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 …
Tag: mysql
Feb 07 2022
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:
Jul 05 2021
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 …
Feb 10 2020
Vicidial backup and restore guide
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 …
Feb 02 2020
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
|
1 |
systemctl start flexisip-proxy flexisip-presence flexisip-conference |
and by looking in /var/opt/belledonne-communications/log/flexisip/flexisip-conference.log I noticed the following error:
|
1 2 3 4 5 6 |
2020-02-02 03:12:30:790 liblinphone-message-Linphone core [0x56197d8a7d60] notified [global_state_changed] 2020-02-02 03:12:30:790 liblinphone-message-No charset defined forcing utf8 4 bytes specially for conference subjet storage 2020-02-02 03:12:30:790 liblinphone-message-Opening linphone database db=xxx user=xxx password='xxx' host=127.0.0.1 charset=utf8mb4 with backend Mysql 2020-02-02 03:12:30:791 liblinphone-warning-Unable to build db session with uri: Failed to find shared library for backend mysql 2020-02-02 03:12:30:791 liblinphone-error-Unable to open linphone database with uri db=xxx user=xxx password='xxx!' host=127.0.0.1 charset=utf8mb4 and backend Mysql 2020-02-02 03:12:30:791 bctbx-error-Linphone Core couldn't start because the connection to the database has failed |
Apr 17 2019
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.
Apr 03 2019
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:
Jan 23 2018
Error Duplicate entry for key on query
On checking MySQL/MariaDB slave status we can see the following error:
|
1 2 3 4 |
mysql> SHOW SLAVE STATUS\G ... Last_SQL_Errno: 1062 Last_SQL_Error: Error 'Duplicate entry '146474' for key 'PRIMARY'' on query. Default database: 'db'. Query: 'INSERT INTO `options` (`name`, `value, autoload`) VALUES ('enable', 'true', 'true')' |
There are a few ways how to treat such kind of errors.
Jan 23 2018
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
Nov 11 2017
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 …
- 1
- 2
Stay tuned! :)
