01

Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts


INTRODUCTION

Tine 2.0 is a free, useful web-based groupware application with the following main features:

  • Address Book
  • Calendar
  • Email (you can add multiple external email accounts)
  • Task Management
  • CRM
  • Time Tracking

Tine 2.0 also supports ActiveSync, which allows you to sync mail, contacts and calendar events to and from your Smartphone (such as an iPhone).

SCREENSHOTS

A few screenshots of Tine 2.0 features:

screenshot calendar1 300x192 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts
Calendar

screenshot tasks 300x192 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts
Task Management

screenshot addressbook 300x192 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts
Address Book

screenshot crm 300x192 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts
CRM

DEMO

To get the feel of Tine 2.0 before setting up your own instance, you can view the use the demo that is made available from the Tine 2.0 website, http://demo.tine20.org/ – be advised that not all features and functions may be usable in the demo.

REQUIREMENTS

In this tutorial, we will be installing Tine 2.0 on a clean, CentOS 5.6 x86 server (note: CentOS 5.6 x64 can be used). Our primary requirements are:

  • A clean Linux server (CentOS preferably, but Ubuntu, Debian etc will be fine)
  • Apache, PHP 5.2.x and MySQL 5.x
  • 256MB RAM minimum
  • 2GB minimum (will scale up with server log activity and file uploads to Tine 2.0 etc)

STEP 1: INSTALLING REQUIRED PACKAGES

1. Log in to your server via SSH.
2. Enable CentOS testing repo in order to install PHP 5.2.x:

# vim /etc/yum.repos.d/CentOS-Testing.repo

add:

[c5-testing]
name=CentOS-5 Testing
baseurl=http://dev.centos.org/centos/$releasever/testing/$basearch/
enabled=1
gpgcheck=1
gpgkey=http://dev.centos.org/centos/RPM-GPG-KEY-CentOS-testing
includepkgs=php*

3. Install the required packages on the server via SSH:

# yum install httpd mod_ssl php php-mysql php-mcrypt php-mbstring php-imap php-gd php-xml mysql-server mysql -y

4. Ensure that PHP is upgraded to the latest version. It is also necessary to remove and re-add php-mcrypt as the old PHP 5.1.x package remains:

 

# yum upgrade php
# yum remove php-mcrypt ; yum install php-mcrypt

3. Make sure our installed services auto-start upon a server reboot:

# chkconfig –levels 345 mysqld on
# chkconfig –levels 345 httpd on

STEP 2: CONFIGURE MYSQL SERVER AND TINE 2.0 DATABASE

1. Restart mysqld and then run the secure setup of MySQL. Important:
Accept the default answers for questions during the secure setup process, except when you enter the new root password (please take note of the MySQL root password that you set)

# /etc/init.d/mysqld restart
# /usr/bin/mysql_secure_installation

2. Next, we will create a database and user. Be sure to change PASSWORD to a secure password of your own choosing:

# mysql -p
mysql> create database tine20;
mysql> grant all privileges on tine20.* to tine20@’localhost’ identified by ‘PASSWORD’;
mysql> flush privileges;

STEP 3: CONFIGURE APACHE/PHP

1. We will modify a few PHP Settings:

# vim /etc/php.ini

Change the values for the following parameters:

memory_limit = 64M
max_execution_time = 180
max_input_time = 600
upload_max_filesize = 256M
post_max_size = 256M

Restart Apache for changes to take effect:

# /etc/init.d/httpd restart

STEP 4: PREPARING TINE 2.0 DIRECTORIES

We will be installing Tine 2.0 to Apache’s default document root, /var/www/html. We will also be creating a few storage directories for Tine 2.0 in /home/tine20:

# mkdir -p /home/tine20/cache
# mkdir -p /home/tine20/filestore
# mkdir -p /home/tine20/logs
# mkdir -p /home/tine20/session
# mkdir -p /home/tine20/tmp

# chown apache.apache /home/tine20
# chown apache.apache /home/tine20/* -R

STEP 5: INSTALLING TINE 2.0

1. Get the required files and extract them:

# cd /var/www/html
# wget http://www.tine20.org/downloads/2011-01-4/tine20-allinone_2011-01-4.tar.bz2
# wget http://www.tine20.org/downloads/2011-01-4/tine20-activesync_2011-01-4.tar.bz2
# tar xjvf tine20-allinone_2011-01-4.tar.bz2
# tar xvjf tine20-activesync_2011-01-4.tar.bz2
# chown apache.apache /var/www/html/* -R

2. Next, we will modify rename and change few settings in config.inc.php to prepare for our setup:

# mv config.inc.php.dist config.inc.php
# vim config.inc.php

Change the host, dbname, username, password to the details of the database you created in Step 2:2. Under ‘setupuser’ change the password to a stronger password to use for setting up Tine 2.0

3. Access the setup file via your server’s IP address, eg: http://1.2.3.4/setup.php – your first login will be the ‘tine20setup’ and the setup password set above.

4. Terms and Conditions: Accept the license and privacy agreement and click ‘Accept Terms and Conditions’ at the top left of the screen and then click ‘Setup Checks’.

5. Setup Checks: All Setup Checks should be passed, click ‘Config Manager’ to continue.

tine20 setupchecks 300x192 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts

6. Config Manager: Ensure that your database information is correct in the field (this is taken from config.inc.php). Enable logging and caching. We will use the following directories for Tine 2.0 as created earlier:

Logging (priority: Error) – /home/tine20/logs
Caching – /home/tine20/cache
Temporary Files – /home/tine20/tmp
Session – /home/tine20/session
Filestore – /home/tine20/filestore

tine20 config 300x192 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts

Once done, click ‘Save config’ in the top left, and then click ‘Authentication/Accounts’ to continue.

7. Authentication/Accounts: create your initial user under ‘Initial Admin User’ and accept the default options for the rest of the fields. You might lose your session due to changing to a new session path in the step above. If this is the case, simply re-login, accept the Terms and Conditions again, and then enter your initial admin user details again. Click ‘Save Config’ and then ‘Application Manager’ once you are ready to continue.

8. Application Manager: right-click the applications you want to install and click ‘Install application’. In this tutorial, we will install ActiveSync, Addressbook, Admin, Calendar, CRM, Felamimail, Tasks, Timetracker and Tinebase. Click ‘Go to Tine 2.0 login’ once you are ready.

tine20 app manager 300x192 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts

9. Tine 2.0 login – log in with your initial admin user as created in Step 5:7. To add application tabs, click the Tine 2.0 drop-down arrow and select the application you wish to open. This will automatically add an application tab.

tine20 menu 300x192 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts

STEP 6: CONFIGURING TINE 2.0

1. One of the first things you might wish to do in Tine 2.0 is to update your profile. To do this, click the Tine 2.0 drop-down arrow and click ‘Edit Profile’.

2. The next step is to edit your preferences. To do this, click the Tine 2.0 drop-down arrow and click ‘Edit Preferences’.

3. Email Accounts: you can add email accounts by opening the Email application, and then clicking ‘Add Account’ in the top bar.

STEP 7: CONFIGURING ACTIVESYNC

1. You will need to add a rewrite rule to your Apache configuration for ActiveSync:

# vim /etc/httpd/conf/httpd.conf

Add the following line under ‘ServerRoot’:

RewriteEngine on
RewriteRule /Microsoft-Server-ActiveSync(.*) /var/www/html/index.php$1 [E=REDIRECT_ACTIVESYNC:true,E=REMOTE_USER:%{HTTP:Authorization}]

Restart Apache for this to take effect:

# /etc/init.d/httpd restart

STEP 8: CONFIGURING ACTIVESYNC ON YOUR SMARTPHONE (IPHONE 4)

1. For iPhone, go to Settings > Mail, Contacts, Calendars > Add Account > Microsoft Exchange.

The server address is your Tine 2.0 IP address, and your username and password is your admin username and password. You might get a message about being unable to verify the account. This is OK. Click Save settings.

iphone exchange activesync 200x300 Free PHP Groupware: How to install and configure Tine 2.0 with ActiveSync for Calendars and Contacts

Once you have added the account, you must go back to it and disable ‘Use SSL’. You may also want to uncheck ‘Mail’ and leave ‘Calendars’ and ‘Contacts’ synced.

2. Once you have added your Tine 2.0 ActiveSync account to your iPhone, you should change your default calendar to your Tine 2.0 ActiveSync account.

Go to Settings > Mail, Contacts, Calendars > Calendars (near the bottom) > Default Calendar > Your Tine 2.0 ActiveSync Calendar.

 

That’s it! You should be done. If you have any issues with configuring this, please add a comment below and I will try as best as I can to assist you.

Random Posts Recent Comments

  • Tony Says:

    Thanks it works! Just close the cmd windows and open a new one...

  • greenhart Says:

    I found another way around it. For the /format switch I used: /format:"%WINDIR%\system32\wbem\en-...

  • Jari Aalto Says:

    To determine OS, you can also use command lsb_release(1). See the options how to extract only part o...

  • shadovice Says:

    thanks! it worked like a charm, although there is still minor typo remained: rpm -Uvh http://downlo...

  • Joh Says:

    Great, thank you. Also works with the new version and Centos 6.3 without test repo, just install ...

  • sierprinsky Says:

    Muchas gracias por tu aporte :)...

  • kilby Says:

    The listed solution worked fine for me under Win7 64bit Though I had to run the copy as Asministr...

  • Viper5112 Says:

    The files are already in the C:\Windows\SysWOW64\wbem\en-US and they need to be in the system32 fold...

  • slowmOoh Says:

    Thanks...

  • Jørgen Says:

    @Jordan, I had the same problem also on Windows 7 64 bits. It worked for my user account and Admini...

Tag Cloud

backup mail backup mail server backup mailserver backup mx cd burner control multiple computers with one keyboard and mouse control panel DAG disk benchmark disk performance test DNS DNS check enable dag repo free cd burner free DNS check hdd benchmark http proxy install keyboard over network kloxo kloxo 64-bit kvm lxadmin lxadmin-master lxlabs mouse over network mtr ping plotter proxy proxy hide IP qmail repo RPM rpmforge share keyboard and mouse over network share keyboard over network share mouse and keyboard share mouse over network software kvm squid squid hide IP squid proxy trace traceroute tracert