powered by Jive Software

Error installing mysql database schema in 3.6.3

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