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.
Hello
Zammad teams
Does zammad support connecting to an external database?
Thanks.
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
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
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.
This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.