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 7.2.4 to Kopano 10.0.6.502 failed

    Kopano Groupware Core
    1
    5
    304
    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.
    • stan23
      stan23 last edited by stan23

      Hi,
      I’m trying to migrate from a pretty old server running Zarafa 7.2.4.29 to a recent Debian 10.

      Steps I did so far:

      on the old machine (Debian 7, Zarafa):

      mysqldump --skip-opt ---single-transaction -p zarafa > zarafa_dump

      on the new machine (Debian 10, Kopano):

      1. install Kopano Community version with the script from https://github.com/thctlo/Kopano
        1.1 create a test user and check that Webapp is working
      2. copy the zarafa_dump and the attachments folder (and adjust ownership)
      3. drop database kopano
      4. create database kopano and import the dump
      mysql -u root -p -e "CREATE DATABASE kopano;"
mysql -u root -p kopano < /backup/mySQLdump_zarafa
      1. start kopano-server

      According to the log, I had to execute

      kopano-dbadm k-1216
kopano-dbadm usmp

      The config files are the default except for mysql credentials and logfile.
      I’m using the DB plugin for users.

      But now in Webapp I get the message Cannot connect to Kopano Core. when trying to log in.

      Kopano server log is like:

      2020-11-19T11:23:24.305753: [error  ] SQL [00000047] Failed: Field 'id' doesn't have a default value, Query Size: 109, Query: "INSERT INTO syncs (change_id, sourcekey, sync_type, sync_time) VALUES (1, '', '1', FROM_UNIXTIME(1605781404))"
2020-11-19T11:23:24.305814: [error  ] KDatabase::I_Update() query failed: "Field 'id' doesn't have a default value", query: INSERT INTO syncs (change_id, sourcekey, sync_type, sync_time) VALUES (1, '', '1', FROM_UNIXTIME(1605781404))
...
2020-11-19T12:00:00.837828: [warning] K-1534: CreateLocalObject: external user "1001" has no login name
2020-11-19T12:00:00.838212: [warning] K-1534: CreateLocalObject: external user "1002" has no login name
2020-11-19T12:00:00.838612: [warning] K-1534: CreateLocalObject: external user "1003" has no login name
2020-11-19T12:00:00.838987: [warning] K-1534: CreateLocalObject: external user "1004" has no login name
2020-11-19T12:00:00.839355: [warning] K-1534: CreateLocalObject: external user "1005" has no login name
2020-11-19T12:00:03.569143: [error  ] SQL [00000051] Failed: Field 'id' doesn't have a default value, Query Size: 165, Query: "REPLACE INTO changes(change_type, sourcekey, parentsourcekey, sourcesync, flags) VALUES (4101, '¶P¹[Dï¤ØËZn/:Nä&\0\0\0', '¶P¹[Dï¤ØËZn/:N\r\0\0\0\0\0\0\0', 0, 0)"
2020-11-19T12:00:03.569190: [error  ] KDatabase::I_Update() query failed: "Field 'id' doesn't have a default value", query: REPLACE INTO changes(change_type, sourcekey, parentsourcekey, sourcesync, flags) VALUES (4101, '¶P¹[Dï¤ØËZn/:Nä&\0\0\0', '¶P¹[Dï¤ØËZn/:N\r\0\0\0\0\0\0\0', 0, 0)
2020-11-19T12:00:03.569374: [error  ] SQL [00000051] Failed: Field 'id' doesn't have a default value, Query Size: 165, Query: "REPLACE INTO changes(change_type, sourcekey, parentsourcekey, sourcesync, flags) VALUES (4101, '¶P¹[Dï¤ØËZn/:Nå&\0\0\0', '¶P¹[Dï¤ØËZn/:N\r\0\0\0\0\0\0\0', 0, 0)"
2020-11-19T12:00:03.569394: [error  ] KDatabase::I_Update() query failed: "Field 'id' doesn't have a default value", query: REPLACE INTO changes(change_type, sourcekey, parentsourcekey, sourcesync, flags) VALUES (4101, '¶P¹[Dï¤ØËZn/:Nå&\0\0\0', '¶P¹[Dï¤ØËZn/:N\r\0\0\0\0\0\0\0', 0, 0)
2020-11-19T12:00:03.569583: [error  ] SQL [00000051] Failed: Field 'id' doesn't have a default value, Query Size: 165, Query: "REPLACE INTO changes(change_type, sourcekey, parentsourcekey, sourcesync, flags) VALUES (4101, '¶P¹[Dï¤ØËZn/:Næ&\0\0\0', '¶P¹[Dï¤ØËZn/:N\r\0\0\0\0\0\0\0', 0, 0)"
2020-11-19T12:00:03.569603: [error  ] KDatabase::I_Update() query failed: "Field 'id' doesn't have a default value", query: REPLACE INTO changes(change_type, sourcekey, parentsourcekey, sourcesync, flags) VALUES (4101, '¶P¹[Dï¤ØËZn/:Næ&\0\0\0', '¶P¹[Dï¤ØËZn/:N\r\0\0\0\0\0\0\0', 0, 0)

      kopano-admin -l lists all the imported users.
      kopano-storeadm -O fails with a Segmentation fault but without further logs.

      What am I missing here?
      I could retry the mysql dump in case an option was missing.

      I also tried kopano-backup but couldn’t make it connect to the old server.

      I have 2 main users (with a few years of mails), 4 rare users and about 5 faceless users which just send notification mails (like my NAS).
      I’m hesitating to buy a subscription because of the faceless users. Maybe there’s a way to have the faceless users just in Postfix and not in Kopano.

      Best regards
      Marco

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

        This is the output of storeadm with maximum loglevel:

        # kopano-storeadm -vvvvv -O
[debug  ] Initializing provider "Kopano Directory Service"
[debug  ] Initializing provider "Private Folders"
[debug  ] Initializing provider "Public Folders"
Segmentation fault

        The public folder does exist, I cannot create it using

        # kopano-storeadm -vvvvv -P
[debug  ] Initializing provider "Kopano Directory Service"
[debug  ] Initializing provider "Private Folders"
[debug  ] Initializing provider "Public Folders"
[error  ] Public store already exists: collision (80040604)

        Best regards
        Marco

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

          Hi,

          as I cannot edit my initial post anymore, here’s my update:
          I was able to solve the SQL errors by dumping and importing the DB once again.
          Webapp seems to work. Postfix is not completely tested yet.

          I still have these warnings every 15 minutes:

          2020-11-19T16:15:02.851851: [warning] K-1534: CreateLocalObject: external user "1000" has no login name
2020-11-19T16:15:02.852331: [warning] K-1534: CreateLocalObject: external user "1001" has no login name
2020-11-19T16:15:02.852715: [warning] K-1534: CreateLocalObject: external user "1002" has no login name
2020-11-19T16:15:02.853131: [warning] K-1534: CreateLocalObject: external user "1003" has no login name
2020-11-19T16:15:02.853552: [warning] K-1534: CreateLocalObject: external user "1004" has no login name
2020-11-19T16:15:02.853993: [warning] K-1534: CreateLocalObject: external user "1005" has no login name
          stan23 1 Reply Last reply Reply Quote 0
          • stan23
            stan23 @stan23 last edited by

            @stan23 said in Migration from Zarafa 7.2.4 to Kopano 10.0.6.502 failed:

            Webapp seems to work. Postfix is not completely tested yet.

            Postfix seems to work as well now.

            I still have these warnings every 15 minutes:

            And although I have about 15 users, the warnings are always for the numbers 1000 to 1005.

            Regards
            Marco

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

              Okay, looks like I managed to get Kopano 10.0.6.502 working in my “productive” setup (i.e. for me and my family).

              Next step is to get a subscription, once the upgrade (or better downgrade) path from Kopano Core 10.0 to Kopano One is clear.

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