Delete user from the DB

Openfire Openfire Support
1

Hi there,

I have a couple of questions:

  1. When I delete the user from the Admin Console, all the user’‘s informations (roster and who have them on their’'s roster too, and so on) are erased in the DB as well?

  2. If I erase directly from the DB, where do I have to delete to erase it all, like I said above?

For the second question, the most relevant tables and keys are those:

jiveOffline username

jivePrivate username

jiveRoster username

jiveRoster jid

jiveRosterGroups rosterID same as in jiveRoster rosterID

jiveUser username

jiveUserProp username

jiveVCard username

There are any others?

ps: DB is MySQL

regards,

Rodrigo.

2

Anyone?

3

Hi,

deleting users is something which does not run fine. Even if you use the admin console you will have to do some post work. Caleb posted a script to do this here:

http://www.jivesoftware.org/community/thread.jspa?threadID=17274&tstart=0

It is the same issue for all databases.

LG