Wildfire ran fine, but after upgrading the the latest 3.3.0 of Openfire the program keeps shutting down. I unstalled everything and installed a brand new version of Openfire but the problem continues. I am running it on Windows2003.
Here is my warn log. The last line was written just before it shut down “No ACK was received when sending stanza” What exactly does it mean?
Thanks for any help you can provide.
warn.log
2007.04.16 12:20:02 Error when trying to update to new name
java.sql.SQLException: Table not found in statement
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement. in dwr.xml
2007.04.17 13:30:52 Autocreating jiveID row for type ‘‘125’’
2007.04.17 18:35:58 No ACK was received when sending stanza to: org.jivesoftware.openfire.nio.NIOConnection@1461b5b MINA Session: (SOCKET, R: /72.168.145.73:11007, L: /72.32.209.224:5222, S: 0.0.0.0/0.0.0.0:5222)
Under wildfire/bin/extras there’‘s a viewer for the internal db. It think that’‘s where you’‘ll need to go and run the commands above. On my linux box it’‘s embedded-db-viewer.sh but I imagine there’'s something similar in the windows version.
these entries are fine. I assume that you got the error message only during the first startup as there was not yet a jiveversion table.
It’‘s fine if it’'s in the .script or the .log file. The .log file will be written as long as Openfire runs and every time you shut it down properly the .script file will be updated.
No. I get the error message all of the time. It has been happening for 3-4 days. It did it after the upgrade, so I uninstalled everything and installed the new version from scratch and still have the problem.
Openfire will not run than 2-3 hours at a time before it shuts itself down. Here I am trying to sell my boss on the values of having an in house IM and I can’'t even keep the one we have running.
Did you try to find the internal db viewer? If it’'s not there, it looks like you should be able to connect to it via JDBC. On linux, the config file is wildfire/bin/extra/embedded-db.rc
it contains
urlid embedded-db
url jdbc:hsqldb:…/…/embedded-db/wildfire
username sa
password
probably a little different for you since you’'re actually using the internal db, but hopefully you can work something out
There is no external viewer for windows and I have no clue how to use JDBC on a windows box. I’‘m a linux admin, but the companie I work for runs everything on windows boxes (I’'m working on changing that).
I’‘m afraid that if I can’‘t get this working by tonight I am going to have to drop Openfire and look for another solution. I’'m willing to work the bugs out but my boss is not.
I’‘m sorry to hear you’'re having so much trouble.
There is a viewer for the embedded database that comes with the Windows installation as well. It should be in your C:\Program Files\Openfire\bin\extra directory and it’'s called embedded-db-viewer.bat. Be sure the Openfire is not running when you run the viewer. If the viewer is not there please let me know and I can either email it to you or attach it to this thread.
Well, we certainly want to keep the lyncing to an absolute minimum.
I’‘m a little bit surprised that a missing table would cause Openfire to shutdown after a few hours. It’'s too bad that you how to downgrade before we had a chance to figure out was going on…
Going forward, since you’‘re in a Windows environment is there a installation of SQLServer available somewhere that you can use? Typically, running Openfire with an external database is the prefered type of installation since you can take advantage of the infrastructure (greater levels of procssing power, extra memeory, backups, monitoring, etc.) that companies typically allot to database installations, and you can take some load off of Openfire since it doesn’'t have to use resources to keep the internal database up and running.