- rpm -q openfire
openfire-3.5.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
openfire-3.5.1-1
ERROR 1170 (42000) at line 77: BLOB/TEXT column ‘jid’ used in key specification without a key length
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.