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 ?
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)
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.
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.