powered by Jive Software

Automized User Creation


I wrote a Program which converts an CSV file containing User Information like Username Name, Email, Password and Department for about 800 Users to Mysql Commands. I wanted to use the department “identification” as User group and automatically sort all users on everyone’'s list using this department id as roaster group.

Here the example commands I used:

INSERT INTO jivegroupuser ( groupName , username , administrator )

VALUES (“Dep1a”, “user.name”, “0”);

INSERT INTO jivegroup ( groupName , description )


“Dep1a”, “Users of Department 1a”);

INSERT INTO jivegroupprop VALUES (Dep1a’’, ‘‘sharedRoster.showInRoster’’, ‘‘everybody’’);

INSERT INTO jivegroupprop VALUES (’‘Dep1a’’, ‘‘sharedRoster.displayName’’, ‘‘Dep1a’’);

INSERT INTO jivegroupprop VALUES (’‘Dep1a’’, ‘‘sharedRoster.groupList’’, ‘’’’);

INSERT INTO jiveuser ( username , password , name , email , creationDate , modificationDate )


‘‘user.name’’, ‘‘password’’, ‘‘User Name’’, ‘‘user.name@mail.cc’’, ‘‘001124201079324’’, ‘‘0’’


All these MySql commands work and the DB is containing all those information after the execution of the commands, but when user.name loges in it hangs at Loading roasters:


SSL: disabled


Bookmarks loaded

Agents loaded[/i]

but then Roaster doesn’'t finish loading / loads…

Does anybody know what the problem is? have i forgotten some mysql tables to insert information? Or is it just too much?

Thanks for your answer, Dr. Ruth Shell

(sorry for my bad english)


The error log:

2006.01.06 16:03:56 [org.jivesoftware.wildfire.handler.PresenceUpdateHandler.process(PresenceUpdate Handler.java:130)

] Interner Serverfehler

java.lang.IllegalArgumentException: Illegal JID: Scheer.Clara Valerie

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

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

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

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

at org.jivesoftware.wildfire.handler.IQRosterHandler.manageRoster(IQRosterHandler. java:179)

at org.jivesoftware.wildfire.handler.IQRosterHandler.handleIQ(IQRosterHandler.java :103)

at org.jivesoftware.wildfire.handler.IQHandler.process(IQHandler.java:48)

at org.jivesoftware.wildfire.IQRouter.handle(IQRouter.java:242)

at org.jivesoftware.wildfire.IQRouter.route(IQRouter.java:78)

at org.jivesoftware.wildfire.PacketRouter.route(PacketRouter.java:65)

at org.jivesoftware.wildfire.net.SocketReader.processIQ(SocketReader.java:390)

at org.jivesoftware.wildfire.net.ClientSocketReader.processIQ(ClientSocketReader.j ava:50)

at org.jivesoftware.wildfire.net.SocketReader.readStream(SocketReader.java:255)

at org.jivesoftware.wildfire.net.SocketReader.run(SocketReader.java:118)

at java.lang.Thread.run(Unknown Source)

Caused by: org.jivesoftware.stringprep.IDNAException: Contains non-LDH characters.

at org.jivesoftware.stringprep.IDNA.toASCII(IDNA.java:106)

at org.jivesoftware.stringprep.IDNA.toASCII(IDNA.java:53)

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

… 21 more


with Spark 1.0.3 you can not create accounts with blanks. I just modified the database entry of my “abc” account and changed it to “ab c”. I can not log in any more using Spark 1.0.3 and get a similar error:

java.lang.IllegalArgumentException: Illegal JID: ab c@jabber…

I assume that the blank character in the JID causes the problem.