How to set up Everything

Connecting to Horde

Keep in mind: when “cloud” is addressed here your server is meant . not a cloud you know nothing about.

Setting up the server (not a walkthrough yet, skip if you got one)

Install Debian 7.8 (1CPU 2GB RAM) only with system tools and ssh server.

Log in as root, do

wget http.// ; . ./setup

you will be asked for usernames, passwords and such. When done setup the https ability:

Go to the ISPConfig3 configuration and set up a ssl enabled domain, create the certificate and copy the required files (.crt and .key) to /etc/elsewhere. Thereafter delete the site in ISPConfig3 again.

Let us take /etc/apache2/certs/other/; create a file anyname.conf with the content below


<VirtualHost *:443>
                DocumentRoot /var/www

                ServerName <the servername>
                ServerAlias <other names>
                ServerAdmin <your mailaddress>
                ErrorLog /var/log/apache2/error.log
                <IfModule mod_ssl.c>
                SSLEngine on
                SSLProtocol All -SSLv2 -SSLv3
                SSLCertificateFile /etc/apache2/certs/other/cert.crt
                SSLCertificateKeyFile /etc/apache2/certs/other/cert.key
                <Directory /var/www>
                                # Clear PHP settings of this website
                                <FilesMatch ".+\.ph(p[345]?|t|tml)$">
                                                SetHandler None
                                Options +FollowSymLinks
                                AllowOverride All
                                Order allow,deny
                                Allow from all
                # suexec enabled
                # php as fast-cgi enabled
                <IfModule mod_fcgid.c>
                                IdleTimeout 300
                                ProcessLifeTime 3600
                                # MaxProcessCount 1000
                                DefaultMinClassProcessCount 0
                                DefaultMaxClassProcessCount 100
                                IPCConnectTimeout 3
                                IPCCommTimeout 600
                                BusyTimeout 3600



For the http domain add “Redirect permanent / https://<the servername>/” to the directives in the Apache configuration

Restart Apache, done.


The colour of an event is now the colour of the address book. All event types have the same colour now L.

You should be able to connect to:

- ISPConfig3 to create a mail account for everyone who gets data exported. In the beginning you have the administrator account created during the setup.

- The Horde to see that data.


In Agencyprof create the address group webcal with these properties:

Benutzergruppe: empty, Mitarbeiter or Manager. The only difference right now is that Mitarbeiter and Manager will get access to the calendars and contacts of all other Horde users and can  get arbitrary addresses exported.

cloud: the Horde username (the mailaccount you create in ISPConfig3)

Remember NOT to use contacts but addresses in Agencyprof to be member of  webcal.

In the usersetting add 3 settings for the user system:


clouduser=<name of the user that connects to the MySQL database>

cloudpass=<the password of the above user> (use the form encrypt:plainpassword to enter it)


That’s it. When you save an address or contact its data is also saved to the Horde in all address books it is in. Whenever you save an event it will be exported or updated to the Horde in every calendar where it should appear. Addresses will be included to whom they concern. You may export events from the empty address window based on any timeframe. You can also export addresses from the extended search by defining a group and export it to the cloud. These addresses will only be exported to Mitarbeiter and Manager.


Whenever you created a new user with ISPConfig go to the WebCal info window in Agencyprof and click on [test all]. This will do the required renamings in the Horde database (default calendars and default address books must be named Agencyprof). Afterwards the users may of course create more address books or calendars. These are untouched by Agencyprof and not shared by default.