Hi
I have the same problem with “configuraiton does not save” and “phone mapping blank page”
-
I first had the 3.1.0.1 beta of wildlife server with asterisk-im 1.1.1 - the second problem happened.
-
then I’'ve upgraded asterisk-im to this beta = 1.2.0beta2 - and both of the above happened.
-
then I read this forum messages and tried to downgrade the wildlife to version 3.0.1 (release)
still the same behavior with both asterisk-im plugin versions…
The only thing I haven’'t done is using MySQL instead of embedded DB. Is that really necessary?
Here is the latest test logs with:
Error log of WildLife 3.0.1:
at org.jivesoftware.phone.BasePhoneManager.getPhoneServers(BasePhoneManager.java:1 02)
at org.jivesoftware.phone.asterisk.AsteriskPhoneManager.init(AsteriskPhoneManager. java:52)
at org.jivesoftware.phone.asterisk.AsteriskPlugin.initPhoneManager(AsteriskPlugin. java:82)
at org.jivesoftware.phone.PhonePlugin.init(PhonePlugin.java:94)
at org.jivesoftware.phone.PhonePlugin$1.call(PhonePlugin.java:278)
at org.jivesoftware.phone.PhonePlugin$1.call(PhonePlugin.java:276)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2006.10.07 17:34:22 org.jivesoftware.phone.database.DbPhoneDAO.insert(DbPhoneDAO.java:447) Table not found in statement
java.sql.SQLException: Table not found in statement
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(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.insert(DbPhoneDAO.java:436)
at org.jivesoftware.phone.BasePhoneManager.createPhoneServer(BasePhoneManager.java :119)
at org.jivesoftware.phone.asterisk.AsteriskPhoneManager.createPhoneServer(Asterisk PhoneManager.java:239)
at org.jivesoftware.phone.asterisk.AsteriskPhoneManager.loadLegacyServerConfigurat ion(AsteriskPhoneManager.java:87)
at org.jivesoftware.phone.asterisk.AsteriskPhoneManager.init(AsteriskPhoneManager. java:55)
at org.jivesoftware.phone.asterisk.AsteriskPlugin.initPhoneManager(AsteriskPlugin. java:82)
at org.jivesoftware.phone.PhonePlugin.init(PhonePlugin.java:94)
at org.jivesoftware.phone.PhonePlugin$1.call(PhonePlugin.java:278)
at org.jivesoftware.phone.PhonePlugin$1.call(PhonePlugin.java:276)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
2006.10.07 17:34:23 org.jivesoftware.phone.database.DbPhoneDAO.getPhoneDevices(DbPhoneDAO.java:719) Column not found: SERVERID in statement
java.sql.SQLException: Column not found: SERVERID in statement
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(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.getPhoneDevices(DbPhoneDAO.java:711)
at org.jivesoftware.phone.BasePhoneManager.getAllPhoneDevices(BasePhoneManager.jav a:66)
at org.jivesoftware.phone.asterisk.AsteriskPhoneManager.loadLegacyServerConfigurat ion(AsteriskPhoneManager.java:89)
at org.jivesoftware.phone.asterisk.AsteriskPhoneManager.init(AsteriskPhoneManager. java:55)
at org.jivesoftware.phone.asterisk.AsteriskPlugin.initPhoneManager(AsteriskPlugin. java:82)
at org.jivesoftware.phone.PhonePlugin.init(PhonePlugin.java:94)
at org.jivesoftware.phone.PhonePlugin$1.call(PhonePlugin.java:278)
at org.jivesoftware.phone.PhonePlugin$1.call(PhonePlugin.java:276)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
“Info” log:
2006.10.07 17:34:15 unloading asterisk-im plugin resources
2006.10.07 17:34:15 Unregistering phone plugin as a component
2006.10.07 17:34:16 Reached end of stream, terminating reader.
2006.10.07 17:34:16 Closing socket.
2006.10.07 17:34:22 Found old database version 0 for asterisk-im. Upgrading to version 2…
2006.10.07 17:34:22 Database update successful.
2006.10.07 17:34:22 Initializing phone plugin
2006.10.07 17:34:22 Initializing Asterisk Manager connection
2006.10.07 17:34:22 Connecting to 10.106.72.73 port 5038
2006.10.07 17:34:22 Connected via Asterisk Call Manager/1.0
2006.10.07 17:34:23 Successfully logged in
2006.10.07 17:34:23 Determined Asterisk version: Asterisk 1.2
2006.10.07 17:34:23 Connecting to 10.106.72.73 port 5038
2006.10.07 17:34:23 Connected via Asterisk Call Manager/1.0
2006.10.07 17:34:23 Successfully logged in
2006.10.07 17:34:23 Determined Asterisk version: Asterisk 1.2
Debug log:
2006.10.07 17:34:15 Unloading plugin asterisk-im
2006.10.07 17:34:15 Shutting down Manager connections
2006.10.07 17:34:22 Loading plugin asterisk-im
As can be seen above, I’'ve just restarted the plugin to produce the logs.
Then I did the operations as described in the beginning of the message above
and error log got filled with this:
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
2006.10.07 17:40:11 org.jivesoftware.phone.database.DbPhoneDAO.getPhoneServers(DbPhoneDAO.java:631)
java.sql.SQLException: Table not found in statement
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.(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:623)
at org.jivesoftware.phone.BasePhoneManager.getPhoneServers(BasePhoneManager.java:1 02)
at org.jivesoftware.wildfire.plugin.phone.phone_002dsettings_jsp._jspService(phone _002dsettings_jsp.java:169)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.jivesoftware.wildfire.container.PluginServlet.handleJSP(PluginServlet.java: 234)
at org.jivesoftware.wildfire.container.PluginServlet.service(PluginServlet.java:92 )
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:830)
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)
at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:11 8)
at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:52)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)
at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:65)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)
at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)
at org.jivesoftware.admin.PluginFilter.doFilter(PluginFilter.java:69)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)
at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)
at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:821)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:471)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:816)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:982)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:833)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
TIA
Tomer