Migration from Zarafa 7.2.4 to Kopano 10.0.6.502 failed


  • 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


  • 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


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


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