Home » Forums » ejabberd & XMPP » ejabberd Administration

Getting all roster entries

Submitted by synack on Mon, 2011-02-07 13:40

Hi there

I'm looking to get a full list of all roster entries, so I can easily do a compare against what I have in my mySQL db. I thought I could do a dump of the roster DB, then parse it, but the problem I'm having, is that it 

ejabberdctl dump_table roster.txt roster

seems to fail with a memory error. I think that perhaps it is trying to write too much to memory before actually writing the file.

As there another way of getting all the roster entries?

‹ Active Directory setup questions 2.1.3 invalid host error on OpenBSD 4.8 x64 (newbie) ›

synack wrote: As there

Submitted by mfoss on Mon, 2011-02-07 15:58.
synack wrote:

As there another way of getting all the roster entries?

You can also try other commands, maybe one of them is efficient enough for your database:

$ ejabberdctl export2odbc localhost /tmp/

$ ejabberdctl dump /tmp/ejabberd.dump
Dump internal Mnesia database to a text file dump. 

$ ejabberdctl export_piefxis /tmp/

If you have installed mod_admin_extra, you can run this command, but it only provides pairs of JIDs, not all the contact information:

$ ejabberdctl process_rosteritems list any any any any
There are 2 roster items in total.
Matches: badlop2@localhost badlop@localhost
Matches: badlop@localhost badlop2@localhost

And of course, you can also view the users rosters in the WebAdmin.

»
Syndicate content

User login