Resolved Plesk Premium Email (Kolab) - licensing and functional issues

[kt1]

Dear all,

this week I decided to try Plesk Premium Email.
Therefore I had to switch from Courier/Qmail to Dovecot/Postfix (using Ubuntu 18.04). Everything went fine without installation errors. First steps went fine so far, the enhanced Roundcube interface is working (at least with basis functionality).
But now some questions arise ...

1.) Spam detection
After using some mail accounts with Plesk Premium Email webinterface, all mails are filtered into Spam folder - Spamassassin reports "0.7 points, 0.0 needed". In domain settings 7.0 is configured as minimum level for spam detection. Is there any repair script I have to run?

2.) Licensing
I understand there are 2 models - free vs. full license with different functionality. For testing purposes I bought 1 Premium/full license. Further licenses are planned after evaluation.

2a.) Functionality
I do not see any difference in functionality setting abonnements to free or to full!?
In my understanding the functions should differ in web interface ... how can I identify both levels?

2b.) License assignment
How can I assign the licenses to mail accounts?
I am not aware of any chance to assign the bought licenses to mail accounts. When assigning Free and Full (and disabled) to abonnements, there seems to be no change in functionality.
The extension dashboard notes "11 of 1 licensed mailboxes", but I have only one domain/abonnement with "Full" (with only ONE mailbox created) with every other disabled. How can I check which "11 mailboxes" are mentioned?

3.) Calendar/Contacts
In web interface, I can see the calendar and contacts and can create new entries. In the file structure (/var/qmail/mailnames ...) new files are created. But when switching the view to email and back to calender or contacts, none of the entries is shown, the calendar (and contact) view is empty. Rights are 600 popuser : popuser.

Any hints and comments are very welcome.

Kind regards,
Karsten

 

[kt1]

Regarding 3.) Calender/Contacts:
from the error.log:

[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_event' doesn't exist (SQL Query: SELECT * FROM `kolab_cache_even
t` WHERE `folder_id` = '8' AND `tags` LIKE '% x-has-alarms %' AND `dtstart` <= '2020-11-26 13:00:00' AND `dtend` >= '2019-11-26 13:00:00') in /usr/share/ro
undcubemail/program/lib/Roundcube/rcube_db.php on line 543 (POST /k5N1AhJ6JrVZ90nk/?_task=calendar&_action=refresh)
[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_task' doesn't exist (SQL Query: SELECT `msguid`, `uid` FROM `kol
ab_cache_task` WHERE `folder_id` = '11' ORDER BY `msguid` DESC) in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 543 (POST /k5N1AhJ6J
rVZ90nk/?_task=calendar&_action=refresh)
[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_task' doesn't exist (SQL Query: SELECT COUNT(*) AS `numrows` FRO
M `kolab_cache_task` WHERE `folder_id` = '11') in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 543 (POST /k5N1AhJ6JrVZ90nk/?_task=ca
lendar&_action=refresh)
[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_task' doesn't exist (SQL Query: SELECT COUNT(*) AS `numrows` FRO
M `kolab_cache_task` WHERE `folder_id` = '11' AND `tags` LIKE '% x-has-alarms %' AND `tags` NOT LIKE '% x-complete %') in /usr/share/roundcubemail/program/
lib/Roundcube/rcube_db.php on line 543 (POST /k5N1AhJ6JrVZ90nk/?_task=calendar&_action=refresh)
[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_task' doesn't exist (SQL Query: SELECT * FROM `kolab_cache_task`
 WHERE `folder_id` = '11' AND `tags` LIKE '% x-has-alarms %' AND `tags` NOT LIKE '% x-complete %') in /usr/share/roundcubemail/program/lib/Roundcube/rcube_
db.php on line 543 (POST /k5N1AhJ6JrVZ90nk/?_task=calendar&_action=refresh)
[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_event' doesn't exist (SQL Query: SELECT COUNT(*) AS `numrows` FR
OM `kolab_cache_event` WHERE `folder_id` = '7' AND `changed` >= '2019-11-27 00:54:22' AND `dtstart` <= '2019-12-02 13:00:00' AND `dtend` >= '2019-11-24 13:
00:00') in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 543 (POST /k5N1AhJ6JrVZ90nk/?_task=calendar&_action=refresh)
[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_event' doesn't exist (SQL Query: SELECT * FROM `kolab_cache_even
t` WHERE `folder_id` = '7' AND `changed` >= '2019-11-27 00:54:22' AND `dtstart` <= '2019-12-02 13:00:00' AND `dtend` >= '2019-11-24 13:00:00') in /usr/shar
e/roundcubemail/program/lib/Roundcube/rcube_db.php on line 543 (POST /k5N1AhJ6JrVZ90nk/?_task=calendar&_action=refresh)
[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_event' doesn't exist (SQL Query: SELECT COUNT(*) AS `numrows` FR
OM `kolab_cache_event` WHERE `folder_id` = '8' AND `changed` >= '2019-11-27 00:54:22' AND `dtstart` <= '2019-12-02 13:00:00' AND `dtend` >= '2019-11-24 13:
00:00') in /usr/share/roundcubemail/program/lib/Roundcube/rcube_db.php on line 543 (POST /k5N1AhJ6JrVZ90nk/?_task=calendar&_action=refresh)
[2019-Nov-27 00:59:22 +0100]: <2racng4n> DB Error: [1146] Table 'roundcubemail.kolab_cache_event' doesn't exist (SQL Query: SELECT * FROM `kolab_cache_even
t` WHERE `folder_id` = '8' AND `changed` >= '2019-11-27 00:54:22' AND `dtstart` <= '2019-12-02 13:00:00' AND `dtend` >= '2019-11-24 13:00:00') in /usr/shar
e/roundcubemail/program/lib/Roundcube/rcube_db.php on line 543 (POST /k5N1AhJ6JrVZ90nk/?_task=calendar&_action=refresh)
[27-Nov-2019 00:59:22 Europe/Berlin] PHP Warning:  file_put_contents(/var/log/roundcubemail/console.log): failed to open stream: Permission denied in /usr/
share/roundcubemail/program/lib/Roundcube/rcube.php on line 1319

 

[kt1]

Okay, meanwhile the problems are solved thanks to the excellent Plesk support team!

ad 1) Spam detection:

It could be fixed either from Plesk UI or through a command line:

1. Log into Plesk
2. Navigate to Domains > example.com > E-Mail Addresses > [email protected] > Spam Filter
3. Enable Switch on spam filtering for this email address
4. Click on Show Advanced Settings and set the desired value in the text box next to Spam filter sensitivity *

But since that´s much effort to do it manually for each mailbox, I used the following command:
Set required_score to 7.0 for all mailboxes that have required_score 0.0 via command line:

1. Connect to the server via SSH
2. Execute the following command:
   

   # grep 0.0 /var/qmail/mailnames/*/*/.spamassassin/user_prefs | sed -n -e 's/.*mailnames\/\(.*\)\/\(.*\)\/\.spamassassin\/user_prefs.*$/\2\@\1/p' | xargs -i /usr/local/psa/bin/spamassassin -u {} -status true -hits 7.0

Now everything works fine with the spam filters.

ad 3) Calendar/Contacts:

For some reason several required tables were not existent in the database. After creating them manually, the calendar and contacts now work properly.

 

[carlosmarchi]

Hi there!

Regarding your item 2a.) Functionality, I'm stuck at the same point. I have installed an additional Plesk server to test the Plesk Email Premium with a paid license and Seafile, but I can't find any significant difference between them, excpect for the Seafile integration.

Have you made any progress on this subject, i.e. comparing the paid vs free Plesk Email Premium?

Thank,
Carlos Marchi

 

[kt1]

Hi,

no, I don't see any difference yet. Especially the fact that I can't assign accounts specifically to the Premium license has kept me from buying licenses for it so far.

Regards,
Karsten

 

[Fraquane]

I really need help with roundcube ...



it's so complicated to explain



send me a message by email or SMS so that I can explain my problem to you

phone: +33614801332

email: [email protected]



that would be really sweet and I would be really grateful.

so that one can help me by teamviewer or you control the pc


Thank you

 

[Greg Sevastos]

Anyone having issues with Premium email after the latest Plesk update today? Doesn't seem to be working for me!