Synapse / Matrix Container cannot create database

Hi Folks,

after installation of Matrix / Synapse App from App center I see the container always rebooting.

Container Logs show that the container seem to create database with the following error:

2020-08-25 09:02:07,677 - twisted - 192 - ERROR - None - ********************************************************
2020-08-25 09:02:07,678 - twisted - 192 - ERROR - None -  Database is incorrectly configured:
2020-08-25 09:02:07,678 - twisted - 192 - ERROR - None -
2020-08-25 09:02:07,678 - twisted - 192 - ERROR - None -      - 'COLLATE' is set to 'en_US.UTF-8'. Should be 'C'
2020-08-25 09:02:07,678 - twisted - 192 - ERROR - None -      - 'CTYPE' is set to 'en_US.UTF-8'. Should be 'C'
2020-08-25 09:02:07,678 - twisted - 192 - ERROR - None -
2020-08-25 09:02:07,679 - twisted - 192 - ERROR - None -  See docs/postgres.md for more information.
2020-08-25 09:02:07,679 - twisted - 192 - ERROR - None - ********************************************************

could someonw please help how to fix / solve this issue?

best,

Mat

Help yourself, then the community will help you

Things to fix this:

  1. deinstall synapse from UCS - this will leave the postgres db on the server (also a bug?)
  2. DROP synapse db from postgresql server
  3. create new empty synapse db following https://github.com/matrix-org/synapse/blob/develop/docs/postgres.md
  4. install synapse App from UCS app store.

enjoy