I need your help

Openfire Openfire Support
1

hello

im having some truble running openfire on my raq4 .

raq4 is running centos4.6

i installed mysql , webmain and openfire

i created a database called openfiredb and a user jabber with all the permissions

when i go to ip:9090 every i use the i see my dns name in the 2nd page of setup

when it comes to the database i choose mysql

this is the error log

http://rafb.net/p/YWaLu735.html

2

ok i really need any help in here

now i have this error

the openfire database shema does not appear to be installed !!

could some one please help

im running centos 4.6 on raq4

thanks

3

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
4

i did excute the command

and i get this error

ERROR 1050 (42S01) at line 4: Table ‘jiveUser’ already exists

and the link is not working

thanks

5

sorry, that stupid new Clearspace does change links…hoping it works this time:

http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/database .html#mysql

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

6

ok

i deleted the database

and followed the link

i created a database called openfire

but when i do

cat: openfire_mysql.sql | mysql openfire

i get this error

cat : openfire_mysql.sql: no such file or directory

?

and in / openfire dir

i get

error 1170 (42000) at line 77:blob/text column ‘jid’ used in key specification without a key length

7

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

8

im running ver 4.1.20

9

Hm, weird. Maybe an update to MySQL 5 does help?

10

im running strongbolt on raq4

thats centos ver4.6

i did yum update and upgrade but mysql is not upgrading

i dont know why?

i did a yum search mysql-5

but no result

i have an extra server without os

i can use it as a jabber server with openfire but i dontknow wich distro to choose

is thare any destro that comes with openfire preinstalled

11

hm, here it is:

http://mirror.centos.org/centos/4/centosplus/i386/RPMS/

mysql-server-5.0.62-1.el4_6.i386.rpm

mysql-5.0.62-1.el4_6.i386.rpm

i did a yum search mysql-5

but no result

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

12

i just found aout that i cant upgrade mysql to v5

i do have one asterisknow box i might use openfire with it .hope it’ll work