AnsweredAssumed Answered

Howto resolve database problem on new install

Question asked by dkwiebe on Dec 17, 2007
Latest reply on May 2, 2008 by support@sjobeck.com

 

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)

 

 

Outcomes