Remote Mysql migration does not work

Get Help
1

I have downloaded the xibo docker version 2.0.1 (xibosignage/xibo-cms:release-2.0.1) and I have a remote mysql version 8.0.16 which I clustered with innodb. When I run “docker-compose -f cms_remote-mysql.yml up -d” it works. But I get this message on cms page “The CMS is temporarily off-line as an upgrade is in progress. Please check with your system administrator for updates or refresh your page in a few minutes.”
And in docker-compose logs for cms-web_1 I have these message:

Attaching to xibo-docker_cms-web_1, xibo-docker_cms-xmr_1 cms-web_1 | MySQL started
cms-web_1 | Updating settings.php
cms-web_1 | ERROR 1049 (42000): Unknown database ‘xibo’ cms-web_1 | New install
cms-web_1 | Provisioning Database
cms-web_1 | Phinx by CakePHP - https://phinx.org. 0.9.2
cms-web_1 |
cms-web_1 | using config file .varwwwcmsphinx.php
cms-web_1 | using config parser php
cms-web_1 | using migration paths
cms-web_1 | - /var/www/cms/db/migrations
cms-web_1 | warning no environment specified, defaulting to: production cms-web_1 | using adapter mysql
cms-web_1 | using database xibo
cms-web_1 |
cms-web_1 | == 20180130073838 InstallMigration: migrating
cms-web_1 |
cms-web_1 |
cms-web_1 | [PDOException]
cms-web_1 | SQLSTATE[22001]: String data, right truncated: 1406 Data too long for colum cms-web_1 | n ‘title’ at row 38
cms-web_1 |
cms-web_1 |
cms-web_1 | migrate [-c|–configuration CONFIGURATION] [-p|–parser PARSER] [-e|–environment ENVIRONMENT] [-t|–target TARGET] [-d|–date DATE] [-x|–dry-run] cms-web_1 |
cms-web_1 | Configuring Database Settings
cms-web_1 | Setting up Maintenance
cms-web_1 | Protected Maintenance
cms-web_1 | Importing ca-certs
cms-web_1 | cp: can’t stat ‘/var/www/cms/ca-certs/.pem’: No such file or directory cms-web_1 | cp: can’t stat '/var/www/cms/ca-certs/.crt’: No such file or directory cms-web_1 | WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping cms-web_1 | Configuring Maintenance
cms-web_1 | Removing web/install/index.php from production container cms-web_1 | Starting cron
cms-web_1 | Starting webserver

it connects to db, it creates xibo datebase but it doesnt work as it seems the error of migration is the problem.
Any idea what should I do?

2

I would suggest you take a look at this link. It sounds like you have a similar issue as I had with the SQL table creation.

3

PS: As soon as you move your old “settings.php” file into your new production web folder, it will put your installation into maintenance mode until it completes successfully.

Andre

4

Thank you.
Well this file is for local db. I want to use remote mysql and there is no docker-compose for that.

5

The error you received was related to some bad scripting in a few of the files used to complete the migration. If you manually make those changes to all the files (except the docker file) and rerun the migration again - it should work. I am not sure if the partial migration that was done prior to encountering errors that were caused by the scripting issues will present an issue for you so you might need to restore your db before performing the migration again.

6

MySQL 5.7 isn’t supported in 2.0.1. You’ll need to wait for 2.0.2 to be released before you can use that configuration.