Database could not be created


  • Used Zammad version: 2
  • Used Zammad installation source: (source, package, …) package
  • Operating system: CentOS 7.2
  • Browser + version: FF 56

Expected behavior:

  • Default Database creation

Actual behavior:

  • Could not create

Steps to reproduce the behavior:

I am trying to install zammad package using yum but while installation it gives up error saying-

createdb: database creation failed: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)
HINT: Use the same encoding as in the template database, or use template0 as template.

Since the database has not imported, zammad has not started in port no 3000

Have installed it in CentOS 7 in another location few days back, this errors did not props up.


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

Having the same error message, when trying to run db:create.

Used Zammad version: 6.1.develop
Used source: package
OS: Debian 12 on WSL
Locale: LANG=en_US.UTF-8

Created the database manually:

root@Yogabook:~# sudo -u postgres psql
psql (15.3 (Debian 15.3-0+deb12u1))
Type "help" for help.

postgres=# CREATE database zammad with owner zammad;

Please make sure, the database is created in UTF8-mode. I am not sure, if the command above is taking care of that.