Kopano Cheat Sheet

Table of Contents

How to set Kopano Out of Office

Integrate Shared Calendar in Outlook

What is it? See here.

Download the plugin from here:

https://download.kopano.io/community/olextension%3A/

List all Users

kopano-admin -l

How to renew a Let’s Encrypt SSL certificate on a Kopano Server

There is no one way to do this, but you could try this sequence:

service httpd stop;/usr/bin/certbot renew;service httpd start;service kopano-gateway restart

The above procedure:
- Stops the web server
- Runs the certbot renew command
- Restarts the web server
- Restarts the kopano-gateway service

How to block an email from a user using the Kopano Web App

Users can block emails from other users using the Kopano web application. Here are the steps:

1. Log in to https://domain.com/webapp/ with your username and password.
2. Got to “Settings” top right
3. Go to “Rules” and press “New”

On the rule form, do the following:

Fill in the “rule name” (can be anything for example delete all email from [email protected]
Underneath “When the Message…” choose “…is received from” and go to “Select one…” and type the errant email address (by From: at the botton)
At “Do the following…” choose “Delete the message”.

Save the rule.

How to reset a Kopano password

Kopano passwords are reset using the command line.

SSH to the server
Use this command

kopano-admin -u [email protected] -p NewSecret
User information updated.

If you have an older version of Kopano, as in ancient, do the below instead. All that’s difference is kopano-admin is replaced with zarafa-admin

zarafa-admin -u [email protected] -p NewSecret
User information updated.

Reference

https://documentation.kopano.io/kopanocore_administrator_manual/user_management.html#updating-user-information-with-db-plugin

How to create a new Kopano user

kopano-admin -c [email protected] -p secret -e [email protected] -f "Full Name"

How to update an existing user’s full name

kopano-admin -u [email protected] -f "New Full Name"

How to delete a Kopano user

kopano-admin -d [email protected]

IMAP issues on a Mac with incoming on port 993

On a working Mac you might suddenly find that port 993 stops working. The error will manifest itself in the log file like below:

Oct 31 10:45:33 host kopano-gateway[1354141]: ECChannel::HrEnableTLS(): SSL_accept failed: 5
Oct 31 10:45:33 host kopano-gateway[1354141]: Unable to negotiate SSL connection with a.b.c.d:7145

Our solution was to change to port 143 and remove SSL and in advanced settings, allow insecure connections.

Restoring the Deleted Items folder

You might get this problem after an email migration:

Missing folders
The following required folder is missing in the hierarchy:
Deleted items
Not all functionality of WebApp might be working properly because of this.

To fix do this:

kopano-recreate-systemfolders --user '[email protected]' --create "Deleted Items" --systemfolder wastebasket

You’ll see this:

User([email protected])
Create tmp folder Deleted Items
Promote new folder to be a system folder

Reference: https://forum.kopano.io/topic/3525/folder-deleted-items-has-disappeared/2

Usage Summary Script That Emails

The script below will summarize email and website usage and email recipients with the information.

#!/bin/bash

totald1=`df -h | grep root | awk '{ print "Used:",$3, "| Available:",$4, "| Used: "$5"%"}'`
totald2=`df -h | grep mysql | awk '{ print "Used:",$3, "| Available:",$4, "| Used: "$5"%"}'`
cloud=`du -h --max-depth=1 /srv/www/htdocs/example.com/data/ | cut -d "/" -f 1,7`
users=`kopano-admin -l | grep "@" | awk '{print $1}'`
mail=`for i in $users; do echo $i; kopano-admin --details $i | grep "Current store size" | awk {'print $4}'; done`
d=`date +%m-%d-%Y`
echo "
==================
Total:
==================
$totald1
$totald2

==================
Cloud:
==================
$cloud

==================
Mail:
==================
$mail


" | mailx -r ServerUsage -s "Server Usage for $d" -b [email protected] [email protected]

Add the script to your CRONTAB to have regular usage updates.