Can't run a SOGo Backup

it does write the user file that contains the sogo settings for each user yes.i will look at some alternatives if I cant get the sogo-tool going.thanks

You’re welcome!

Please note that nethserver’s backup module seems to take care of the Sogo backups. I’ve seen that in the logs, there are some includes too.

yes, I did not see it before because the backup script push to /dev/null the error message, but each night the backup is done in /var/lib/sogo/backup. We have tested the restoration and it should be workable but of course we can test it again

Just tested it again and all is workable for me

install nethserver-automysqlbackup and do a backup

automysqlbackup

drop the mysql database of sogo

mysql
drop database sogo;

build it again

signal-event nethserver-sogo-update

then restore all settings and data (calaendar and contact)

sogo-restore-user /var/lib/sogo/backups/sogo-2018-01-04_0030 -A

We can see the warning, it is workable even if for each user we see it one time. It is true we know the settings in ldap (samba4 and ldap) are not good, mainly when we want to set the imap acl (mailbox, calendar, contact) because the sAMAccountName is used and not the userPrincipalName (for example stephane and not stephane@de-labrusse.fr)

My concern is if we adjust this correct setting, all records made in mysql are lost because they are done with the key ‘stephane’ and not with the full address mail.

In fact this should be tested parameter per parameter, probably it is not hard to find.

1 Like

I have the same at my logs, for me it’s a problem with caldavsynchronizer. If you enter a mailadress at the synchronization profile you get these errors.
For more details you can also have a look at the following thread:

Sogo LDAP bind error
Do you use caldavsynchronizer?

1 Like

I don’t use caldavsynchronizer, just lightning and sogo connector, also K9 with a carddav application

could someone try it the old fashioned way?

With the some_test_dir of your choice and location (can be in var/tmp)

mkdir  /root/some_test_dir
chown sogo:sogo /root/some_test_dir
su -s '/bin/bash' -c '/usr/sbin/sogo-tool backup /root/some_test_dir ALL' - sogo

Executing it like this sogo-tool does not have to read sogo.conf

Didn’t work for me in /root/somedir

[root@testserver ~]# chown sogo:sogo /root/some_test_dir [root@testserver ~]# su -s '/bin/bash' -c '/usr/sbin/sogo-tool backup /root/some_test_dir ALL' - sogo 2018-01-04 13:50:39.192 sogo-tool[4822:4822] an error occured during directory creation

so I used /tmp:

[root@testserver ~]# su - sogo -s '/bin/bash' -c '/usr/sbin/sogo-tool backup /tmp/sgbkp ALL' <0x0x22a8840[SOGoCache]> Cache cleanup interval set every 300.000000 seconds <0x0x22a8840[SOGoCache]> Using host(s) '127.0.0.1' as server(s)

Backup file is written.

1 Like

Oke we are getting somewhere!

The backup file is written, even when the error occurs, and has working content. I think we can ignore this error as regards the backup function. It seems to occur randomly, I couldn’t find a pattern:

sogo-tool[30089:30089] ERROR(-[NGLdapSearchResultEnumerator nextObject]): does not support result references yet ..

Did you find a solution that works for you? As @stephdl tested again, sogo-tool should work as expected. The error doesn’t affect the backups.

As far as I am aware, the sogo-tool is supposed to include the data as well as config files. The output I get is a config file for the user (sogo settings) and that’s it. No backup of the database or emails or calendar.

[root@testserver ~]# su - sogo -s ‘/bin/bash’ -c '/usr/sbin/sogo-tool backup /tmp/sgbkp ALL

This gives me the same “does not support result references yet” error and the output in /tmp/sgbkp is only small config files.

I’d recommend to use the built-in cron job backup described here. Calendar events and contacts are included in backup:


https://wiki.nethserver.org/doku.php?id=sogo&s[]=sogo#backup_sogo

To backup mysql db you may use this module:

https://wiki.nethserver.org/doku.php?id=module:automysqlbackup

The mails may be backed up with nethserver-backup.

http://docs.nethserver.org/en/v7/backup.html?highlight=Data

1 Like

OK, thanks
Just to clarify
1, (filter rules, specific settings, events, contacts) are contained within the User file and can be saved with the sogo-tool anywhere.
2, (emails) are contained in the /var/vmail/mydomain.com/user1 folder
3, (SQL database) presumable contains the relationships between a user and the above.

Is it possible to save only 1 and 2, then re-create the server manually restoring the data over the top at the end?
Could I not just back the whole drive up every night? Using some sort of incremental backup (to avoiding writing 500gb everytime)

From the backup I really just want to save users emails and calendar events nightly to an external drive (for disaster recovery). We are only talking 20 users, so rebuilding accounts and settings is not that bad.

Yes, that’s possible. With automysqlbackup to save your databases you may just use the Nethserver backup data function, which does schedule an incremental backup.

Another approach would be some kind of virtualization(proxmox, vmware) to run your Nethserver and just backup/snapshot the VM image.

That’s right but why setting it up again when having it all in one incremental backup.

EDIT:

Hotsync backup may also be a solution for you to reduce disaster recovery time to nearly zero, maybe next to data backup:

  1. calendar, contacts, personal settings are saved by sogo-tool and the cron job each night (you can specify when you want to backup them also)

  2. email are saved by the nethserver-backup-data if installed

  3. all settings, calendars, contacts are stored in the mysql database you can save it by nethserver-automysqlbackup or by nethserver-backup-data.

the nethserver-hotsync looks promised :slight_smile:

1 Like

Thanks again everyone for the help.
The VM snapshot sounds great - wish I was on a VM with this install, too much hassle to change right now.
I like the hotsync, but it is overkill for me on this one, I really want to keep it simple (for ongoing maintenance - when I’ve forgotten how I set I up).

Is this a workable backup in theory. (I realise there are tools/scripts for these)
1, Backup the sogo user files
2, Backup the /var/vmail/mydomain.com/

Restore
3, Reload server (same version as the backup)
4, Recreate users and server settings as before
5, Overwrite the sogo user files and the var/vmail/mydomain.com/

why simply not use the backup way of nethserver -> install nethserver-backup-data

it handles the installation of missed softwares and of course the restoration of your configuration.

Keep things simple

Of course a backup strategy is valid, only if you try the restoration time to time…After I like to get the belt and the suspenders, therefore my email are also saved by rsync and my database by automysqlbackup

1 Like

Many thanks, will try a restore tomorrow.

Thanks everyone for the help.
The nethserver backup works great, The belt and braces approach from above is the one I am going for.
Restore worked for me too.

2 Likes