The CMS is temporarily offline after Xibo CMS upgrade (Docker, Ubuntu)

missionit · January 17, 2023, 6:47pm

Hello

I have Xibo CMS 3.0.2 running in a docker on Ubuntu 22.04.1, I followed the instructions to upgrade to the latest release here: Upgrade Xibo for Docker Install | Xibo Digital Signage. Upon following those instructions, Xibo is inaccessible with the error “The CMS is temporarily offline due to an update in progress. Please check with your system administrator for updates or refresh the page in a few minutes.”. I noticed in the console output, a mysql error that the user needs the PROCESS privilege, I went through the steps to add that privilege, which did not resolve the error. I went ahead and added that privilege to every single user that mysql listed, but the error persisted. I’m not too familiar with working in depth with mysql and linux in general, so please bear with me. (rolling back to 3.0.2 immediately brings Xibo back online without any error)
Any help is greatly appreciated, I’m sure I’m just missing some small detail somewhere.

cms-web_1         | Waiting for MySQL to start - max 300 seconds
cms-web_1         | MySQL started
cms-web_1         | Configuring MySQL cnf file
cms-web_1         | Updating settings.php
cms-web_1         | settingId
cms-web_1         | 3
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         |      up  20180130073838  2021-11-02 20:14:22  2021-11-02 20:14:27  InstallMigration
cms-web_1         |      up  20180131113100  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep85Migration
cms-web_1         |      up  20180131113853  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep86Migration
cms-web_1         |      up  20180131113941  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep87Migration
cms-web_1         |      up  20180131113948  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep88Migration
cms-web_1         |      up  20180131113952  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep92Migration
cms-web_1         |      up  20180131113957  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep120Migration
cms-web_1         |      up  20180131114002  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep121Migration
cms-web_1         |      up  20180131114007  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep122Migration
cms-web_1         |      up  20180131114013  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep123Migration
cms-web_1         |      up  20180131114017  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep124Migration
cms-web_1         |      up  20180131114021  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep125Migration
cms-web_1         |      up  20180131114025  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep126Migration
cms-web_1         |      up  20180131114030  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep127Migration
cms-web_1         |      up  20180131114050  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep128Migration
cms-web_1         |      up  20180131114058  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep129Migration
cms-web_1         |      up  20180131114103  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep130Migration
cms-web_1         |      up  20180131114107  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep131Migration
cms-web_1         |      up  20180131114110  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep132Migration
cms-web_1         |      up  20180131114114  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep133Migration
cms-web_1         |      up  20180131114118  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep134Migration
cms-web_1         |      up  20180131114123  2021-11-02 20:14:27  2021-11-02 20:14:27  OldUpgradeStep135Migration
cms-web_1         |      up  20180131122645  2021-11-02 20:14:27  2021-11-02 20:14:27  OneRegionPerPlaylistMigration
cms-web_1         |      up  20180131123038  2021-11-02 20:14:27  2021-11-02 20:14:28  PlaylistTagsMigration
cms-web_1         |      up  20180131123248  2021-11-02 20:14:28  2021-11-02 20:14:28  WidgetFromToDtMigration
cms-web_1         |      up  20180212143336  2021-11-02 20:14:28  2021-11-02 20:14:28  DaypartSystemEntriesAsRecords
cms-web_1         |      up  20180213173846  2021-11-02 20:14:28  2021-11-02 20:14:28  MailFromNameSettingMigration
cms-web_1         |      up  20180219141257  2021-11-02 20:14:28  2021-11-02 20:14:28  DisplayGroupClosureIndexToNonUnique
cms-web_1         |      up  20180223180534  2021-11-02 20:14:28  2021-11-02 20:14:28  DataSetColumnFilterAndSortOptionsMigration
cms-web_1         |      up  20180302182421  2021-11-02 20:14:28  2021-11-02 20:14:29  WidgetCreatedAndModifiedDtMigration
cms-web_1         |      up  20180313085749  2021-11-02 20:14:29  2021-11-02 20:14:29  MediaTableEditedIdIndexMigration
cms-web_1         |      up  20180320154652  2021-11-02 20:14:29  2021-11-02 20:14:29  PlaylistAddDynamicFilterMigration
cms-web_1         |      up  20180327153325  2021-11-02 20:14:29  2021-11-02 20:14:29  RemoveUserLoggedInMigration
cms-web_1         |      up  20180514114415  2021-11-02 20:14:29  2021-11-02 20:14:29  FixCaseOnHelpTextFieldMigration
cms-web_1         |      up  20180515123835  2021-11-02 20:14:29  2021-11-02 20:14:30  LayoutPublishDraftMigration
cms-web_1         |      up  20180529065816  2021-11-02 20:14:30  2021-11-02 20:14:30  DataSetTruncateFixMigration
cms-web_1         |      up  20180529073531  2021-11-02 20:14:30  2021-11-02 20:14:30  DisplayAsVncLinkMigration
cms-web_1         |      up  20180621134013  2021-11-02 20:14:30  2021-11-02 20:14:30  AddWidgetSyncTaskMigration
cms-web_1         |      up  20180621134250  2021-11-02 20:14:30  2021-11-02 20:14:30  EventLayoutPermissionSettingMigration
cms-web_1         |      up  20180906115552  2021-11-02 20:14:30  2021-11-02 20:14:30  AddForeignKeysToTagsMigration
cms-web_1         |      up  20180906115606  2021-11-02 20:14:30  2021-11-02 20:14:30  AddForeignKeysToPermissionsMigration
cms-web_1         |      up  20180906115712  2021-11-02 20:14:30  2021-11-02 20:14:30  AddForeignKeysToWidgetMediaMigration
cms-web_1         |      up  20180906131643  2021-11-02 20:14:30  2021-11-02 20:14:30  ForgottenPasswordReminderMigration
cms-web_1         |      up  20180906131716  2021-11-02 20:14:30  2021-11-02 20:14:30  DataSetRssMigration
cms-web_1         |      up  20181011160130  2021-11-02 20:14:30  2021-11-02 20:14:31  SimpleSettingsMigration
cms-web_1         |      up  20181113173310  2021-11-02 20:14:31  2021-11-02 20:14:31  RemoveFinanceModuleMigration
cms-web_1         |      up  20181113180337  2021-11-02 20:14:31  2021-11-02 20:14:31  SplitTickerModuleMigration
cms-web_1         |      up  20181126113231  2021-11-02 20:14:31  2021-11-02 20:14:31  Release1812Migration
cms-web_1         |      up  20181210092443  2021-11-02 20:14:31  2021-11-02 20:14:31  RemoveImageUriModuleMigration
cms-web_1         |      up  20181212114400  2021-11-02 20:14:31  2021-11-02 20:14:31  CreatePlayerVersionsTableMigration
cms-web_1         |      up  20181217135044  2021-11-02 20:14:31  2021-11-02 20:14:32  EventSyncMigration
cms-web_1         |      up  20190121092556  2021-11-02 20:14:32  2021-11-02 20:14:32  PlayerUpgradeAndOverrideConfigMigration
cms-web_1         |      up  20190125170130  2021-11-02 20:14:32  2021-11-02 20:14:32  PlayerSoftwareVersionFieldMigration
cms-web_1         |      up  20190129103831  2021-11-02 20:14:32  2021-11-02 20:14:32  AddLinuxDisplayProfileMigration
cms-web_1         |      up  20190212112534  2021-11-02 20:14:32  2021-11-02 20:14:32  AddProofOfPlayStatsDurationAndCountMigration
cms-web_1         |      up  20190212115432  2021-11-02 20:14:32  2021-11-02 20:14:32  AddDefaultTransitionDurationSettingMigration
cms-web_1         |      up  20190213160914  2021-11-02 20:14:32  2021-11-02 20:14:32  AddGlobalStatSettingMigration
cms-web_1         |      up  20190213162212  2021-11-02 20:14:32  2021-11-02 20:14:32  AddHorizontalMenuSettingMigration
cms-web_1         |      up  20190214102508  2021-11-02 20:14:32  2021-11-02 20:14:32  AddLayoutEnableStat
cms-web_1         |      up  20190214102516  2021-11-02 20:14:32  2021-11-02 20:14:32  AddMediaEnableStat
cms-web_1         |      up  20190220165703  2021-11-02 20:14:32  2021-11-02 20:14:32  AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1         |      up  20190227101705  2021-11-02 20:14:32  2021-11-02 20:14:32  MakeDisplayLicenseColumnUniqueMigration
cms-web_1         |      up  20190228120603  2021-11-02 20:14:32  2021-11-02 20:14:33  AddDynamicCriteriaTagsMigration
cms-web_1         |      up  20190301115046  2021-11-02 20:14:33  2021-11-02 20:14:33  AdjustGenericfileValidExtensionsMigration
cms-web_1         |      up  20190315134628  2021-11-02 20:14:33  2021-11-02 20:14:33  AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1         |      up  20190322162052  2021-11-02 20:14:33  2021-11-02 20:14:33  AddPublishedDateColumnMigration
cms-web_1         |      up  20190326163016  2021-11-02 20:14:33  2021-11-02 20:14:33  CreateLayoutHistoryTableMigration
cms-web_1         |      up  20190328111718  2021-11-02 20:14:33  2021-11-02 20:14:33  AddCampaignStatMigration
cms-web_1         |      up  20190401150256  2021-11-02 20:14:33  2021-11-02 20:14:33  AddScheduleNowPageMigration
cms-web_1         |      up  20190509101525  2021-11-02 20:14:33  2021-11-02 20:14:33  CreateReportScheduleTableMigration
cms-web_1         |      up  20190509102648  2021-11-02 20:14:33  2021-11-02 20:14:33  CreateSavedReportTableMigration
cms-web_1         |      up  20190509113001  2021-11-02 20:14:33  2021-11-02 20:14:33  AddReportPageMigration
cms-web_1         |      up  20190510140126  2021-11-02 20:14:33  2021-11-02 20:14:33  TwoFactorAuthMigration
cms-web_1         |      up  20190514134430  2021-11-02 20:14:33  2021-11-02 20:14:35  NullableTextFieldsMigration
cms-web_1         |      up  20190515094133  2021-11-02 20:14:35  2021-11-02 20:14:35  AddHtmlDatatypeMigration
cms-web_1         |      up  20190515105624  2021-11-02 20:14:35  2021-11-02 20:14:35  InstallAdditionalStandardModulesMigration
cms-web_1         |      up  20190517080033  2021-11-02 20:14:35  2021-11-02 20:14:35  AddForeignKeysToLktagTablesMigration
cms-web_1         |      up  20190521092700  2021-11-02 20:14:35  2021-11-02 20:14:35  AddReportScheduleTaskMigration
cms-web_1         |      up  20190521092930  2021-11-02 20:14:35  2021-11-02 20:14:36  AddPreviousRunDateReportScheduleMigration
cms-web_1         |      up  20190521102635  2021-11-02 20:14:36  2021-11-02 20:14:36  PlaylistDurationUpdateAtTimestamp
cms-web_1         |      up  20190603083836  2021-11-02 20:14:36  2021-11-02 20:14:36  ChangeStatTableStartEndColumnMigration
cms-web_1         |      up  20190610150331  2021-11-02 20:14:36  2021-11-02 20:14:37  TagsWithValuesMigration
cms-web_1         |      up  20190611145607  2021-11-02 20:14:37  2021-11-02 20:14:37  RemoveOldVersionTableMigration
cms-web_1         |      up  20190612140955  2021-11-02 20:14:37  2021-11-02 20:14:38  DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1         |      up  20190620112611  2021-11-02 20:14:38  2021-11-02 20:14:38  MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1         |      up  20190620142655  2021-11-02 20:14:38  2021-11-02 20:14:38  AddPlaylistEnableStatMigration
cms-web_1         |      up  20190626091331  2021-11-02 20:14:38  2021-11-02 20:14:38  WidgetHistoryMigration
cms-web_1         |      up  20190626110359  2021-11-02 20:14:38  2021-11-02 20:14:38  CreateStatTableMigration
cms-web_1         |      up  20190628083649  2021-11-02 20:14:38  2021-11-02 20:14:38  AddStatsMigrationTaskMigration
cms-web_1         |      up  20190710213414  2021-11-02 20:14:38  2021-11-02 20:14:38  AddIsActiveReportScheduleMigration
cms-web_1         |      up  20190717101342  2021-11-02 20:14:38  2021-11-02 20:14:38  NullableCommandValidationStringMigration
cms-web_1         |      up  20190719074601  2021-11-02 20:14:38  2021-11-02 20:14:38  MissingDefaultValueMigration
cms-web_1         |      up  20190725115532  2021-11-02 20:14:38  2021-11-02 20:14:38  AddScheduleReminderTaskMigration
cms-web_1         |      up  20190801102042  2021-11-02 20:14:38  2021-11-02 20:14:38  DisplayProfileCommandLinkFixMigration
cms-web_1         |      up  20190801141737  2021-11-02 20:14:38  2021-11-02 20:14:38  DatasetAddCustomHeadersColumnMigration
cms-web_1         |      up  20190801142302  2021-11-02 20:14:38  2021-11-02 20:14:38  AddDoohUserTypeMigration
cms-web_1         |      up  20190802145636  2021-11-02 20:14:38  2021-11-02 20:14:38  CreateScheduleReminderTableMigration
cms-web_1         |      up  20190806144729  2021-11-02 20:14:38  2021-11-02 20:14:38  AddShowContentFromMigration
cms-web_1         |      up  20190823081448  2021-11-02 20:14:38  2021-11-02 20:14:38  AddImageProcessingTaskMigration
cms-web_1         |      up  20190828123735  2021-11-02 20:14:38  2021-11-02 20:14:38  AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1         |      up  20190903083314  2021-11-02 20:14:38  2021-11-02 20:14:38  AddGlobalSettingForCascadePermissionsMigration
cms-web_1         |      up  20190905084201  2021-11-02 20:14:38  2021-11-02 20:14:38  AddSettingForDefaultTransitionTypeMigration
cms-web_1         |      up  20190905084642  2021-11-02 20:14:38  2021-11-02 20:14:38  AddSettingForAutoLayoutPublishMigration
cms-web_1         |      up  20190910132520  2021-11-02 20:14:38  2021-11-02 20:14:39  DisplayMoveCmsMigration
cms-web_1         |      up  20190917093141  2021-11-02 20:14:39  2021-11-02 20:14:39  InterruptLayoutMigration
cms-web_1         |      up  20190918090608  2021-11-02 20:14:39  2021-11-02 20:14:39  AddDefaultSettingQuickChartMigration
cms-web_1         |      up  20190919154513  2021-11-02 20:14:39  2021-11-02 20:14:39  AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1         |      up  20190926135518  2021-11-02 20:14:39  2021-11-02 20:14:39  AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1         |      up  20190926140809  2021-11-02 20:14:39  2021-11-02 20:14:39  InstallSavedReportsAndSpacerModulesMigration
cms-web_1         |      up  20191001092651  2021-11-02 20:14:39  2021-11-02 20:14:39  AddNotificationOriginalFilenameMigration
cms-web_1         |      up  20191022101141  2021-11-02 20:14:39  2021-11-02 20:14:39  AddCommandEntityToPermissionEntityMigration
cms-web_1         |      up  20191024152519  2021-11-02 20:14:39  2021-11-02 20:14:39  AddScheduleExclusionsTableMigration
cms-web_1         |      up  20191122114104  2021-11-02 20:14:39  2021-11-02 20:14:39  FixDuplicateModuleFilesMigration
cms-web_1         |      up  20191126103120  2021-11-02 20:14:39  2021-11-02 20:14:39  GeoScheduleMigration
cms-web_1         |      up  20191126141140  2021-11-02 20:14:39  2021-11-02 20:14:40  RemoteDataSetCsvSourceMigration
cms-web_1         |      up  20191205180116  2021-11-02 20:14:40  2021-11-02 20:14:40  AddPlaylistDashboardPageUserMigration
cms-web_1         |      up  20200107082625  2021-11-02 20:14:40  2021-11-02 20:14:40  DisplayAddResolutionMigration
cms-web_1         |      up  20200115115935  2021-11-02 20:14:40  2021-11-02 20:14:40  AddReportScheduleMessageMigration
cms-web_1         |      up  20200122143630  2021-11-02 20:14:40  2021-11-02 20:14:40  AddReleasedRequiredFileMigration
cms-web_1         |      up  20200122191232  2021-11-02 20:14:40  2021-11-02 20:14:40  AddCommercialLicenceColumnMigration
cms-web_1         |      up  20200129104944  2021-11-02 20:14:40  2021-11-02 20:14:40  AddEngagementsStatsMigration
cms-web_1         |      up  20200130165443  2021-11-02 20:14:40  2021-11-02 20:14:40  CountdownModuleAddMigration
cms-web_1         |      up  20200311110512  2021-11-02 20:14:40  2021-11-02 20:14:41  AddIsDrawerColumnMigration
cms-web_1         |      up  20200311110535  2021-11-02 20:14:41  2021-11-02 20:14:41  CreateActionTableMigration
cms-web_1         |      up  20200319093235  2021-11-02 20:14:41  2021-11-02 20:14:41  ChangeInterruptLayoutMigration
cms-web_1         |      up  20200401121544  2021-11-02 20:14:41  2021-11-02 20:14:41  AddSystemUserSettingMigration
cms-web_1         |      up  20200407143200  2021-11-02 20:14:41  2021-11-02 20:14:41  AddCodeColumnToLayoutMigration
cms-web_1         |      up  20200422101006  2021-11-02 20:14:41  2021-11-02 20:14:41  AddDataSetRowLimitMigration
cms-web_1         |      up  20200427085958  2021-11-02 20:14:41  2021-11-02 20:14:42  AddReportScheduleStartEndMigration
cms-web_1         |      up  20200530103029  2021-11-02 20:14:42  2021-11-02 20:14:42  DisplayRemoteLinksMigration
cms-web_1         |      up  20200604103141  2021-11-02 20:14:42  2021-11-02 20:14:42  CommandImprovementsMigration
cms-web_1         |      up  20200612141755  2021-11-02 20:14:42  2021-11-02 20:14:42  OauthUpgradeMigration
cms-web_1         |      up  20200720092246  2021-11-02 20:14:42  2021-11-02 20:14:42  AddSavedReportSchemaVersionMigration
cms-web_1         |      up  20200916134817  2021-11-02 20:14:42  2021-11-02 20:14:42  RemoveOldScreenshotsMigration
cms-web_1         |      up  20200917140227  2021-11-02 20:14:42  2021-11-02 20:14:42  DisplayGroupCreatedModifiedDates
cms-web_1         |      up  20201007080829  2021-11-02 20:14:42  2021-11-02 20:14:44  AddFoldersMigration
cms-web_1         |      up  20201007093511  2021-11-02 20:14:44  2021-11-02 20:14:44  FeaturesMigration
cms-web_1         |      up  20201025153753  2021-11-02 20:14:44  2021-11-02 20:14:44  RemoveOldPermissionSettingsMigration
cms-web_1         |      up  20210105105646  2021-11-02 20:14:44  2021-11-02 20:14:44  AddMcaasScopeAndRouteMigration
cms-web_1         |      up  20210113134628  2021-11-02 20:14:44  2021-11-02 20:14:44  EnableUserSharingFeatureOnUsersGroupMigration
cms-web_1         |      up  20210201150259  2021-11-02 20:14:44  2021-11-02 20:14:45  UserOnboardingMigration
cms-web_1         |      up  20210305131937  2021-11-02 20:14:45  2021-11-02 20:14:45  FixDuplicateTagsMigration
cms-web_1         |      up  20210407111756  2021-11-02 20:14:45  2021-11-02 20:14:45  RemoveReportNameColumnFromSavedReportMigration
cms-web_1         |      up  20210601104441  2021-11-02 20:14:45  2021-11-02 20:14:45  AddUserAgentToDataSetMigration
cms-web_1         |    down  20210128143602                                            MenuBoardsMigration
cms-web_1         |    down  20210421142731                                            RemoveMaintenanceKeyMigration
cms-web_1         |    down  20210603114231                                            NewCalendarTypeMigration
cms-web_1         |    down  20210608142925                                            AddOrientationToResolutionAndMediaMigration
cms-web_1         |    down  20210611122809                                            AddPurgeListTableMigration
cms-web_1         |    down  20210806122814                                            AddNumberOfItemsToPlaylistMigration
cms-web_1         |    down  20210813094723                                            AddCycleBasedPlaybackOptionToCampaignMigration
cms-web_1         |    down  20210817105702                                            AddCustomSeparatorToDatasetMigration
cms-web_1         |    down  20210820100520                                            AddActionEventTypeMigration
cms-web_1         |    down  20210901134913                                            AddIpAddressColumnToAuditLogMigration
cms-web_1         |    down  20210901150615                                            AddTooltipAndIsRequiredColumnsMigration
cms-web_1         |    down  20211109130951                                            FixOrphanedDisplayGroupsMigration
cms-web_1         |    down  20211109134929                                            FixPlaylistManagerUserGroupMigration
cms-web_1         |    down  20211109141925                                            DatasetAddOptionToTruncateOnNoNewDataMigration
cms-web_1         |    down  20211116153103                                            ConnectorsMigration
cms-web_1         |    down  20211231141457                                            AddMoreTagFilteringOptionsMigration
cms-web_1         |    down  20211231153355                                            AddIsCustomToDisplayProfileMigration
cms-web_1         |    down  20220117150212                                            AddLayoutExchangeConnectorMigration
cms-web_1         |    down  20220119124436                                            AddCodeColumnToMenuBoardsMigration
cms-web_1         |    down  20220131151346                                            AddDateFormatToDataSetColumnMigration
cms-web_1         |    down  20220201163832                                            ReportLogoMigration
cms-web_1         |    down  20220203145712                                            ApplicationsTweaksMigration
cms-web_1         |    down  20220207160047                                            TidyCalendarModuleTypes
cms-web_1         |    down  20220224130122                                            AddResolutionRoutesToDesignScopeMigration
cms-web_1         |    down  20220225105237                                            MergeWeatherWidgets
cms-web_1         |    down  20220302152503                                            LayoutRemoveOrientationMigration
cms-web_1         |    down  20220307134554                                            AddWorldClockMigration
cms-web_1         |    down  20220906085300                                            ThreeTwoZeroMigration
cms-web_1         |    down  20220907135653                                            AddLogicalOperatorNameMigration
cms-web_1         |    down  20220907143500                                            UserHomeFolderMigration
cms-web_1         |    down  20221013103000                                            AdvertisingConnectorsMigration
cms-web_1         |    down  20221024082400                                            AdCampaignMigration
cms-web_1         |    down  20221101090337                                            CreateDisplayTypeTableMigration
cms-web_1         |    down  20221101130018                                            AddDisplayMetaDataMigration
cms-web_1         |    down  20221104095722                                            CreateDisplayLocationTypeTableMigration
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
cms-web_1         | mysqldump: Got error: 1146: "Table 'cms.connectors' doesn't exist" when using LOCK TABLES
cms-web_1         | Running database migrations
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 cms
cms-web_1         | 
cms-web_1         |  == 20210128143602 MenuBoardsMigration: migrating
cms-web_1         | 
cms-web_1         | In PdoAdapter.php line 134:
cms-web_1         |                                                                                
cms-web_1         |   SQLSTATE[42S02]: Base table or view not found: 1146 Table 'cms.menu_board'   
cms-web_1         |   doesn't exist                                                                
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         | 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         | Setting up Quickchart
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
cms-web_1         | AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using 172.29.0.6. Set the 'ServerName' directive globally to suppress this message

frederic_Horcholle · January 17, 2023, 7:50pm

Hi missionit,
Welcome !
You must run dockercompose in the same directory of your old xibo directory (in my config /opt/xibo/), before you must keep your config file, move all yml files in a backup directory, use the docker compose you downloaded and run docker-compose up -d.
Done it severals times with no problem.
Tell me
See you
Fred

missionit · January 17, 2023, 8:08pm

More information on what I do to upgrade:
Currently Xibo CMS is up and running perfectly on 3.0.2, to upgrade, I download the latest release, run the command “docker-compose down” in my current Xibo directory, then I copy the new version files into my current directory (after taking a backup of course) overwriting the old files. Then I run “docker-compose up -d” in the same directory. This leaves me with the mentioned issue and the console output above.

frederic_Horcholle · January 17, 2023, 9:58pm

ok good, can you confirm that you have in the backup directory /opt/xibo/shared/backup/db (in my config) the 2 backup files latest.sql.gz and previous.sql.gz ?
Can you check aswell you have enough disk space ?
Do you run docker-compose with sudo ?

missionit · January 17, 2023, 10:06pm

In that directory I have “backup.sql.gz”
There is plenty of free space (~30GB used of 1TB)
Yes I run with sudo, if I don’t run with sudo the command fails immediately with a different error.

frederic_Horcholle · January 19, 2023, 6:53pm

Hi,
Did you check this post Xibo update issues and try to clear all logs ?
and this one
Unable to restore library after fresh install 2.3.3
to restore from a backup ?
Would you agree to send me your backup files (database and piece of Library?) It would be easier to find the way to debug in situ.
Thanks

missionit · January 19, 2023, 8:42pm

One time I ran the upgrade and left it for over 12 hours. The database is only about 30GB, this did not resolve the issue.
How would I send more info? All I’m familiar with is “docker-compose logs” to see the logs. Is there a path to more detailed logs?

alex · January 20, 2023, 8:34am

The problem comes from that line.

At some point in the past, the connectors table data file was deleted from your MySQL data directory.

To fix it, you’d need to bring the CMS up at version 3.0.2, access the database, and drop the connectors table.

Then re-create the connectors table using the table definition from another 3.0.2 CMS. You’d have to do a new 3.0.2 install in a separate temporary directory to get that, and then dump the table with mysqldump and then restore it in to your production database. Then attempt the upgrade again.

frederic_Horcholle · January 20, 2023, 1:37pm

Thanks Alex for your help
Missionit, if you need, I am still available to help.

missionit · February 8, 2023, 6:48pm

Hi Alex, thanks for the input.
When trying to use mysqldump, I get the error: Got error 2002: "Cant connect to local mysql server through socket '/run/mysqld/mysqld.sock' (2)" when trying to connect

Steps to recreate:

Open terminal in current Xibo docker directory
Run sudo docker exec -it -uroot xibo-docker_cms-web_1 bash
Run mysqldump -u root -p cms connectors > connectorsold.sql
I have also tried adding -h localhost --protocol=TCP --port=3306, (in the database info I saw Connection: msql via TCP/IP and TCP Port: 3306)

I can connect to the database easily by running mysql -uroot -p

Any input is appreciated, I am fairly new to mysql and linux.

system · May 11, 2023, 12:48am

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