MySQL_installation

[kjbechcicki]

Hello everyone!
I want to install zammad with mysql as db. I followed guide from official site " Install from source"

Using Ubuntu 22.04 and I stuck with the point when I try to migrate db (rake db:migrate). Has everyon face the same issue ? Any solution ?

Blockquote
– create_table(:groups, {:options=>“ENGINE=InnoDB”, :id=>:integer})
→ 0.6335s
– add_index(:groups, [:name], {:unique=>true})
rake aborted!
StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Specified key was too long; max key length is 3072 bytes
/usr/share/rvm/gems/ruby-3.1.3/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:in _query' /usr/share/rvm/gems/ruby-3.1.3/gems/mysql2-0.5.5/lib/mysql2/client.rb:151:in block in query’
/usr/share/rvm/gems/ruby-3.1.3/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:in handle_interrupt' /usr/share/rvm/gems/ruby-3.1.3/gems/mysql2-0.5.5/lib/mysql2/client.rb:150:in query’
< Blockquote

[MrGeneration]

The MariaDB / MySQL support is nearing it’s supported end and will be removed with Zammad 7. You should not start with MySQL at this point, please stick to PostgreSQL.

This also brings all supported features. MySQL does no longer provide the required database support all Zammad functions require.

[kjbechcicki]

I have already installed zammad with postgres db and everything worked like a charm. The problem is the fact that people I work with insist on mysql version ;/ The fact that something nearing to end doesn’t mean end so I ask kindly again. Anybody face the same issue ?

ERROR during db:migrate step

StandardError: An error has occurred, all later migrations canceled:
Mysql2::Error: Specified key was too long; max key length is 3072 bytes

[MrGeneration]

I’m not going to help you with a fresh MySQL installation.
It’s your problem that your customer insists on MySQL, sorry.