the openfire database shema does not appear to be installed !!
You need to import the database schema first…just follow the database guide, or execute this:
shell> mysql -p -u jabber openfiredb </opt/openfire/resources/database/openfire_mysql.sql
ERROR 1050 (42S01) at line 4: Table ‘jiveUser’ already exists
I assume Openfire has never worked for you, so it’s no problem for you to lose Openfires database. Just drop all existing tables in your database openfiredb and try again.*
*
error 1170 (42000) at line 77:blob/text column ‘jid’ used in key specification without a key length
Which MySQL version are you using? Openfire does require MySQL 4.1.18 or later (5.x recommended).
Since it is on the mirror, maybe a “yum clean all” does help. Are you using fastestmirror-plugin? Sometimes you get a “bad” mirror, which is faster than the others because it does not have all packets and nobody is downloading there