Im trying to install zammad and are following the guide here Install from package — Zammad documentation .
Im using Ubuntu 22.04. My question is how zammad determines what database to use? In Software — Zammad documentation it says that zammad supports PostgreSQL and MySQL, but if i have both installed which will zammad use to work with ?
Anyway the real problem for me following the guide is when i get to Set up Elasticsearch — Zammad documentation and issue the command “zammad run rails r “Setting.set(‘es_url’, ‘http://localhost:9200’)””
I get the error
"/opt/zammad/vendor/bundle/ruby/3.0.0/gems/bootsnap-1.13.0/lib/bootsnap/load_path_cache/core_ext/kernel_require.rb:32:in `require’: Error loading the ‘mysql2’ Active Record adapter. Missing a gem it depends on? libmysqlclient.so.21: cannot open shared object file: No such file or directory - /opt/zammad/vendor/bundle/ruby/3.0.0/gems/mysql2-0.5.4/lib/mysql2/mysql2.so (LoadError)
Dont know how to fix this. It looks like it should be bundled wit hzammad?
After installing libmysqlclient21 it went a bit furter but now fails on
zammad run rails r “Setting.set(‘es_url’,‘http://localhost:9200’)”
nil versions are discouraged and will be deprecated in Rubygems 4
/opt/zammad/vendor/bundle/ruby/3.0.0/gems/mysql2-0.5.4/lib/mysql2/client.rb:148:in `_query’: Mysql2::Error: Table ‘zammad.settings’ doesn’t exist (ActiveRecord::StatementInvalid)
Alright seems to work now.
For it to work for me in Ubuntu 22.04 i had to install libssl 1.1 ( dependencies - Unable to locate package libssl1.1 - Ask Ubuntu) and libmysqlclient21.
With my installation it detected that i used mysql, but i wanted postgresql. So for that to work i followed the Mysql → PostGRE migration with some altercations.
Had to create a user named zammad and give it CREATEDB permissions. After that i did step 4 in Install from source — Zammad documentation . Then i continued with installation guide.
Ubuntu 22 LTS is currently explicitly not supported by the package installation:
Why do you ignore these kind of things.
You should downgrade your OS - other wise any bug you encounter may be caused by your incompatibility and leaves you out alone.
Becouse i saw it too late. Its working as intended now atleast. Im aware as you say that any bugg later on might be due to unsupported platform.
Do you know on top of your head any existing bugs that makes it unusable?