Add user/asterisk phone mapping error

Openfire Plugins Asterisk-IM
1

Folks,

I’‘m trying to add an user /asterisk phone mapping but I’'m getting these error logs:

2005.11.21 18:28:46 [org.jivesoftware.messenger.plugin.phone.phone_002dusers_jsp.jspService(phone 002dusers_jsp.java:268)

]

java.lang.IllegalArgumentException: Invalid type

at org.jivesoftware.database.SequenceManager.nextID(SequenceManager.java:83)

at org.jivesoftware.database.SequenceManager.nextID(SequenceManager.java:114)

at org.jivesoftware.phone.database.JiveIDGenerator.generate(JiveIDGenerator.java:2 7)

at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractS aveEventListener.java:85)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrReq uestedId(DefaultSaveOrUpdateEventListener.java:184)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(Defa ultSaveOrUpdateEventListener.java:173)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.performSaveOrUpdate(De faultSaveOrUpdateEventListener.java:96)

at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(Default SaveOrUpdateEventListener.java:69)

at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:464)

at org.hibernate.impl.SessionImpl.saveOrUpdate(SessionImpl.java:459)

at org.jivesoftware.phone.database.HibernatePhoneDAO.save(HibernatePhoneDAO.java:1 20)

at org.jivesoftware.phone.BasePhoneManager.save(BasePhoneManager.java:42)

at org.jivesoftware.messenger.plugin.phone.phone_002dusers_jsp._jspService(phone_0 02dusers_jsp.java:264)

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

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

at org.jivesoftware.messenger.container.PluginServlet.handleJSP(PluginServlet.java :227)

at org.jivesoftware.messenger.container.PluginServlet.service(PluginServlet.java:9 1)

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

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

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:822)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

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:813)

at org.jivesoftware.util.LocaleFilter.doFilter(LocaleFilter.java:43)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.util.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingF ilter.java:41)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.jivesoftware.admin.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)

at org.mortbay.jetty.servlet.WebApplicationHandler$CachedChain.doFilter(WebApplica tionHandler.java:813)

at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler. java:494)

at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:569)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)

at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.ja va:624)

at org.mortbay.http.HttpContext.handle(HttpContext.java:1434)

at org.mortbay.http.HttpServer.service(HttpServer.java:896)

at org.mortbay.http.HttpConnection.service(HttpConnection.java:814)

at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:981)

at org.mortbay.http.HttpConnection.handle(HttpConnection.java:831)

at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:244)

at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:366)

at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)

JM Version: 2.3.0

Asterisk-IM: 1.0.0

I’‘ve already restarted my Jive messenger and my Asterisk server, but it’'s still showing these errors.

Any Ideas?

Thanks in Advance,

Eduardo

2

Oi Eduardo,

Which DB are you using? Could you execute this statement “SELECT * FROM jiveID” and check that you have idTypes with values 100 and 101? If not you will have to execute any or both of these statements according to which one is missing:

insert into jiveID (idType, id) values (100,1);

insert into jiveID (idType, id) values (101,1);

Adeus,

– Gato

3

Gato,

I did what you said before and now it’'s working perfectly.

Regards,

Eduardo