Change Database

malcontent · March 9, 2005, 9:39pm

I want to change the database settings. I set up using the built in HSQL but now want to put it in sql server. Is it OK for me just change the XML file? Will that mess anything up like history?

matt · March 10, 2005, 1:02am

malcontent,

You’‘ll lose any data in the existing database, so you’‘ll need to re-create users. Assuming that’'s not a big deal:

Stop the server.
Edit conf/jive-messenger.xml and set true to false
Start the server and enter the admin console; you should be taken to the setup tool.
This time around, choose the external database option instead of embedded db and enter the relevant info.

Regards,

Matt

Ryan_Graham · March 10, 2005, 2:09pm

Hi malcontent,

If losing your users is a big deal let me know, I might be able to help you out.

Thanks,

Ryan

malcontent · March 10, 2005, 6:46pm

The users are in LDAP so no big deal. I lost a couple of groups but I am testing phase now so again no big deal.

Izhar_Khan · October 13, 2022, 11:36am

i have created embedded database during openfire setup . . . now i wanna connect sql express to openfire but i have no idea.
so please let me know if you know about it.