Problem to update to 3.0.0

ChrstianM82 · June 25, 2021, 8:08am

Hi,

the last two hours we tried unsuccessfully to update our Xibo CMS (docker on Linux) from version 2.3.6 to 3.0.0. According to the logfile of xibo_cms-web_1 this error occurs:
PHP Fatal error: Uncaught Error: Class ‘Slim\Middleware’ not found in /var/www/cms/custom/XiboForAndroidOnPremise.php:53

An update to 2.3.10 worked without problems. But even after that we can’t get to version 3.0.0.

Any Idea?

here is the log:

Status: Downloaded newer image for memcached:alpine
Creating xibo_cms-memcached_1  ... done
Creating xibo_cms-quickchart_1 ... done
Creating xibo_cms-xmr_1        ... done
Creating xibo_cms-db_1         ... done
Creating xibo_cms-web_1        ... done

docker logs --tail 50 --follow --timestamps xibo_cms-web_1

2021-06-25T07:43:46.064797020Z Updating settings.php
2021-06-25T07:43:46.080344364Z Generating RSA private key, 2048 bit long modulus (2 primes)
2021-06-25T07:43:46.159266545Z ......................................................+++++
2021-06-25T07:43:46.194530882Z .......................+++++
2021-06-25T07:43:46.194780168Z e is 65537 (0x010001)
2021-06-25T07:43:46.198208449Z writing RSA key
2021-06-25T07:43:46.247790339Z settingId
2021-06-25T07:43:46.247815199Z 1
2021-06-25T07:43:46.247818825Z Existing Database, checking if we need to upgrade it
2021-06-25T07:43:46.285002536Z Phinx by CakePHP - https://phinx.org. 0.9.2
2021-06-25T07:43:46.285146029Z
2021-06-25T07:43:46.285799219Z using config file .varwwwcmsphinx.php
2021-06-25T07:43:46.288390215Z PHP Fatal error:  Uncaught Error: Class 'Slim\Middleware' not found in /var/www/cms/custom/XiboForAndroidOnPremise.php:53
2021-06-25T07:43:46.288409345Z Stack trace:
2021-06-25T07:43:46.288413052Z #0 /var/www/cms/vendor/composer/ClassLoader.php(444): include()
2021-06-25T07:43:46.288416130Z #1 /var/www/cms/vendor/composer/ClassLoader.php(322): Composer\Autoload\includeFile('/var/www/cms/ve...')
2021-06-25T07:43:46.288419230Z #2 [internal function]: Composer\Autoload\ClassLoader->loadClass('Xibo\\Custom\\Xib...')
2021-06-25T07:43:46.288422648Z #3 /var/www/cms/custom/settings-custom.php(71): spl_autoload_call('Xibo\\Custom\\Xib...')
2021-06-25T07:43:46.288425556Z #4 /var/www/cms/web/settings.php(40): include('/var/www/cms/cu...')
2021-06-25T07:43:46.288428346Z #5 /var/www/cms/phinx.php(34): require('/var/www/cms/we...')
2021-06-25T07:43:46.288430970Z #6 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Config/Config.php(125): include('/var/www/cms/ph...')
2021-06-25T07:43:46.288433832Z #7 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/Command/AbstractCommand.php(266): Phinx\Config\Config::fromPhp('/var/www/cms/ph...')
2021-06-25T07:43:46.288556570Z #8 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/Command/AbstractCommand.php(93): Phinx\Console\Command\AbstractCommand->loadConfig(Object(Symfony\Component\Console\Input\ArgvI in /var/www/cms/custom/XiboForAndroidOnPremise.php on line 53
2021-06-25T07:43:46.291849094Z We will upgrade it, take a backup
2021-06-25T07:43:46.305954446Z mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
2021-06-25T07:43:52.597264946Z Running database migrations
2021-06-25T07:43:52.636437449Z Phinx by CakePHP - https://phinx.org. 0.9.2
2021-06-25T07:43:52.636523752Z
2021-06-25T07:43:52.637148490Z using config file .varwwwcmsphinx.php
2021-06-25T07:43:52.638876958Z PHP Fatal error:  Uncaught Error: Class 'Slim\Middleware' not found in /var/www/cms/custom/XiboForAndroidOnPremise.php:53
2021-06-25T07:43:52.638898671Z Stack trace:
2021-06-25T07:43:52.638902266Z #0 /var/www/cms/vendor/composer/ClassLoader.php(444): include()
2021-06-25T07:43:52.638905242Z #1 /var/www/cms/vendor/composer/ClassLoader.php(322): Composer\Autoload\includeFile('/var/www/cms/ve...')
2021-06-25T07:43:52.638908104Z #2 [internal function]: Composer\Autoload\ClassLoader->loadClass('Xibo\\Custom\\Xib...')
2021-06-25T07:43:52.638911542Z #3 /var/www/cms/custom/settings-custom.php(71): spl_autoload_call('Xibo\\Custom\\Xib...')
2021-06-25T07:43:52.638914360Z #4 /var/www/cms/web/settings.php(40): include('/var/www/cms/cu...')
2021-06-25T07:43:52.638917125Z #5 /var/www/cms/phinx.php(34): require('/var/www/cms/we...')
2021-06-25T07:43:52.638919820Z #6 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Config/Config.php(125): include('/var/www/cms/ph...')
2021-06-25T07:43:52.638922587Z #7 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/Command/AbstractCommand.php(266): Phinx\Config\Config::fromPhp('/var/www/cms/ph...')
2021-06-25T07:43:52.638973158Z #8 /var/www/cms/vendor/robmorgan/phinx/src/Phinx/Console/Command/AbstractCommand.php(93): Phinx\Console\Command\AbstractCommand->loadConfig(Object(Symfony\Component\Console\Input\ArgvI in /var/www/cms/custom/XiboForAndroidOnPremise.php on line 53
2021-06-25T07:43:52.642605786Z Importing ca-certs
2021-06-25T07:43:52.643260394Z cp: can't stat '/var/www/cms/ca-certs/*.pem': No such file or directory
2021-06-25T07:43:52.643891592Z cp: can't stat '/var/www/cms/ca-certs/*.crt': No such file or directory
2021-06-25T07:43:52.671043762Z WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
2021-06-25T07:43:52.683073424Z Setting up Quickchart
2021-06-25T07:43:52.707021179Z Configuring Maintenance
2021-06-25T07:43:53.188376537Z Removing web/install/index.php from production container
2021-06-25T07:43:53.226311628Z Starting cron
2021-06-25T07:43:53.226923449Z Starting webserver
2021-06-25T07:43:53.289292377Z AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 172.22.0.6. Set the 'ServerName' directive globally to suppress this message

alex · June 25, 2021, 8:44am

You’ll also need to update your Middleware for your On-Premise license pack. You can download a fresh copy from Customer Portal in the license pool section.

ChrstianM82 · June 25, 2021, 9:08am

We can’ download the module, we get this error from your website:

400 No required SSL certificate was sent (xibosignage.com):

400 Bad Request

No required SSL certificate was sent
nginx

dan · June 25, 2021, 9:23am

Apologies we need to update that link - the correct link is: https://xibo.org.uk/api/downloads/340

Edit: the original link has now been updated in My Products.

ChrstianM82 · June 25, 2021, 10:18am

ok, that problem is fixed, but we run into the next. the Browser tells me:

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.

That is what the log says:

> 2021-06-25T10:08:49.527868237Z      up  20190806144729  2020-02-03 08:22:54  2020-02-03 08:22:54  AddShowContentFromMigration
> 2021-06-25T10:08:49.527930971Z      up  20190823081448  2020-02-03 08:22:54  2020-02-03 08:22:54  AddImageProcessingTaskMigration
> 2021-06-25T10:08:49.527976262Z      up  20190828123735  2020-02-03 08:22:54  2020-02-03 08:22:54  AddDefaultSettingResizeLimitResizeThresholdMigration
> 2021-06-25T10:08:49.528038236Z      up  20190903083314  2020-02-03 08:22:54  2020-02-03 08:22:54  AddGlobalSettingForCascadePermissionsMigration
> 2021-06-25T10:08:49.528076745Z      up  20190905084201  2020-02-03 08:22:54  2020-02-03 08:22:54  AddSettingForDefaultTransitionTypeMigration
> 2021-06-25T10:08:49.528141089Z      up  20190905084642  2020-02-03 08:22:54  2020-02-03 08:22:54  AddSettingForAutoLayoutPublishMigration
> 2021-06-25T10:08:49.528177827Z      up  20190910132520  2020-02-03 08:22:54  2020-02-03 08:22:55  DisplayMoveCmsMigration
> 2021-06-25T10:08:49.528255164Z      up  20190917093141  2020-02-03 08:22:55  2020-02-03 08:22:55  InterruptLayoutMigration
> 2021-06-25T10:08:49.528307637Z      up  20190918090608  2020-02-03 08:22:55  2020-02-03 08:22:55  AddDefaultSettingQuickChartMigration
> 2021-06-25T10:08:49.528382475Z      up  20190919154513  2020-02-03 08:22:55  2020-02-03 08:22:55  AddNotificationAttachmentFilenameNonUsersMigration
> 2021-06-25T10:08:49.528431636Z      up  20190926135518  2020-02-03 08:22:55  2020-02-03 08:22:55  AddSettingForTransitionAutoApplyToLayoutMigration
> 2021-06-25T10:08:49.528520061Z      up  20190926140809  2020-02-03 08:22:55  2020-02-03 08:22:55  InstallSavedReportsAndSpacerModulesMigration
> 2021-06-25T10:08:49.528562431Z      up  20191001092651  2020-02-03 08:22:55  2020-02-03 08:22:55  AddNotificationOriginalFilenameMigration
> 2021-06-25T10:08:49.528631934Z      up  20191022101141  2020-02-27 20:37:02  2020-02-27 20:37:02  AddCommandEntityToPermissionEntityMigration
> 2021-06-25T10:08:49.528686455Z      up  20191024152519  2020-02-27 20:37:02  2020-02-27 20:37:02  AddScheduleExclusionsTableMigration
> 2021-06-25T10:08:49.528760794Z      up  20191122114104  2020-02-03 08:22:55  2020-02-03 08:22:55  FixDuplicateModuleFilesMigration
> 2021-06-25T10:08:49.528823533Z      up  20191126103120  2020-02-27 20:37:02  2020-02-27 20:37:02  GeoScheduleMigration
> 2021-06-25T10:08:49.528893678Z      up  20191126141140  2020-02-27 20:37:02  2020-02-27 20:37:03  RemoteDataSetCsvSourceMigration
> 2021-06-25T10:08:49.528949485Z      up  20191205180116  2020-02-27 20:37:03  2020-02-27 20:37:03  AddPlaylistDashboardPageUserMigration
> 2021-06-25T10:08:49.529025901Z      up  20200107082625  2020-02-27 20:37:03  2020-02-27 20:37:03  DisplayAddResolutionMigration
> 2021-06-25T10:08:49.529066885Z      up  20200115115935  2020-02-27 20:37:03  2020-02-27 20:37:03  AddReportScheduleMessageMigration
> 2021-06-25T10:08:49.529143139Z      up  20200122143630  2020-02-27 20:37:03  2020-02-27 20:37:03  AddReleasedRequiredFileMigration
> 2021-06-25T10:08:49.529188816Z      up  20200122191232  2020-02-27 20:37:03  2020-02-27 20:37:04  AddCommercialLicenceColumnMigration
> 2021-06-25T10:08:49.529268678Z      up  20200129104944  2020-02-27 20:37:04  2020-02-27 20:37:04  AddEngagementsStatsMigration
> 2021-06-25T10:08:49.529313386Z      up  20200130165443  2020-02-27 20:37:04  2020-02-27 20:37:04  CountdownModuleAddMigration
> 2021-06-25T10:08:49.529405154Z    down  20200311110512                                            AddIsDrawerColumnMigration
> 2021-06-25T10:08:49.529444068Z    down  20200311110535                                            CreateActionTableMigration
> 2021-06-25T10:08:49.529529715Z    down  20200319093235                                            ChangeInterruptLayoutMigration
> 2021-06-25T10:08:49.529575487Z    down  20200401121544                                            AddSystemUserSettingMigration
> 2021-06-25T10:08:49.529672460Z    down  20200407143200                                            AddCodeColumnToLayoutMigration
> 2021-06-25T10:08:49.529682682Z    down  20200422101006                                            AddDataSetRowLimitMigration
> 2021-06-25T10:08:49.529761862Z    down  20200427085958                                            AddReportScheduleStartEndMigration
> 2021-06-25T10:08:49.529801062Z    down  20200530103029                                            DisplayRemoteLinksMigration
> 2021-06-25T10:08:49.529870640Z    down  20200604103141                                            CommandImprovementsMigration
> 2021-06-25T10:08:49.529936348Z    down  20200612141755                                            OauthUpgradeMigration
> 2021-06-25T10:08:49.529994748Z    down  20200720092246                                            AddSavedReportSchemaVersionMigration
> 2021-06-25T10:08:49.530089088Z    down  20200916134817                                            RemoveOldScreenshotsMigration
> 2021-06-25T10:08:49.530128118Z    down  20200917140227                                            DisplayGroupCreatedModifiedDates
> 2021-06-25T10:08:49.530226335Z    down  20201007080829                                            AddFoldersMigration
> 2021-06-25T10:08:49.530266208Z    down  20201007093511                                            FeaturesMigration
> 2021-06-25T10:08:49.530327212Z    down  20201025153753                                            RemoveOldPermissionSettingsMigration
> 2021-06-25T10:08:49.530389225Z    down  20210105105646                                            AddMcaasScopeAndRouteMigration
> 2021-06-25T10:08:49.530474068Z    down  20210113134628                                            EnableUserSharingFeatureOnUsersGroupMigration
> 2021-06-25T10:08:49.530518352Z    down  20210201150259                                            UserOnboardingMigration
> 2021-06-25T10:08:49.530572210Z    down  20210305131937                                            FixDuplicateTagsMigration
> 2021-06-25T10:08:49.530681695Z    down  20210407111756                                            RemoveReportNameColumnFromSavedReportMigration
> 2021-06-25T10:08:49.530691292Z    down  20210601104441                                            AddUserAgentToDataSetMigration
> 2021-06-25T10:08:49.530694710Z
> 2021-06-25T10:08:49.534843919Z We will upgrade it, take a backup
> 2021-06-25T10:08:49.681759129Z mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces
> 2021-06-25T10:08:55.777475189Z Running database migrations
> 2021-06-25T10:08:55.817816715Z Phinx by CakePHP - https://phinx.org. 0.9.2
> 2021-06-25T10:08:55.817841090Z
> 2021-06-25T10:08:55.818701509Z using config file .varwwwcmsphinx.php
> 2021-06-25T10:08:55.820674948Z using config parser php
> 2021-06-25T10:08:55.821728943Z using migration paths
> 2021-06-25T10:08:55.822118645Z  - /var/www/cms/db/migrations
> 2021-06-25T10:08:55.822334009Z warning no environment specified, defaulting to: production
> 2021-06-25T10:08:55.822378191Z using adapter mysql
> 2021-06-25T10:08:55.822388988Z using database cms
> 2021-06-25T10:08:55.840621565Z
> 2021-06-25T10:08:55.840969279Z  == 20200311110512 AddIsDrawerColumnMigration: migrating
> 2021-06-25T10:08:56.128758975Z  == 20200311110512 AddIsDrawerColumnMigration: migrated 0.2876s
> 2021-06-25T10:08:56.128787973Z
> 2021-06-25T10:08:56.128797664Z  == 20200311110535 CreateActionTableMigration: migrating
> 2021-06-25T10:08:56.227624427Z  == 20200311110535 CreateActionTableMigration: migrated 0.0986s
> 2021-06-25T10:08:56.227662840Z
> 2021-06-25T10:08:56.227667809Z  == 20200319093235 ChangeInterruptLayoutMigration: migrating
> 2021-06-25T10:08:56.445637617Z  == 20200319093235 ChangeInterruptLayoutMigration: migrated 0.2175s
> 2021-06-25T10:08:56.445673193Z
> 2021-06-25T10:08:56.445694595Z  == 20200401121544 AddSystemUserSettingMigration: migrating
> 2021-06-25T10:08:56.465302568Z  == 20200401121544 AddSystemUserSettingMigration: migrated 0.0194s
> 2021-06-25T10:08:56.465334163Z
> 2021-06-25T10:08:56.465633137Z  == 20200407143200 AddCodeColumnToLayoutMigration: migrating
> 2021-06-25T10:08:56.698194895Z  == 20200407143200 AddCodeColumnToLayoutMigration: migrated 0.2325s
> 2021-06-25T10:08:56.698232273Z
> 2021-06-25T10:08:56.698249506Z  == 20200422101006 AddDataSetRowLimitMigration: migrating
> 2021-06-25T10:08:57.095519597Z  == 20200422101006 AddDataSetRowLimitMigration: migrated 0.3971s
> 2021-06-25T10:08:57.095557919Z
> 2021-06-25T10:08:57.095590441Z  == 20200427085958 AddReportScheduleStartEndMigration: migrating
> 2021-06-25T10:08:57.363677062Z  == 20200427085958 AddReportScheduleStartEndMigration: migrated 0.2677s
> 2021-06-25T10:08:57.363714425Z
> 2021-06-25T10:08:57.363755874Z  == 20200530103029 DisplayRemoteLinksMigration: migrating
> 2021-06-25T10:08:58.281626038Z  == 20200530103029 DisplayRemoteLinksMigration: migrated 0.9178s
> 2021-06-25T10:08:58.281656908Z
> 2021-06-25T10:08:58.281841026Z  == 20200604103141 CommandImprovementsMigration: migrating
> 2021-06-25T10:08:58.789425259Z  == 20200604103141 CommandImprovementsMigration: migrated 0.5077s
> 2021-06-25T10:08:58.789461076Z
> 2021-06-25T10:08:58.789681435Z  == 20200612141755 OauthUpgradeMigration: migrating
> 2021-06-25T10:08:59.261751198Z  == 20200612141755 OauthUpgradeMigration: migrated 0.4721s
> 2021-06-25T10:08:59.261782017Z
> 2021-06-25T10:08:59.261786825Z  == 20200720092246 AddSavedReportSchemaVersionMigration: migrating
> 2021-06-25T10:08:59.427038449Z  == 20200720092246 AddSavedReportSchemaVersionMigration: migrated 0.1652s
> 2021-06-25T10:08:59.427068581Z
> 2021-06-25T10:08:59.427270282Z  == 20200916134817 RemoveOldScreenshotsMigration: migrating
> 2021-06-25T10:08:59.447351174Z  == 20200916134817 RemoveOldScreenshotsMigration: migrated 0.0192s
> 2021-06-25T10:08:59.447380037Z
> 2021-06-25T10:08:59.447384093Z  == 20200917140227 DisplayGroupCreatedModifiedDates: migrating
> 2021-06-25T10:08:59.785410465Z  == 20200917140227 DisplayGroupCreatedModifiedDates: migrated 0.3389s
> 2021-06-25T10:08:59.785439361Z
> 2021-06-25T10:08:59.785444323Z  == 20201007080829 AddFoldersMigration: migrating
> 2021-06-25T10:09:02.781609428Z
> 2021-06-25T10:09:02.793822531Z In PdoAdapter.php line 134:
> 2021-06-25T10:09:02.793857141Z
> 2021-06-25T10:09:02.793872548Z   SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '0
> 2021-06-25T10:09:02.793875190Z   000-00-00 00:00:00' for column 'createdDt' at row 1
> 2021-06-25T10:09:02.793877785Z
> 2021-06-25T10:09:02.793880800Z
> 2021-06-25T10:09:02.793947718Z migrate [-c|--configuration CONFIGURATION] [-p|--parser PARSER] [-e|--environment ENVIRONMENT] [-t|--target TARGET] [-d|--date DATE] [-x|--dry-run]
> 2021-06-25T10:09:02.793953379Z
> 2021-06-25T10:09:02.799404321Z Importing ca-certs
> 2021-06-25T10:09:02.800122052Z cp: can't stat '/var/www/cms/ca-certs/*.pem': No such file or directory
> 2021-06-25T10:09:02.800714574Z cp: can't stat '/var/www/cms/ca-certs/*.crt': No such file or directory
> 2021-06-25T10:09:03.036045094Z WARNING: ca-certificates.crt does not contain exactly one certificate or CRL: skipping
> 2021-06-25T10:09:03.048517497Z Setting up Quickchart
> 2021-06-25T10:09:03.072579473Z Configuring Maintenance
> 2021-06-25T10:09:03.548964339Z Removing web/install/index.php from production container
> 2021-06-25T10:09:03.625356263Z Starting cron
> 2021-06-25T10:09:03.626192830Z Starting webserver
> 2021-06-25T10:09:03.932488217Z AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 172.26.0.6. Set the 'ServerName' directive globally to suppress this message

ChrstianM82 · June 25, 2021, 10:34am

I was able to fix it. I run this procedere:

restoring the V2.3.6
docker-compose pull
copy the content from https://github.com/xibosignage/xibo-cms/releases/download/3.0.0/xibo-docker.tar.gz into the folder
docker-compose stop
docker-compose down
add this line to the compose file:

command: mysqld --sql_mode=“ONLY_FULL_GROUP_BY,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”

docker-compose up -d

ChrstianM82 · June 25, 2021, 11:06am

and again we restored back to 2.3.6
After the first login it looked fine, but all layouts were black. No media was loaded from the library. I checked the library and found a lot of files, much more than before (10x more). The download from the library works, so the files are still there.

dan · June 25, 2021, 11:35am

When you say there are 10x more files in the library than before, can you elaborate? What are these new files you’re seeing in there?

ChrstianM82 · June 25, 2021, 11:46am

For example: We have one PDF with the current corona information. This PDF is often replaced by a new version. It looks like, that after the update, I see all versions of this file in the library. Same name, diffrent ID’s.

After the restore, our displays could load the files from the library, but not the text elemets. We had to checkout and checkin every layout, now it works.

dan · June 25, 2021, 11:51am

I’ve recreated that issue thank you - see

dan · June 25, 2021, 3:55pm

I think this probably is due to the “Verify module files” routine not being correctly run by the upgrader. I’ve created an issue for us to track that:

Thanks for your help.

ChrstianM82 · June 28, 2021, 7:51am

Ok, so the command in the compose file I added can’t be the cause?

system · September 27, 2021, 1:52pm

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.