Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: GGD on May 25, 2008, 04:09:55 PM
-
I followed the instructions on the contib http://wiki.contribs.org/Openfire (http://wiki.contribs.org/Openfire) and I cannot get the application to setup correctly. When I get to the “create your data base” part specifically the line where it mentions “mysql openfiredb < openfire_mysql.sql” I enter that line into the server and it spits back out an error message of "ERROR 1170 (42000) at line 77: BLOB/TEXT column 'jid' used in key specification without a key length" and it will not do the action, also when I go to the web admin website and go to the data base- standard connection and enter the Database URL: jdbc:mysql://localhost:3306/openfiredb and click continue after putting in the user name and password, it says "The Openfire database schema does not appear to be installed. Follow the installation guide to fix this error." Currently I am using both the sark-sme-7.3-2.2.1-617 and the SME 7.3 (the one that is currently available for download on the website). I am also using the following openfire rpm: openfire-3.5.1-1.i386. And I am getting the same error messages. Any ideas as to what the issue would be?
thank you for your time
Dave
-
I followed the instructions on the contib http://wiki.contribs.org/Openfire (http://wiki.contribs.org/Openfire) and I cannot get the application to setup correctly. When I get to the “create your data base” part specifically the line where it mentions “mysql openfiredb < openfire_mysql.sql” I enter that line into the server and it spits back out an error message of "ERROR 1170 (42000) at line 77: BLOB/TEXT column 'jid' used in key specification without a key length" and it will not do the action
It seems there are some errors with the DB import, therefore you are presented an error that the database is not properly initialized, unfortunately I have no experience with openfire. Did you install the same version as mentioned in the wiki?
-
I went to the website that was mentioned in the wiki and I downloaded the version that is on there... I tried to find that particular version that was on the wiki but it wasn't there... the current version was thou (I think it was a later version than what was in the wiki)
-
I went to the website that was mentioned in the wiki and I downloaded the version that is on there... I tried to find that particular version that was on the wiki but it wasn't there... the current version was thou (I think it was a later version than what was in the wiki)
Perhaps a bug has slipped in the routine to create the database... perhaps worth mentioning on the Discussino tab of before mentioned wiki page, perhaps more people will notice or even have a workaround for it, perhaps you should contact the packager and send them a notice of your error so they can diagnose and try and fix it.
-
I sent an email to the author of the wiki and they told me to post it on the fourms.... who would be the "packager"?
-
who would be the "packager"?
Don't know but most likely to be found on the site you downloaded the package from.
-
understood.... I will see if they have anything on this issue there....
thanks
Dave
-
It looks as if the latest version of openfire requires mysql 5. Try this link here to download the same version as in the howto http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire-3.4.4-1.i386.rpm (http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire-3.4.4-1.i386.rpm)
or use
wget http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire-3.4.4-1.i386.rpm
also
you have to remove openfire-3.5.1-1.i386 with the following command
/etc/rc.d/init.d/openfire stop
yum remove openfire
rm -Rf /opt/openfire
mysqladmin drop openfiredb
config delete openfire
signal-event remoteaccess-update
Reinstall commands
cd /tmp
wget http://www.igniterealtime.org/downloadServlet?filename=openfire/openfire-3.4.4-1.i386.rpm
yum localinstall openfire-3.4.4-1.i386.rpm
and follow the rest of the installation procedures
Russell
-
Lets see if anyone replies:
http://www.igniterealtime.org/community/thread/33137
BTW, I'm currently using 3.5.1 on SME just fine. I did this via upgrade from earlier releases so did not encounter this fresh db install issue. The same should work for you.
Darrell
-
I tried a fresh install using the openfire howto and faced the same problem, I did try and make modification to openfire_mysql.sql @ line 321 and changed the number from 16 to 13
INSERT INTO jiveVersion (name, version) VALUES ('openfire', 13);
and the database loaded
I will try 3.4.4-1 to 3.5.1 and see what happens
Well either way, the howto has been updated anyway
Russell