Package 'mysql-server' has no installation candidate

[RaymondDay]

I have WordPress on the:

 

 _   _ ____  _   _   _
| \ | |  _ \(_) | \ | | ___  ___
|  \| | |_) | | |  \| |/ _ \/ _ \
| |\  |  __/| | | |\  |  __/ (_) |
|_| \_|_|   |_| |_| \_|\___|\___/

Welcome to Armbian 23.02.2 Buster with Linux 5.15.93-sunxi

No end-user support: untested automated build & unsupported (buster) userspace!

System load:   86%              Up time:       2 min
Memory usage:  57% of 491M      Zram usage:    18% of 245M      IP:            192.168.86.91
CPU temp:      41°C             Usage of /:    3% of 116G
RX today:      10.7 MiB

Last login: Wed Jan 10 17:09:36 2024 from 192.168.86.95

 

I uninstalled the mariadb because I use "WP Synchro" in WordPress it it just errors with mariadb.

 

How do I install:

 

root@nano-doc2:~# apt install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Package mysql-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'mysql-server' has no installation candidate
root@nano-doc2:~#

 

Same happened on a Debian install on a 8-bit old server I have to fix that I had to edit the apt source file for the next version of Debian coming out yet and it had a whole bunch of updates and I could update and install mysql-server like that.

 

But I don't think it will work like that with Armbian.

 

-Raymond Day

[Werner]

moved to userspace

 

Buster is EOL

[Igor]

38 minutes ago, RaymondDay said:

Package mysql-server is not available

User-land package control comes from upstream.
 

https://www.google.com/search?q=Package+mysql-server+is+not+available
1st hit

https://stackoverflow.com/questions/20259036/mysql-package-mysql-server-has-no-installation-candidate

 

38 minutes ago, RaymondDay said:

But I don't think it will work like that with Armbian.

It should work the same way, but method is not officially supported (yet).

[RaymondDay]

Yes I know can install the "apt-get install mariadb-server" but like I said the mariabd gets a lot of errors on WordPress when coping it with "WP Synchro" One day I pick just stay install don't stop with errors. That took over a hour to press the keys to say that.

 

But in the end the mysql did not work.

 

I all ready tried 3 times look at this:

 

root@nano-doc2:~# ls -l
total 124
-rwxrwxrwx 1 root root 23213 Mar 28  2022 install_max2play.sh~
-rw-r--r-- 1 root root  1320 Jan 19  2020 jcameron-key.asc
-rw-r--r-- 1 root root 35532 Feb 20  2020 mysql-apt-config_0.8.15-1_all.deb
-rw-r--r-- 1 root root 18048 Feb 15  2023 mysql-apt-config_0.8.24-1_all.deb
-rw-r--r-- 1 root root 18172 Jan 11 08:14 mysql-apt-config_0.8.29-1_all.deb
drwxr-xr-x 5 root root  4096 Aug 29 07:33 NanoHatOLED
-rw-r--r-- 1 root root  5372 Mar 19  2023 packages.txt
-rw-r--r-- 1 root root  4945 Aug 29 07:28 setup-repos.sh
root@nano-doc2:~#

 

None work.

 

-Raymond Day

[RaymondDay]

I just put in the /etc/sources.list this line:

deb http://ftp.de.debian.org/debian sid main

 

I then did apt update

 

Then did this:

 

root@nano-doc2:~# apt install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 mysql-server : Depends: mysql-server-8.0 but it is not going to be installed
E: Unable to correct problems, you have held broken packages.
root@nano-doc2:~#

 

That did work on a 8 bit Deben server. But not this ARM one.

 

Can I fix this some how?

 

-Raymond Day

[Igor]

53 minutes ago, RaymondDay said:

That did work on a 8 bit Deben server.

ARM was perhaps not in good shape in Jessie / Buster era. Today, Bullseye and Bookworm should be in perfect state. I suggest you to upgrade to and then try again. Or start with a clean image.

[RaymondDay]

I got this on a nano pi and have WordPress on it and use it as a backup and I back it up with WP Synchro.

 

MariaDB Database Server
MariaDB version 10.5.21

 

But it gets all sort of errors like this:

 

1 Error(s) during migration:

Migration aborted, due to a SQL query failing. See WP Synchro log (found in menu "Logs") for specific information about the query that failed. The specific error from database server was: "Unknown collation: 'utf8mb4_0900_ai_ci'". That means that the charset/collation used is not supported by the target database engine. The table charset/collations needs to be changed into a supported charset/collation for the target database or excluded from migration. See documentation on wpsynchro.com for further help.

1 Error(s) during migration:

Table 'wordpress.wpsyntmp_65b643f7cbd44' doesn't exist

1 Error(s) during migration:

Table 'wordpress.wpsyntmp_65b643f7cc1c2' doesn't exist

3 Error(s) during migration:

Table 'wordpress.wpsyntmp_65b643f7cc396' doesn't exist
Table 'wordpress.wpsyntmp_65b643f7cc396' doesn't exist
Table 'wordpress.wpsyntmp_65b643f7cc396' doesn't exist

 

I can click on RESUME MIGRATION and that's how I got the errors here but it can keep going and I did that one time before took me over a hour to click on the RESUME MIGRATION over and over. Then at the end WordPress said error in database.

 

Have another Debian on a old i386 and I got MySQL install on it. by putting this one line in /etc/apt/sources.list:

 

deb http://ftp.de.debian.org/debian bookworm main contrib non-free non-free-firmware

 

Then could do a apt update and apt install mysql-server.

 

That worked but it don't on this  arm armbian for the nano pi.

 

I know with MySQL I don't get any error with the WP Synchro.

 

Looked and I guess no way to install the MySQL on it. Or can't they update the MariaDB to be 100% computable with MySQL?

 

root@nanopi-dock:~# apt install mysql-server
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Package mysql-server is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'mysql-server' has no installation candidate
root@nanopi-dock:~#

 

-Raymond Day