502 Bad Gateway using ubuntu, ansible, lxc, nginx and mattermost

Troubleshooting
1

Hello. I have ubuntu desktop 18.04.02 running in virtualbox. I have installed linux containers running on ubuntu and have installed ansible(2.5.1) on the ubuntu desktop. I created 3 linux containers (lxc). on one of the containers i have nginx(version 1.14.2) running as well as mattermost(version 5.12.0). the problem is that when i invoke firefox on the ubuntu desktop and try to access mattermost running on the matterweb linux container, I receive a " 502 Bad Gateway" message.

When I run “systemctl status mattermost” on the matterweb linux container, I get the following
root@matterweb:/etc/nginx/conf.d# systemctl status mattermost
● mattermost.service - Mattermost
Loaded: loaded (/etc/systemd/system/mattermost.service; enabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Fri 2019-06-28 13:58:23 UTC; 1h 14min ago
Process: 78 ExecStart=/home/mattermost/mattermost_app/bin/platform (code=exited, status=102)
Main PID: 78 (code=exited, status=102)

Jun 28 13:57:51 matterweb platform[78]: {“level”:“info”,“ts”:1561730271.959878,“caller”:“sqlstore/supplier.go:224”,“ms
Jun 28 13:57:51 matterweb platform[78]: {“level”:“error”,“ts”:1561730271.9624765,“caller”:“sqlstore/supplier.go:236”,”
Jun 28 13:58:01 matterweb platform[78]: {“level”:“info”,“ts”:1561730281.9636757,“caller”:“sqlstore/supplier.go:224”,"m
Jun 28 13:58:01 matterweb platform[78]: {“level”:“error”,“ts”:1561730281.966658,“caller”:“sqlstore/supplier.go:236”,"m
Jun 28 13:58:11 matterweb platform[78]: {“level”:“info”,“ts”:1561730291.9675682,“caller”:“sqlstore/supplier.go:224”,“m
Jun 28 13:58:11 matterweb platform[78]: {“level”:“error”,“ts”:1561730291.9807322,“caller”:“sqlstore/supplier.go:236”,”
Jun 28 13:58:21 matterweb platform[78]: {“level”:“info”,“ts”:1561730301.981353,“caller”:“sqlstore/supplier.go:224”,“ms
Jun 28 13:58:21 matterweb platform[78]: {“level”:“error”,“ts”:1561730301.9849637,“caller”:“sqlstore/supplier.go:232”,”
Jun 28 13:58:23 matterweb systemd[1]: mattermost.service: Main process exited, code=exited, status=102/n/a
Jun 28 13:58:23 matterweb systemd[1]: mattermost.service: Failed with result ‘exit-code’.

Any ideas?

Thanks

2

Hi @jcurt11n,

As a first step, some of these earlier threads might help:

3

Thanks for those links. Unfortunately, the solution to my problem was stated in those links.

4

Sorry about that mistype, the links did not provide me with a solution.

5

Hi @jcurt11n, would you be open to providing your complete log file?

6

Thanks Amy.

Here are the mattermost and nginx logs and config files.

Regards,

Jim Curtin

(Attachment mattermost_logs.zip is missing)

7

@jcurt11n I think you will have to attach it directly in Forum.

8

OK here is the mattermost log and config.json.

Thanks for your help.

mattermost log:

{“level”:“info”,“ts”:1562850598.102926,“caller”:“utils/i18n.go:83”,“msg”:“Loaded system translations for ‘en’ from ‘/home/mattermost/mattermost_app/i18n/en.json’”}
{“level”:“info”,“ts”:1562850598.1063418,“caller”:“app/server_app_adapters.go:58”,“msg”:“Server is initializing…”}
{“level”:“info”,“ts”:1562850598.1609452,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850598.1653557,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850608.166153,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850608.166689,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850618.167426,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850618.1679726,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850628.1689749,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850628.169536,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850638.2007537,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850638.2027361,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850648.2031746,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850648.2036648,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850658.2050395,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850658.2057145,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850668.2059548,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850668.2067046,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850678.2078822,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850678.2083576,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850688.2088242,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850688.209368,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850698.2104292,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850698.2109432,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850708.211846,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850708.2125547,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850718.216654,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850718.2212,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850728.2231894,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850728.2239838,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850738.2246442,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850738.2255247,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850748.2289753,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850748.229754,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850758.2301006,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850758.230944,“caller”:“sqlstore/supplier.go:236”,“msg”:“Failed to ping DB retrying in 10 seconds err=dial tcp 127.0.0.1:5432: connect: connection refused”}
{“level”:“info”,“ts”:1562850768.2320561,“caller”:“sqlstore/supplier.go:224”,“msg”:“Pinging SQL master database”}
{“level”:“error”,“ts”:1562850768.2327633,“caller”:“sqlstore/supplier.go:232”,“msg”:“Failed to ping DB, server will exit err=dial tcp 127.0.0.1:5432: connect: connection refused”}

config.json

{
“ServiceSettings”: {
“SiteURL”: “”,
“WebsocketURL”: “”,
“LicenseFileLocation”: “”,
“ListenAddress”: “127.0.0.1:8065”,
“ConnectionSecurity”: “”,
“TLSCertFile”: “”,
“TLSKeyFile”: “”,
“TLSMinVer”: “1.2”,
“TLSStrictTransport”: false,
“TLSStrictTransportMaxAge”: 63072000,
“TLSOverwriteCiphers”: [],
“UseLetsEncrypt”: false,
“LetsEncryptCertificateCacheFile”: “./config/letsencrypt.cache”,
“Forward80To443”: false,
“TrustedProxyIPHeader”: [
“X-Forwarded-For”,
“X-Real-IP”
],
“ReadTimeout”: 300,
“WriteTimeout”: 300,
“MaximumLoginAttempts”: 10,
“GoroutineHealthThreshold”: -1,
“GoogleDeveloperKey”: “”,
“EnableOAuthServiceProvider”: false,
“EnableIncomingWebhooks”: true,
“EnableOutgoingWebhooks”: true,
“EnableCommands”: true,
“EnableOnlyAdminIntegrations”: true,
“EnablePostUsernameOverride”: false,
“EnablePostIconOverride”: false,
“EnableLinkPreviews”: false,
“EnableTesting”: false,
“EnableDeveloper”: false,
“EnableSecurityFixAlert”: true,
“EnableInsecureOutgoingConnections”: false,
“AllowedUntrustedInternalConnections”: “”,
“EnableMultifactorAuthentication”: false,
“EnforceMultifactorAuthentication”: false,
“EnableUserAccessTokens”: false,
“AllowCorsFrom”: “”,
“CorsExposedHeaders”: “”,
“CorsAllowCredentials”: false,
“CorsDebug”: false,
“AllowCookiesForSubdomains”: false,
“SessionLengthWebInDays”: 30,
“SessionLengthMobileInDays”: 30,
“SessionLengthSSOInDays”: 30,
“SessionCacheInMinutes”: 10,
“SessionIdleTimeoutInMinutes”: 43200,
“WebsocketSecurePort”: 443,
“WebsocketPort”: 80,
“WebserverMode”: “gzip”,
“EnableCustomEmoji”: false,
“EnableEmojiPicker”: true,
“EnableGifPicker”: false,
“GfycatApiKey”: “2_KtH_W5”,
“GfycatApiSecret”: “3wLVZPiswc3DnaiaFoLkDvB4X0IV6CpMkj4tf2inJRsBY6-FnkT08zGmppWFgeof”,
“RestrictCustomEmojiCreation”: “all”,
“RestrictPostDelete”: “all”,
“AllowEditPost”: “always”,
“PostEditTimeLimit”: -1,
“TimeBetweenUserTypingUpdatesMilliseconds”: 5000,
“EnablePostSearch”: true,
“MinimumHashtagLength”: 3,
“EnableUserTypingMessages”: true,
“EnableChannelViewedMessages”: true,
“EnableUserStatuses”: true,
“ExperimentalEnableAuthenticationTransfer”: true,
“ClusterLogTimeoutMilliseconds”: 2000,
“CloseUnusedDirectMessages”: false,
“EnablePreviewFeatures”: true,
“EnableTutorial”: true,
“ExperimentalEnableDefaultChannelLeaveJoinMessages”: true,
“ExperimentalGroupUnreadChannels”: “disabled”,
“ExperimentalChannelOrganization”: false,
“ImageProxyType”: “”,
“ImageProxyURL”: “”,
“ImageProxyOptions”: “”,
“EnableAPITeamDeletion”: false,
“ExperimentalEnableHardenedMode”: false,
“DisableLegacyMFA”: false,
“ExperimentalStrictCSRFEnforcement”: false,
“EnableEmailInvitations”: true,
“ExperimentalLdapGroupSync”: false,
“DisableBotsWhenOwnerIsDeactivated”: true,
“EnableBotAccountCreation”: false
},
“TeamSettings”: {
“SiteName”: “Mattermost”,
“MaxUsersPerTeam”: 50,
“EnableTeamCreation”: true,
“EnableUserCreation”: true,
“EnableOpenServer”: false,
“EnableUserDeactivation”: false,
“RestrictCreationToDomains”: “”,
“EnableCustomBrand”: false,
“CustomBrandText”: “”,
“CustomDescriptionText”: “”,
“RestrictDirectMessage”: “any”,
“RestrictTeamInvite”: “all”,
“RestrictPublicChannelManagement”: “all”,
“RestrictPrivateChannelManagement”: “all”,
“RestrictPublicChannelCreation”: “all”,
“RestrictPrivateChannelCreation”: “all”,
“RestrictPublicChannelDeletion”: “all”,
“RestrictPrivateChannelDeletion”: “all”,
“RestrictPrivateChannelManageMembers”: “all”,
“EnableXToLeaveChannelsFromLHS”: false,
“UserStatusAwayTimeout”: 300,
“MaxChannelsPerTeam”: 2000,
“MaxNotificationsPerChannel”: 1000,
“EnableConfirmNotificationsToChannel”: true,
“TeammateNameDisplay”: “username”,
“ExperimentalViewArchivedChannels”: false,
“ExperimentalEnableAutomaticReplies”: false,
“ExperimentalHideTownSquareinLHS”: false,
“ExperimentalTownSquareIsReadOnly”: false,
“ExperimentalPrimaryTeam”: “”,
“ExperimentalDefaultChannels”: []
},
“ClientRequirements”: {
“AndroidLatestVersion”: “”,
“AndroidMinVersion”: “”,
“DesktopLatestVersion”: “”,
“DesktopMinVersion”: “”,
“IosLatestVersion”: “”,
“IosMinVersion”: “”
},
“SqlSettings”: {
“DriverName”: “postgres”,
“DataSource”: “postgres://mmuser:abc123@127.0.0.1:5432/mattermost?sslmode=disable\u0026connect_timeout=10”,
“DataSourceReplicas”: [],
“DataSourceSearchReplicas”: [],
“MaxIdleConns”: 10,
“ConnMaxLifetimeMilliseconds”: 3600000,
“MaxOpenConns”: 10,
“Trace”: false,
“AtRestEncryptKey”: “4nzxs7z6c5gmfsmabe5xkike1f885op1”,
“QueryTimeout”: 30
},
“LogSettings”: {
“EnableConsole”: true,
“ConsoleLevel”: “DEBUG”,
“ConsoleJson”: true,
“EnableFile”: true,
“FileLevel”: “INFO”,
“FileJson”: true,
“FileLocation”: “”,
“EnableWebhookDebugging”: true,
“EnableDiagnostics”: true
},
“NotificationLogSettings”: {
“EnableConsole”: true,
“ConsoleLevel”: “DEBUG”,
“ConsoleJson”: true,
“EnableFile”: true,
“FileLevel”: “INFO”,
“FileJson”: true,
“FileLocation”: “”
},
“PasswordSettings”: {
“MinimumLength”: 5,
“Lowercase”: false,
“Number”: false,
“Uppercase”: false,
“Symbol”: false
},
“FileSettings”: {
“EnableFileAttachments”: true,
“EnableMobileUpload”: true,
“EnableMobileDownload”: true,
“MaxFileSize”: 52428800,
“DriverName”: “local”,
“Directory”: “./data/”,
“EnablePublicLink”: false,
“PublicLinkSalt”: “9mhb9duk4zg36y9jp9frjcs8r8tgffnh”,
“InitialFont”: “luximbi.ttf”,
“AmazonS3AccessKeyId”: “”,
“AmazonS3SecretAccessKey”: “”,
“AmazonS3Bucket”: “”,
“AmazonS3Region”: “”,
“AmazonS3Endpoint”: “s3.amazonaws.com”,
“AmazonS3SSL”: true,
“AmazonS3SignV2”: false,
“AmazonS3SSE”: false,
“AmazonS3Trace”: false
},
“EmailSettings”: {
“EnableSignUpWithEmail”: true,
“EnableSignInWithEmail”: true,
“EnableSignInWithUsername”: true,
“SendEmailNotifications”: false,
“UseChannelInEmailNotifications”: false,
“RequireEmailVerification”: false,
“FeedbackName”: “”,
“FeedbackEmail”: “”,
“ReplyToAddress”: "test@example.com",
“FeedbackOrganization”: “”,
“EnableSMTPAuth”: false,
“SMTPUsername”: “”,
“SMTPPassword”: “”,
“SMTPServer”: “dockerhost”,
“SMTPPort”: “2500”,
“ConnectionSecurity”: “”,
“SendPushNotifications”: false,
“PushNotificationServer”: “”,
“PushNotificationContents”: “generic”,
“EnableEmailBatching”: false,
“EmailBatchingBufferSize”: 256,
“EmailBatchingInterval”: 30,
“EnablePreviewModeBanner”: true,
“SkipServerCertificateVerification”: false,
“EmailNotificationContentsType”: “full”,
“LoginButtonColor”: “#0000”,
“LoginButtonBorderColor”: “#2389D7”,
“LoginButtonTextColor”: “#2389D7”
},
“RateLimitSettings”: {
“Enable”: false,
“PerSec”: 10,
“MaxBurst”: 100,
“MemoryStoreSize”: 10000,
“VaryByRemoteAddr”: true,
“VaryByUser”: false,
“VaryByHeader”: “”
},
“PrivacySettings”: {
“ShowEmailAddress”: true,
“ShowFullName”: true
},
“SupportSettings”: {
“TermsOfServiceLink”: “https://about.mattermost.com/default-terms/”,
“PrivacyPolicyLink”: “https://about.mattermost.com/default-privacy-policy/”,
“AboutLink”: “https://about.mattermost.com/default-about/”,
“HelpLink”: “https://about.mattermost.com/default-help/”,
“ReportAProblemLink”: “https://about.mattermost.com/default-report-a-problem/”,
“SupportEmail”: "feedback@mattermost.com",
“CustomTermsOfServiceEnabled”: false,
“CustomTermsOfServiceReAcceptancePeriod”: 365
},
“AnnouncementSettings”: {
“EnableBanner”: false,
“BannerText”: “”,
“BannerColor”: “#f2a93b”,
“BannerTextColor”: “#333333”,
“AllowBannerDismissal”: true
},
“ThemeSettings”: {
“EnableThemeSelection”: true,
“DefaultTheme”: “default”,
“AllowCustomThemes”: true,
“AllowedThemes”: []
},
“GitLabSettings”: {
“Enable”: false,
“Secret”: “”,
“Id”: “”,
“Scope”: “”,
“AuthEndpoint”: “”,
“TokenEndpoint”: “”,
“UserApiEndpoint”: “”
},
“GoogleSettings”: {
“Enable”: false,
“Secret”: “”,
“Id”: “”,
“Scope”: “profile email”,
“AuthEndpoint”: “https://accounts.google.com/o/oauth2/v2/auth”,
“TokenEndpoint”: “https://www.googleapis.com/oauth2/v4/token”,
“UserApiEndpoint”: “https://www.googleapis.com/plus/v1/people/me”
},
“Office365Settings”: {
“Enable”: false,
“Secret”: “”,
“Id”: “”,
“Scope”: “User.Read”,
“AuthEndpoint”: “https://login.microsoftonline.com/common/oauth2/v2.0/authorize”,
“TokenEndpoint”: “https://login.microsoftonline.com/common/oauth2/v2.0/token”,
“UserApiEndpoint”: “https://graph.microsoft.com/v1.0/me”
},
“LdapSettings”: {
“Enable”: false,
“EnableSync”: false,
“LdapServer”: “”,
“LdapPort”: 389,
“ConnectionSecurity”: “”,
“BaseDN”: “”,
“BindUsername”: “”,
“BindPassword”: “”,
“UserFilter”: “”,
“GroupFilter”: “”,
“GroupDisplayNameAttribute”: “”,
“GroupIdAttribute”: “”,
“FirstNameAttribute”: “”,
“LastNameAttribute”: “”,
“EmailAttribute”: “”,
“UsernameAttribute”: “”,
“NicknameAttribute”: “”,
“IdAttribute”: “”,
“PositionAttribute”: “”,
“LoginIdAttribute”: “”,
“SyncIntervalMinutes”: 60,
“SkipCertificateVerification”: false,
“QueryTimeout”: 60,
“MaxPageSize”: 0,
“LoginFieldName”: “”,
“LoginButtonColor”: “#0000”,
“LoginButtonBorderColor”: “#2389D7”,
“LoginButtonTextColor”: “#2389D7”
},
“ComplianceSettings”: {
“Enable”: false,
“Directory”: “./data/”,
“EnableDaily”: false
},
“LocalizationSettings”: {
“DefaultServerLocale”: “en”,
“DefaultClientLocale”: “en”,
“AvailableLocales”: “”
},
“SamlSettings”: {
“Enable”: false,
“EnableSyncWithLdap”: false,
“EnableSyncWithLdapIncludeAuth”: false,
“Verify”: false,
“Encrypt”: false,
“IdpUrl”: “”,
“IdpDescriptorUrl”: “”,
“AssertionConsumerServiceURL”: “”,
“ScopingIDPProviderId”: “”,
“ScopingIDPName”: “”,
“IdpCertificateFile”: “”,
“PublicCertificateFile”: “”,
“PrivateKeyFile”: “”,
“IdAttribute”: “”,
“FirstNameAttribute”: “”,
“LastNameAttribute”: “”,
“EmailAttribute”: “”,
“UsernameAttribute”: “”,
“NicknameAttribute”: “”,
“LocaleAttribute”: “”,
“PositionAttribute”: “”,
“LoginButtonText”: “With SAML”,
“LoginButtonColor”: “#34a28b”,
“LoginButtonBorderColor”: “#2389D7”,
“LoginButtonTextColor”: “#ffffff”
},
“NativeAppSettings”: {
“AppDownloadLink”: “https://about.mattermost.com/downloads/”,
“AndroidAppDownloadLink”: “https://about.mattermost.com/mattermost-android-app/”,
“IosAppDownloadLink”: “https://about.mattermost.com/mattermost-ios-app/”
},
“ClusterSettings”: {
“Enable”: false,
“ClusterName”: “”,
“OverrideHostname”: “”,
“UseIpAddress”: true,
“UseExperimentalGossip”: false,
“ReadOnlyConfig”: true,
“GossipPort”: 8074,
“StreamingPort”: 8075,
“MaxIdleConns”: 100,
“MaxIdleConnsPerHost”: 128,
“IdleConnTimeoutMilliseconds”: 90000
},
“MetricsSettings”: {
“Enable”: false,
“BlockProfileRate”: 0,
“ListenAddress”: “:8067”
},
“ExperimentalSettings”: {
“ClientSideCertEnable”: false,
“ClientSideCertCheck”: “secondary”,
“EnableClickToReply”: false,
“LinkMetadataTimeoutMilliseconds”: 5000,
“RestrictSystemAdmin”: false
},
“AnalyticsSettings”: {
“MaxUsersForStatistics”: 2500
},
“ElasticsearchSettings”: {
“ConnectionUrl”: “http://dockerhost:9200”,
“Username”: “elastic”,
“Password”: “changeme”,
“EnableIndexing”: false,
“EnableSearching”: false,
“EnableAutocomplete”: false,
“Sniff”: true,
“PostIndexReplicas”: 1,
“PostIndexShards”: 1,
“ChannelIndexReplicas”: 1,
“ChannelIndexShards”: 1,
“UserIndexReplicas”: 1,
“UserIndexShards”: 1,
“AggregatePostsAfterDays”: 365,
“PostsAggregatorJobStartTime”: “03:00”,
“IndexPrefix”: “”,
“LiveIndexingBatchSize”: 1,
“BulkIndexingTimeWindowSeconds”: 3600,
“RequestTimeoutSeconds”: 30
},
“DataRetentionSettings”: {
“EnableMessageDeletion”: false,
“EnableFileDeletion”: false,
“MessageRetentionDays”: 365,
“FileRetentionDays”: 365,
“DeletionJobStartTime”: “02:00”
},
“MessageExportSettings”: {
“EnableExport”: false,
“ExportFormat”: “actiance”,
“DailyRunTime”: “01:00”,
“ExportFromTimestamp”: 0,
“BatchSize”: 10000,
“GlobalRelaySettings”: {
“CustomerType”: “A9”,
“SmtpUsername”: “”,
“SmtpPassword”: “”,
“EmailAddress”: “”
}
},
“JobSettings”: {
“RunJobs”: true,
“RunScheduler”: true
},
“PluginSettings”: {
“Enable”: true,
“EnableUploads”: false,
“EnableHealthCheck”: true,
“Directory”: “./plugins”,
“ClientDirectory”: “./client/plugins”,
“Plugins”: {},
“PluginStates”: {
“com.mattermost.nps”: {
“Enable”: true
}
}
},
“DisplaySettings”: {
“CustomUrlSchemes”: [],
“ExperimentalTimezone”: false
},
“ImageProxySettings”: {
“Enable”: false,
“ImageProxyType”: “local”,
“RemoteImageProxyURL”: “”,
“RemoteImageProxyOptions”: “”
}
}

9

Hi @jcurt11n,

Based on your logs it looks like Mattermost isn’t able to connect to your database. Verify that your DB server is running and that the connection string in your config file under SqlSettings>DataSource is correct.