Zammad database configuration

pentarou · May 27, 2020, 6:19pm

Hello,

I rented a VPS and followed the installation documentation to install on CentOS via RPM, so I assumed I had to configure a database and even installed the recommended PostgreSQL for this, but everything seems to be pre-configured already.

I have probably followed the wrong documentation, but I am curious how Zammad works now without configuring a database, and if this method is safe and stable to use as it is really a requirement as it will handle important data.

I hope someone can shed some light on this, thank you.

MrGeneration · June 2, 2020, 9:06am

Zammad by default uses a socket connection to your postgresql server.
The authentication is handled on user basis which should be perfectly fine.

Technically this doesn’t have to involve any passwords for that reason.

I think the perfect lecture for that is postgresql documentation:
https://www.postgresql.org/docs/9.1/runtime-config-connection.html

We basically allow user “zammad” to access the database “zammad”. The Zammad services are running as this exact user.

Of course, above only applies in a default installation. No more magic is done.
If you care what exactly has been run, you can view it here:

github.com

zammad/zammad/blob/develop/contrib/packager.io/functions#L131



function stop_zammad () {
  echo "# Stopping Zammad"
  ${INIT_CMD} stop zammad
}

function create_database_password () {
  DB_PASS="$(tr -dc A-Za-z0-9 < /dev/urandom | head -c10)"
}

function create_postgresql_db () {
  if [ -n "$(which postgresql-setup 2> /dev/null)" ]; then
    echo "# Preparing postgresql server"
    postgresql-setup initdb
  fi

  echo "# Creating postgresql bootstart"
  ${INIT_CMD} enable postgresql.service

  echo "# Restarting postgresql server"
  ${INIT_CMD} restart postgresql

Functions is called by https://github.com/zammad/zammad/blob/develop/contrib/packager.io/postinstall.sh
on every installation and upgrade.

pentarou · June 5, 2020, 1:50pm

Thank you kindly for your reply, MrGeneration, this answers my question.

system · October 3, 2020, 1:50pm

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