User Creation Exception

Openfire Openfire Support
1

When trying to create a user throught the web interface I get the following exception:

2004.10.11 16:37 [com.jivesoftware.xmpp.user.spi.DbUserAccountProvider.createUser(DbUserAccountProvider.java:68)] Internal server error
java.sql.SQLException: ORA-00911: invalid character
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:407)
at com.jivesoftware.xmpp.user.spi.DbUserAccountProvider.createUser(DbUserAccountProvider.java:53)
at com.jivesoftware.xmpp.user.spi.UserManagerImpl.createUser(UserManagerImpl.java:80)
at com.jivesoftware.messenger.admin.user_0002dcreate_jsp._jspService(user_0002dcreate_jsp.java:693)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:525)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
at org.mortbay.http.HttpServer.service(HttpServer.java:879)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:197)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511) 2004.10.11 16:37 [com.jivesoftware.messenger.admin.user_0002dcreate_jsp._jspService(user_0002dcreate_jsp.java:722)]
com.jivesoftware.xmpp.auth.UnauthorizedException: Created an account but could not load it. username: test pass: test email: test
at com.jivesoftware.xmpp.user.spi.UserManagerImpl.createUser(UserManagerImpl.java:83)
at com.jivesoftware.messenger.admin.user_0002dcreate_jsp._jspService(user_0002dcreate_jsp.java:693)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:294)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:525)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
at org.mortbay.http.HttpServer.service(HttpServer.java:879)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:197)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)

The server installation went fine. Any thoughts on what the problem might be?

Thanks,

Ryan

Environmnet:

  • Jive Messenger 1.1 (Windows Installer)

  • Oracle 8.1.7.4.0 / classes12.zip

2

Ryan,

Thanks for the bug report. The problem is that at the end of the query there is a semi-colon. I’‘m not sure but it’'s probable that a new release of Messenger will be available this week at www.jivesoftare.org which will contain a fix for this bug.

If you can’'t wait for the next release and you need to create those accounts, just let me know and we can find some way out.

Thanks,

– Gato

3

Hi Gato,

Thanks for the feedback. I’'m happy to wait until the next version of Messenger is released to see if the bug has been fixed. Now if only Messenger were open-source I could fix it myself, oh wait…

It would actually be nice if there was some documentation on how to manually insert users either via straight SQL or through the Messenger API. I’'m planning a migration from our current XMPP IM solution to Messenger and would like to make the change as transparent as possible to our users.

Thanks,

Ryan