Connect to external database

Infos:

  • Used Zammad version: 5.2.1
  • Used Zammad installation type: (source, package, docker-compose, …)
  • Operating system: debian 11
  • Browser + version:

Hello
Zammad teams
Does zammad support connecting to an external database?
Thanks.

Expected behavior:

Actual behavior:

Steps to reproduce the behavior:

For what?, some color around the scenario may help.

Also for Zammad itself, the preferred DB is PostgreSQL, but others are listed FYI.

https://docs.zammad.org/en/latest/prerequisites/software.html

If it was me and I wanted to set up a scenario of maybe an APP server & separate DB server I would test some settings in the /opt/zammad/config/database.yml, it clearly states you can specify a hostname and port if the DB(supported DB as mentioned) is not on the local host.

If you were wondering how to do this, maybe do a standard/initial install and then, create, migrate and seed the DB on the remote host.

No reason not to test it on a Sandbox.

Cheers
Robert

1 Like

Hello
thanks for you reply

We are planning to use APP server & separate DB server method
Now MariaDB already exists

I use Install from source to install zammad,
when installed to
https://docs.zammad.org/en/latest/install/source.html#step-2-install-dependencies

If choose mariadb/mysql
Then when the “Install Gems for Zammad” chapter:
$bundle set config without “test development postgres”
log:
Could not find command “set”.
$ bundle install
log: (without the following error if libpq-dev is installed)
Installing pg 1.2.3 with native extensions
Gem::Ext::BuildError: ERROR: Failed to build gem native extension.
An error occurred while installing pg (1.2.3), and Bundler cannot continue.

Then, Step 4 is also a problem
https://docs.zammad.org/en/latest/install/source.html#step-4-initialize-your-database

and
systemctl status zammad: show service started
Active: active (running)
But I get an error when I execute the following command
&zammad run rails r “Setting.set(‘es_url’, ‘http://localhost:9200’)”
-bash: zammad: command not found

:innocent:,The logic is a bit messed up
So not sure if external databases are supported

Don’t. Go with postgresql right away even if others is supported.

If your take is “but it’s supported”, clearly read this:
https://docs.zammad.org/en/latest/prerequisites/software.html#database-server

If you then don’t understand why I’m rushing you to postgresql, you don’t understand the scope and really should avoid MariaDB with Zammad.