powered by Jive Software

Having problems adding users

I just installed jive messenger 1.1, and i’'m having problems adding users. I can edit my single administrative user just fine, but cant add any. here is the output on the error log:

2004.09.28 11:34 [com.jivesoftware.xmpp.user.spi.DbUserAccountProvider.createUser(DbUserAccountP rovider.java:68)

] Internal server error

java.sql.SQLException: [SQLServer 2000 Driver for JDBC]Can’'t start a cloned connection while in manual transaction mode.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseStatement.(Unknown Source)

at com.microsoft.jdbc.base.BasePreparedStatement.(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)

at com.jivesoftware.util.ConnectionAdapter.prepareStatement(ConnectionAdapter.java :43)

at com.jivesoftware.xmpp.user.spi.DbUserAccountProvider.createUser(DbUserAccountPr ovider.java:55)

at com.jivesoftware.xmpp.user.spi.UserManagerImpl.createUser(UserManagerImpl.java: 80)

at com.jivesoftware.messenger.admin.user_0002dcreate_jsp._jspService(user_0002dcre ate_jsp.java:692)

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.ja va: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.09.28 11:34 [com.jivesoftware.messenger.admin.user_0002dcreate_jsp._jspService(user_0002dcr eate_jsp.java:721)

]

com.jivesoftware.xmpp.auth.UnauthorizedException: Created an account but could not load it. username: caquijada pass: office email: caquijada@frscorp.net

at com.jivesoftware.xmpp.user.spi.UserManagerImpl.createUser(UserManagerImpl.java: 83)

at com.jivesoftware.messenger.admin.user_0002dcreate_jsp._jspService(user_0002dcre ate_jsp.java:692)

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.ja va: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)

as you can tell im using MS SQL 2000. Im also running jive messenger as a standalone installation, i was able to get it running as a service just fine (I had spent a full day some months ago trying to get 1.08 running as a windows service with no luck).

This happens regardless of how I add a new user (through the web interface, or through a client trying to register). Using Gaim, when I try to register a new user, Gaim seems to be working fine as if it had been able to register a new user, but trying to establish a new session just doesnt happen. I’'ve checked the tables in the database, and no users have been added at all!

could it be that im using an older version of the ms sql jdbc driver? I know some java, but its somewhat limited so im lost as to what it could be.

Try setting the SelectMethod property of the driver to Cursor. For example,

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=messenger;SelectMethod=Cu rsor

Let me know if the problem still persists.

Regards,

– Gato

Wow, that worked. I knew it was going to be something really simple, I just don’'t know enough about database connectivity yet! Thanks!

Messenger 1.1 looks great so far. It’'s one great peice of software