Topic: HOWTO: openxchange 6 for sme7 / sme8 beta

[tariqf]

If anyone's interested here's a howto for setting up openxchange hyperion on a fresh SME. when I've worked out how to use the wiki I'll see if I can add this there!

sme7.3 or sme8beta2 fresh install
yum -y update (on sme8 see bugtracker for how to fix broken yum repos)
SME7 only: yum -y --enablerepo=* install mysql-server
install cyrus imapd from here: http://wiki.contribs.org/Cyrus-imap - this enables the filtering options
wget http://sipxecs.sipfoundry.org/pub/sipXecs/LatestStable/CentOS/5/i386/RPM/java-1.5.0-sun-1.5.0.10-2jpp.i586.rpm
yum -y localinstall java-1.5.0-sun-1.5.0.10-2jpp.i586.rpm
vim /etc/yum.conf and add

[ox]
name=Open-Xchange
baseurl=http://software.open-xchange.com/OX6/stable/RHEL5/
enabled=1
gpgcheck=0

yum -y install open-xchange-admin-client \
open-xchange-admin-doc open-xchange-admin-plugin-hosting-doc \
open-xchange-admin-plugin-hosting open-xchange-admin \
open-xchange-authentication-database open-xchange-cache \
open-xchange-charset open-xchange-common open-xchange-configjump-generic \
open-xchange-configread open-xchange-control open-xchange-data-conversion-ical4j \
open-xchange-global open-xchange-group-managerequest open-xchange-gui \
open-xchange-i18n open-xchange-imap open-xchange-jcharset open-xchange-mailfilter \
open-xchange-management open-xchange-monitoring open-xchange-online-help-he-de \
open-xchange-online-help-he-en open-xchange-online-help-he-fr \
open-xchange-passwordchange-database open-xchange-passwordchange-servlet \
open-xchange-push-udp open-xchange-resource-managerequest open-xchange-server \
open-xchange-sessiond open-xchange-settings-extensions open-xchange-smtp \
open-xchange-spamhandler-default open-xchange

mysql
GRANT ALL PRIVILEGES ON *.* TO 'openexchange'@'localhost' IDENTIFIED BY 'db_password';
quit
config setprop mysqld LocalNetworkingOnly no
expand-template /etc/my.cnf
svc -t /service/mysqld
/opt/open-xchange/sbin/initconfigdb --configdb-pass=db_password
/opt/open-xchange/sbin/oxinstaller --servername=oxserver --configdb-pass=db_password --master-pass=admin_master_password
/etc/init.d/open-xchange-admin start
/etc/init.d/open-xchange-groupware start
/opt/open-xchange/sbin/registerserver -n oxserver -A oxadminmaster -P admin_master_password
mkdir /var/opt/filestore
chown open-xchange:open-xchange /var/opt/filestore
/opt/open-xchange/sbin/registerfilestore -A oxadminmaster -P admin_master_password -t file:///var/opt/filestore
/opt/open-xchange/sbin/registerdatabase -A oxadminmaster -P admin_master_password -n oxdatabase -p db_password -m true

CREATE DEFAULT USER CONTEXT
/opt/open-xchange/sbin/createcontext -A oxadminmaster -P admin_master_password -c 1 -u oxadminmaster -d "Context Admin" -g Admin -s User -p secret -L defaultcontext -e oxadmin@yourdomain -q 1024 --access-combination-name=all

CREATE A USER EXAMPLE (user should exist already in server-manager)
/opt/open-xchange/sbin/createuser -c 1 -A oxadminmaster -P secret -u username -d "Full Name" -g firstname -s lastname -p password -e emailaddress@yourdomain --imaplogin username --imapserver 127.0.0.1 --smtpserver 127.0.0.1

mkdir /var/log/lighttpd/
chown www:www /var/log/lighttpd/
wget http://www.yourproblemsolved.com/oxhttpd.tar.bz2
tar jxf oxhttpd.tar.bz2
mv oxhttpd /opt/
vim /etc/rc.local and add
/etc/init.d/open-xchange-groupware start
/etc/init.d/open-xchange-admin start
/opt/oxhttpd/./lighttpd -f /opt/oxhttpd/lighttpd.conf -m /opt/oxhttpd/modules/

SME7 ONLY
yum install perl perl-suidperl --disablerepo=* --enablerepo=base --enablerepo=updates --enablerepo=smeos --enablerepo=smeupdates --enablerepo=smeaddons
rpm -e perl --nodeps
yum -y install perl perl-Time-HiRes

DELTE USER EXAMPLE
/opt/open-xchange/sbin/deleteuser -u username -c 1 -A oxadminmaster -P secret

Now reboot, and you can open a browser and go to http://yourserver:81 and login to openxchange 6. For our users we create a new firefox profile with all toolbars/menus etc. disabled so it can be used as if it is an normal application. You can also install funambol and ox connector which enables you to sync blackberry, IPOD etc.

[FraunhoferIFF]

I am a German open Exchange fan. It becomes time for the new version of OX.
I hope the developer Vincent looks here sometimes with purely and helps in rpm to transform.

Thank you and Sorry for my bad english.

Marcel

[tariqf]

Yes I used to use Vincent's RPMS until they became too outdated.

What I would like to see but have not had time to do is to implement an upgrade to the sme version of dovecot to support sieve so I don't have to change it to cyrus as per my howto.

[alvin]

Have you resolved the issues with OX authentication and password update not working with ldap?

[yythoss]

The Link:

wget http://www.yourproblemsolved.com/oxhttpd.tar.bz2

is broken!
Where can I get this file?

yythoss

[yythoss]

@tariqf

Can you send me the file oxhttpd.tar.bz2, so I can take a look to change the Apache Server, to do this job.

yythoss

[yythoss]

@tariqf

thank you, the link is working now.
 
I have read your HowTo, but my config doesn't work. 
Can you tell me, what Tomcat Version you have installed and your config from the Tomcat?

yythoss