Migrating archive to sql issues

[Saphar]

Hello, I am trying to follow the tutorial to migrate mnesia to sql:
https://www.process-one.net/blog/install-and-configure-mariadb-with-ejabberd/

I am experiencing problems with the export of the DB:

ejabberdctl export2sql HOST /tmp/mnesia.sql

I have this installation on debian from bullseye-backports, the node is running:

ejabberdctl status
The node ejabberd@localhost is started with status: started
ejabberd 23.01-1~bpo11+1 is running in that node

I tried first:

ejabberdctl export2sql mydomain.ltd /tmp/mnesia.sql

gives the error:

Failed RPC connection to the node ejabberd@localhost: nodedown

Then I tried:

ejabberdctl export2sql localhost /tmp/mnesia.sql

Giving the error:

Unhandled exception occurred executing the command:
** exception error: {module_not_loaded,mod_muc,<<"localhost">>}
   in function  gen_mod:get_module_opts/2 (gen_mod.erl, line 338)
   in call from gen_mod:get_module_opt_hosts/2 (gen_mod.erl, line 323)
   in call from ejd2sql:export/3 (ejd2sql.erl, line 77)
   in call from lists:foreach/2 (lists.erl, line 1342)
   in call from ejd2sql:export/2 (ejd2sql.erl, line 70)
   in call from ejabberd_ctl:call_command/4 (ejabberd_ctl.erl, line 334)
   in call from ejabberd_ctl:try_call_command/4 (ejabberd_ctl.erl, line 295)
   in call from ejabberd_ctl:process2/4 (ejabberd_ctl.erl, line 235)

In the logs I see the following error:

2023-08-04 04:36:46.488570-04:00 [warning] <0.618.0>@ejabberd_sql:handle_reconnect/2:479 odbc connection failed:
** Reason: {"IM002",0,
            "[unixODBC][Driver Manager]Data source name not found, and no default driver specified Connection to database failed."}
** Retry after: 30 seconds

I do not have any odbc configuration in the config file, I have nothing configured about databases in the config file. But I need to migrate because my archive is over 2GB. Can anyone help me?

[prefiks]

Is your host really named localhost (your config file have localhost in hosts: section)?

[prefiks]

Also if that works try ejd2sql:export(<<"xmpp.my.host">>, <<"/tmp/dump.sql">>)., looks like you need to provide strings that way to this command

[Saphar]

It runs with "ok", but still there is no file.

if I run: su - ejabberd -c "touch /tmp/test" it does put a file there, so permissions are good.

[Saphar]

Other question, if I skip this step will I be able to switch to SQL? (and just loose the archived messages?)

[prefiks]

That depends, if you want to switch all modules to use sql with data conversion, then all data will be not accessible (so also probably accounts, rosters, etc), but if you only set db_type: sql in mod_mam options, then only this module will not see old data, it will just write new data to sql db.

[Saphar]

Thank you. I did that, now it works with SQL.