Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

    Migration from Zarafa to Kopano

    Kopano Groupware Core
    5
    17
    3354
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • fbartels
      fbartels Kopano @BMWfan last edited by

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

      Regards Felix

      Resources:
      https://kopano.com/blog/how-to-get-kopano/
      https://documentation.kopano.io/
      https://kb.kopano.io/

      Support overview:
      https://kopano.com/support/

      1 Reply Last reply Reply Quote 0
      • BMWfan
        BMWfan last edited by BMWfan

        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:
        alt text

        i hope someone can help me.

        Thanks in advance.

        1 Reply Last reply Reply Quote 0
        • BMWfan
          BMWfan last edited by 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?

          1 Reply Last reply Reply Quote 0
          • AnotherAndy
            AnotherAndy last edited by

            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

            1 Reply Last reply Reply Quote 0
            • BMWfan
              BMWfan last edited by 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 ?

              1 Reply Last reply Reply Quote 0
              • BMWfan
                BMWfan last edited by 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 :-)

                1 Reply Last reply Reply Quote 0
                • BMWfan
                  BMWfan last edited by 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
                  
                  1 Reply Last reply Reply Quote 0
                  • AnotherAndy
                    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

                    best regards

                    BMWfan 1 Reply Last reply Reply Quote 0
                    • BMWfan
                      BMWfan @AnotherAndy last edited by 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 1 Reply Last reply Reply Quote 0
                      • AnotherAndy
                        AnotherAndy @BMWfan last edited by

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

                        BMWfan 1 Reply Last reply Reply Quote 0
                        • BMWfan
                          BMWfan @AnotherAndy last edited by 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.

                          1 Reply Last reply Reply Quote 0
                          • BMWfan
                            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.

                            1 Reply Last reply Reply Quote 0
                            • First post
                              Last post