Migrating Openfire 3.6.3 HDB to 3.10.2 PSQL


I am trying to migrate our current openfire 3.6.3 server runnig HSQL database to a new one, running 3.10.2 and PostgreSQL.

The new server is already running and I thought that I would just need to copy the “insert into ofUser” queries from the HSQLDB to Postgres, however, the server did not accept the users’ password on this new version.

Is this expected ?

Also, the Import/Export plugin did not work on the 3.6.3 version.

Is there any other way to do the user migration between these versions ?

Maybe I am doing something wrong…


Ok, I just found out what it was.

I needed the same ‘passwordKey’ from the 3.6.3 HSQLDB version, stored in the table ‘ofProperty’.