search

esl / MongooseIM

MongooseIM is Erlang Solutions' robust, scalable and efficient XMPP server, aimed at large installations. Specifically designed for enterprise purposes, it is fault-tolerant and can utilise the resources of multiple clustered machines.
Other
1.67k stars 427 forks source link

Doesn't work with MariaDB #1801

Closed shaljam closed 6 years ago

shaljam commented 6 years ago

MongooseIM version: 2.1.1 Installed from: pkg Erlang/OTP version: Erlang/OTP 19 [erts-8.3.5] OS: Ubuntu 16.04

I get the same error with MariaDB 10.2.14. How can I update mysql-otp?

fenek commented 6 years ago

Hi @shaljam

Current MongooseIM master features updated mysql-otp and the next release will be available on Tuesday. Package should be available for download on Wednesday in worst case.

ludwikbukowski commented 6 years ago

When last time I tested mongooseim with MariaDB there were problems with applying scheme because some columns had too big size e.g[1] - the maximum size is 767 bytes.

[1] https://github.com/esl/MongooseIM/blob/master/priv/mysql.sql#L26

shaljam commented 6 years ago

@ludwikbukowski Seems like MariaDB >= 10.2.2 solves that problem (from this answer), but this arises.

kzemek commented 6 years ago

@ludwikbukowski MySQL <= 5.7.8 and equivalent MariaDB versions need additional configuration as per Version notice section in docs.

ludwikbukowski commented 6 years ago

Oh thanks!, it didn't see this section before ;P