I had the same issue, using AD, but had some issues with the recovery:
-I edited the xml config file as listed in this post
-I ran throug the setup again with the same settings as before and added myself as admin
-I’ve tried the process with restarting the service in 42.5 different ways but the same problem always happens:
-All users connecting to openfire with spark & gaim clients would lose ALL of their contacts in their contacts list.
-All contacts appeared in the roster as “not logged in or away” regardless of whether the contact was logged in or not
-So, the only method I’ve found is to re-add all contacts in the individual clients (Spark & gaim).
-Rather than go back through the entire setup process, I tried updating the field in what I was guessing was the correct field for admin users in the openfire database (using mysql) but that didn’t work
-I use a mysqldump every night for backup - Tried restoring the database from a period before I was locked out but the same thing happens - no contacts show up.
Any other thoughts?
I am going to try and do a partial restore of the database since I only really need the conversations to be restored…but I haven’t gone through the schema to see what dependencies I’m going to jack up.
Help and any suggestions are greatly appreciated.