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

Autumn Clack

• April 10, 2019 20:00

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 the appropriate channels via the Red Hat Satellite service and also by hand via a repo file in yum.repos.d. I have attached the output of the failed upgrade message below. I have also tried to force reinstall the latest version of cPanel again to see if that might produce a different result but it did not. Thanks in advance for your assistance! Autumn Starting process with log file at /var/cpanel/logs/mysql_upgrade.20190410-194652/upgrade_mysql_with_status.log Obtained version information from system. Proceeding with MySQL/MariaDB upgrade despite the following: Critical: 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, read thedocumentation. Critical: MariaDB enables "strict mode" by default as of version 10.2. Strict mode controls how MariaDB and MySQL handle invalid or missing values in data-change statements such as INSERT or UPDATE. Applications not built with strict mode enabled may cause undesired behavior; please verify applications using MariaDB are compatible before upgrading. More information about strict mode is availablehere. Obtained version information from system. Ensuring the "MariaDB103" repository is available and working. Restarting mysql service. Waiting for "mysql" to restart ""waiting for "mysql" to initialize "finished. Service Status mysql (/usr/sbin/mysqld) is running as mysql with PID 11411 (systemd+/proc check method). Startup Log Apr 10 19:46:54 server.example.com systemd[1]: Starting MariaDB 10.2.23 database server... Apr 10 19:46:54 server.example.com mysqld[11411]: 2019-04-10 19:46:54 140095996504256 [Note] /usr/sbin/mysqld (mysqld 10.2.23-MariaDB) starting as process 11411 ... Apr 10 19:46:54 server.example.com systemd[1]: Started MariaDB 10.2.23 database server. Log Messages 2019-04-10 19:46:54 140095996504256 [Note] /usr/sbin/mysqld: ready for connections. 2019-04-10 19:46:54 140009403053824 [Note] /usr/sbin/mysqld: Shutdown complete 2019-04-10 19:43:36 140009873307840 [Note] /usr/sbin/mysqld: ready for connections. 2019-04-10 19:43:36 140092104222464 [Note] /usr/sbin/mysqld: Shutdown complete 2019-04-10 19:24:45 140092226541760 [Note] /usr/sbin/mysqld: ready for connections. Apr 10 19:46:54 itastst701a mysqld: 2019-04-10 19:46:54 140095996504256 [Note] /usr/sbin/mysqld (mysqld 10.2.23-MariaDB) starting as process 11411 ... mysql restarted successfully. No repository exists for "MariaDB103" at "/usr/local/cpanel/etc/rpm/generic/MariaDB103/yumrepo". at /usr/local/cpanel/Cpanel/Repos.pm line 171. Obtained version information from system. Proceeding with MySQL/MariaDB upgrade despite the following: Critical: 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, read thedocumentation. Critical: MariaDB enables "strict mode" by default as of version 10.2. Strict mode controls how MariaDB and MySQL handle invalid or missing values in data-change statements such as INSERT or UPDATE. Applications not built with strict mode enabled may cause undesired behavior; please verify applications using MariaDB are compatible before upgrading. More information about strict mode is availablehere.

• 

  cPanelMichael

  • April 15, 2019 19:17

  Hello @Autumn Clack, Case CPANEL-25892 is open to address an issue where the RHEL YUM repo files for MariaDB 10.3 are missing from the /usr/local/cpanel/etc/rpm/rhel/6/ and /usr/local/cpanel/etc/rpm/rhel/7/ directories. I'll monitor the status of this case and update this thread with more information as it becomes available. In the meantime, you can run the following commands to manually enable the MariaDB 10.3 repo on RHEL versions 6/7: For RHEL version 6: # mkdir -p /usr/local/cpanel/etc/rpm/rhel/6/MariaDB103/x86_64 # vi /usr/local/cpanel/etc/rpm/rhel/6/MariaDB103/x86_64/yumrepo
  Once the file is open in the "vi" editor, populate it with the following contents and save: # MariaDB 10.3 CentOS repository list - created 2014-10.39 00:41 UTC # http://mariadb.org/mariadb/repositories/ [MariaDB103] name = MariaDB103 baseurl = http://yum.mariadb.org/10.3/rhel6-amd64/ gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
  For RHEL version 7: # mkdir -p /usr/local/cpanel/etc/rpm/rhel/7/MariaDB103/x86_64 # vi /usr/local/cpanel/etc/rpm/rhel/7/MariaDB103/x86_64/yumrepo
  Once the file is open in the "vi" editor, populate it with the following contents and save: # MariaDB 10.3 CentOS repository list - created 2014-10.39 00:41 UTC # http://mariadb.org/mariadb/repositories/ [MariaDB103] name = MariaDB103 baseurl = http://yum.mariadb.org/10.3/rhel7-amd64/ gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
  Let me know if you encounter any issues upon enabling the workaround. Thank you.

  0
• 

  Autumn Clack

  • April 16, 2019 23:48

  Michael, Thank you very much for the manual fix to enable the repo! It worked as expected. --Autumn

  0
• 

  cPanelMichael

  • July 09, 2019 19:53

  Hello, To update, this is fixed in version 82. Here's the entry in the Release Tier on the link below:

  0

Please sign in to leave a comment.