Hi, all!
Can't export data from mnesia :(
I tried ejabberdctl export2odbc myserver.mydomain /tmp/output, but I have received only vcard data (table vcard_search)!
Help me, please! I need export all data include users/passwords for migrate to PostgreSQL!
Looking for ejabberd docs?
To access the most up-to-date ejabberd documentation, please visit docs.ejabberd.im »
mod_ctlextra export to odbc
Submitted by CombatPenguin on Wed, 2006-12-20 11:55
CombatPenguin wrote:I
I tried ejabberdctl export2odbc myserver.mydomain /tmp/output
You are right, there was a bug on mod_ctlextra. Get the new fixed version from SVN, and now the syntax is:
Big thanks!
Big thanks!!! It works!!!
Hmm...
ejabberdctl export2odbc jabber.mydomain /tmp/
Exporting Mnesia table 'last' on server 'jabber.mydomain' to file '/tmp/last.txt'
Exporting Mnesia table 'offline' on server 'jabber.mydomain' to file '/tmp/offline.txt'
Exporting Mnesia table 'passwd' on server 'jabber.mydomain' to file '/tmp/passwd.txt'
Exporting Mnesia table 'private_storage' on server 'jabber.mydomain' to file '/tmp/private_storage.txt'
And next:
=ERROR REPORT==== 20-Dec-2006::20:54:12 ===
E(<3921.23754.19>:ejabberd_hooks:187): {undef,
[{ejd2odbc,
export_private_storage,
["jabber.ellada.com.ua",
"/tmp/private_storage.txt"]},
{lists,foreach,2},
{mod_ctlextra,ctl_process,2},
{ejabberd_hooks,run_fold1,4},
{ejabberd_ctl,process,1},
{rpc,'-handle_call/3-fun-0-',5}]}
running hook: {ejabberd_ctl_process,[["export2odbc",
"jabber.mydomain",
"/tmp/"]]}
** at node ejabberd@jabber **
Tables private_storage and vcard_search not exported! :(
Table not exportable
=ERROR REPORT==== 20-Dec-2006::20:54:12 === E(<3921.23754.19>:ejabberd_hooks:187): {undef, [{ejd2odbc, export_private_storage, ["jabber.ellada.com.ua", "/tmp/private_storage.txt"]},Tables private_storage and vcard_search not exported! :(
I'm developing for ejabberd SVN, and you seem to use ejabberd 1.1.2. Some tables will not be exported. I've updated mod_ctlextra so it does not crash. Please try the new version, and remember that privacy_storage table will not be exported.
Many thanks!!!
You rescued me :)
Thank you!
Don't wish to open a new topic...
How I can see which modules or options ejabberd compiled in?
Interesting odbc support!
P.S. I have binary version from
Sorry for my bad English :(
ejabberd from
ejabberd from has odbc modules compiled in. But it doesn't include native mysql and postgresql drivers.
Thanks
ejabberd from has odbc modules compiled in. But it doesn't include native mysql and postgresql drivers.
Thanks, I have already found in deb-src: DEB_CONFIGURE_EXTRA_FLAGS := --enable-odbc