# Piler configuration

#### Piler installed from original sources

Before installing the ZI-Piler must be install Piler server. To do this refer to the [http://ww.mailpiler.org/wiki/current:installation ](http://www.mailpiler.org/wiki/current:installation)

In order to enable Zimbra-Piler SSO functionality some changes must be done on already installed Piler. The following steps have to be followed:

1. Make a copy before the installation
2. Upgrade database
3. Patch Piler files (commonly in /var/www/piler directory)
4. Add ZIMBRA\_INITIALIZE\_URL parameter to config-site.php file
5. Generate server key
6. Zimlet

#### Upgrading database

User 'piler' password is in /usr/local/etc/piler/piler.conf file (mysqlpwd variable)

```
mysql -u piler -p piler < db-mysql-intalioupdate.sql
```

#### Patch piler files

In this example, the piler files are in /var/www/piler directory and Apache user is www-data.

```
patch -p1 -d /var/piler/www < pilerX.X.X.patch 
patch -p0 -d /var/piler/www < config.patch

chown www-data:www-data .htaccess
chown www-data:www-data controller/login/remote_login.php
chown www-data:www-data controller/token/auth.php
chown www-data:www-data controller/token/login.php
chown www-data:www-data controller/token/logout.php
chown www-data:www-data gen_server_key.php
chown www-data:www-data index.php
chown www-data:www-data model/token/server_token.php
chown www-data:www-data model/token/user_token.php
chown www-data:www-data model/user/auth.php
chown www-data:www-data system/helper/Security.php
chown www-data:www-data view/theme/default/templates/common/layout-audit.tpl
chown www-data:www-data view/theme/default/templates/login/remote_login.tpl
chown www-data:www-data view/theme/mobile/templates/common/layout-email.tpl
```

#### Adding ZIMBRA\_INITIALIZE\_URL parameter to config-site.php

Edit /usr/local/etc/piler/config-site.php file and add this line. The &lt;ZIMBRA\_HOSTNAME&gt; string change to the hostname of your Zimbra (zimbraPublicHostname parameter).

```
$config['ZIMBRA_INITIALIZE_URL'] = 'https://<ZIMBRA_HOSTNAME>/service/extension/IntalioZiPilerExt/ZiPilerSSO/?action=login';
```

#### Genereate server key

Call sever key generator and place this key to the ZI-Piler configuration (Zimbra administration console -&gt; Tools and Migration -&gt; ZI-Piler -&gt; SSO Settings -&gt; Authorization server key)

```
cd /var/piler/www/
php gen_server_key.php --webui /var/piler/www
```