Connect to external database

[hing]

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:

[RSmith]

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

[hing]

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

，The logic is a bit messed up
So not sure if external databases are supported

[MrGeneration]

@hing

Now MariaDB already exists

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.