Migrating mod_mam from mnesia tosqlite, archive_msg.DAT not exported to sql

[blob42]

Hi,

I reached the limit of messages archive with mod_mam and decided to setup sqlite database. I followed the procedure by initializing the shema on sqlite db and setting sql_type and sql_database in the config as well as changing db_type: sql in mod_mam.

I used the export2sql command then I imported back into the sqlite database. mod_mam seems working well, I don't have any errors about the archive limit with Mnesia.

However it is obvious that the export script did not export the previous message archive to sqlite, so if I try to connect with a new XMPP client I only get the message archive since I started using sqlite.

I can see that the file archive_msg.DAT is 2G and the sqlite database only weights ~500Ko.

How do I migrate the previous messages to sqlite ? I can see that the feature is implemented in mod_mam_sql but I have no idea how to use the code.

EDIT: I realized that now the command edj2sql does not exist when I type I have no completion

[blob42]

SOLVED: There were two problems from my side:

1. I was not adding the dot at the end of statements in the debug console
2. I was not using the right domain to run the export command, it looks like it changed at some point and now I have to use the host as defined in ejabberd.yml instead of previously using "ejabberd@ejabberd"

see #3867