[ejabberd] export2odbc not exporting rosters

Wijnand Wiersma wijnand at nedbsd.nl
Thu Apr 26 00:14:49 MSD 2007


Hi All,

I want to do some migrations and I figured exporting everything known to
ejabberd to SQL will be very handy.
I extended my installation to include the ejabberdctl export2odbc
command and tried to do a export:

root at jabber:/tmp# ejabberdctl export2odbc jabbernet.eu /tmp/jabbernet.eu/
Trying to export Mnesia table 'last' on server 'jabbernet.eu' to file
'/tmp/jabbernet.eu/last.txt'
Trying to export Mnesia table 'offline' on server 'jabbernet.eu' to file
'/tmp/jabbernet.eu/offline.txt'
Trying to export Mnesia table 'passwd' on server 'jabbernet.eu' to file
'/tmp/jabbernet.eu/passwd.txt'
Trying to export Mnesia table 'private_storage' on server 'jabbernet.eu'
to file '/tmp/jabbernet.eu/private_storage.txt'
Trying to export Mnesia table 'roster' on server 'jabbernet.eu' to file
'/tmp/jabbernet.eu/roster.txt'
Trying to export Mnesia table 'vcard' on server 'jabbernet.eu' to file
'/tmp/jabbernet.eu/vcard.txt'
Trying to export Mnesia table 'vcard_search' on server 'jabbernet.eu' to
file '/tmp/jabbernet.eu/vcard_search.txt'
root at jabber:/tmp# cat jabbernet.eu/roster.txt
root at jabber:/tmp#
root at jabber:/tmp# wc jabbernet.eu/*.txt
      1   10895  112278 jabbernet.eu/last.txt
      1   17693  256135 jabbernet.eu/offline.txt
      1    9304  105291 jabbernet.eu/passwd.txt
      0       0       0 jabbernet.eu/roster.txt
      1    2457 1198517 jabbernet.eu/vcard.txt
      1    9735   94246 jabbernet.eu/vcard_search.txt
      5   50084 1766467 total

All files are filled except for the roster.txt file, which is the most
important file for now.
Is this a known bug and does anyone have a solution?

Wijnand





More information about the ejabberd mailing list