Ignite Realtime: i need your help

Skip navigation

Up to Discussions in Openfire Support

5778 Views 11 Replies Latest reply: Aug 9, 2008 5:42 AM by icecube

icecube

7 posts since
Aug 4, 2008

Currently Being Moderated

Aug 4, 2008 12: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

Like (0)

Tags: openfire, centos, raq4

icecube
7 posts since
Aug 4, 2008

Currently Being Moderated

Aug 8, 2008 3: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

Like (0)
- Coolcat
  797 posts since
  Mar 19, 2007
  
  Currently Being Moderated
  
  Aug 8, 2008 3: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
  
  Like (0)
  - icecube
    7 posts since
    Aug 4, 2008
    
    Currently Being Moderated
    
    Aug 8, 2008 8: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
    
    Like (0)
    - Coolcat
      797 posts since
      Mar 19, 2007
      
      Currently Being Moderated
      
      Aug 8, 2008 9: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
      
      Like (0)
      - icecube
        7 posts since
        Aug 4, 2008
        
        Currently Being Moderated
        
        Aug 8, 2008 10:11 AM (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
        
        Like (0)
        
        Coolcat
        797 posts since
        Mar 19, 2007
        
        Currently Being Moderated
        
        Aug 8, 2008 12: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
        
        Like (0)
        
        icecube
        7 posts since
        Aug 4, 2008
        
        Currently Being Moderated
        
        Aug 8, 2008 1:31 PM (in response to Coolcat)
        Re: i need your help
        
        im running ver 4.1.20
        
        Report Abuse
        
        Like (0)
        
        Coolcat
        797 posts since
        Mar 19, 2007
        
        Currently Being Moderated
        
        Aug 8, 2008 2:30 PM (in response to icecube)
        Re: i need your help
        
        Hm, weird. Maybe an update to MySQL 5 does help?
        
        Report Abuse
        
        Like (0)
        
        icecube
        7 posts since
        Aug 4, 2008
        
        Currently Being Moderated
        
        Aug 8, 2008 2: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
        
        Like (0)
        
        Coolcat
        797 posts since
        Mar 19, 2007
        
        Currently Being Moderated
        
        Aug 8, 2008 4: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
        
        Like (0)
        
        icecube
        7 posts since
        Aug 4, 2008
        
        Currently Being Moderated
        
        Aug 9, 2008 5: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
        
        Like (0)

Go to original post

Legend

Correct Answers - 10 points
Helpful Answers - 5 points

Aug 4, 2008 12:56 PM

i need your help

Actions

More Like This

Bookmarked By (0)

Legend