mariadb

  1. R

    SystemD services disappeared since MariaDB update?

    Since UPCP ran this morning, all my custom services loaded via systemctl have disappeared. The services themselves are not running, but the ".service" files are showing under "/etc/systemd/system" and the symlinks are also showing under "/etc/systemd/system/multi-user.target.wants". According...
  2. C

    SOLVED MariaDB 10.0 > 10.1 or 10.2

    Hi Cpanel Members & Team I'm trying to update mariaDB 10.0 to (10.1 or 10.2) and this is my issues Error installing MariaDB dependencies: (XID kkfzd8) The system failed to execute yum with the arguments “--assumeyes --config /etc/yum.conf install shadow-utils grep perl-DBI coreutils...
  3. C

    Aborted connection errors after upgrade to MariaDB 10.2

    I recently upgraded from MariaDB 10.1 to 10.2, and am seeing lots of these kind of errors, but I don't seem to be losing data or notice any issues besides the warnings: 2018-08-21 15:57:48 140579807250176 [Warning] Aborted connection 926492 to db: 'database_name' user: 'site_user' host...
  4. P

    Move from MySQL 5.7 to MariaDB 10.0.34 manually?

    Hello I´m updating all my cpanel servers to new ones. (from centOS 6X to centOS 7 because Cloudlinux 6X will discontinue soon). At now i have installed MariaDB 10.0.34 and all sites are working fine and perfect. 2 days ago i built one of the new ones (by default with mySQL 5.7) and i made the...
  5. D

    SOLVED Mariadb 10.2 - Disabling Strict Mode

    I am wondering if disabling strict mode going to stick when cpanel/WHM auto updates itself? If so, is it going to stick while upgrading minor MariaDB 10.2.x versions?
  6. G

    Change MariaDB tmp folder?

    Hello, I try to change tmp folder of mariadb because I found out that files .MAD are are constantly being created inside tmp folder and despite the fact that I increased the tmp folder from the beginning of the installation of cpanel to 15GB are filling the space with results operational...
  7. U

    The system failed to drop the MySQL user error

    hi, after i downgrade from mariadb 10.2 to mysql 5.6 i got this error when i delete user The system failed to drop the MySQL user “xxxx” because of an error: (XID bn962q) The system received an error from the “MySQL” database “mysql”: 1728 (Cannot load from mysql.procs_priv. The table is...
  8. A

    Cant update MariaDB

    Yum update failing on this: Transaction check error: file /etc/my.cnf conflicts between attempted installs of MariaDB-common-10.2.16-1.el7.centos.x86_64 and cl-MariaDB102-libs-10.2.15-1.el7.cloudlinux.x86_64 file /usr/lib64/mysql/plugin/auth_gssapi_client.so conflicts between attempted...
  9. cPanelMichael

    InnoDB fails to start on systems using MariaDB when the kernel is older than 2.6.24

    Hello, In MariaDB version 10.1.34, the F_DUPFD_CLOEXEC flag is used with FCNTL as part of the operation to create a temporary file during the InnoDB startup process. Kernel versions older than 2.6.24 do not support the F_DUPFD_CLOEXEC flag, and thus InnoDB will fail to start. The following line...
  10. P

    Downgrade Mariadb to 10.1?

    Hello i using cpanel last version on centos 7 i install mariadn 20.2 in MySQL/MariaDB Upgrade option in WHM i want install mariadb 10.1 ..( i want downgrade from 10.2 to 10.1) can you help me ? i read this post : That's correct. If you want to use MariaDB 10.1, you'd create...
  11. P

    Upgrading MariaDB and old sites

    My server is currently using Maria 5.6 and I am wanting to upgrade to V 10. But there are quite a few sites on the server that can only run php 5.3. Will upgrading Maria cause problems with those sites? I'm getting different answers and no one seems to know for sure. I've checked the Maria site...
  12. L

    MariaDB Did Not Start Up After Upgrade

    I'm using WHM/cPanel 70, and I decided to take the plunge and do the upgrade from MariaDB 10.1 to 10.2 using the MySQL/MariaDB upgrade tool in WHM. During Step 7 of the upgrade process, I got the following error: MariaDB did not start up after upgrade; there may be a problem in /etc/my.cnf. at...
  13. keat63

    Upgrading MySQL 5.6 to MariaDB 10.2 Question

    My server is currently on MySql5.6 If I were to upgrade this to Maria10.2, what's the likelyhood of it breaking ?
  14. M

    Problems after moving to MariaDB

    Accidentally I have replacement MySQL server. We are using MySQL version 5.6.37 and Does not get any Server Error Log. Today I Do Upgrade to MariaDB 10.2.8 and Now lot of Server Error Log happened about Deadlock found when trying to get lock and Lock wait timeout exceeded. So this issue only...
  15. unarea

    MariaDB restart warning

    Ok, Im setting up a new server with cpanel 68.0.37 release. I upgraded mysql 5.6 to mariadb 10.1, that´s ok. I tested some sites before the dns move and all is ok. Mysql -v shows that mariadb is running. Now when I restart mysql (service mysql restart) I get this error: Restarting mysql (via...
  16. C

    SOLVED convert from MysqlDB to MariaDB

    Hello everyone, I know there are many guides that talk about converting from MysqlDB to MariaDB. However, I think I have what is probably an obvious question to someone in the mysql world or cpanel world. These guides (unless I missed it) did not talk about restoring the data. do I need to...
  17. D

    install MariaDB instead of MySQL

    Is there a way to specify in the /root/cpanel_profile/cpanel.config file : install MariaDB10.1 instead of MySQL 5.6? I know there was an option in cpanel.config for: mysql-version and you could do it there but that has been deprecated in favor updating /var/cpanel/rpm.versions.d/local.versions...
  18. NovemberRain

    migrated-from-my.cnf-settings service file is marked world-inaccessible

    systemd: Configuration file /etc/systemd/system/mariadb.service.d/migrated-from-my.cnf-settings.conf is marked world-inaccessible. This has no effect as configuration data is accessible via APIs without restrictions. Proceeding anyway. /var/log/messages on my server is full of these lines. What...
  19. MajorLancelot

    MariaDB/MySQL Datafile-level Compatibility

    MariaDB is on the path of gradually diverging from MySQL. One obvious example is the internal data dictionary currently under development for MySQL 8. This will be a major change to the way metadata is stored and used within the server, and MariaDB doesn’t have an equivalent feature...
  20. J

    mysql 5.6 to mariadb 10.1.x centos 7.x datadir issue

    I'm looking to upgrade/switch away from MySQL 5.6 in favor of MariaDB 10.1.x however, I received the following fatal error: As of MariaDB 10.1.16, the data directory cannot reside in /home, /usr, /etc, /boot, or /root directories on systemd equipped systems. You must move your MySQL data...