Topic: need info or notes on Clearspace

[fixit]

Has anyone attemped to install Clearspace from 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

[cactus]

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

Code: [Select]

mkdir -p /etc/e-smith/templates-custom/etc/my.cnfCopy the template fragment to the custom template location:

Code: [Select]

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.

Code: [Select]

nano /etc/e-smith/templates/etc/my.cnf/011max_allowed_packetRegenerate the configuration template:

Code: [Select]

expand-template /etc/my.cnfRestart the mysql daemon:

Code: [Select]

service mysqld restart

[fixit]

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

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/


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