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
    3353
    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.
    • 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