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 please be aware that due to https://jira.kopano.io/browse/KC-839 you should be running a 7.2.x before upgrading to Kopano.

      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/

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

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