Re: [SOGo] Best practice of sogo system / user backup - suggestions?
Hi Igor, thanks for your great feedback,
Looks like what I had in mind. :-)
regards . Götz
Am 20.06.13 18:30, schrieb Igor Vitorac:
I have read many backup/restore hints and I have made the following:
- I have one backup scripts that dumps all SOGo calendars and user
settings with sogo-tool. Please see below HELPER BACKUP script
- I have second backup script that picks output from first script and
takes the rest Please see below MAIN BACKUP file
- My backup is based on sogo-tool which is MUCH more safer then simple
DB dump. I am doing additional DB dump as well, just to have additional
way to troubleshoot the problems. Backup with sogo-tool is safer since
it enables you to restore SOGo on newer version which is the case very
often. With simple DB dump you may have problems if you want to install
on fresh SOGo instance with higher version (unless you compile the same
version).
-- HELPER BACKUP script --
#!/bin/sh
# This script is used to backup Sogo calendars and user setttings.
# It must be executed as sogo user
date=`date -I`
#Backup Sogo data files
cd /home/sogo/backup/
/usr/sbin/sogo-tool backup daily_$date ALL backup_report.txt 21
mv backup_report.txt ./daily_$date/
/usr/bin/defaults read sogod ./daily_$date/sogo_conf_text.backup
# these files has to be taken by root cron job for KRONOS backup
tar -cjf daily_$date.tar.bz2 daily_$date
# remove files once packed to archive
rm -rf /home/sogo/backup/daily_$date
#Remove old backup archives
/usr/bin/find /home/sogo/backup -name \*.tar.bz2 -mtime +3 -exec /bin/rm
-f {} \;
-- END HELPER BACKUP script --
-- MAIN BACKUP file --
#!/bin/sh
# This script is used to backup Sogo
date=`date -I`
Stoping some services
#Stop apache server
/etc/init.d/httpd stop
Files
#Backup Sogo data files
# there is another sogo user cron script that backups calendars 1 hour
before this script
cd /root/kronos_backup/backup/
tar -cjf sogo_home_$date.tar.bz2 /home/sogo/
DBs
#Backup DBs
/usr/bin/mysqldump --user=root --opt --databases sogo sogo_bkp_$date.sql
/usr/bin/mysqldump --user=root --opt --databases mysql
mysql_bkp_$date.sql
/usr/bin/mysqldump -u root sogo sogo_users sogo_users_bkp_$date.sql
# Backup for etc folder
tar -cjf etc_backup_$date.tar.bz2 /etc
# Pack the DB files
tar -cjf SOGO_DB_$date.tar.bz2 sogo_bkp_$date.sql
tar -cjf MySQL_DB_$date.tar.bz2 mysql_bkp_$date.sql
tar -cjf SOGO_USERS_TBL_$date.tar.bz2 sogo_users_bkp_$date.sql
# Remove sql files
rm -f sogo_bkp_$date.sql
rm -f mysql_bkp_$date.sql
rm -f sogo_users_bkp_$date.sql
Cleanup
#Remove old files
/usr/bin/find /root/kronos_backup/backup -name \*.tar.bz2 -mtime +2
-exec /bin/rm -f {} \;
Starting services
#Start apache server
/etc/init.d/httpd start
-- END MAIN BACKUP file --
When it comes to the restore/migration part:
- you install clean SOGo
- sogo user source restore depends from your deployment
- restore SOGo config (from config made above):
sudo -u sogo defaults write sogo_conf_text.backup
- restore SOGo calendar and user settings with the script like following:
#!/bin/bash
for i in $( ls /home/sogo/temp/ALL/daily_2013-04-01/); do
echo Processing $i user...
sudo -u sogo sogo-tool restore -F ALL
/home/sogo/temp/ALL/daily_2013-04-01 $i
sudo -u sogo sogo-tool restore -p
/home/sogo/temp/ALL/daily_2013-04-01 $i
done
Pay attention that above has been tested on SOGo 2.0.4b with config
located in .Defaults file.
Hope this helps. Do not hesitate to ask for additional clarification.
Regards,
Igor
Götz Reinicke - IT Koordinator wrote, On 19/06/2013 13:28:
Hi,
I'd like to ask what is your best practice to backup restore your sogo
system and/or user data?
Should we do a e.g. database dump/backup of the mysql (what we already
do for other systems) and do a user based sogo-tool backup?
Regarding the sogo-tool, is there a way to do incremental backups and is
it somehow possible to do backups of user groups?
Thanks for any suggestion . Regards . Götz
--
Götz Reinicke
IT-Koordinator
Tel. +49 7141 969 82 420
Fax +49 7141 969 55 420
E-Mail goetz.reini...@filmakademie.de
Filmakademie Baden-Württemberg GmbH
Akademiehof 10
71638 Ludwigsburg
www.filmakademie.de
Eintragung Amtsgericht Stuttgart HRB 205016
Vorsitzender des Aufsichtsrats: Jürgen Walter MdL
Staatssekretär im Ministerium für Wissenschaft,
Forschung und Kunst Baden-Württemberg
Geschäftsführer: Prof. Thomas Schadt
smime.p7s
Description: S/MIME Kryptografische Unterschrift
Re: [SOGo] Best practice of sogo system / user backup - suggestions?
On Wed, Jun 19, 2013 at 01:28:00PM +0200, Götz Reinicke - IT Koordinator wrote: I'd like to ask what is your best practice to backup restore your sogo system and/or user data? Should we do a e.g. database dump/backup of the mysql (what we already do for other systems) and do a user based sogo-tool backup? We do both. Daily backup of the postgres-database, plus daily sogo-tool backups of all users that has been active the last 24 hours. That should give us the possibility of doing quick single user restore from the sogo-tool backup, and also quick full system restore from database backup. -jf -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Best practice of sogo system / user backup - suggestions?
Jan-Frode Myklebust wrote, On 21/06/2013 12:50: On Wed, Jun 19, 2013 at 01:28:00PM +0200, Götz Reinicke - IT Koordinator wrote: I'd like to ask what is your best practice to backup restore your sogo system and/or user data? Should we do a e.g. database dump/backup of the mysql (what we already do for other systems) and do a user based sogo-tool backup? We do both. Daily backup of the postgres-database, plus daily sogo-tool backups of all users that has been active the last 24 hours. That should give us the possibility of doing quick single user restore from the sogo-tool backup, and also quick full system restore from database backup. -jf I forgot to mentioned that fact, that you can restore single user with sogo-tool. And not just ordinary single user restore, but you have possibility to restore only deleted records (events)! Amazing! I have tested both restores and it works. Regards, Igor -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] Location icon don't change in lightning 1.9.1
Hello,
We are in the process of evaluation. So far so good!
I have a small bug though. I used thunderbird 17.0.6 and the sogo connector
17.0.5. Sogo server is 2.0.5
When I book a resource like a meeting room, the icon beside of the meeting room
stays an envelope for individual. I thought it would change automatically to
the room icon because the kind is location.
I setup the kind field name in the conf.
SOGoUserSources = (
{
type = ldap;
CNFieldName = cn;
IDFieldName = uid;
UIDFieldName = uid;
baseDN = ou=users,dc=ist,dc=ac,dc=at;
bindDN = cn=blah,ou=whatever,dc=ist,dc=ac,dc=at;
bindPassword = ***;
canAuthenticate = YES;
displayName = IST authentication;
hostname = ldap://completely.obfuscated.local:389;
id = auth;
isAddressBook = YES;
KindFieldName = Kind;
MultipleBookingsFieldName = Multiplebookings;
}
Here is a ldap entry:
cn: meeting-room
objectClass: posixAccount
objectClass: inetOrgPerson
objectClass:organizationalPerson
objectClass: person
objectClass: CalendarResource
objectClass: calEntry
objectClass: top
sn: meetingroom
.
.
.
mail:
Kind: location
Multiplebookings: 1
Is the icon suppose to change by itself? If not, it would be very cool if it
can. :)
Thanks for your help
Jean
--
users@sogo.nu
https://inverse.ca/sogo/lists
Re: [SOGo] Location icon don't change in lightning 1.9.1
On 2013-06-21 7:12 AM, j...@ist.ac.at wrote: Is the icon suppose to change by itself? If not, it would be very cool if it can.:) This isn't yet supported. -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] SOGod Freeze while using100% CPU
Hi MJ, Thank you for your advice. I changed it to 32 as your suggestion. Only wait and see. Somsak On Wednesday, June 19, 2013 22:59 ICT, mourik jan heupink heup...@gmail.com wrote: Hi Somsak, When we had problems like these, we were told to increase our WOWorkersCount. We have now set WOWorkersCount = 32; in our /etc/sogo/sogo.conf And we have not seen the 100% cpu usage ever since. Hope it helps you too. MJ On 6/19/2013 12:38, Sogo Thailand wrote: Hi all We have around 15 users access to email server. I found that SOGos use 100% CPU. SOGo is running on SME Server 8.0 Our netstat command show. Active Internet connections (w/o servers) Proto Recv-Q Send-Q Local Address Foreign Address State tcp0 0 localhost:2 localhost:46156 FIN_WAIT2 tcp0 0 localhost:2 localhost:46157 TIME_WAIT tcp0 0 localhost:2 localhost:46155 TIME_WAIT tcp0 0 localhost:2 localhost:46153 TIME_WAIT tcp0 0 localhost:2 localhost:46150 FIN_WAIT2 tcp0 0 localhost:2 localhost:46148 FIN_WAIT2 tcp0 0 localhost:2 localhost:46149 TIME_WAIT tcp0 0 localhost:2 localhost:46170 FIN_WAIT2 tcp0 0 localhost:2 localhost:46171 FIN_WAIT2 tcp0 0 localhost:2 localhost:46168 TIME_WAIT tcp0 0 localhost:2 localhost:46166 TIME_WAIT tcp0 0 localhost:2 localhost:46165 TIME_WAIT tcp0 0 localhost:2 localhost:46162 TIME_WAIT tcp0 0 localhost:2 localhost:46163 TIME_WAIT tcp0 0 localhost:2 localhost:46160 TIME_WAIT tcp0 0 localhost:2 localhost:46161 TIME_WAIT tcp0 0 localhost:2 localhost:46094 TIME_WAIT tcp0 0 mail2.eicm.com:https pc-9.eicm.com:4421 TIME_WAIT tcp0 0 localhost:2 localhost:46095 TIME_WAIT tcp0 0 mail2.eicm.com:https pc-9.eicm.com:4422 TIME_WAIT tcp0 0 localhost:49786 localhost:ldap TIME_WAIT tcp0 0 localhost:49787 localhost:ldap TIME_WAIT tcp0 0 localhost:50528 localhost:imap TIME_WAIT tcp0 0 localhost:50556 localhost:imap TIME_WAIT tcp0 0 mail2.eicm.com:imaps pc-9.eicm.com:62796 ESTABLISHED tcp0 0 localhost:2 localhost:46083 TIME_WAIT tcp0 0 localhost:11211 localhost:48506 ESTABLISHED tcp0 0 localhost:2 localhost:46111 TIME_WAIT tcp0 0 localhost:2 localhost:46108 TIME_WAIT tcp0 0 localhost:2 localhost:46106 TIME_WAIT tcp0 0 localhost:2 localhost:46102 FIN_WAIT2 tcp0 0 localhost:2 localhost:46103 FIN_WAIT2 tcp0 0 mail2.eicm.com:https node-qol.pool-180-180:25567 ESTABLISHED tcp0 0 localhost:2 localhost:46127 TIME_WAIT tcp0 0 localhost:2 localhost:46124 FIN_WAIT2 tcp0 0 mail2.eicm.com:https node-qol.pool-180-180:25568 TIME_WAIT tcp0 0 localhost:11211 localhost:48463 ESTABLISHED tcp0 0 localhost:2 localhost:46123 FIN_WAIT2 tcp0 0 mail2.eicm.com:https node-qol.pool-180-180:25579 ESTABLISHED tcp0 0 localhost:2 localhost:46118 FIN_WAIT2 tcp0 0 localhost:2 localhost:46119 TIME_WAIT tcp0 0 mail2.eicm.com:https pc-00132.eicm.com:4322 TIME_WAIT tcp0 0 localhost:2 localhost:46117 TIME_WAIT tcp0 0 mail2.eicm.com:https pc-00132.eicm.com:4324 TIME_WAIT tcp0 0 localhost:2 localhost:46115 TIME_WAIT tcp0 0 localhost:2 localhost:46113 TIME_WAIT tcp0 0 localhost:2
[SOGo] ANN: SOGo v2.0.6
The Inverse Team is pleased to announce the immediate availability of SOGo 2.0.6. This is a minor release of SOGo which focuses on improved stability over previous versions. What is SOGo SOGo is a free and modern scalable groupware server. It offers shared calendars, address books and emails through your favorite Web browser or by using a native client such as Mozilla Thunderbird and Lightning, Apple Calendar and Address Book (OSX and iOS) and Microsoft Outlook. SOGo is standard-compliant and supports CalDAV, CardDAV, GroupDAV and reuses existing IMAP, SMTP and database servers - making the solution easy to deploy and interoperable with many applications. SOGo features : * Scalable architecture suitable for deployments from dozen to many thousand users * Rich Web-based interface that shares the look and feel, the features and the data of Mozilla Thunderbird and Lightning * Improved integration with Mozilla Thunderbird and Lightning by using the SOGo Connector and the SOGo Integrator * Native compatibility for Microsoft Outlook 2003, 2007 and 2010 * Two-way synchronization support with any SyncML-capable devices (BlackBerry, Palm, Windows CE, etc.) by using the Funambol SOGo Connector * Excellent native integration with Apple software (OSX and iOS) and Android-based devices and many more! SOGo and our connectors are completely free. Changes from the previous release Enhancements * updated CKEditor to version 4.1.1 (#2333) * new failed login attempts rate-limiting options. See the new SOGoMaximumFailedLoginCount, SOGoMaximumFailedLoginInterval and SOGoFailedLoginBlockInterval defaults * new message submissions rate-limiting options. See the new SOGoMaximumMessageSubmissionCount, SOGoMaximumRecipientCount, SOGoMaximumSubmissionInterval and SOGoMessageSubmissionBlockInterval defaults * now possible to send or not event notifications on a per-event basis * now possible to see who created an event/task in a delegated calendar * multi-domain support in OpenChange (implemented using a trick) Bug fixes * fixed decoding of the charset parameter when using single quotes (#2306) * fixed potential crash when sending MDN from Sent folder (#2209) * fixed handling of unicode separators (#2309) * fixed public access when SOGoTrustProxyAuthentication is used (#2237) * fixed access right issues with import feature (#2294) * fixed IMAP ACL issue when SOGoForceExternalLoginWithEmail is used (#2313) * fixed handling of CAS logoutRequest (#2346) * fixed many major OpenChange stability issues Seehttp://www.sogo.nu/bugs/changelog_page.php?project_id=1for closed tickets andhttps://github.com/inverse-inc/sogo/commits/SOGo-2.0.6for the complete change log. Getting SOGo SOGo is free software and is distributed under the GNU GPL. As such, you are free to download and try it by visiting the following page : http://www.sogo.nu/downloads/backend.html You can also download the sources by following the instructions on this page: http://www.sogo.nu/development/source_code.html Frontend clients such as Mozilla Thunderbird, Mozilla Lightning (Inverse Edition), SOGo Connector and SOGo Integrator extensions are available for download from : http://www.sogo.nu/downloads/frontends.html Documentation about the installation and configuration of SOGo, Thunderbird or mobile devices is available from : http://www.sogo.nu/downloads/documentation.html You can also try our online SOGo demo at : http://www.sogo.nu/tour/online_demo.html Upgrading to v2.0.6 No special measure needs to be taken when upgrading from v2.0.5. How can I help ? SOGo is a collaborative effort in order to create the best Free and Open Source groupware solution. There are multiple ways you can contribute to the project : * Documentation reviews, enhancements and translations * Write test cases - if you know Python, join in! * Feature requests or by sharing your ideas (see the roadmap) * Participate to the discussion in mailing lists * Patches for bugs or enhancements (http://www.sogo.nu/bugs) * Provide new translations (http://sogo.nu/english/support/faq/article/how-to-translate-sogo-in-another-language-2.html) Feel free to send us your questions. You can also post them to the SOGo mailing list:http://sogo.nu/lists/ Getting Support For any questions, do not hesitate to contact us by writing tosupp...@inverse.ca mailto:supp...@inverse.ca Customer support packages for SOGo are available fromhttp://inverse.ca/support.html -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse inc. :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] BTS activities for Friday, June 21 2013
Title: BTS activities for Friday, June 21 2013 BTS Activities Home page: http://www.sogo.nu/bugs Project: SOGo For the period covering: Friday, June 21 2013 idlast updatestatus (resolution)categorysummary 2321 2013-06-21 05:49:18 updated (open) OpenChange backend Problem with charset="iso-8859-1" 2351 2013-06-21 12:38:34 new (open) sogo-tool sogo-tool cannot import an export from sogo-tool 1.3.18a 2349 2013-06-21 07:18:07 updated (open) Web Address Book Mail change in contact doesn't pass on contact in list 2350 2013-06-21 07:59:27 new (open) Web Address Book Display of list content is too small 644 2013-06-21 04:22:37 updated (open) Web Mail Move folders 2331 2013-06-21 02:28:09 updated (open) with SOGo Inverse SOGo connector (17.05) crashes thunderbird 2061 2013-06-21 13:50:54 closed (wont fix) OpenChange backend "SambaSource" user source for OpenChange backend
Re: [SOGo] ANN: SOGo v2.0.6
Will there be a NEW (Zeg) with all the updates that we can test ? Ray -Original Message- From: Ludovic Marcotte lmarco...@inverse.ca Date: Fri, 21 Jun 2013 16:24:45 To: users@sogo.nu Reply-To: users@sogo.nu Subject: [SOGo] ANN: SOGo v2.0.6 The Inverse Team is pleased to announce the immediate availability of SOGo 2.0.6. This is a minor release of SOGo which focuses on improved stability over previous versions. What is SOGo SOGo is a free and modern scalable groupware server. It offers shared calendars, address books and emails through your favorite Web browser or by using a native client such as Mozilla Thunderbird and Lightning, Apple Calendar and Address Book (OSX and iOS) and Microsoft Outlook. SOGo is standard-compliant and supports CalDAV, CardDAV, GroupDAV and reuses existing IMAP, SMTP and database servers - making the solution easy to deploy and interoperable with many applications. SOGo features : * Scalable architecture suitable for deployments from dozen to many thousand users * Rich Web-based interface that shares the look and feel, the features and the data of Mozilla Thunderbird and Lightning * Improved integration with Mozilla Thunderbird and Lightning by using the SOGo Connector and the SOGo Integrator * Native compatibility for Microsoft Outlook 2003, 2007 and 2010 * Two-way synchronization support with any SyncML-capable devices (BlackBerry, Palm, Windows CE, etc.) by using the Funambol SOGo Connector * Excellent native integration with Apple software (OSX and iOS) and Android-based devices and many more! SOGo and our connectors are completely free. Changes from the previous release Enhancements * updated CKEditor to version 4.1.1 (#2333) * new failed login attempts rate-limiting options. See the new SOGoMaximumFailedLoginCount, SOGoMaximumFailedLoginInterval and SOGoFailedLoginBlockInterval defaults * new message submissions rate-limiting options. See the new SOGoMaximumMessageSubmissionCount, SOGoMaximumRecipientCount, SOGoMaximumSubmissionInterval and SOGoMessageSubmissionBlockInterval defaults * now possible to send or not event notifications on a per-event basis * now possible to see who created an event/task in a delegated calendar * multi-domain support in OpenChange (implemented using a trick) Bug fixes * fixed decoding of the charset parameter when using single quotes (#2306) * fixed potential crash when sending MDN from Sent folder (#2209) * fixed handling of unicode separators (#2309) * fixed public access when SOGoTrustProxyAuthentication is used (#2237) * fixed access right issues with import feature (#2294) * fixed IMAP ACL issue when SOGoForceExternalLoginWithEmail is used (#2313) * fixed handling of CAS logoutRequest (#2346) * fixed many major OpenChange stability issues Seehttp://www.sogo.nu/bugs/changelog_page.php?project_id=1for closed tickets andhttps://github.com/inverse-inc/sogo/commits/SOGo-2.0.6for the complete change log. Getting SOGo SOGo is free software and is distributed under the GNU GPL. As such, you are free to download and try it by visiting the following page : http://www.sogo.nu/downloads/backend.html You can also download the sources by following the instructions on this page: http://www.sogo.nu/development/source_code.html Frontend clients such as Mozilla Thunderbird, Mozilla Lightning (Inverse Edition), SOGo Connector and SOGo Integrator extensions are available for download from : http://www.sogo.nu/downloads/frontends.html Documentation about the installation and configuration of SOGo, Thunderbird or mobile devices is available from : http://www.sogo.nu/downloads/documentation.html You can also try our online SOGo demo at : http://www.sogo.nu/tour/online_demo.html Upgrading to v2.0.6 No special measure needs to be taken when upgrading from v2.0.5. How can I help ? SOGo is a collaborative effort in order to create the best Free and Open Source groupware solution. There are multiple ways you can contribute to the project : * Documentation reviews, enhancements and translations * Write test cases - if you know Python, join in! * Feature requests or by sharing your ideas (see the roadmap) * Participate to the discussion in mailing lists * Patches for bugs or enhancements (http://www.sogo.nu/bugs) * Provide new translations (http://sogo.nu/english/support/faq/article/how-to-translate-sogo-in-another-language-2.html) Feel free to send us your questions. You can also post them to the SOGo mailing list:http://sogo.nu/lists/ Getting Support For any questions, do not hesitate to contact us by writing tosupp...@inverse.ca mailto:supp...@inverse.ca Customer support packages for SOGo are available fromhttp://inverse.ca/support.html -- Ludovic Marcotte lmarco...@inverse.ca :: +1.514.755.3630 :: http://inverse.ca Inverse
