Migration from Zarafa to Kopano

BMWfan

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: horst@my-domain.de
mail: anything@my-domain.de
mail: webmaster@my-domain.de
mail: info@my-domain.de

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

HI @BMWfan
take a look here:
https://forum.kopano.io/topic/442/ldap-migration-zarafa-kopano-not-working/8
I had the same problem with the import :-)
Looks like your ldap config is not correct - can you post it?
rest regards

BMWfan

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 [00000124] 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 ?

BMWfan

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 (7.2.6.10) 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 :-)

BMWfan

Hey, now iam trying to migrate also my postfix settings.
I get every time this message:

Jan  7 13:43:29 euve61038 postfix/cleanup[15812]: warning: ldap:/etc/postfix/ldap-aliases.cf lookup error for "root@my-domain.de"
Jan  7 13:43:29 euve61038 postfix/cleanup[15812]: warning: 1A5E436003B: virtual_alias_maps map lookup problem for root@my-domain.de -- message not accepted, try again later
Jan  7 13:43:29 euve61038 postfix/pickup[15741]: warning: 1AA0636003B: message has been queued for 8 days
Jan  7 13:43:29 euve61038 postfix/pickup[15741]: 1AA0636003B: uid=0 from=<root>
Jan  7 13:43:29 euve61038 postfix/cleanup[15812]: 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:

etc/postfix/ldap-aliases.cf

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

etc/postfix/ldap-users.conf

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

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

best regards

BMWfan

@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:

uid=kopanoservice,dc=my-domain,dc=local

?

AnotherAndy

@bmwfan
very good question - I suggest the phpldapadmin webfrontend :-)

BMWfan

@anotherandy
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

@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.