View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004256SOGosogo-toolpublic2017-08-22 02:352018-02-07 12:09
Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
PlatformOSOS Version
Product Version 
Target VersionFixed in Version 
Summary0004256: sogo-tool (SOGo-3.2.10) cannot fully restore backup generated by SOGo-2.3.22
DescriptionI was trying to migrate SOGo-2.2.15 to the latest 3.2.10, here's what i did and the result (cannot restore shared calendars)

This is what i did, it’s fully working with SOGo-2.3.22 (the latest 2.x), but NOT fully working with SOGo-3.2.10:

1) OLD server is running SOGo-2.2.15. Take backup with 'sogo-tool backup’.
2) Setup a new (1st) VM with SOGo-2.3.22 (latest nightly build), drop sogo database, re-create the database and restart SOGo. SOGo creates required SQL tables automatically. Note: since it’s already 2.3.x with new SQL structure, i didn’t run the database script "”.
3) Restore SOGo backup data (toke on step 1) with ‘sogo-tool restore’. Everything is fine, personal calendars/contacts and shared calendars are all present.
4) Now take a backup on this new (1st) VM with "sogo-tool backup" (note: it's SOGo-2.3.22).
5) Setup 2nd VM with SOGO-3.2.10 (latest nightly build), drop sogo database, re-create the database and restart SOGo. SOGo creates required SQL tables automatically. Restore the backup token on 1st VM (step 4, SOGo-2.3.22) with ’sogo-tool restore'. Personal calendars/contacts are all present, but NO shared calendars.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate 0004385new Sogo-tool deletes sogo_acl table when it restores folders from a user backup 

-  Notes
MartinL (reporter)
2017-09-04 09:12

I have also noticed this issue.

I also noticed that restoring an user on the same server with SOGo 3.2.10 does not restore ACL neither. So I think this is due to a bug of sogo-tool in the last version and it not due to an incompatibility between v2 and v3.
mcmer (reporter)
2017-12-23 11:01

me too(tm):
2.2.17 backup, 3.2.10 restore, acl{} of folders is not imported.

(For me the severity is more than "minor", it keeps me from migrating a group with complex shares...)
thoehlig (reporter)
2018-01-09 05:43

Any news regarding this issue?
We have the same problem.
User avatar (0012503)
francis (administrator)
2018-01-12 09:02

To restore the preferences, you must call sogo-tool a second time with the "-p" argument:

sogo-tool restore -p <directory> <user>
ASolana (reporter)
2018-02-04 13:48
edited on: 2018-02-04 14:01

It seems "-p" argument is not working as expected on SOGo 3.2.10.

My SOGO 3.2.10 server is configured to create total of nine database tables - and prevent SOGo from creating three database tables per collection.

After restore an user from a sogo-tool backup the acl permissions are all missing.

The user had shared their calendars and addressbooks to other users giving them modify permissions.

I've executed these commands:

sogo-tool backup folder-1 user

sogo-tool remove user

sogo-tool restore -f ALL folder-1 user
sogo-tool restore -p folder-1 user

- At this point no ACLs are restored on user.
It's easy to check that, make a new sogo-tool user backup an run a diff command:

sogo-tool backup folder-2 user

diff folder-1/user folder-2/user
==> only acl permissions are missing

User avatar (0012583)
francis (administrator)
2018-02-07 11:50

Is the destination server running a 9-table (combined tables) model?
ASolana (reporter)
2018-02-07 12:09

Yes, my destination server is running a 9-table (combined tables) on SOGo 3.2.10.

I've noticed that sogo-tool deletes sogo_acl table when it tries to restore folders. So this issue is worst than expected. I've opened another bug "[SOGo 0004390]" about that.

- Issue History
Date Modified Username Field Change
2017-08-22 02:35 zhb New Issue
2017-09-04 09:12 MartinL Note Added: 0012254
2017-12-23 11:01 mcmer Note Added: 0012487
2018-01-09 05:43 thoehlig Note Added: 0012497
2018-01-12 09:02 francis Note Added: 0012503
2018-02-04 13:48 ASolana Note Added: 0012552
2018-02-04 13:50 ASolana Note Edited: 0012552 View Revisions
2018-02-04 13:53 ASolana Note Edited: 0012552 View Revisions
2018-02-04 14:01 ASolana Note Edited: 0012552 View Revisions
2018-02-07 11:45 francis Relationship added has duplicate 0004385
2018-02-07 11:50 francis Note Added: 0012583
2018-02-07 12:09 ASolana Note Added: 0012584

Copyright © 2000 - 2018 MantisBT Team
Powered by Mantis Bugtracker