Hello guys, I think I really need help for this one
Here’s the story, I’ve got old server installed openfire 3.8.2 and I want to move all of it’s database (most important username & pass) to new server installed openfire 3.9.3.
I use MySQL for openfire database, when I tried to export all database from old openfire server and import it to new openfire server, all of my friend can’t login to their account, of course before import old database, I already create a new database in new server.
Is it because openfire 3.8.2 didn’t use encryption when first installed (blowfish or AES) like openfire 3.9.3 ? Or am I the one who did the wrong move when moving my old openfire database ?
Then I notice there’s a different table labeling from openfire 3.8.2 and 3.9.3, let say in 3.8.2 user login database store in ofuser and in 3.9.3 store in ofUser, because of this I create a fresh database, direct my openfire 3.9.3 to that database and import only ofuser from 3.8.2 to 3.9.3 in hope they can login to their account, but still my client can’t login to their account.
NB : their password is stored in encryptedPassword column, and when I checked, the content from encryptedPassword column old and new are the same.
And here lies the problem, I need to move it’s database to a new server, so it’s not upgrade openfire from 3.8.2 to 3.9.3 on the same server but move database from old openfire 3.8.2 server to new openfire 3.9.3 server. any idea ?
I think he has a db on the same server with the old Openfire and wants to scrap that server. There should be tools to dump MySQL database and move it to a new server.
Btw wroot, do you have userExportImport plugin version 2.3.1 ? I think that plugin can solve my problem, I tried download from igniterealtime, but I don’t think they have the older version.
One more thought. If you are trying to export the db from 3.8.2 server and import it to 3.9.3 server, then maybe that’s the problem. Install 3.8.2 on the new server, then try importing the db and then upgrade to 3.9.3.