Xibo update issues

I have followed the docker upgrade guide for Xibo and made sure to stay within the versioning jumps. Currently running 1.8.X and can’t get the upgrade to take to 2.3.12. No errors appear during docker-compose down/up and xibo starts up the four new containers. I can’t get to the web portal though. Have attempted a few times seeing if I missed a step or used the wrong version to no avail.

Hello and welcome to the Community!

What is showing in the docker logs?

docker-compose [-f custom file if you're using it] logs cms-web

Let me spin the update back up and I will post the logs. Had to roll back so we could do some signage updates.

Attaching to xibo_cms-web_1
cms-web_1 | Waiting for MySQL to start - max 300 seconds
cms-web_1 | MySQL started
cms-web_1 | Updating settings.php
cms-web_1 | settingId
cms-web_1 | 1
cms-web_1 | Existing Database, checking if we need to upgrade it
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 | ordering by creation time
cms-web_1 |
cms-web_1 | Status [Migration ID] Started Finished Migration Name
cms-web_1 | ----------------------------------------------------------------------------------
cms-web_1 | down 20180130073838 InstallMigration
cms-web_1 | down 20180131113100 OldUpgradeStep85Migration
cms-web_1 | down 20180131113853 OldUpgradeStep86Migration
cms-web_1 | down 20180131113941 OldUpgradeStep87Migration
cms-web_1 | down 20180131113948 OldUpgradeStep88Migration
cms-web_1 | down 20180131113952 OldUpgradeStep92Migration
cms-web_1 | down 20180131113957 OldUpgradeStep120Migration
cms-web_1 | down 20180131114002 OldUpgradeStep121Migration
cms-web_1 | down 20180131114007 OldUpgradeStep122Migration
cms-web_1 | down 20180131114013 OldUpgradeStep123Migration
cms-web_1 | down 20180131114017 OldUpgradeStep124Migration
cms-web_1 | down 20180131114021 OldUpgradeStep125Migration
cms-web_1 | down 20180131114025 OldUpgradeStep126Migration
cms-web_1 | down 20180131114030 OldUpgradeStep127Migration
cms-web_1 | down 20180131114050 OldUpgradeStep128Migration
cms-web_1 | down 20180131114058 OldUpgradeStep129Migration
cms-web_1 | down 20180131114103 OldUpgradeStep130Migration
cms-web_1 | down 20180131114107 OldUpgradeStep131Migration
cms-web_1 | down 20180131114110 OldUpgradeStep132Migration
cms-web_1 | down 20180131114114 OldUpgradeStep133Migration
cms-web_1 | down 20180131114118 OldUpgradeStep134Migration
cms-web_1 | down 20180131114123 OldUpgradeStep135Migration
cms-web_1 | down 20180131122645 OneRegionPerPlaylistMigration
cms-web_1 | down 20180131123038 PlaylistTagsMigration
cms-web_1 | down 20180131123248 WidgetFromToDtMigration
cms-web_1 | down 20180212143336 DaypartSystemEntriesAsRecords
cms-web_1 | down 20180213173846 MailFromNameSettingMigration
cms-web_1 | down 20180219141257 DisplayGroupClosureIndexToNonUnique
cms-web_1 | down 20180223180534 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | down 20180302182421 WidgetCreatedAndModifiedDtMigration
cms-web_1 | down 20180313085749 MediaTableEditedIdIndexMigration
cms-web_1 | down 20180320154652 PlaylistAddDynamicFilterMigration
cms-web_1 | down 20180327153325 RemoveUserLoggedInMigration
cms-web_1 | down 20180514114415 FixCaseOnHelpTextFieldMigration
cms-web_1 | down 20180515123835 LayoutPublishDraftMigration
cms-web_1 | down 20180529065816 DataSetTruncateFixMigration
cms-web_1 | down 20180529073531 DisplayAsVncLinkMigration
cms-web_1 | down 20180621134013 AddWidgetSyncTaskMigration
cms-web_1 | down 20180621134250 EventLayoutPermissionSettingMigration
cms-web_1 | down 20180906115552 AddForeignKeysToTagsMigration
cms-web_1 | down 20180906115606 AddForeignKeysToPermissionsMigration
cms-web_1 | down 20180906115712 AddForeignKeysToWidgetMediaMigration
cms-web_1 | down 20180906131643 ForgottenPasswordReminderMigration
cms-web_1 | down 20180906131716 DataSetRssMigration
cms-web_1 | down 20181011160130 SimpleSettingsMigration
cms-web_1 | down 20181113173310 RemoveFinanceModuleMigration
cms-web_1 | down 20181113180337 SplitTickerModuleMigration
cms-web_1 | down 20181126113231 Release1812Migration
cms-web_1 | down 20181210092443 RemoveImageUriModuleMigration
cms-web_1 | down 20181212114400 CreatePlayerVersionsTableMigration
cms-web_1 | down 20181217135044 EventSyncMigration
cms-web_1 | down 20190121092556 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | down 20190125170130 PlayerSoftwareVersionFieldMigration
cms-web_1 | down 20190129103831 AddLinuxDisplayProfileMigration
cms-web_1 | down 20190212112534 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | down 20190212115432 AddDefaultTransitionDurationSettingMigration
cms-web_1 | down 20190213160914 AddGlobalStatSettingMigration
cms-web_1 | down 20190213162212 AddHorizontalMenuSettingMigration
cms-web_1 | down 20190214102508 AddLayoutEnableStat
cms-web_1 | down 20190214102516 AddMediaEnableStat
cms-web_1 | down 20190220165703 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | down 20190227101705 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | down 20190228120603 AddDynamicCriteriaTagsMigration
cms-web_1 | down 20190301115046 AdjustGenericfileValidExtensionsMigration
cms-web_1 | down 20190315134628 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | down 20190322162052 AddPublishedDateColumnMigration
cms-web_1 | down 20190326163016 CreateLayoutHistoryTableMigration
cms-web_1 | down 20190328111718 AddCampaignStatMigration
cms-web_1 | down 20190401150256 AddScheduleNowPageMigration
cms-web_1 | down 20190509101525 CreateReportScheduleTableMigration
cms-web_1 | down 20190509102648 CreateSavedReportTableMigration
cms-web_1 | down 20190509113001 AddReportPageMigration
cms-web_1 | down 20190510140126 TwoFactorAuthMigration
cms-web_1 | down 20190514134430 NullableTextFieldsMigration
cms-web_1 | down 20190515094133 AddHtmlDatatypeMigration
cms-web_1 | down 20190515105624 InstallAdditionalStandardModulesMigration
cms-web_1 | down 20190517080033 AddForeignKeysToLktagTablesMigration
cms-web_1 | down 20190521092700 AddReportScheduleTaskMigration
cms-web_1 | down 20190521092930 AddPreviousRunDateReportScheduleMigration
cms-web_1 | down 20190521102635 PlaylistDurationUpdateAtTimestamp
cms-web_1 | down 20190603083836 ChangeStatTableStartEndColumnMigration
cms-web_1 | down 20190610150331 TagsWithValuesMigration
cms-web_1 | down 20190611145607 RemoveOldVersionTableMigration
cms-web_1 | down 20190612140955 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | down 20190620112611 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | down 20190620142655 AddPlaylistEnableStatMigration
cms-web_1 | down 20190626091331 WidgetHistoryMigration
cms-web_1 | down 20190626110359 CreateStatTableMigration
cms-web_1 | down 20190628083649 AddStatsMigrationTaskMigration
cms-web_1 | down 20190710213414 AddIsActiveReportScheduleMigration
cms-web_1 | down 20190717101342 NullableCommandValidationStringMigration
cms-web_1 | down 20190719074601 MissingDefaultValueMigration
cms-web_1 | down 20190725115532 AddScheduleReminderTaskMigration
cms-web_1 | down 20190801102042 DisplayProfileCommandLinkFixMigration
cms-web_1 | down 20190801141737 DatasetAddCustomHeadersColumnMigration
cms-web_1 | down 20190801142302 AddDoohUserTypeMigration
cms-web_1 | down 20190802145636 CreateScheduleReminderTableMigration
cms-web_1 | down 20190806144729 AddShowContentFromMigration
cms-web_1 | down 20190823081448 AddImageProcessingTaskMigration
cms-web_1 | down 20190828123735 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | down 20190903083314 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | down 20190905084201 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | down 20190905084642 AddSettingForAutoLayoutPublishMigration
cms-web_1 | down 20190910132520 DisplayMoveCmsMigration
cms-web_1 | down 20190917093141 InterruptLayoutMigration
cms-web_1 | down 20190918090608 AddDefaultSettingQuickChartMigration
cms-web_1 | down 20190919154513 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | down 20190926135518 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | down 20190926140809 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | down 20191001092651 AddNotificationOriginalFilenameMigration
cms-web_1 | down 20191022101141 AddCommandEntityToPermissionEntityMigration
cms-web_1 | down 20191024152519 AddScheduleExclusionsTableMigration
cms-web_1 | down 20191122114104 FixDuplicateModuleFilesMigration
cms-web_1 | down 20191126103120 GeoScheduleMigration
cms-web_1 | down 20191126141140 RemoteDataSetCsvSourceMigration
cms-web_1 | down 20191205180116 AddPlaylistDashboardPageUserMigration
cms-web_1 | down 20200107082625 DisplayAddResolutionMigration
cms-web_1 | down 20200115115935 AddReportScheduleMessageMigration
cms-web_1 | down 20200122143630 AddReleasedRequiredFileMigration
cms-web_1 | down 20200122191232 AddCommercialLicenceColumnMigration
cms-web_1 | down 20200129104944 AddEngagementsStatsMigration
cms-web_1 | down 20200130165443 CountdownModuleAddMigration
cms-web_1 |
cms-web_1 | We will upgrade it, take a backup
cms-web_1 | mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

I have followed the above adding in the command line but it doesn’t resolve the issue. Looking further shows modifying the SQL account or the password complexity is an issue but I am unsure the direction to take.

The logs show that it is in the middle of taking a backup. If your database is large (with a lot of proof of play for example) it will take some time to take the backup and then to actually do the upgrade, so you will need to wait :slight_smile:

Once it’s done taking a backup, it will then proceed. The message about PROCESS is normal and can be ignored

The linked post to is specifically for 3.0.0-rc versions and so you should not be making the patch mentioned.

1 Like

Alright will get it back to that state and just let it run. I know the lib folder is around 50 gigs at this point and around 250 displays. Will follow up just to get this post wrapped up if its resolved with a bit a patience.

Alright an hour later and its up and running on version 2.3.12! I didn’t anticipate the extra wait time after the updating during the compose up -d command. Thanks for the fantastic fast response.

1 Like
The Xibo Community site uses cookies. What are cookies?