powered by Jive Software

Problem with creating rooms (2005-07-16)

With the latest build i have such problem. When trying to create room it always says that a room with such ID already exist, and when i look in summary it appears there indead. maybe i should still edit messenger.script like Gato has advised me in this thread?

http://www.jivesoftware.org/forums/thread.jspa?threadID=15061

and this is what i’'ve got while trying to change some settings in such room:

Exception:

org.jivesoftware.messenger.muc.ConflictException

at org.jivesoftware.messenger.muc.spi.IQOwnerHandler.processConfigurationForm(IQOw nerHandler.java:359)

at org.jivesoftware.messenger.muc.spi.IQOwnerHandler.handleDataFormElement(IQOwner Handler.java:309)

at org.jivesoftware.messenger.muc.spi.IQOwnerHandler.handleIQ(IQOwnerHandler.java: 87)

at org.jivesoftware.messenger.admin.muc_002droom_002dedit_002dform_jsp._jspService (muc_002droom_002dedit_002dform_jsp.java:289)

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

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.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:78)

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

Hey wroot,

The stack trace that you posted occurs when you are trying to remove all the owners of the room. Since you were editing the room the problem was that the room didn’'t have any owner which is very weird. My guess is that an error occured while creating the room so it now has no owner. Any other error in the logs?

BTW, if you are using the latest nightly build then you should recreate the DB or add the extra fields I mentioned before.

Regards,

– Gato

wow. I have edited messenger.script and JM is not even starting up. I’'ve got errors in Startup console.

Changes:

ROLESTOBROADCAST INTEGER NOT NULL useReservedNick INTEGER NOT NULL, canChangeNick INTEGER NOT NULL, canRegister INTEGER NOT NULL[/b],CONSTRAINT MUCROOM_PK PRIMARY KEY(NAME))

Strange:

One file has dissapeared in embedded-db dir. I think it was messenger.lck or like.

Error in console:

Database setup or configuration error: Please verify your database settings and check the logs/error.log file for detailed error messages.

java.lang.IllegalArgumentException: java.lang.NullPointerException

at org.jivesoftware.messenger.XMPPServer.verifyDataSource(XMPPServer.java:416)

at org.jivesoftware.messenger.XMPPServer.start(XMPPServer.java:188)

at org.jivesoftware.messenger.XMPPServer.(XMPPServer.java:117)

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at java.lang.Class.newInstance0(Unknown Source)

at java.lang.Class.newInstance(Unknown Source)

at org.jivesoftware.messenger.starter.ServerStarter.start(ServerStarter.java:82)

at org.jivesoftware.messenger.starter.ServerStarter.main(ServerStarter.java:46)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at com.exe4j.runtime.LauncherEngine.launch(Unknown Source)

at com.exe4j.runtime.WinLauncher.main(Unknown Source)

Caused by: java.lang.NullPointerException

at org.jivesoftware.messenger.XMPPServer.verifyDataSource(XMPPServer.java:405)

… 16 more

Error starting the server. Please check the log files for more information.

Server halted

So i have messed up my DB totally?

Hey wroot,

Is a comma missing before “useReservedNick INTEGER”? Have you added a value for each new column in the existing mucRooms? To do that you will need add something like “,0,1,1” as final values in the “INSERT mucRoom” commands.

Regards,

– Gato

The messenger.lck file is an internal file used by the db to indicate that it is being used. So when you stop the server that file should go away.

– Gato

Ok. I have added a comma and final values and now server started up. But there was nothing in Rooms Summary, so i have deleted all MUC INSERTS and started server again. Now i can create rooms and they stay after restart. Though i will try tomorrow after upgrading it again.

So, are these changes to DB in 2.2.0 affecting only MUC?

Yep, those were the last changes made to the database.

Regards,

– Gato

Ok. Thanx. That’'s all for now

so, i’'m downloading 2005-07-20 now. What do i need to edit/add this time?

Wroot,

Delete all the INSERTs in the table jiveVCard. and and edit the CREATE TABLE jiveVCard to include this info:

username VARCHAR(32) NOT NULL,

value LONGVARCHAR NOT NULL,

CONSTRAINT jiveVCard_pk PRIMARY KEY (username)

That’'s all. And remember to make a back up first.

Regards,

– Gato

Nevermind. I’'ve tried to edit DB and JM started successfully, but then i still had problems with rooms. So i have installed 2.2.0b2 clean now.