Marcel
November 11, 2020, 8:35am
1
CMS Version
2.3.7 Docker Installation Debian Server
Player Type
Windows
Player Version
R255.3-255
Issue
All images with a resolution above 1920x1080 will not be converted
Error: xxxx.jpg is pending conversion
Settings: Resize Threshold 1920 / Resize Limit 6000
I need urgent help
What can I do
alex
November 11, 2020, 10:37am
2
Check why your Image Processing task isn’t running would be a good first step. If it’s a Docker install then XTR has been setup for you, so perhaps the task has hit a critical error and disabled itself?
alex
November 11, 2020, 11:05am
4
Go to the Tasks page in the CMS and see what the status of the task is.
1 Like
Marcel
November 11, 2020, 11:23am
5
Task is running
is that normal with the last status?
alex
November 11, 2020, 11:25am
6
Your tasks have never run - you can see the Last Run date is empty.
On a Docker install XTR is setup to run for you unless you disable it. Have you disabled it perhaps?
Marcel
November 11, 2020, 11:34am
7
No
The only change I’ve made is the custom port 8080: 80
Everything else is the original settings.
Marcel
November 11, 2020, 12:23pm
8
@alex
Maybe helps docker-compose logs
docker-compose logs
Attaching to xibo_cms-web_1, xibo_cms-xmr_1, xibo_cms-db_1, xibo_cms-quickchart_1
cms-db_1 | 2020-11-11 12:15:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-11-11 12:15:09+00:00 [Note] [Entrypoint]: Switching to dedicated user ‘mysql’
cms-db_1 | 2020-11-11 12:15:09+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 5.6.48-1debian9 started.
cms-db_1 | 2020-11-11 12:15:10 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
cms-db_1 | 2020-11-11 12:15:10 0 [Note] mysqld (mysqld 5.6.48) starting as process 1 …
cms-db_1 | 2020-11-11 12:15:10 1 [Note] Plugin ‘FEDERATED’ is disabled.
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Using atomics to ref count buffer pool pages
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: The InnoDB memory heap is disabled
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Memory barrier is not used
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Compressed tables use zlib 1.2.11
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Using Linux native AIO
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Using CPU crc32 instructions
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Initializing buffer pool, size = 128.0M
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Completed initialization of buffer pool
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Highest supported file format is Barracuda.
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: 128 rollback segment(s) are active.
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: Waiting for purge to start
cms-db_1 | 2020-11-11 12:15:10 1 [Note] InnoDB: 5.6.48 started; log sequence number 21515686674
cms-db_1 | 2020-11-11 12:15:10 1 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-11-11 12:15:10 1 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
cms-db_1 | 2020-11-11 12:15:10 1 [Note] Server hostname (bind-address): ‘’; port: 3306
cms-db_1 | 2020-11-11 12:15:10 1 [Note] IPv6 is available.
cms-db_1 | 2020-11-11 12:15:10 1 [Note] - ‘::’ resolves to ‘::’;
cms-db_1 | 2020-11-11 12:15:10 1 [Note] Server socket created on IP: ‘::’.
cms-db_1 | 2020-11-11 12:15:10 1 [Warning] Insecure configuration for --pid-file: Location ‘/var/run/mysqld’ in the path is accessible to all OS users. Consider choosing a different directory.
cms-db_1 | 2020-11-11 12:15:10 1 [Warning] ‘proxies_priv’ entry ‘@ root@458987d00f12’ ignored in --skip-name-resolve mode.
cms-db_1 | 2020-11-11 12:15:10 1 [Note] Event Scheduler: Loaded 0 events
cms-db_1 | 2020-11-11 12:15:10 1 [Note] mysqld: ready for connections.
cms-db_1 | Version: ‘5.6.48’ socket: ‘/var/run/mysqld/mysqld.sock’ port: 3306 MySQL Community Server (GPL)
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 | up 20180130073838 2020-07-29 08:11:36 2020-07-29 08:11:36 InstallMigration
cms-web_1 | up 20180131113100 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep85Migration
cms-web_1 | up 20180131113853 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep86Migration
cms-web_1 | up 20180131113941 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep87Migration
cms-web_1 | up 20180131113948 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep88Migration
cms-web_1 | up 20180131113952 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep92Migration
cms-web_1 | up 20180131113957 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep120Migration
cms-web_1 | up 20180131114002 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep121Migration
cms-web_1 | up 20180131114007 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep122Migration
cms-web_1 | up 20180131114013 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep123Migration
cms-web_1 | up 20180131114017 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep124Migration
cms-web_1 | up 20180131114021 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep125Migration
cms-web_1 | up 20180131114025 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep126Migration
cms-web_1 | up 20180131114030 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep127Migration
cms-web_1 | up 20180131114050 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep128Migration
cms-web_1 | up 20180131114058 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep129Migration
cms-web_1 | up 20180131114103 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep130Migration
cms-web_1 | up 20180131114107 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep131Migration
cms-web_1 | up 20180131114110 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep132Migration
cms-web_1 | up 20180131114114 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep133Migration
cms-web_1 | up 20180131114118 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep134Migration
cms-web_1 | up 20180131114123 2020-07-29 08:11:36 2020-07-29 08:11:36 OldUpgradeStep135Migration
cms-web_1 | up 20180131122645 2020-07-29 08:11:36 2020-07-29 08:11:36 OneRegionPerPlaylistMigration
cms-web_1 | up 20180131123038 2020-07-29 08:11:36 2020-07-29 08:11:36 PlaylistTagsMigration
cms-web_1 | up 20180131123248 2020-07-29 08:11:36 2020-07-29 08:11:37 WidgetFromToDtMigration
cms-web_1 | up 20180212143336 2020-07-29 08:11:37 2020-07-29 08:11:37 DaypartSystemEntriesAsRecords
cms-web_1 | up 20180213173846 2020-07-29 08:11:37 2020-07-29 08:11:37 MailFromNameSettingMigration
cms-web_1 | up 20180219141257 2020-07-29 08:11:37 2020-07-29 08:11:37 DisplayGroupClosureIndexToNonUnique
cms-web_1 | up 20180223180534 2020-07-29 08:11:37 2020-07-29 08:11:37 DataSetColumnFilterAndSortOptionsMigration
cms-web_1 | up 20180302182421 2020-07-29 08:11:37 2020-07-29 08:11:37 WidgetCreatedAndModifiedDtMigration
cms-web_1 | up 20180313085749 2020-07-29 08:11:37 2020-07-29 08:11:37 MediaTableEditedIdIndexMigration
cms-web_1 | up 20180320154652 2020-07-29 08:11:37 2020-07-29 08:11:37 PlaylistAddDynamicFilterMigrationcms-web_1 | up 20180327153325 2020-07-29 08:11:37 2020-07-29 08:11:37 RemoveUserLoggedInMigration
cms-web_1 | up 20180514114415 2020-07-29 08:11:37 2020-07-29 08:11:37 FixCaseOnHelpTextFieldMigration
cms-web_1 | up 20180515123835 2020-07-29 08:11:37 2020-07-29 08:11:37 LayoutPublishDraftMigration
cms-web_1 | up 20180529065816 2020-07-29 08:11:37 2020-07-29 08:11:37 DataSetTruncateFixMigration
cms-web_1 | up 20180529073531 2020-07-29 08:11:37 2020-07-29 08:11:37 DisplayAsVncLinkMigration
cms-web_1 | up 20180621134013 2020-07-29 08:11:37 2020-07-29 08:11:37 AddWidgetSyncTaskMigration
cms-web_1 | up 20180621134250 2020-07-29 08:11:37 2020-07-29 08:11:37 EventLayoutPermissionSettingMigration
cms-web_1 | up 20180906115552 2020-07-29 08:11:37 2020-07-29 08:11:38 AddForeignKeysToTagsMigration
cms-web_1 | up 20180906115606 2020-07-29 08:11:38 2020-07-29 08:11:38 AddForeignKeysToPermissionsMigration
cms-web_1 | up 20180906115712 2020-07-29 08:11:38 2020-07-29 08:11:38 AddForeignKeysToWidgetMediaMigration
cms-web_1 | up 20180906131643 2020-07-29 08:11:38 2020-07-29 08:11:38 ForgottenPasswordReminderMigration
cms-web_1 | up 20180906131716 2020-07-29 08:11:38 2020-07-29 08:11:38 DataSetRssMigration
cms-web_1 | up 20181011160130 2020-07-29 08:11:38 2020-07-29 08:11:38 SimpleSettingsMigration
cms-web_1 | up 20181113173310 2020-07-29 08:11:38 2020-07-29 08:11:38 RemoveFinanceModuleMigration
cms-web_1 | up 20181113180337 2020-07-29 08:11:38 2020-07-29 08:11:38 SplitTickerModuleMigration
cms-web_1 | up 20181126113231 2020-07-29 08:11:38 2020-07-29 08:11:38 Release1812Migration
cms-web_1 | up 20181210092443 2020-07-29 08:11:38 2020-07-29 08:11:38 RemoveImageUriModuleMigration
cms-web_1 | up 20181212114400 2020-07-29 08:11:38 2020-07-29 08:11:38 CreatePlayerVersionsTableMigration
cms-web_1 | up 20181217135044 2020-07-29 08:11:38 2020-07-29 08:11:38 EventSyncMigration
cms-web_1 | up 20190121092556 2020-07-29 08:11:38 2020-07-29 08:11:38 PlayerUpgradeAndOverrideConfigMigration
cms-web_1 | up 20190125170130 2020-07-29 08:11:38 2020-07-29 08:11:38 PlayerSoftwareVersionFieldMigration
cms-web_1 | up 20190129103831 2020-07-29 08:11:38 2020-07-29 08:11:38 AddLinuxDisplayProfileMigration
cms-web_1 | up 20190212112534 2020-07-29 08:20:29 2020-07-29 08:20:29 AddProofOfPlayStatsDurationAndCountMigration
cms-web_1 | up 20190212115432 2020-07-29 08:11:38 2020-07-29 08:11:38 AddDefaultTransitionDurationSettingMigration
cms-web_1 | up 20190213160914 2020-07-29 08:20:29 2020-07-29 08:20:30 AddGlobalStatSettingMigration
cms-web_1 | up 20190213162212 2020-07-29 08:11:38 2020-07-29 08:11:38 AddHorizontalMenuSettingMigrationcms-web_1 | up 20190214102508 2020-07-29 08:20:30 2020-07-29 08:20:30 AddLayoutEnableStat
cms-web_1 | up 20190214102516 2020-07-29 08:20:30 2020-07-29 08:20:30 AddMediaEnableStat
cms-web_1 | up 20190220165703 2020-07-29 08:11:38 2020-07-29 08:11:38 AddScheduleRecurrenceMonthlyRepeatsOnMigration
cms-web_1 | up 20190227101705 2020-07-29 08:11:38 2020-07-29 08:11:38 MakeDisplayLicenseColumnUniqueMigration
cms-web_1 | up 20190228120603 2020-07-29 08:11:38 2020-07-29 08:11:38 AddDynamicCriteriaTagsMigration
cms-web_1 | up 20190301115046 2020-07-29 08:11:38 2020-07-29 08:11:38 AdjustGenericfileValidExtensionsMigration
cms-web_1 | up 20190315134628 2020-07-29 08:20:30 2020-07-29 08:20:30 AddBandwidthLimitColumnToDisplaygroupMigration
cms-web_1 | up 20190322162052 2020-07-29 08:20:30 2020-07-29 08:20:30 AddPublishedDateColumnMigration
cms-web_1 | up 20190326163016 2020-07-29 08:20:30 2020-07-29 08:20:30 CreateLayoutHistoryTableMigrationcms-web_1 | up 20190328111718 2020-07-29 08:20:30 2020-07-29 08:20:30 AddCampaignStatMigration
cms-web_1 | up 20190401150256 2020-07-29 08:20:30 2020-07-29 08:20:30 AddScheduleNowPageMigration
cms-web_1 | up 20190509101525 2020-07-29 08:20:30 2020-07-29 08:20:30 CreateReportScheduleTableMigration
cms-web_1 | up 20190509102648 2020-07-29 08:20:30 2020-07-29 08:20:31 CreateSavedReportTableMigration
cms-web_1 | up 20190509113001 2020-07-29 08:20:31 2020-07-29 08:20:31 AddReportPageMigration
cms-web_1 | up 20190510140126 2020-07-29 08:20:31 2020-07-29 08:20:31 TwoFactorAuthMigration
cms-web_1 | up 20190514134430 2020-07-29 08:20:31 2020-07-29 08:20:32 NullableTextFieldsMigration
cms-web_1 | up 20190515094133 2020-07-29 08:20:32 2020-07-29 08:20:32 AddHtmlDatatypeMigration
cms-web_1 | up 20190515105624 2020-07-29 08:20:32 2020-07-29 08:20:32 InstallAdditionalStandardModulesMigration
cms-web_1 | up 20190517080033 2020-07-29 08:20:32 2020-07-29 08:20:33 AddForeignKeysToLktagTablesMigration
cms-web_1 | up 20190521092700 2020-07-29 08:20:33 2020-07-29 08:20:33 AddReportScheduleTaskMigration
cms-web_1 | up 20190521092930 2020-07-29 08:20:33 2020-07-29 08:20:33 AddPreviousRunDateReportScheduleMigration
cms-web_1 | up 20190521102635 2020-07-29 08:20:33 2020-07-29 08:20:33 PlaylistDurationUpdateAtTimestampcms-web_1 | up 20190603083836 2020-07-29 08:20:33 2020-07-29 08:20:33 ChangeStatTableStartEndColumnMigration
cms-web_1 | up 20190610150331 2020-07-29 08:20:33 2020-07-29 08:20:34 TagsWithValuesMigration
cms-web_1 | up 20190611145607 2020-07-29 08:20:34 2020-07-29 08:20:34 RemoveOldVersionTableMigration
cms-web_1 | up 20190612140955 2020-07-29 08:20:34 2020-07-29 08:20:34 DisplayTableDatabaseSchemaAdjustmentsMigration
cms-web_1 | up 20190620112611 2020-07-29 08:20:34 2020-07-29 08:20:34 MoveTidyStatsToStatsArchiveTaskMigration
cms-web_1 | up 20190620142655 2020-07-29 08:20:34 2020-07-29 08:20:35 AddPlaylistEnableStatMigration
cms-web_1 | up 20190626091331 2020-07-29 08:20:35 2020-07-29 08:20:35 WidgetHistoryMigration
cms-web_1 | up 20190626110359 2020-07-29 08:20:35 2020-07-29 08:20:35 CreateStatTableMigration
cms-web_1 | up 20190628083649 2020-07-29 08:20:35 2020-07-29 08:20:35 AddStatsMigrationTaskMigration
cms-web_1 | up 20190710213414 2020-07-29 08:20:35 2020-07-29 08:20:35 AddIsActiveReportScheduleMigration
cms-web_1 | up 20190717101342 2020-07-29 08:20:35 2020-07-29 08:20:35 NullableCommandValidationStringMigration
cms-web_1 | up 20190719074601 2020-07-29 08:20:35 2020-07-29 08:20:35 MissingDefaultValueMigration
cms-web_1 | up 20190725115532 2020-07-29 08:29:27 2020-07-29 08:29:27 AddScheduleReminderTaskMigration
cms-web_1 | up 20190801102042 2020-07-29 08:20:35 2020-07-29 08:20:35 DisplayProfileCommandLinkFixMigration
cms-web_1 | up 20190801141737 2020-07-29 08:29:27 2020-07-29 08:29:27 DatasetAddCustomHeadersColumnMigration
cms-web_1 | up 20190801142302 2020-07-29 08:29:27 2020-07-29 08:29:27 AddDoohUserTypeMigration
cms-web_1 | up 20190802145636 2020-07-29 08:29:27 2020-07-29 08:29:27 CreateScheduleReminderTableMigration
cms-web_1 | up 20190806144729 2020-07-29 08:29:27 2020-07-29 08:29:27 AddShowContentFromMigration
cms-web_1 | up 20190823081448 2020-07-29 08:29:27 2020-07-29 08:29:27 AddImageProcessingTaskMigration
cms-web_1 | up 20190828123735 2020-07-29 08:29:27 2020-07-29 08:29:27 AddDefaultSettingResizeLimitResizeThresholdMigration
cms-web_1 | up 20190903083314 2020-07-29 08:29:27 2020-07-29 08:29:27 AddGlobalSettingForCascadePermissionsMigration
cms-web_1 | up 20190905084201 2020-07-29 08:29:27 2020-07-29 08:29:27 AddSettingForDefaultTransitionTypeMigration
cms-web_1 | up 20190905084642 2020-07-29 08:29:27 2020-07-29 08:29:27 AddSettingForAutoLayoutPublishMigration
cms-web_1 | up 20190910132520 2020-07-29 08:29:27 2020-07-29 08:29:27 DisplayMoveCmsMigration
cms-web_1 | up 20190917093141 2020-07-29 08:29:27 2020-07-29 08:29:28 InterruptLayoutMigration
cms-web_1 | up 20190918090608 2020-07-29 08:29:28 2020-07-29 08:29:28 AddDefaultSettingQuickChartMigration
cms-web_1 | up 20190919154513 2020-07-29 08:29:28 2020-07-29 08:29:28 AddNotificationAttachmentFilenameNonUsersMigration
cms-web_1 | up 20190926135518 2020-07-29 08:29:28 2020-07-29 08:29:28 AddSettingForTransitionAutoApplyToLayoutMigration
cms-web_1 | up 20190926140809 2020-07-29 08:29:28 2020-07-29 08:29:28 InstallSavedReportsAndSpacerModulesMigration
cms-web_1 | up 20191001092651 2020-07-29 08:29:28 2020-07-29 08:29:28 AddNotificationOriginalFilenameMigration
cms-web_1 | up 20191022101141 2020-07-29 08:29:28 2020-07-29 08:29:28 AddCommandEntityToPermissionEntityMigration
cms-web_1 | up 20191024152519 2020-07-29 08:29:28 2020-07-29 08:29:28 AddScheduleExclusionsTableMigration
cms-web_1 | up 20191122114104 2020-07-29 08:29:28 2020-07-29 08:29:28 FixDuplicateModuleFilesMigration
cms-web_1 | up 20191126103120 2020-07-29 08:29:28 2020-07-29 08:29:28 GeoScheduleMigration
cms-web_1 | up 20191126141140 2020-07-29 08:29:28 2020-07-29 08:29:29 RemoteDataSetCsvSourceMigration
cms-web_1 | up 20191205180116 2020-07-29 08:29:29 2020-07-29 08:29:29 AddPlaylistDashboardPageUserMigration
cms-web_1 | up 20200107082625 2020-07-29 08:29:29 2020-07-29 08:29:29 DisplayAddResolutionMigration
cms-web_1 | up 20200115115935 2020-07-29 08:29:29 2020-07-29 08:29:29 AddReportScheduleMessageMigrationcms-web_1 | up 20200122143630 2020-07-29 08:29:29 2020-07-29 08:29:29 AddReleasedRequiredFileMigration
cms-web_1 | up 20200122191232 2020-07-29 08:29:29 2020-07-29 08:29:29 AddCommercialLicenceColumnMigration
cms-web_1 | up 20200129104944 2020-07-29 08:29:29 2020-07-29 08:29:29 AddEngagementsStatsMigration
cms-web_1 | up 20200130165443 2020-07-29 08:29:29 2020-07-29 08:29:29 CountdownModuleAddMigration
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.25.0.5. Set the ‘ServerName’ directive globally to suppress this message
cms-quickchart_1 | Stackdriver logging is disabled
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“5b9cc4fa94c1”,“pid”:1,“level”:30,“msg”:“Loaded 6 keys from API keyfile”,“time”:“2020-11-11T12:15:11.020Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“5b9cc4fa94c1”,“pid”:1,“level”:30,“msg”:“Telemetry is enabled”,“time”:“2020-11-11T12:15:11.144Z”,“v”:0}
cms-quickchart_1 | Wed, 11 Nov 2020 12:15:11 GMT body-parser deprecated undefined extended: provide extended option at index.js:40:17
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“5b9cc4fa94c1”,“pid”:1,“level”:30,“msg”:“Setting request timeout: 1000 ms”,“time”:“2020-11-11T12:15:11.770Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“5b9cc4fa94c1”,“pid”:1,“level”:30,“msg”:“NODE_ENV: production”,“time”:“2020-11-11T12:15:11.770Z”,“v”:0}
cms-quickchart_1 | {“name”:“quickchart”,“hostname”:“5b9cc4fa94c1”,“pid”:1,“level”:30,“msg”:“Listening on port 3400”,“time”:“2020-11-11T12:15:11.770Z”,“v”:0}
alex
November 11, 2020, 12:46pm
9
Can you check your config.env
file and see if you have a value for
XTR_ENABLED
set?
alex
November 11, 2020, 1:41pm
11
I would restart the containers then as a first step
Marcel
November 11, 2020, 1:47pm
12
I have already made. This did not help.
alex
November 11, 2020, 1:52pm
13
Did you perhaps use a password in config.env
for MySQL that is non-alpha numeric? ie does it use any special characters?
Marcel
November 11, 2020, 2:16pm
14
Yes
there is a # $ and % in the SQL password
alex
November 11, 2020, 2:37pm
15
OK, that will be why then.
We do specifically say to choose an alpha-numeric password in the comments there.
Unfortunately fixing it isn’t so easy. You’d need to export the current database to a file, destroy the current containers and your MySQL database data, update config.env with a suitable password (ideally using the generator we suggest), and then importing your backup.
So assuming you’re using the custom-ports yml file, it would be roughly this:
docker-compose -f cms_custom-ports.yml exec cms-db bash
cd /var/lib/mysql
mysqldump -u cms -p cms > import.sql
Enter the password from config.env
when prompted.
exit
mv shared/db/import.sql shared/backup
docker-compose -f cms_custom-ports.yml down
mv shared/db shared/db-old
Edit config.env and put a suitable password there (using the generator)
docker-compose -f cms_custom-ports.yml up -d
docker-compose -f cms_custom-ports.yml logs -f
You should see the MySQL container create and initialise an empty database, then import your backup.
Assuming it all goes well, you can then delete shared/db-old
when you’re ready.
Marcel
November 11, 2020, 4:43pm
16
it works
great great thanks for the professional support
1 Like
system
Closed
February 10, 2021, 10:43pm
17
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.