Koozali.org: home of the SME Server
Obsolete Releases => SME 7.x Contribs => Topic started by: fixit on October 12, 2007, 04:20:21 PM
-
Has anyone attemped to install Clearspace from http://www.jivesoftware.com/products/clearspace/ (http://www.jivesoftware.com/products/clearspace/) as I am having trouble with the installation process.
I am haveing trouble with the java side of things
if anyone has any current notes or a howtos for java and mysql connector java, I would be interested in them
also
how do we change the max allowed packet=16M to max_allowed_packet=500M for mysql
Thnaks, Russell
-
how do we change the max allowed packet=16M to max_allowed_packet=500M for mysql
Do you really need 500M of packet size??? That is an awfull lot as the default value for MySQL is 1M according to the MySQL manual (http://dev.mysql.com/doc/refman/4.1/en/packet-too-large.html). What are you doing that sends such big packets? Are you using such big blob size fields? How about optimizing your queries?
Create a directory for the custom template:
mkdir -p /etc/e-smith/templates-custom/etc/my.cnfCopy the template fragment to the custom template location:
cp /etc/e-smith/templates/etc/my.cnf/011max_allowed_packet /etc/e-smith/templates-custom/etc/my.cnf/Modify the copied fragment to your need using vim or nano and save it e. g. nano /etc/e-smith/templates/etc/my.cnf/011max_allowed_packetRegenerate the configuration template:expand-template /etc/my.cnfRestart the mysql daemon:service mysqld restart
-
I have managed to install clearspace on sme, these are my rough install notes for clearspace & clearspacex, I will put up a howto on the wiki, unless some ones else does it befor me.
Take a look at http://wiki.contribs.org/Openfire (http://wiki.contribs.org/Openfire) for a refernce when connecting to the database
To install clearspacex, just replace the word clearspace with clearspacex
Java Setup instructions
Download
jre-6u3-linux-i586-rpm.bin from http://www.java.com/en/download/linux_manual.jsp (http://www.java.com/en/download/linux_manual.jsp)
chmod a+x jre-6u1-linux-i586-rpm.bin
sh jre-6u1-linux-i586-rpm.bin
and also download mysql connector java from
http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.0.8.tar.gz/from/http://mysql.planetmirror.com/ (http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.0.8.tar.gz/from/http://mysql.planetmirror.com/)
extract mysql-connector-java-5.0.8.tar.gz
tar xvzf mysql-connector-java-5.0.8.tar.gz
and copy the mysql-connector-java-5.0.8-bin.jar to /usr/java/jre1.6.0_03/lib/ext
cp /tmp/downloads/mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar /usr/java/jre1.6.0_03/lib/ext
go to http://www.jivesoftware.com/evaluation!input.jspa?type=cs (http://www.jivesoftware.com/evaluation!input.jspa?type=cs) and fill in the details to get to the downloads section
select the Standalone tar.gz (Unix, Mac)
I put my downloads into /tmp/downloads
cd /tmp/downloads
tar xvzf jive_clearspace_standalone_1_6_0.tar.gz
mv /tmp/downloads/jive_clearspace_standalone_1_6_0 /opt/clearspace
chown -R www.www /opt/clearspace
chmod 750 /opt/clearspace
cd /opt/clearspace
===================================
pico setJavaHome
export JAVA_HOME=/usr/java/jre1.6.0_03
====================================
Save by pressing Ctrl x, press y to save changes and press enter
cd /root and edit .bash_profile to include export JAVA_HOME=/usr/java
=============================================
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export JAVA_HOME=/usr/java
export
unset USERNAME
===========================================================
Create Clearspace Database
============================================================
mysqladmin create clearspacedb
mysql -e "grant all privileges on clearspacedb.* to clearspaceuser@localhost identified by 'yourclearspacepassword'"
mysql -e "flush privileges"
==================================================
cd /opt/clearspace/database
mysql clearspacedb < jive_clearspace_mysql.sql
To use the MySQL database you will need to run these command to make port 3306 available for clearspace
/sbin/e-smith/config setprop mysqld LocalNetworkingOnly no
/sbin/e-smith/expand-template /etc/my.cnf
/etc/rc.d/rc7.d/S50mysqld restart
cd /opt/clearspace
sh start-clearspace.sh
go to http://domain-name-or-ip:8080/clearspace
Database URL: jdbc:mysql://localhost:3306/clearspacedb
Username: clearspaceuser
Password: yourclearspacepassword