Installing Horde Groupware

danb35 · May 23, 2018, 10:49pm

By default with the current module, Ingo sets up local rules. However, it’s pretty straightforward to configure it to use Sieve instead and control server-based filtering. See below for what needs to be changed:
https://skrilnetz.net/server-side-mail-filtering-with-horde-ingo-and-sieve/

mrmarkuz · May 28, 2018, 9:32pm

You’re right. Seems we need a hook to set it at login. I only found some old code but it should be possible:

https://wiki.horde.org/CustomizingPreferences
https://wiki.horde.org/CustomizingPreferencesH3?referrer=HowTo#toc8

That’s really nice, a must-have.

I also noticed that the mail addresses in turba AD address book are missing, only usernames are synced.

I am going to add/fix these points asap, thanks for testing.

danb35 · May 28, 2018, 10:18pm

I noticed that, after I added a Sieve filter in Ingo, the filters I’d set up in Roundcube stopped working. A little bit of digging revealed that the Roundcube filter set had been disabled, but I haven’t dug further to see if that was a fluke or not.

m.traeumner · June 18, 2018, 12:12pm

Can someone help with active sync? Can’t find the module to install.

cc/ @mrmarkuz, @danb35

mrmarkuz · June 18, 2018, 8:44pm

Horde Activesync would be a nice feature but it seems Android contacts/calendars are not supported…I found this howto but I didn’t test it:

https://wiki.horde.org/activesync

m.traeumner · June 19, 2018, 12:06pm

So, I started to install activesync for horde, but can’t connect with my outlook. Can somebody else try it please.
HowTo install

Active Sync

https://dokuwiki.tachtler.net/doku.php?id=tachtler:horde5_-framework-_activesync

https://www.horde.org/apps/horde/docs/INSTALL

You have to install horde activesync with pear, because of it‘s license it‘s not contained in epel

For pear installation execute the following command from terminal

yum install php-pear

Updating pear and register horde pear channel

pear upgrade PEAR
pear channel-discover pear.horde.org

Install Horde ActiveSync

pear install horde/Horde_Activesync

Now you have to Update All DB Schemas.

Start your web-browser and change address to X.X.X.X/horde/admin/config
Please click on “Update All DB Schemas”.
You should get the message that activesync db is updated.
Please click on Horde settings and after it choose the ActiveSync tab.
Set the following settings

$conf['activesync']['params']['driverconfig'] = 'horde';
$conf['activesync']['storage'] = 'Sql';
$conf['activesync']['emailsync'] = true;
$conf['activesync']['version'] = '14.1';
$conf['activesync']['auth']['type'] = 'basic';
$conf['activesync']['autodiscovery'] = 'full';
$conf['activesync']['outlookdiscovery'] = false;
$conf['activesync']['logging']['type'] = false;
$conf['activesync']['ping']['heartbeatmin'] = 60;
$conf['activesync']['ping']['heartbeatmax'] = 2700;
$conf['activesync']['ping']['heartbeatdefault'] = 480;
$conf['activesync']['ping']['deviceping'] = true;
$conf['activesync']['ping']['waitinterval'] = 15;
$conf['activesync']['enabled'] = true;

Now press the button to generate the activesync configuration.
Activesync is configured now.

Stefano_Zamboni · June 19, 2018, 3:54pm

which outlook, FTR?

activesync is supported only from Outlook 2013 onwards

m.traeumner · June 20, 2018, 7:13am

Thanks for your answer @Stefano_Zamboni,
it’s Outlook 2013 and I choose manual configuration and connect with outlook.com or other compatible Exchange ActiveSync Service.
I get an error message, that the name at the certificate (the name is Nethserver) is not the same as the internet page. I can continue with yes. After continuing I get the message:

Sign in at ActiveSync-e-mail-server (EAS): Server wasn’t found.

Stefano_Zamboni · June 20, 2018, 7:14am

in this case, the only thing that can help you is to dig into the logs

m.traeumner · June 20, 2018, 7:15am

Ok, I activate the activesync logs at the config and have a look for it. I’ll be back later.

m.traeumner · June 20, 2018, 9:58am

I can’t find anything at the logs. Enabled activesync.log at horde, but the file is not created. Client logs (windows) aren’t helpful too. At messages and horde log I can’t find anything either.

mrmarkuz · June 25, 2018, 12:04am

I tried it and finally it did not really work.

I created /etc/httpd/conf.d/horde.conf with following content I found in the horde wiki

Alias /Microsoft-Server-ActiveSync /usr/share/horde/rpc.php
Alias /autodiscover/autodiscover.xml /usr/share/horde/rpc.php
Alias /Autodiscover/Autodiscover.xml /usr/share/horde/rpc.php
Alias /AutoDiscover/AutoDiscover.xml /usr/share/horde/rpc.php

Then I restarted httpd

systemctl restart httpd

After that Outlook 16 can connect but does not see mails and Android Samsung mail can’t connect but the device is shown at horde admin panel. Outlook is shown too.

I’ll test some more the next days …maybe there’s a chance to get it to work.

mrmarkuz · June 28, 2018, 11:02pm

Contacts and calendars are working with Outlook 2016 and Nine on Android!

Sending mails works but the mails in the folders are not shown. As a workaround one may setup a separate IMAP account.

/etc/httpd/conf.d/horde.conf:

Alias /Microsoft-Server-ActiveSync /usr/share/horde/rpc.php
Alias /autodiscover/autodiscover.xml /usr/share/horde/rpc.php
Alias /Autodiscover/Autodiscover.xml /usr/share/horde/rpc.php
Alias /AutoDiscover/AutoDiscover.xml /usr/share/horde/rpc.php
RewriteEngine On
#RewriteRule ^/Microsoft-Server-ActiveSync /usr/share/horde/rpc.php [PT,L,QSA]
RewriteRule .* - [E=HTTP_MS_ASPROTOCOLVERSION:%{HTTP:Ms-Asprotocolversion}]
RewriteRule .* - [E=HTTP_X_MS_POLICYKEY:%{HTTP:X-Ms-Policykey}]
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]

ActiveSync settings:

$conf['activesync']['params']['driverconfig'] = 'horde';
$conf['activesync']['storage'] = 'Sql';
$conf['activesync']['emailsync'] = true;
$conf['activesync']['version'] = '14.1';
$conf['activesync']['auth']['type'] = 'basic';
$conf['activesync']['autodiscovery'] = 'user';
$conf['activesync']['outlookdiscovery'] = false;
$conf['activesync']['logging']['path'] = '/var/log/horde/activesync.log';
$conf['activesync']['logging']['type'] = 'onefile';
$conf['activesync']['ping']['heartbeatmin'] = 60;
$conf['activesync']['ping']['heartbeatmax'] = 2700;
$conf['activesync']['ping']['heartbeatdefault'] = 480;
$conf['activesync']['ping']['deviceping'] = true;
$conf['activesync']['ping']['waitinterval'] = 15;
$conf['activesync']['enabled'] = true;

I get an error in /var/log/horde/activesync.log when syncing mails, I tried playing with horde permissions but no success:

[53228][2018-06-28T22:50:56+00:00] >>>: Polling Horde_Core_ActiveSync_Driver::_getMailFolders()
[53228][2018-06-28T22:50:56+00:00] ERR: User markus is not authorized for Mail

m.traeumner · June 29, 2018, 12:29pm

Hi Markus,
I’ve found something with a cyrus-imap, how I know dovecot is based on it.

For now, i’ve disabled the BINARY capability in the imp backend
configuration using:
$servers[‘advanced’][‘capability_ignore’] = array(‘BINARY’);

Have a look here:

https://lists.horde.org/archives/horde/Week-of-Mon-20140224/050740.html

mark_nl · June 29, 2018, 7:33pm

Have to dig deep in my memory; had to deal with this before, and of course not sure if it is the same issue. And it was the root of the inbox-box; are the incoming mails stored in root (/) of the mailbox or inside the subfolder /INBOX. IIRC you can solve it with an alias namespace in dovecots configuration.

This also solves quite some troubles with (older)android; It favors the “cyrus-imap way” which is storing incoming in /INBOX, IIRC dovecot as configured on NS stores incoming in in the root (/) of the mailbox.

Just a lead…

EDIT:
I knew i wrote it down somewhere : https://github.com/markVnl/nethserver-sogo/issues/5

EDIT2:
although this is not the issue, just yo be accurate

mrmarkuz · June 29, 2018, 10:18pm

Thanks @m.traeumner and @mark_nl, I found the error.

Creating a file /usr/share/horde/imp/config/backends.local.php with following content solved it. It was already discussed here, I just missed it. Now mails, calendars and contacts are working in Outlook and Nine.

$servers['imap'] = array(
    // ENABLED by default; will connect to IMAP port on local server
    'disabled' => false,
    'name' => 'IMAP Server',
    'hostspec' => 'localhost',
    'hordeauth' => true,
    'protocol' => 'imap',
    'port' => 143,   
    'secure' => 'tls',
);

mrmarkuz · June 29, 2018, 11:19pm

Just create these two files and the mail address is auto populated at first login:

/usr/share/horde/config/prefs.local.php:

<?php
 $_prefs['from_addr']['hook'] = true;
 $_prefs['fullname']['hook'] = true;

/usr/share/horde/config/hooks.local.php:

<?php
class Horde_Hooks
{
    public function prefs_init($pref, $value, $username, $scope_ob)
    {
        switch ($pref) {
        case 'from_addr':
            if (is_null($username)) {
                return $value;
            }
            $mail = $username.'@domain.local';
            return empty($mail)
                ? ''
                : $mail;

        case 'fullname':
            if (is_null($username)) {
                return $value;
            }
            return empty($username)
                ? ''
                : $username;
        }
    }
}

I just adapted the script from Wiki :: LDAPHooksHorde5

Fs1234 · April 2, 2019, 2:37pm

Hello,

I’ve been trying to configure this part but without success. Appears my hooks are ignored…

Can you help me?

mrmarkuz · April 2, 2019, 4:18pm

Are you running Nethserver 7.6?
Do you use LDAP or Active Directory?

Fs1234 · April 2, 2019, 4:59pm

Hi,

I’m using centos 7.5, my environment have the following setup:

Server 1: Horde Groupware 5.2.22 (centos 7.5)
Server 2: OpenLap, used to get my Address Book
Server 3: IMAP Server (Dovecot, postfix)

I have doubts with my authentication method, I have the option “Let a Horde application handle authentication” , this is a problem?

I want to auto-populate the Mail preferences/Personal information for my users. For that I’ve tried to follow your documentation and this documentation https://wiki.horde.org/LDAPHooksHorde5 but without success

Thank you.