Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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

Discussion in 'Database Discussion' started by Autumn Clack, Apr 10, 2019.

Tags:
  1. Autumn Clack

    Autumn Clack Registered

    Joined:
    Apr 10, 2019
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Michigan
    cPanel Access Level:
    Root Administrator
    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

    Code:
    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.
     
    #1 Autumn Clack, Apr 10, 2019
    Last edited by a moderator: Apr 10, 2019
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    47,299
    Likes Received:
    2,155
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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:

    Code:
    # 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:

    Code:
    # 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:

    Code:
    # 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:

    Code:
    # 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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Autumn Clack

    Autumn Clack Registered

    Joined:
    Apr 10, 2019
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    1
    Location:
    Michigan
    cPanel Access Level:
    Root Administrator
    Michael,

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

    --Autumn
     
    cPanelMichael likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice