Well, my MySQL docker got upgraded to MySQL v8.
Because of this, the password is now using the new sha2 authentication plugins ( and I want it to stay that way for security) and since OSMC is on MySQL 5.5, it can no longer authenticate. When working from the command line to log into the remote database, I see this:
osmc@rrl-vero:~/.kodi/userdata$ mysql -h 192.168.3.21 -u root -p
Enter password:
ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib/arm-linux-gnueabihf/mariadb18/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
After doing some research, it seems that OSMC needs to have its MySQL client updated. I tried some of the avilable guides out there and I guess there is some issue with arm64 support. I tried the following guide:
https://linoxide.com/linux-how-to/install-mysql-ubuntu/
When I get to the point in the guide where you run apt update to sync the new repositories, I get the following errors:
root@rrl-vero:/home/osmc/.kodi/userdata# apt update
Ign:2 http://ftp.debian.org/debian stretch InRelease
Hit:3 http://security.debian.org stretch/updates InRelease
Hit:1 http://ftp.fau.de/osmc/osmc/apt stretch InRelease
Hit:4 http://repo.mysql.com/apt/debian stretch InRelease
Hit:5 http://ftp.debian.org/debian stretch-updates InRelease
Hit:6 http://ftp.debian.org/debian stretch Release
Reading package lists... Done
N: Skipping acquire of configured file 'mysql-apt-config/binary-arm64/Packages' as repository 'http://repo.mysql.com/apt/debian stretch InRelease' doesn't support architecture 'arm64'
N: Skipping acquire of configured file 'mysql-apt-config/binary-armhf/Packages' as repository 'http://repo.mysql.com/apt/debian stretch InRelease' doesn't support architecture 'armhf'
N: Skipping acquire of configured file 'mysql-8.0/binary-arm64/Packages' as repository 'http://repo.mysql.com/apt/debian stretch InRelease' doesn't support architecture 'arm64'
N: Skipping acquire of configured file 'mysql-8.0/binary-armhf/Packages' as repository 'http://repo.mysql.com/apt/debian stretch InRelease' doesn't support architecture 'armhf'
N: Skipping acquire of configured file 'mysql-tools/binary-armhf/Packages' as repository 'http://repo.mysql.com/apt/debian stretch InRelease' doesn't support architecture 'armhf'
N: Skipping acquire of configured file 'mysql-tools/binary-arm64/Packages' as repository 'http://repo.mysql.com/apt/debian stretch InRelease' doesn't support architecture 'arm64'
And running apt-install mysql-client reports that it is at the current version (5.5.9999+default)
So…
How can I get the support for connections to mysql8 servers?
Yeah, I suppose I can go back to using SQLite since I only have one Kodi machine at the moment, but I plan to have more and really want the shared mysql-based libraries available to me.
Please advise.