Migration from Zarafa to Kopano
iam trying to install Kopano on a Debian 9 Server with OpenLDAP …
Ive used for 3 years or more zarafa only with one mailbox on a debian 6 server. There are to many dependencies because i would not upgrade to debian 7/8/9.
Is there anyway to import my old mails, files from zarafa to kopano?
Ive used also openldap for authentication, mysql for the mails and the file setting for the attachment before.
Sinux last edited by
my best Way ;)
kitserve last edited by
According to the documentation, the database and attachments formats are unchanged between Zarafa and Kopano (depending on how old your version of Zarafa is). You should be able to do a fresh install of Kopano, then rsync the attachments across (don’t forget to reset the permissions, so they belong to the kopano user), export the Zarafa database using mysqldump and then import it into the Kopano database. Probably a good idea to stop the Kopano services while doing this and then start them again once you’ve finishing copying everything!
BMWfan last edited by
@fbartels thank you of your Information.
Thats the cause why i’am asking which options i have to migrate to kopano.
Iam running on this 7.2.0-47017 zarafa version but i have read here Migration Quick Start-Guide-ZCP to Kopano Core that only Version 7.2.3 is a fork so for me totally compatible to kopano. In this case is a migrate like what kitserve describes anyhow functioning?
Thanks in advance for your answers.
@bmwfan yes, of course. Your linked article (and also the steps decribed in the link) just say that the first Kopano version was pretty much identical with Zarafa 7.2.3. Not more, not less.
So for now, i have migrated my attachments, mysql and ldap from my old Debian 6 Server to the new Debian 9 Server. The Old MySQL Zarafa Database is imported and renamed to Kopano. (i hope thats all for the mysql part). The LDAP database is also imported. Kopano is installed.
At the moment iam stucking at this point LDAP data transplantation to new schema
kopano schema is imported.
openldap is stopped.
ive already created this file: zarafa2kopano.ldif
ive already removed all files from folder /var/lib/ldap
If i try to readd the “new” kopano ldap database, i get this error:
i hope someone can help me.
Thanks in advance.
Now, i found the issue.
In the file zarafa2kopano.ldif was the objectclass under my user still zarafa-user instead of kopano-user. Ive changed it and import it.
Because of some alock package is unstable failures had i done this:
cd /var/lib/ldap/ chown openldap:openldap -R ./*
then the Import was successfull.
One Problem still exist, i cannot login in the kopano webapp.
This is my Output if i make a ldapsearch:
dn: cn=Horst Plero,cn=mailusers,dc=my-domain,dc=local givenName: Horst sn: Plero cn: Horst Plero uid: Horstler uidNumber: 1000 gidNumber: 1000 homeDirectory: /home/Horstler loginShell: /bin/sh objectClass: inetOrgPerson objectClass: posixAccount objectClass: top objectClass: kopano-user kopanoAccount: 1 kopanoAdmin: 1 mail: firstname.lastname@example.org mail: email@example.com mail: firstname.lastname@example.org mail: email@example.com
I know here Install Kopano Core on Debian with OpenLDAP
are more entries as what i have in my output, but iam not sure if every entry is needed and how i can add it.
The command kopano-admin -l give me this output:
Unable to list users: "object" not found
ive copied my ldap.cfg from my old zarafa Installation to the new kopano installation, i hope this is not the fault.
Had anybody a idea why it is not functioning?
AnotherAndy last edited by
take a look here:
I had the same problem with the import :-)
Looks like your ldap config is not correct - can you post it?
I think there are more dependencies. If i stop the Kopano-server and try to restart then i get this message:
● kopano-server.service - Kopano Core Storage Server Loaded: loaded (/lib/systemd/system/kopano-server.service; enabled; vendor pr Active: failed (Result: exit-code) since Sat 2017-11-11 18:11:30 CET; 1s ago Docs: man:kopano-server(8) man:kopano-server.cfg(5) man:kopano-admin(8) Process: 22072 ExecStart=/usr/sbin/kopano-server -F (code=exited, status=255) Main PID: 22072 (code=exited, status=255)
And the logs inlcudes this:
Sat Nov 11 18:11:36 2017: [ notice] Starting kopano-server version 8.4.90 (pid 22107) Sat Nov 11 18:11:36 2017: [error ] Coredumps will not be generated: kopano-server requires the fs.suid_dumpable sysctl to contain the value 2, not 0. Sat Nov 11 18:11:36 2017: [error ] SQL  Failed: Unknown column 'micro' in 'field list', Query Size: 158, Query: "SELECT major, minor, micro, revision, databaserevision FROM versions ORDER BY major DESC, minor DESC, micro DESC, revision DESC, databaserevision DESC LIMIT 1" Sat Nov 11 18:11:36 2017: [error ] KDatabase::DoSelect(): query failed: SELECT major, minor, micro, revision, databaserevision FROM versions ORDER BY major DESC, minor DESC, micro DESC, revision DESC, databaserevision DESC LIMIT 1: Unknown column 'micro' in 'field list' Sat Nov 11 18:11:36 2017: [error ] Can't update the database: Sat Nov 11 18:11:36 2017: [ notice] Server shutdown complete.
Is there anybody who knows how i can fix this, perhaps @fbartels ?
So, i ve solved it by myself.
Ive installed a new Debian 7 Server with zarafa in version 7.2.0-48204, imported my mysql database , my ldap database and the zarafa server.cfg. Ive upgraded then to the newest version (22.214.171.124) and exported this database and imported it on my Primary new Server and it works. :-)
The LDAP issue is also solved. Ive rechecked again all settings and found some faults which ive changed.
Thanks for all :-)
Hey, now iam trying to migrate also my postfix settings.
I get every time this message:
Jan 7 13:43:29 euve61038 postfix/cleanup: warning: ldap:/etc/postfix/ldap-aliases.cf lookup error for "firstname.lastname@example.org" Jan 7 13:43:29 euve61038 postfix/cleanup: warning: 1A5E436003B: virtual_alias_maps map lookup problem for email@example.com -- message not accepted, try again later Jan 7 13:43:29 euve61038 postfix/pickup: warning: 1AA0636003B: message has been queued for 8 days Jan 7 13:43:29 euve61038 postfix/pickup: 1AA0636003B: uid=0 from=<root> Jan 7 13:43:29 euve61038 postfix/cleanup: warning: dict_ldap_connect: Unable to bind to server ldap://localhost:389 with dn uid=kopanoservice,dc=my-domain,dc=local: 49 (Invalid credentials)
But where can i edit the ldap credentials?
I have imported my whole ldap database and configuration files so it should work with the old, or not?
These are the only files where i could find the uid=zarafaservice and where credentials are deposited:
server_host = localhost search_base = dc=my-domain,dc=local version = 3 bind = yes bind_dn = uid=kopanoservice,dc=my-domain,dc=local bind_pw = secret scope = sub query_filter = (kopanoAliases=%s) result_attribute = mail
server_host = localhost search_base = dc=my-domain,dc=local version = 3 bind = yes bind_dn = uid=kopanoservice,dc=my-domain,dc=local bind_pw = secret scope = sub query_filter = (mail=%s) result_attribute = mail
AnotherAndy last edited by AnotherAndy
hi @BMWfan ,
is your ldap server running and can you connect to it with the account kopanoservice?
For example with phpldapadmin you can verify this.
or you use:
ldapsearch -x -D cn=admin,dc=domain,dc=local -W -b dc=domain,dc=local
The ldap-users.conf and ldap-aliases.conf seem to have no error - I think you should search at the openldap server.
in the main.cf of your postfix vou have this entries:
virtual_mailbox_domains = domain.de
virtual_mailbox_maps = ldap:/etc/postfix/ldap-users.cf
virtual_alias_maps = ldap:/etc/postfix/ldap-aliases.cf
virtual_transport = lmtp:127.0.0.1:2003
there are the credentials for the ldap- users- lookup
@anotherandy thank you for your quick response.
Yes, it is. I can also connect to my Kopano Mailbox which is authenticated via ldap.
How can i set the credentials new for this:
AnotherAndy last edited by
very good question - I suggest the phpldapadmin webfrontend :-)
thank you. I have installed the phplapadmin frontend but there is no kopanoservice as a entry where i can check or refresh my password.
BMWfan last edited by
@anotherandy Now i’ve created a new Security Object’ called ‘zarafaservice’ with phpldapadmin and assigned it my old Password and it seems to be to function.