Up to Discussions in Openfire Support

This Question is Not Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (5 pts)
11 Replies Last post: Aug 9, 2008 7:42 AM by icecube  
icecube Bronze
icecube
7 posts since
Aug 4, 2008
Currently Being Moderated

Aug 4, 2008 2:56 PM

i need your help

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

Tags: openfire, centos, raq4
icecube Bronze
icecube
7 posts since
Aug 4, 2008
Currently Being Moderated
Aug 8, 2008 5:11 AM in response to: icecube
Re: i need your help

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

Report Abuse
Coolcat KeyContributor
Coolcat
702 posts since
Mar 19, 2007
Currently Being Moderated
Aug 8, 2008 5:44 AM in response to: icecube
Re: i need your help
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
Report Abuse
icecube Bronze
icecube
7 posts since
Aug 4, 2008
Currently Being Moderated
Aug 8, 2008 10:51 AM in response to: Coolcat
Re: i need your help

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

Report Abuse
Coolcat KeyContributor
Coolcat
702 posts since
Mar 19, 2007
Currently Being Moderated
Aug 8, 2008 11:35 AM in response to: icecube
Re: i need your help

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.

Report Abuse
icecube Bronze
icecube
7 posts since
Aug 4, 2008
Currently Being Moderated
Aug 8, 2008 12:11 PM in response to: Coolcat
Re: i need your help

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

Report Abuse
Coolcat KeyContributor
Coolcat
702 posts since
Mar 19, 2007
Currently Being Moderated
Aug 8, 2008 2:04 PM in response to: icecube
Re: i need your help
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).

Report Abuse
icecube Bronze
icecube
7 posts since
Aug 4, 2008
Currently Being Moderated
Aug 8, 2008 3:31 PM in response to: Coolcat
Re: i need your help

im running ver 4.1.20

Report Abuse
Coolcat KeyContributor
Coolcat
702 posts since
Mar 19, 2007
Currently Being Moderated
Aug 8, 2008 4:30 PM in response to: icecube
Re: i need your help

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

Report Abuse
icecube Bronze
icecube
7 posts since
Aug 4, 2008
Currently Being Moderated
Aug 8, 2008 4:53 PM in response to: Coolcat
Re: i need your help

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

Report Abuse
Coolcat KeyContributor
Coolcat
702 posts since
Mar 19, 2007
Currently Being Moderated
Aug 8, 2008 6:29 PM in response to: icecube
Re: i need your help

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

Report Abuse
icecube Bronze
icecube
7 posts since
Aug 4, 2008
Currently Being Moderated
Aug 9, 2008 7:42 AM in response to: Coolcat
Re: i need your help

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

Report Abuse

More Like This

  • Retrieving data ...