On Tue, 19 Nov 2024 01:46:11 +0100,
Kirill A. Korinsky <kirill@korins.ky> wrote:
> 
> And here it is:
> 
>         2024-11-19 01:40:16.246908+01:00 [critical] <0.647.0>@ejabberd:exit_or_halt/2:158 Failed to start Erlang application 'odbc': no such file or directory: odbc .app. This usually means that ejabberd or Erlang was compiled/installed incorrectly.
>         2024-11-19 01:40:16.247055+01:00 [error] <0.647.0>@ejabberd_hooks:safe_apply/4:460 Hook user_receive_packet crashed when running mod_mam:user_receive_packet /1:
> 
> My point: Postgres and MySQL, both, require setup. Mnesia and sqlite works
> out of the box. Mnesia nice DB but it is used for message archive by default
> and it will be broken, as soon as size hit 2Gb. I think that we should
> enable sqlite for message archive by default, because migration from Mnesia
> to anything is tricky, and allow users to have an explosion when their DB
> reach 2Gb isn't good idea.
> 

Volker had suggested to check that sql_type: sqlite is in config.

Indeed it wasn't. And as soon as I enabled it, it work.

Seems to be no need for ODBC in lang/erlang and no need for unixodbc either.

-- 
wbr, Kirill