I’m setting up a brand new Openfire installation using version 3.6.3 on a server with mySQL version 4.1.22. When I try to setup the database schema openfire_mysql.sql, I get the following error:
ERROR 1170 (42000) at line 57: BLOB/TEXT column ‘jid’ used in key specification without a key length
Any suggestions?
HI,
Unfortunately, that old of a version of mysql is not receiving much love with Openfire. Here is a Jira ticket with more issues along those lines:
http://www.igniterealtime.org/issues/browse/JM-1470
I am not a MySQL user, but you may need to edit your resources/database/openfire_mysql.sql script and change VARCHAR(1024) to VARCHAR(255)
Unfortunately, that version of MySQL is with RHEL4 correct?
daryl
That worked; thanks! The database documentation ought to be updated. It says Make sure that you are using MySQL 4.1.18. (I was using 4.1.22 so I thought it would be ok.)