MariaDB Database can't be created

Server provisioning and management
#1

Hi there,

i wanted to add a MariaDB Database and had errors. So i ventured into the SSH Console of the server and wanted to do an update of everything and check things. But got the bellow error message :frowning:

I think the repo you choose is not available anymore :frowning:

Ign:10 http://mariadb.mirror.liquidtelecom.com/repo/10.4/ubuntu focal InRelease  
Err:11 http://mariadb.mirror.liquidtelecom.com/repo/10.4/ubuntu focal Release
  404  Not Found [IP: 197.155.77.1 80]
Reading package lists... Done                        
E: The repository 'http://mariadb.mirror.liquidtelecom.com/repo/10.4/ubuntu focal Release' does not have a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
#2

I think the repo you choose is not available anymore :frowning:

That’s what it sounds like. We’ll look into this immediately and update the status here. Thanks for the heads up and extremely sorry about the issue.

1 Like
#3

Thanks for the quick answer.

Just FYI, why does the Interface say, installed correctly, but the repo is completely broken? There may be a bug also in the Status/Heartbeat sensor? :slight_smile:

#4

It’s probably because we failed to read the exit status code for the failed repo error. We’ll try to make sure that it’s been read and reported correctly but the first priority right now is to make sure that at least it can be installed.

Also, can you please message me your Cleavr username or email?

#5

quick update:
I tried to repro this on a newly provisioned Hetzner server and I was able to successfully install MariaDB. It could be because based on the location it was fetching the installed from, the repo was dead. Will continue to investigate. In the mean time, can you please message me the server name you were trying to installing this on?

#6

We have identified and fixed the issue. Can you please try installing it once again and let us know whether it works or not?

#7

Hi @ashok I installed it and it installed. But creating a database afterwords still throws an error.

The old ppa is still installed :frowning:

#8

I setup the server completely new, and installed MariaDB Service…

But Database creation made an error and the terminal gave error after sudo apt update

Ign:5 http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.4/ubuntu focal InRelease
Err:6 http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.4/ubuntu focal Release
  404  Not Found [IP: 104.21.29.13 80]
Reading package lists... Done
E: The repository 'http://nyc2.mirrors.digitalocean.com/mariadb/repo/10.4/ubuntu focal Release' does not have a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
N: See apt-secure(8) manpage for repository creation and user configuration details.
#9

Hey Guys,

I tried to install a new Databaseserver with MySQL 8.0. This time there is no apt repo issue. But i can’t create a database on the server :frowning:

I changed nothing, but i’m quite frustrated of what i did wrong or happened wrong.

#10

Sounds like this is reproduceable - can you please let me know which server and region the servers where this issue occurs are?

My first thought is maybe apt-get is blocked or sluggish at the server region.

#11

a hetzner server in Nurnberg :slight_smile:

i’m currently doing the installation by hand bc we need this working tonight :frowning:

#12

I believe I know what the issue is. Are you by chance using dashes in the db name/user/password?

MySQL db doesn’t like dashes, ‘-’, but does allow underscores.

We’ll prioritize better validation for this since it just gives a generic error at the moment.

#13

@amiedema and no passwords longer then 79 characters fyi