Migration from Kopano to Grommunio

Hhispeed · Nov 26, 2024

Hi @ all this is my first post here at Grommunio .

I need to switch to Grommunio from Kopano. I have a database with the attachments stored in the database.
This is my plan:

Stop the productive system and save the whole VM
Restore the whole VM and try to store the attachments outside the database.
Create a backup of the current Kopano database
Install a new Debian Server
Install Grommunio Community on the fresh Debian server
Restore the Database on the fresh server?
Use gromox-kdb2mt
How do i restore the attachments?

Then i have a special setup with fetchmail which i need to test if I can do successfully the steps above.
Did i forget something?

Thank you for your help.

Best Regads
hispeed

crpb · Nov 26, 2024

Theres an proofen easy mode

https://github.com/grommunio/gromox/blob/prime/tools/kopano2grommunio.sh

I would clone/backup the old server, try an attachment export. If it's working do it with the live system. and from there you can just use the mentioned script.

Hhispeed · Nov 27, 2024

Thank you for this info, i didn't know until now about that script. I will check and try that. I hope I can export the attachments this is probably the "big" part. My database has around 12 GB so it's not that big as others I think.

WalterH · Nov 28, 2024

hispeed I hope I can export the attachments

On the Kopano server you find the script db-convert-attachments-to-files to export the attachments. Documentation: https://documentation.kopano.io/kopanocore_administrator_manual/upgrading.html
See: 4.1.1.2. Migrating database attachments to files - added this information.

crpb · Nov 28, 2024

@WalterH o_0

crpb try an attachment export.

Hhispeed · 2025-03-13T21:12:30+00:00

@WalterH
You wrote in the script: "This script assumes a correct setup of grommunio attached to LDAP/AD." I have actually my users only local in kopano database, is this also a problem?
Right now i'm preparing everything for the first attempt. It looks like I need to do a lot of steps until i will be done....

crpb · 2025-03-13T23:34:18+00:00

grom_create_user () {
        kopano-admin -l | tail -n +5 | head -n -1 | awk '{print $1}' | xargs -n 1 kopano-admin --details | awk '/(Fullname|Emailaddress):/ {$1=""; print substr($0,2)}' | paste - - | while IFS=$'\t' read -r fullname email
        do
                echo "grommunio-admin user create $email --property displayname=\"$fullname\""
        done
}

WalterH · 2025-03-14T05:54:48+00:00

hispeed We read the users from LDAP. But see the post from crpb.