Topic: Horde 5.2 on SME9

[mrjhb3]

No, I just have the file manager and bookmark programs also installed.  Horde-Feed provides, Support for working with feed formats such as RSS and Atom.  Not having that, doesn't seem to be your issue, but you can install that if you want.  It'll be there the next time I push out some updates.  I must have deleted the rpm, but still have the src rpm.

[SchulzStefan]

John,
in webmail, do you have a spam-button to tag single emails manually?

[mrjhb3]

Yes, I made it available in one of the patches I did.  The template is in /etc/e-smith/templates/home/httpd/html/horde/imp/config/backends.local.php/120IMAPServers


partial...

        if (($spamassassin{'UseBayes'} || '0') eq '1' and (($spamd{'SpamLearning'} || 'disabled') eq 'enabled'))
        {
           $OUT .= "    'spam' => array(\n";
           $OUT .= "        'innocent' => array(\n";
           $OUT .= "            'display' => true,\n";
           $OUT .= "              'program' => '/usr/bin/spamc -C revoke -u %l',\n";
           $OUT .= "        ),\n";
           $OUT .= "        'spam' => array(\n";
           $OUT .= "           'display' => false,\n";
           $OUT .= "              'program' => '/usr/bin/spamc -C report -u %l',\n";
           $OUT .= "        )\n";
           $OUT .= "    ),\n";
         }
        $OUT .= ");\n";
    }


You need to set  UseBayes to 1 for the spamassassin prop and SpamLearning to enabled for the spamd prop for the spam and innocent buttons to show up.  Probably an easier way, but those props were already present, and I just used them.

[SchulzStefan]

Yes, template is there and those button has been there before I did the update.

# config show spamassassin
spamassassin=service
    BayesAutoLearnThresholdNonspam=0.10
    BayesAutoLearnThresholdSpam=6.00
    DNSAvailable=yes
    MessageRetentionTime=90
    OkLanguages=all
    OkLocales=all
    RejectLevel=9
    ReportSafe=0
    Sensitivity=custom
    SkipRBLChecks=0
    SortSpam=enabled
    Subject=[SPAM]
    SubjectTag=enabled
    TagLevel=4
    UseBayes=1
    status=enabled

# config show spamd
spamd=service
    status=enabled

# less /etc/e-smith/templates/home/httpd/html/horde/imp/config/backends.local.php/120IMAPServers

        if (($spamassassin{'UseBayes'} || '0') eq '1' and (($spamd{'SpamLearning'} || 'disabled') eq 'enabled'))
        {
           $OUT .= "    'spam' => array(\n";
           $OUT .= "        'innocent' => array(\n";
           $OUT .= "            'display' => true,\n";
           $OUT .= "              'program' => '/usr/bin/spamc -C revoke -u %l',\n";
           $OUT .= "        ),\n";
           $OUT .= "        'spam' => array(\n";
           $OUT .= "           'display' => false,\n";
           $OUT .= "              'program' => '/usr/bin/spamc -C report -u %l',\n";
           $OUT .= "        )\n";
           $OUT .= "    ),\n";
         }
        $OUT .= ");\n";


# expand-template /home/httpd/html/horde/imp/config/backends.local.php

leads to:

<?php
/*
#------------------------------------------------------------
#              !!DO NOT MODIFY THIS FILE!!
#
# Manual changes will be lost when this file is regenerated.
#
# Please read the developer's guide, which is available
# at http://www.contribs.org/development/
#
# Copyright (C) 1999-2006 Mitel Networks Corporation
#------------------------------------------------------------
*/

//100Overrides
$servers['imap']['disabled'] = true;

//120IMAPServers
$servers['ivbonline.de'] = array(
    'disabled' => false,
    'name' => 'IMAP Server',
    'hostspec' => 'localhost',
    'hordeauth' => true,
    'protocol' => 'imap',
    'port' => '143',
    'secure' => 'notls',
    'maildomain' => 'domain.de',
    'smtphost' => 'localhost',
    'smtpport' => '25',
    'cache' => false,
);
$servers['eyeseetv.de'] = array(
    'disabled' => false,
    'name' => 'IMAP Server',
    'hostspec' => 'localhost',
    'hordeauth' => true,
    'protocol' => 'imap',
    'port' => '143',
    'secure' => 'notls',
    'maildomain' => 'foobar.de',
    'smtphost' => 'localhost',
    'smtpport' => '25',
    'cache' => false,
);
$servers['fax'] = array(
    'disabled' => false,
    'name' => 'IMAP Server',
    'hostspec' => 'localhost',
    'hordeauth' => true,
    'protocol' => 'imap',
    'port' => '143',
    'secure' => 'notls',
    'maildomain' => 'fax',
    'smtphost' => 'localhost',
    'smtpport' => '25',
    'cache' => false,
);
$servers['objektschilder.de'] = array(
    'disabled' => false,
    'name' => 'IMAP Server',
    'hostspec' => 'localhost',
    'hordeauth' => true,
    'protocol' => 'imap',
    'port' => '143',
    'secure' => 'notls',
    'maildomain' => 'xyz.de',
    'smtphost' => 'localhost',
    'smtpport' => '25',
    'cache' => false,
);

?>

I.e. in the directory horde/imp/config

# ls -l
insgesamt 228
-rw-r----- 1 root apache  1786  5. Jul 10:16 backends.local.php
-rw-r--r-- 1 root root   21220 20. Mai 10:28 backends.php
-rw-r----- 1 root apache  1257  3. Dez 2016  conf.php
-rw-r--r-- 1 root root    8217 20. Mai 10:28 conf.xml
-rw-r----- 1 root apache   674 14. Jan 2015  header.txt
-rw-r--r-- 1 root root   27740 20. Mai 10:28 hooks.php.dist
-rw-r----- 1 root apache  3016  2. Dez 2016  hooks.php.rpmsave
-rw-r--r-- 1 root root    1755 20. Mai 10:28 menu.php.dist
-rw-r----- 1 root apache   609 27. Nov 2016  mime_drivers.local.php
-rw-r--r-- 1 root root    9107 20. Mai 10:28 mime_drivers.php
-rw-r----- 1 root apache  8312  2. Dez 2016  mime_drivers.php.rpmsave
-rw-r----- 1 root apache  1008 27. Nov 2016  prefs.local.php
-rw-r--r-- 1 root root   51652 20. Mai 10:28 prefs.php
-rw-r----- 1 root apache 54392  2. Dez 2016  prefs.php.rpmsave
-rw-r----- 1 root apache  2436  2. Dez 2016  servers.php.rpmsave
-rw-r----- 1 root apache     0  2. Dez 2016  trailer.txt.rpmsave

Is it correct to assume that the owner of /home/httpd/html/horde should be apache:apache?

[SchulzStefan]

        if (($spamassassin{'UseBayes'} || '0') eq '1' and (($spamd{'SpamLearning'} || 'disabled') eq 'enabled'))

You need to set  UseBayes to 1 for the spamassassin prop and SpamLearning to enabled for the spamd prop for the spam and innocent buttons to show up.  Probably an easier way, but those props were already present, and I just used them.

John,

as I posted my settings of spamassassin and spamd - does those match to work with the spam-buttons in horde? I can't find the spamd prop SpamLearning? Where is this supposed to be?

regards,
stefan

[SchulzStefan]

Meanwhile I found this:

https://bugs.contribs.org/show_bug.cgi?id=10138

Not yet in the email wiki...

# rpm -q smeserver-spamassassin
smeserver-spamassassin-2.4.0-8.el6.sme.noarch

I assume I have to set db configuration setprop spamd SpamLearning enabled

What brings up the spam button in horde.

[mrjhb3]

No, you still need to do this:


db setprop spamd SpamLearning enabled
signal-event email-update


That will satisfy the and statement, and then the spam buttons should appear after a logout and login.


In /var/service/spamd/run, there is this:

#!/usr/bin/perl -w


use strict;
use esmith::ConfigDB;


open(STDERR, ">&STDOUT") or warn "Failed to redirect stderr to stdout: $!";
my $c = esmith::ConfigDB->open_ro || die "Couldn't open the configuration database";


my $spamd   = $c->get('spamd');
my $spamass = $c->get('spamassassin');


if ( ($spamass->prop('status') || 'disabled') ne 'enabled'){
  exec('/usr/bin/sv', 'd', '.');
}
else{
  my $bayes = $spamass->prop('UseBayes') || '0';
  my $tell  = $spamd->prop('SpamLearning') || 'disabled';
  my @args  = qw(-u spamd --syslog=stderr --ipv4-only);
  if ($bayes =~ m/^1|yes|on|enabled$/ && $tell =~ m/^1|yes|on|enabled$/){
    push @args, '--allow-tell';
  }
  exec('/usr/bin/spamd', @args);
}


That enables the tell function for spamd.  Before this enhancement was made, you had to have a custom-template, which I hadn't advertised, because I was going to put in a request to enable the tell function, but someone had the same idea as I.  I've no idea what you did to make them appear before, as you said you had them.  Maybe a custom-template as well, that needs to be re-looked at?


Are both DB settings needed to enable the spam buttons in horde, maybe not, but why would I want to do learning without using bayes?  I can't answer that, so that is why both db settings are needed in order to display the spam buttons.


John

[SchulzStefan]

No, you still need to do this:


db setprop spamd SpamLearning enabled
signal-event email-update


John

This leads to:

# db setprop spamd SpamLearning enabled
usage:
    /sbin/e-smith/db dbfile keys
    /sbin/e-smith/db dbfile print [key]
    /sbin/e-smith/db dbfile show [key]
    /sbin/e-smith/db dbfile get key
    /sbin/e-smith/db dbfile set key type [prop1 val1] [prop2 val2] ...
    /sbin/e-smith/db dbfile setdefault key type [prop1 val1] [prop2 val2] ...
    /sbin/e-smith/db dbfile delete key
    /sbin/e-smith/db dbfile printtype [key]
    /sbin/e-smith/db dbfile gettype key
    /sbin/e-smith/db dbfile settype key type
    /sbin/e-smith/db dbfile printprop key [prop1] [prop2] [prop3] ...
    /sbin/e-smith/db dbfile getprop key prop
    /sbin/e-smith/db dbfile setprop key prop1 val1 [prop2 val2] [prop3 val3] ...
    /sbin/e-smith/db dbfile delprop key prop1 [prop2] [prop3] ...

In other words - it does not work in this way.


I did:

db configuration setprop spamd SpamLearning enabled

That brought up the buttons.

# config show spamd
spamd=service
    SpamLearning=enabled
    status=enabled

# config show spamassassin
spamassassin=service
    BayesAutoLearnThresholdNonspam=0.10
    BayesAutoLearnThresholdSpam=6.00
    DNSAvailable=yes
    MessageRetentionTime=90
    OkLanguages=all
    OkLocales=all
    RejectLevel=9
    ReportSafe=0
    Sensitivity=custom
    SkipRBLChecks=0
    SortSpam=enabled
    Subject=[SPAM]
    SubjectTag=enabled
    TagLevel=4
    UseBayes=1
    status=enabled

Don't know, if this is correct now...?

regards,
stefan

[Jean-Philippe Pialasse]

Just a small reminder, John,
do not forget to propagate those good improvement to the sme10 branch, let me know if you need help doing so!

[mrjhb3]

Stefan, typo, but you knew what to do.  AFAICT, things are good.  You can - tail -f /var/log/spamd/current - and see that when you mark a mail as spam, it gets reported.   That is what I do.  Or, if you have Daniel's newer RPM's, then this will be done when you drag a mail to the junkmail folder.  Not sure how many people are using those.  If that makes it into SME10, then the spam buttons may could go away, or kept for another method.  That is a discussion for another time.


JPP, Yep, I will.  I have them already built for it, and I tested them on A2, but want to re-test on A3, when I have some extended time.  Then create the bug reports, and get things built/tested/verified/committed.


John

[Jean-Philippe Pialasse]

JPP, Yep, I will.  I have them already built for it, and I tested them on A2, but want to re-test on A3, when I have some extended time.  Then create the bug reports, and get things built/tested/verified/committed.

John,
thanks for your dedication on Horde for the community. Just let me know if I can be of any help.

JP

[Bud]

guys please can you help

using sme 9.2 with all the latest updates
PHP Software Collections Contrib is installed
mysql 5.7 is installed

phpmod version set to php5.5

i need to share and synchronize " calendars " and " contacts " with 200+ users with ms outlook and mobile phones - HORDE GROUPWARE WEBMAIL ??

after i run the " sh Install-horde52.sh " script i get the following error

Error:  Multilib version problems found. This often means that the root
       cause is something else and multilib version checking is just
       pointing out that there is a problem. Eg.:

         1. You have an upgrade for turba-h5 which is missing some
            dependency that another package requires. Yum is trying to
            solve this by installing an older version of turba-h5 of the
            different architecture. If you exclude the bad architecture
            yum will tell you what the root cause is (which package
            requires what). You can try redoing the upgrade with
            --exclude turba-h5.otherarch ... this should give you an error
            message showing the root cause of the problem.

         2. You have multiple architectures of turba-h5 installed, but
            yum can only see an upgrade for one of those arcitectures.
            If you don't want/need both architectures anymore then you
            can remove the one with the missing update and everything
            will work.

         3. You have duplicate versions of turba-h5 installed already.
            You can use "yum check" to get yum show these errors.

       ...you can also use --setopt=protected_multilib=false to remove
       this checking, however this is almost never the correct thing to
       do as something else is very likely to go wrong (often causing
       much more problems).

       Protected multilib versions: turba-h5-4.2.25-1.el6.noarch != turba-h5-4.2.24-1.el6.noarch

Installation of horde 5.x rpms for SME Server 9 is complete

after doing " signal-event post-upgrade ; signal-event reboot "
when i go to " https://myspeip/horde " or " https://mysmeip/webmail/ " it seems as if Horde 5.2 is not working or not installed.

when i do:  # pear list -c horde

i get

Channel "horde" does not exist

any ideas what i am doing wrong? 

[mrjhb3]

The errror tells you that there are two turba rpms.  To fix - rm turba-h5-4.2.24-1.el6.noarch.rpm  from your unzipped files, or wait for me to re-upload the zip files later tonight in my day.

Thank you,

John

[Bud]

mrjhb3

thank you for your support

i will await for you to re-upload the new files

much appreciated

[ReetP]

I'm, not sure what versions of PHP that Horde 5.2 runs with but please be conscious of the state of play regarding PHP versions.

https://wiki.contribs.org/PHP_Software_Collections

Currently:

Server version PHP 5.3.3 is supported for security updates by Redhat until the End of Life for RH/CentOS 6 However, less and less web applications will run on it, hence SCL.

Other installed versions - the current lowest supported version today is PHP 7.1 and that is only supported until 30th Nov 2019 - in 5 months time.

So the minimum supported version that should be used now is at least 7.1 and preferably 7.2

This is for your own safety and security.

It also means any other 5.x versions and 7.0 are now unsupported and should not be used.

Rgds
John

(Nope - I hate the rapid pace of change but it is what it is)