Hello,
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
)
VALUES (
“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
)
VALUES (
‘‘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:
Initialized
SSL: disabled
Connected
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)
Edit:
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