Unable to add new user to roster (openfire 3.5.1)

Spark Spark Support
1

After installing openfire 3.5.1 i am unable to add users through spark to my roster. Search lists the users i want to add but when i right click on spark search results and try to add user, spark disconnects from open fire server. Spark logs give this:

SEVERE: Unable to add new entry jonathan@gkptech

No response from the server.:

at org.jivesoftware.smack.Roster.createEntry(Roster.java:249)

at org.jivesoftware.spark.ui.RosterDialog.addEntry(RosterDialog.java:473)

at org.jivesoftware.spark.ui.RosterDialog$4.construct(RosterDialog.java:438)

at org.jivesoftware.spark.util.SwingWorker$2.run(SwingWorker.java:129)

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

Anyone else encountered this with latest openfire release.

2

Found a solution. If you create database from scratch the install script for mysql is wrong for table jive roster. Original query defines

jid VARCHAR(1024) NOT NULL, and the table will not be created. Correct cript for this table is bellow.

CREATE TABLE jiveRoster (

rosterID BIGINT NOT NULL,

username VARCHAR(64) NOT NULL,

jid VARCHAR(255) NOT NULL,

sub TINYINT NOT NULL,

ask TINYINT NOT NULL,

recv TINYINT NOT NULL,

nick VARCHAR(255),

PRIMARY KEY (rosterID),

INDEX jiveRoster_unameid_idx (username),

INDEX jiveRoster_jid_idx (jid)

);

Ill check the other tables to see if they are created properly.