Unable to do the prerequisites for upgrading to 4.4.x (mysql_native_password)

[Ronin]

To be completed by the original poster:

CMS Version

4.3.1

Installation Method

Docker Desktop 4.77.0

Operating System

Windows Server 2022 Standard

Issue

Unable to do the prerequisites for upgrading to 4.4.x

I have a Windows vm with Docker Desktop running CMS 4.3.1 which has been upgraded from version 2 maybe… but at least updated from CMS v3 over a few years

While running through the guide MySQL logs "Please use caching_sha2_password instead" after upgrade to MySQL 8.0/Xibo 4

I’m getting a Permission denied error:

"mysqld: File ‘/binlog.index’ not found (OS errno 13 - Permission denied)
see screen shot

the xibo shared db folder is located in

C:\Xibo\shared\db

I started the docker run command in the C:\Xibo folder

I’ve taken the password from the config.env file

not using the cms_custom-ports.yml or cms_remote-mysql.yml

Any help would be greatly appreciated

Cheers

-

[alex]

@Ronin

C:\Xibo\shared\db

You need to adjust the path in your docker run command as you’re on Windows (which we don’t support/recommend).

I presume it would just be docker run --rm -ti -v C:\Xibo\shared\db:/var/lib/mysql mysql:8.0 bash

but I’ve no way to test that here to confirm. I do know that Docker on windows is case sensitive, so if the Xibo directory has a capital X it’s important you use a capital X in Xibo in your command.

[Ronin]

Thanks for that, I’ll give it a go when I’m back near the server.

Windows still because of some old powershell scripts and sharepoint auth things from making rss work and calendars. should be able to move it to a nix/docker soonish

Cheers

[Ronin]

Thanks, worked fine

I’ve added it to my notes in case I have to run other commands before I get around to a full non windows rebuild

Cheers