Howto resolve database problem on new install

Openfire Plugins Asterisk-IM
1

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(HttpConnection.java:381)

at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396)

at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442)

2007.12.17 22:50:40 org.jivesoftware.phone.database.DbPhoneDAO.getPhoneServers(DbPhoneDAO.java:633)

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 n.java:36)

at org.jivesoftware.phone.database.DbPhoneDAO.getPhoneServers(DbPhoneDAO.java:625)

at org.jivesoftware.phone.BasePhoneManager.getPhoneServers(BasePhoneManager.java:1 05)

at org.jivesoftware.phone.jsp.phone_002dsettings_jsp._jspService(org.jivesoftware. phone.jsp.phone_002dsettings_jsp:178)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

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

at org.jivesoftware.openfire.container.PluginServlet.service(PluginServlet.java:86 )

at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)

2

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.

3

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.

Sjobeck