Openfire_mysql.sql 3.5.1 - ERROR 1170 at fresh install

Openfire Openfire Support
1
  1. rpm -q openfire

openfire-3.5.1-1

  1. cat openfire_mysql.sql | mysql openfiredb

ERROR 1170 (42000) at line 77: BLOB/TEXT column ‘jid’ used in key specification without a key length

2

Open the following file in your favorite text editor…

e.g.

vi /opt/openfire/resources/database/openfire_mysql.sql

Jump to line 77, it should look like this:

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)
);

Modify the line:

jid VARCHAR NOT NULL,

to:

jid VARCHAR(255) NOT NULL NULL,

You you probably have to drop the DB and CREATE it again before trying again.