Running into issue when trying to start mattermost

Hello,

I’m experiencing an error while attempting to start the matter on my server. I’m in the process of migrating from Bitnami Mattermost and following the guide provided in this link: Install Mattermost on Ubuntu 20.04 LTS — Mattermost documentation. However, I seem to have encountered an issue. Do you have any ideas on what may be causing this?

ubuntu@ip-172-31-59-2:/opt/mattermost$ sudo -u mattermost ./bin/mattermost
{"timestamp":"2023-03-16 15:16:13.198 Z","level":"info","msg":"Server is initializing...","caller":"platform/service.go:165","go_version":"go1.18.1"}
{"timestamp":"2023-03-16 15:16:13.211 Z","level":"info","msg":"Pinging SQL","caller":"sqlstore/store.go:240","database":"master"}
{"timestamp":"2023-03-16 15:16:13.335 Z","level":"warn","msg":"Table collation mismatch","caller":"sqlstore/store.go:1235","table_name":"incomingwebhooks","connection_collation":"utf8mb3_general_ci","table_collation":"utf8mb4_0900_ai_ci"}
{"timestamp":"2023-03-16 15:16:13.338 Z","level":"warn","msg":"Table collation mismatch","caller":"sqlstore/store.go:1235","table_name":"preferences","connection_collation":"utf8mb3_general_ci","table_collation":"utf8mb4_0900_ai_ci"}
{"timestamp":"2023-03-16 15:16:13.341 Z","level":"warn","msg":"Table collation mismatch","caller":"sqlstore/store.go:1235","table_name":"users","connection_collation":"utf8mb3_general_ci","table_collation":"utf8mb4_0900_ai_ci"}
{"timestamp":"2023-03-16 15:16:13.344 Z","level":"warn","msg":"Table collation mismatch","caller":"sqlstore/store.go:1235","table_name":"uploadsessions","connection_collation":"utf8mb3_general_ci","table_collation":"utf8mb4_0900_ai_ci"}
{"timestamp":"2023-03-16 15:16:13.347 Z","level":"warn","msg":"Table collation mismatch","caller":"sqlstore/store.go:1235","table_name":"channels","connection_collation":"utf8mb3_general_ci","table_collation":"utf8mb4_0900_ai_ci"}
{"timestamp":"2023-03-16 15:16:13.350 Z","level":"warn","msg":"Table collation mismatch","caller":"sqlstore/store.go:1235","table_name":"publicchannels","connection_collation":"utf8mb3_general_ci","table_collation":"utf8mb4_0900_ai_ci"}
{"timestamp":"2023-03-16 15:16:13.366 Z","level":"info","msg":"Pinging SQL","caller":"sqlstore/store.go:240","database":"master"}
{"timestamp":"2023-03-16 15:16:13.419 Z","level":"warn","msg":"Failed to delete unused features","caller":"sqlstore/preference_store.go:35","error":"Error 1146 (42S02): Table 'mattermost.Preferences' doesn't exist"}
Error: failed to initialize platform: unable to ensure asymmetric signing key: failed to get system property with name=: Error 1146 (42S02): Table 'mattermost.Systems' doesn't exist
{"timestamp":"2023-03-16 15:16:13.471 Z","level":"error","msg":"License key from https://mattermost.com required to unlock enterprise features.","caller":"platform/license.go:106","error":"resource: License id: "}
{"timestamp":"2023-03-16 15:16:13.477 Z","level":"warn","msg":"Failed to save AsymmetricSigningKey","caller":"platform/config.go:241","error":"failed to save system property with name=AsymmetricSigningKey: Error 1146 (42S02): Table 'mattermost.Systems' doesn't exist"}
{"timestamp":"2023-03-16 15:16:13.477 Z","level":"error","msg":"failed to initialize platform: unable to ensure asymmetric signing key: failed to get system property with name=: Error 1146 (42S02): Table 'mattermost.Systems' doesn't exist","caller":"commands/server.go:76"}
Usage:
  mattermost [flags]
  mattermost [command]

Available Commands:
  completion  Generate the autocompletion script for the specified shell
  db          Commands related to the database
  export      Export data from Mattermost
  help        Help about any command
  import      Import data.
  jobserver   Start the Mattermost job server
  server      Run the Mattermost server
  version     Display version information

Flags:
  -c, --config string   Configuration file to use.
  -h, --help            help for mattermost

Use "mattermost [command] --help" for more information about a command.

Hi @backendteam and welcome to the Mattermost forums!

I’m not 100% sure, but it looks like your database is not properly created.
You seem to be using the MySQL backend, is that right? If so, can you please post the output of a show tables command from within the database mattermost? It looks like the table names are all lowercase, when they need to be starting with an uppercase character for MySQL.