I have Openfire working reliably for over 2 years, then without notice, sudden failure. Nothing changed on the server, and the server has not been rebooted for 3 years.
This is my openfire-properties file.
#HSQL Database Engine
#Mon Jan 16 08:10:50 HKT 2012
Using ht eembedded database, which I can see, loads up into memory, my guess is that this loads into memory, and now out of memory, refuses to allow any more, and as a resault stops working, users who are logged in can continue, but no new logins accepted.
During this time, no purges have been done, so I most likly need to clean up the message logs.
Any tips for this? Should I copy the openfire.script file and remove the " INSERT INTO OFMESSAGEARCHIVE VALUES( " lines so I can get it running again?
or is there a memory switch that will allow it to run and then I can use the in admin tools to clean up the archives?
Also, any document on moving from the embeded to mysql?