digineo / ansible-otrs4

Ansible role to install OTRS 4 on a Debian/Ubuntu with PostgreSQL.

OTRS 4

Installs OTRS 4 on a Debian/Ubuntu host with PostgreSQL.

Role Variables

The following variables are defaults an can be overridden:

otrs_version: 4.0.4

Example Playbook

- hosts: servers
  roles:
  - { role: otrs4, otrs_version: "4.0.4" }

License

This code is licensed under MIT license

ansible-otrs4's Issues

Database query failed: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

I'm not sure if that error only happen on my side, i'm really not a PostgreSQL expert. But i've changed the default template to template0.

msg: Database query failed: 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.

diff --git a/tasks/main.yml b/tasks/main.yml
index 5adaa84..83657fa 100644
--- a/tasks/main.yml
+++ b/tasks/main.yml
@@ -72,6 +72,7 @@
   postgresql_db:  name=otrs
                   owner=otrs
                   encoding='UTF-8'
+                  template=template0
                   login_unix_socket=/var/run/postgresql
                   login_user=root

default login?

I just used your role to build my own role for installing OTRS 5.x with mariadb. thanks!

Unfortunately I don't know how to log in the first time, otrs-docs tell me "root@localhost // root" but that does not work for me.
I can set a new password via database, but it would be cool to know the default login or even add some task to set that password from within the role.

edit: ok, it is possible to use the web-installer to set that password. That is OK for running it now and then, for regular test-VMs it might be worth automating that as well. Maybe I find the time to try that ;-)