1. R

    SOLVED Problem with httpd, mariadb and all other processes

    Hello, it's been a few hours since the VPS that I manage gives me problems. When i tried to open phpMyAdmin i received this error mysqli_connect(): (HY000/2002): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Later, i tried a reboot and both Apache and...
  2. S

    MariaDB 10.2 to 10.3 upgrade fails - The preinstall check failed. MariaDB cannot be installed.

    The upgrade from MariaDB 10.2 to 10.3 doesn't work in cPanel. Output: Starting process with log file at /var/cpanel/logs/mysql_upgrade.20191019-133724/unattended_upgrade.log Obtained version information from system. Beginning “MariaDB 10.3” upgrade... Obtained version information from system...
  3. sozotech

    MySQL 5.5 upgrade to 5.7 or MariaDB 10.3?

    In general what is going to be less problematic for breaking users sites, upgrading from MySQL 5.5 to 5.7 or 5.5 to MariaDB 10.3? Best regards, Eric
  4. D

    SOLVED Install MySQL 5.6 instead of MariaDB

    OS : Centos 7.6 KVM WHM : v78.0.20 I am running magento 1.9.x & it supports only MySQL 5.6 (Oracle or Percona) . The problem is cpanel by default installs the MariaDB so can you tell me how i can install the MySQL 5.6 & remove the MariaDB . Please tell me the step by step command i am not so...
  5. A

    SOLVED [CPANEL-25892] No repository exists for MariaDB103 with RHEL

    On a fresh installation of cPanel 78.20, I upgraded to MariaDB 10.2 without issue. When attempting to upgrade from MariaDB 10.2 to 10.3, the upgrade stops at Step 4 with the following error. I have attempted to resolve the issue by confirming the Maria DB packages are available both by adding...
  6. S

    Upgrade MySQL 5.6 to MariaDB 10.3 fails due to repo problem

    As MySQL ran out of date I decided to upgrade from MySQL 5.6 to MariaDB 10.3. Unfortunately the migration wizard quits quite early while with the following error I therefore checked where to find the MariaDB-Client package yum list all maria* Loaded plugins: fastestmirror, priorities...
  7. W

    Updating MariaDB to 10.3

    I want to update my current MariaDB 10.2 to 10.3 However, i am currently running WHM 76.0.18. The latest MariaDB they have is 10.2. I am wondering if it is safe to update to 10.3 from the SSH command line and if that will cause any conflicts with WHM 76? I know WHM 78 has MariaDB 10.3 but...
  8. B

    MariaDB 10.3 with MyRocks

    I just upgraded my VPS to cPanel 78.0.1 so I could run MariaDB 10.3. I was hoping to be able to test converting tables to the MyRocks storage engine, which is included in 10.3, I didn't see the option. I also notice my PHP app is reporting the DB server as MySQL(i) 10.2.21-MariaDB-log when...
  9. G

    Upgrade MariaDB to 10.3: backup without mysqldump?

    I can see the warning when I try to do that: In MariaDB® 10.3, the mysqldump client includes logic for the mysql.transaction_registry table. You cannot use the mysqldump client from an earlier MariaDB release on MariaDB 10.3 and later. For more information about how to upgrade to MariaDB 10.3...
  10. C

    systemctl start mariadb error but mysql running

    Hello, so I needed to move my datadir of MariaDB on my cPanel server because as many it happens, I kept the default config of partitions, and didn't think about it, so I had 20GB and it was getting full, and obviously the main folder taking space was /var/lib/mysql Long story short, I moved the...
  11. 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/". According...
  12. 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...
  13. 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...
  14. 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...
  15. 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?
  16. 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...
  17. 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...
  18. 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/ conflicts between attempted...
  19. C

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