powered by Jive Software

Openfire_sqlserver.sql script: Warning! The maximum key length is 900 bytes

Hi everyone,

I am trying to get OpenFire to work together with a SQL Server Database on my server. I am following the instructions at Openfire: Database Installation Guide for this.

I have created the database and the user for the database, and now want to run the openfire_sqlserver.sql script on that database. I have executed it, and it mostly goes fine, but, I also get two warnings:

Warning! The maximum key length is 900 bytes. The index ‘ofRoster_jid_idx’ has maximum length of 2048 bytes. For some combination of large values, the insert/update operation will fail.

Warning! The maximum key length is 900 bytes. The index ‘ofSASLAuthorized_pk’ has maximum length of 4128 bytes. For some combination of large values, the insert/update operation will fail.

Is this something that needs to be taken care of? I.e., in practice, will these index values ever exceed 900 bytes? This is intended for a production release of our Instant Messenger Application, so it is important that this works 100 percent.

Thanks for all input and answers,

best regards,

Chris

Noone any info on this?