mariadb

  1. B

    SOLVED MariaDB-client-10.3.27-1.el7.c FAILED

    I received about 50 emails today, saying the following /etc/cron.hourly/0yum-hourly.cron: Not using downloaded MariaDB103/repomd.xml because it is older than what we have: Current : Fri Nov 6 17:53:47 2020 Downloaded: Tue Nov 3 02:36:58 2020 So of course I checked in and I ran yum update this...
  2. jmginer

    How to downgrade from Mariadb 10.3.26 to 10.3.25 ?

    Hello, please, let me to know the way to do a correct downgrade from Mariadb 10.3.26 to 10.3.25. Thanks!
  3. M

    SOLVED CPANEL-34745 - MariaDB 10.3.26-1 Breaks PHP < 7.2

    Just wanting to post this here, as I've spent the last 2 hours fault finding an issue on my servers this morning. cPanel servers, all the latest updates. MariaDB automatically updated to 10.3.26-1 over night as part of the cPanel yum update. As soon as this happened, any XenForo site running...
  4. M

    Can't edit user password with MariaDB 10.4

    Good morning, I think that there is a bug with cPanel. Using MariaDB 10.4 (from CloudLinux repositories), nobody can update user password throught cPanel interface. The error log says: [2020-11-02 09:47:31 +0100] info [whostmgrd] Successfully verified signature for cpanel (key types: release)...
  5. AndyX

    Upgrade MySQL or MariaDB instructions incomplete

    The instruction here indicate to select the version of MySQL. Please update the instructions, are we suppose to be in WHM or cPanel? Where to we go to select the MySQL version? Source: MySQL/MariaDB Upgrade | cPanel & WHM Documentation
  6. Michael Legg

    MariaDB The service “mysql” appears to be down but it isn't

    WHM send me an email every hour saying ... Notification The service "mysql" appears to be down. Service Check Method The system's command to check...
  7. S

    Question about MariaDB Update (I have an error)

    We are in the process of updating the MariaDB on a server but have gotten this error; " The system detected issues with the current “/etc/my.cnf” file. These issues may interfere with the upgrade to MariaDB" I loaded up the my.cnf file and here's what it looks like. [mysqld]...
  8. M

    MariaDB 10.1 EOL / Upgrade Concerns

    I am preparing to upgrade MariaDB but am concerned about a couple of websites being compatible. One of them is using October CMS, and a few others are using PHPMyDirectory. Is there a solid way of checking to be sure these sites won't crash prior to the upgrade? PHPMyDirectory Web Hosting...
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...