RaymondDay Posted January 11 Share Posted January 11 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 0 Quote Link to comment Share on other sites More sharing options...
Werner Posted January 11 Share Posted January 11 moved to userspace Buster is EOL 0 Quote Link to comment Share on other sites More sharing options...
Igor Posted January 11 Share Posted January 11 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). 0 Quote Link to comment Share on other sites More sharing options...
RaymondDay Posted January 11 Author Share Posted January 11 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 0 Quote Link to comment Share on other sites More sharing options...
RaymondDay Posted January 11 Author Share Posted January 11 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 0 Quote Link to comment Share on other sites More sharing options...
Igor Posted January 11 Share Posted January 11 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. 0 Quote Link to comment Share on other sites More sharing options...
RaymondDay Posted January 28 Author Share Posted January 28 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 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.