Howto resolve database problem on new install

Good Evening,

I just performed a brand new install of openfire as well as the asterisk plugin. I didn’t get any error messages and things seem to be working properly but when I try to add a new asterisk server this is the error message I get. Any comments?

at org.mortbay.jetty.HttpConnection.handle(


at org.mortbay.thread.BoundedThreadPool$

2007.12.17 22:50:40

java.sql.SQLException: Table not found in statement

at org.hsqldb.jdbc.Util.throwError(Unknown Source)

at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)

at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)

at org.jivesoftware.database.AbstractConnection.prepareStatement(AbstractConnectio


at 05)

at phone.jsp.phone_002dsettings_jsp:178)

at org.apache.jasper.runtime.HttpJspBase.service(

at javax.servlet.http.HttpServlet.service(

at org.jivesoftware.openfire.container.PluginServlet.handleJSP( 228)

at org.jivesoftware.openfire.container.PluginServlet.service( )

at javax.servlet.http.HttpServlet.service(

at org.mortbay.jetty.servlet.ServletHolder.handle(

This appears to be caused by my using the internal database. I did another new install on a different site this morning using the mysql database and it came up just fine.

I wonder if there is a SQL query/script out there that we can use to manually create this new table? We are in a situation where a series of upgrades have slowly but surely made this go sideways on us & we would like to just reset it, just delete the table & create it fresh (using mySQL 5.x). Is this query out there somewhere?

Thanks so much.