At present I have Openfire 3.4.4 installed with a Embedded Database, running on Windows XP, it is a trial system, and has a few users on their (about 10)
All the users use LDAP to authenticate, and we use the embedded Database
Now we are ready to roll this out, to members of our organistaion, and we have decided to run Openfire on CentOs, with a MySql DB.
I have been (unsuccessfully) trying to migrate the existing users Roster etc that is stored in the Windows trial version to the Centos Version.
I have read various discussion on this community about how to do this, including using the export import tool, however for some reason on the Windows Machine it does not want to export the users, downloading to a file, it goes to 101% and says that it can’t find the file export-user-data.jsp
printing it to the screen causes this error
I have gone into the opefire.script, and tried to copy the (what looks like) SQL into MySql, however it causes this error
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘MEMORY TABLE JIVEUSER(USERNAME VARCHAR(64) NOT NULL,PLAINPASSWORD VARCHAR(32),EN’ at line 1
So I am now I am all out of ideas - and wondered if anyone else has any ideas maybe.
Look forward to what you guys have to say