Illegal JID

Rich2 · April 20, 2006, 10:00pm

We are using a mix if Spark 1.1.3 and 1.1.4 with Wildfire 2.6.2. To make it easier on our account admin we left account creation open for a few days. Some users are hacking around trying to test security or more likely just messing with us.

Some accounts they have created are too long to delete, they show in the logs as an illegal JID and I get messages like this: Node cannot be larger than 1023 bytes. Size is 4032 bytes. I can see them, but when I delete them I get a java exception error or kicked from the admin console.

Is there a way I can delete these guys? Right now I am lookign to export my users with the plugin, clean the list and reimport them on to a fresh server. The open account creation will be closed soon and it wont be an issue then, but I prefer to have a way out of this for the future. Thanks!!

Gaston_Dombiak · April 20, 2006, 10:40pm

Hey Rich,

All these problems are important to be fixed. Can you post the exceptions that you have in your log files? We should be able to fix them so you can easily delete these users from the admin console. Meanwhile, you can try deleting them from the database (once the server has been stopped).

The tables where you will have to delete some data are:

jiveUser

jiveUserProp

jiveRoster (if the user created a roster)

jiveRosterGroups

jivePrivacyList (if user created privacy lists)

jiveOffline (to delete offline messages)

jivePrivate

You can find the complete database schema guide here[/url]

Regards,

– Gato

Gaston_Dombiak · April 20, 2006, 10:41pm

BTW, if you don’'t mind leaving some dangling data in the DB then you can just delete the user from jiveUser and that would be it.

– Gato

Rich2 · April 20, 2006, 10:56pm

Thanks for the reply. I’‘ll start looking into DbVisualizer or iSQL-Viewer to mess around in there. Here is an error from the logs… it doesn’'t look like the error log gets populated when I simply try to delete the account. I cropped a few kilobytes from the userid to make it more readable.

~~-error~~-

java.lang.IllegalArgumentException: Illegal JID: wfi-whooooooaaaaaaaaaaaaaaooooooooooooooooooooaaaaaaaaaaaaaaaaaaaoooooooooooooo ooooooooaaaaaaaaaaaaaaaaaaaaaaaaaaaaaoooooooooooooooooooooooooaaaaaaooooooaaaaaa aaaaaaaaooooooooooooooooooooaaaaaaaaaaaaaaaaaaaooooooooooooooooooooooaaaaaaaaaaa aaaaaaaaaaaaaaaaaaoooooooooooooooooooooooooaaaaaaooooooaaaaaaaaaaaaaaooooooooooo oooooooooaaaaaaaaaaaaaaaaaaaooooooooooooooooooooooaaaaaaaaaaaaaaaaaaaaaaaaaaaaao ooooooooooooooooooooooooaaaaaaooooooaaaaaaaaaaaaaaooooooooooooooooooooaaaaaaaaaa aaaaaaaaaooooooooooooooooooooooaaaaaaaaaaaaaaaaaaaaaaaaaaaaaoooooooooooooooooooo oooooaaaaaaooooooaaaaaaaaaaaaaaooooooooooooooooooooaaaaaaaaaaaaaaaaaaaoooooooooo ooooooooooooaaaaaaaaaaaaaaaaaaaaaaaaaaaaaoooooooooooooooooooooooooaaaaaaooooooaa aaaaaaaaaaaaooooooooooooooooooooaaaaaaaaaaaaaaaaaaaooooooooooooooooooooooaaaaaaa aaaaaaaaaaaaaaaaaaaaaaoooooooooooooooooooooooooaaaaaaooooooaaaaaaaaaaaaaaooooooo oooooooooooooaaaaaaaaaaaaaaaaaaaooooooooooooooooooooooaaaaaaaaaaaaaaaaaaaaaaaaaaaaaoooooooooooooooaaaaaa_yea@wildfire.mycom pany.com

at org.xmpp.packet.JID.init(JID.java:401)

at org.xmpp.packet.JID.(Roster.java:84)

at org.jivesoftware.wildfire.roster.RosterManager.getRoster(RosterManager.java:91)

at org.jivesoftware.wildfire.user.User.getRoster(User.java:280)

at org.jivesoftware.wildfire.plugin.ImportExportPlugin.exportUsers(ImportExportPlu gin.java:143)

at org.jivesoftware.wildfire.plugin.ImportExportPlugin.exportUsersToFile(ImportExp ortPlugin.java:75)

at org.jivesoftware.wildfire.plugin.userImportExport.export_002dfile_jsp._jspServi ce(export_002dfile_jsp.java:50)

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

at org.jivesoftware.wildfire.container.PluginServlet.service(PluginServlet.java:91 )

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.AuthCheckFilter.doFilter(AuthCheckFilter.java:98)