MariaDB installation issues

English Applications
1

Greetings!

I’ve used SuSE for over 20 years. Been running production Samba server as local network file server since Netware days,

Looked at a number of other distros over the years when frustrated but always came back to SuSE, namily because of YAST.

Recently I wanted to host a web based contact application for my own use. I wanted to install
mariaDB and dBeaver on Leap 15.4.

In my initial attempt, I got them both running, but was getting errors indicated there was a corruption in the mariaDB repository. Problem with metadata or something.

Finally decided to do a fresh download and install of Leap 15.4, followed by a mariaDB installation. Leap 15.4 installs just fine. To Install MariaDB on OpenSuse 15.4 I followed the instruction in this link: How to install MariaDB 10 on OpenSuse 15.4 – NextGenTips

These are the commands I issues successfully:
zypper ref
zypper update -y
zypper addrepo --gpgcheck --refresh https://yum.maridb.org/10.6/les/15/x86_64 mariadb
sudo zypper addrepo --gpgcheck --refresh Index of /yum/10.6/sles/15/x86_64/ mariadb
rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB

All went fine utill I issued this command:

zypper --gpg-auto-import-keys refresh

Which returned the following:
Retrieving repository ‘mariadb’ metadata …[error]
Repository ‘mariadb’ is invalid.
[mariadb|https://yum.maridb.org/10.6/les/15/x86_64] Valid metadata not found at specified URL
History:

Please check if the URIs defined for this repository are pointing to a valid repository.
Skipping repository ‘mariadb’ because of the above error.
Repository ‘Update repository of openSUSE Backports’ is up to date.
Repository ‘Non-OSS Repository’ is up to date.
Repository ‘Main Repository’ is up to date.
Repository ‘Update repository with updates from SUSE Linux Enterprise 15’ is up to date.
Repository ‘Main Update Repository’ is up to date.
Repository ‘Update Repository (Non-Oss)’ is up to date.
Some of the repositories have not been refreshed because of an error.

Surly this popular database can be easily installed on 15.4
Has anyone been successful?
Can someone point me in the right direction?

Should I just ignore this error and continue to define my database?

Any help appreciated,
Have fun,
Paxton

2

@paxton Hi, why install a third party repository?

Information for package mariadb:
--------------------------------
Repository     : Update repository with updates from SUSE Linux Enterprise 15
Name           : mariadb
Version        : 10.6.12-150400.3.20.5
3

Did you try to follow documentation on MariaDB site instead of using random Internet search hit?

4

Greetings!
Thank you for your replies.
I have tried using the SLE repository .
Similar issues with bad metadata. Guess I am slow.
I have looked for installation instructions on the MariaDB.
I’ve looked all over. tried many, no joy.
Maybe you can hand me the URL’s to these instructions?
Are either of you actually running Maria on 15.4?

Have fun,
Paxton

5

Again, why not the openSUSE 15.4 standard repos?

I never had an extra repo for MariaDB.

6

It appears there is no Leap 15.4 MariaDB depository.
At least I can’t seem to find it.
I deleted the mariadb repository and downloaded the one on the MariaDB site The repository installs with no error but when I run -“zypper --gpg-auto-import-keys refresh”
I get the error
Retrieving repository ‘mariadb’ metadata …[error]
Repository ‘mariadb’ is invalid.
[mariadb|Index of /mariadb/yum/10.11/sles/] Valid metadata not found at specified URL
History:

Still puzzled…

Have fun,
Paxton

7

The question is still: WHY do you want to add an external repository as mariaDB is already included in the openSUSE standard repo as pointed out by Malcom and Henk? Maybe you have a completely screwed up repo list. Thats why it would help if we start at square one and you show us your repolist via:

zypper lr -d

Because under openSUSE you don’t need to add an additional repo for MariaDB. You simply install the package (and additional ones like mariadb-galera if needed)

sudo zypper install mariadb

And if you are not used to a terminal, simply use yast2-software and type “mariadb” into search field, hit “search” and you will see all available maraidb packages in openSUSE.

8

Thank you for your kind replies.
I have, and will again do a fresh install of 15.4
I did see the repository but I failed to get MariaDB properly installed.
So thank you all for the instruction, no problem with the command line but I do often use the GUI .

Have fun,
Paxton

9

You do not need a repository.

That is, when you install openSUSE, you get some standard repositories, by default. And MariaDB is in there!!!

Just use YaST > Software > Software Management and use the Search for mariadb. And install!

It is so simple.

10

@paxton On openSUSE Leap 15.4 I see the following when installing mariadb from the default repository;

zypper in mariadb

Loading repository data...
Reading installed packages...
Resolving package dependencies...

The following recommended package was automatically selected:
mariadb

The following 9 NEW packages are going to be installed:
  libJudy1 libltdl7 liblzo2-2 libmariadb3 libodbc2 mariadb mariadb-client mariadb-errormessages python3-mysqlclient

9 new packages to install.

So what do you mean by failed to get MariaDB installed properly?