Re: [SOGo] subs_ribe user feature for Administrator / SOGoSuperUsernames

2019-06-14 Thread "tim.ban...@gmail.com"
Hello,

I found the answer myself, sogo-tools already has this feature. If
anybody is interested, to subscribe another user to a calendar:

sudo -u sogo sogo-tool manage-acl subscribe user1 Calendar/personal user2

to subscribe user2 to the personal calendar of user1




On 07.06.19 17:08, "tim.ban...@gmail.com" (tim.ban...@gmail.com) wrote:
> Dear SOGo,
> 
> as mentioned here:
> https://lists.inverse.ca/sogo/arc/users/2017-02/msg00065.html
> 
> "... unfortunately the user still has to subscribe manually to the
> resource..."
> 
> So, if I grant userX access to a calendar/address book of userY, userX
> still has to subscribe to this calendar.
> 
> If I could also subscribe userX to userY's resource, userX would see the
> new resource immediately, without the need to find userY's calendar
> (which is very often too complicated).
> 
> Is there any way to do this as administrator (e.g. via the database)? Or
> is this feature planned? I'm using latest sogo 4.x
> 
> kind regards,
> Tim
> 
> 
> ps: "subscribe" in the subject triggered the reply that I shouldn't use
> commands. Therefore the misspelled subject.
> 
-- 
users@sogo.nu
https://inverse.ca/sogo/lists


[SOGo] BTS activities for Friday, June 14 2019

2019-06-14 Thread SOGo reporter
Title: BTS activities for Friday, June 14 2019





  
BTS Activities

  Home page: http://www.sogo.nu/bugs
  Project: SOGo
  For the period covering: Friday, June 14 2019

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
4757
	2019-06-14 12:05:19
	assigned (reopened)
	Backend Mail
	Getting this all time on log
	
	  
	
  
  


-- users@sogo.nuhttps://inverse.ca/sogo/lists

Re: [SOGo] Extracting address books and calendars content

2019-06-14 Thread Christian Mack
Am 14.06.19 um 09:47 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Am 13.06.19 um 17:59 schrieb André Rodier (an...@rodier.me):
>> On Thu, 2019-06-13 at 17:33 +0200, Christian Mack wrote:
> < ... >
>>>
>>> You know sogo-tool backup?
>>>
>>
>> Thanks, Christian, I will use this.
>>
>> I have successfully tested it, and it works. I had trouble the last
>> time I tested, with AppArmor.
>>
>> However, how can I restore a backup for some users, now?
>>
> 
> When you have a sogo-tool backup for user anna in directory ./backup/
> you can list her calendars and addressbooks with:
> 
> /usr/sbin/sogo-tool restore -l ./backup/ anna
> 
> This will give you something like this:
> 
> <0x0x191ea60[SOGoCache]> Cache cleanup interval set every 900.00 seconds
> <0x0x191ea60[SOGoCache]> Using host(s) 'localhost' as server(s)
> 2019-06-14 09:31:43.685 sogo-tool[26667] Restorable folders:
> 2019-06-14 09:31:43.688 sogo-tool[26667]
> Calendar/2013-5614DA00-3-4EA7FE00 (Import Example)
> 2019-06-14 09:31:43.688 sogo-tool[26667]
> Calendar/55D4-57CD2C80-47-7C164080 (Superduper)
> 2019-06-14 09:31:43.689 sogo-tool[26667]
> Calendar/c81a287ec3c4719de08fae31306f851d (Pickwick)
> 2019-06-14 09:31:43.689 sogo-tool[26667]
> Calendar/e6dd60a375bd4c01a6416cacf763b33a (Normal-Tasks)
> 2019-06-14 09:31:43.689 sogo-tool[26667]   Calendar/personal
> (Persönlicher Kalender)
> 2019-06-14 09:31:43.689 sogo-tool[26667]   Contacts/collected
> (Gesammelte Adressen)
> 2019-06-14 09:31:43.689 sogo-tool[26667]   Contacts/personal
> (Persönliches Adressbuch)
> 
> If you want to restore calendar "Import Example" to the state of your
> backup and discard all changes made to it since then, use:
> 
> /usr/sbin/sogo-tool restore -F Calendar/2013-5614DA00-3-4EA7FE00
> ./backup/ anna
> 
> If you just want to restore accidently deleted events and keep all
> changes made since your backup, use:
> 
> /usr/sbin/sogo-tool restore -f Calendar/2013-5614DA00-3-4EA7FE00
> ./backup/ anna
> 
> For addressbooks you just have to exchange the Calendar/... part with
> Contacts/... one.
> 
> If the user deleted the whole calendar or address book, you also can
> restore its settings afterwards with:
> 
> usr/sbin/sogo-tool restore -p ./backup/ anna
> 
> This will restore all settings, not just the ones for the restored
> calendar/addressbook.
> 
> If you use SIEVE in SOGo, then you have to use:
> 
> usr/sbin/sogo-tool restore -p -c /etc/sogo/sieve.creds ./backup/ anna
> 
> This will also restore all SIEVE rules in your IMAP/SIEVE server.
> 

I forgot 2 things ;-)

1) After restore operations always restart memcached, or you will get
strange effects.

2) If you want to restore all calendars and addressbooks of user anna, use:

/usr/sbin/sogo-tool restore -F ALL ./backup/ anna


With that you can restore all users with a loop over all users for
restoring their calendars and addressbooks.
Restarting memcached.
Then another loop over all users for restoring their privileges and
SIEVE rules.
Restarting memcached again.


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature


Re: [SOGo] Extracting address books and calendars content

2019-06-14 Thread an...@rodier.me

On 2019-06-14 08:58, Christian Mack wrote:

Am 14.06.19 um 09:47 schrieb Christian Mack
(christian.m...@uni-konstanz.de):

Am 13.06.19 um 17:59 schrieb André Rodier (an...@rodier.me):

On Thu, 2019-06-13 at 17:33 +0200, Christian Mack wrote:

< ... >


You know sogo-tool backup?



Thanks, Christian, I will use this.

I have successfully tested it, and it works. I had trouble the last
time I tested, with AppArmor.

However, how can I restore a backup for some users, now?



When you have a sogo-tool backup for user anna in directory ./backup/
you can list her calendars and addressbooks with:

/usr/sbin/sogo-tool restore -l ./backup/ anna

This will give you something like this:

<0x0x191ea60[SOGoCache]> Cache cleanup interval set every 900.00 
seconds

<0x0x191ea60[SOGoCache]> Using host(s) 'localhost' as server(s)
2019-06-14 09:31:43.685 sogo-tool[26667] Restorable folders:
2019-06-14 09:31:43.688 sogo-tool[26667]
Calendar/2013-5614DA00-3-4EA7FE00 (Import Example)
2019-06-14 09:31:43.688 sogo-tool[26667]
Calendar/55D4-57CD2C80-47-7C164080 (Superduper)
2019-06-14 09:31:43.689 sogo-tool[26667]
Calendar/c81a287ec3c4719de08fae31306f851d (Pickwick)
2019-06-14 09:31:43.689 sogo-tool[26667]
Calendar/e6dd60a375bd4c01a6416cacf763b33a (Normal-Tasks)
2019-06-14 09:31:43.689 sogo-tool[26667]   Calendar/personal
(Persönlicher Kalender)
2019-06-14 09:31:43.689 sogo-tool[26667]   Contacts/collected
(Gesammelte Adressen)
2019-06-14 09:31:43.689 sogo-tool[26667]   Contacts/personal
(Persönliches Adressbuch)

If you want to restore calendar "Import Example" to the state of your
backup and discard all changes made to it since then, use:

/usr/sbin/sogo-tool restore -F Calendar/2013-5614DA00-3-4EA7FE00
./backup/ anna

If you just want to restore accidently deleted events and keep all
changes made since your backup, use:

/usr/sbin/sogo-tool restore -f Calendar/2013-5614DA00-3-4EA7FE00
./backup/ anna

For addressbooks you just have to exchange the Calendar/... part with
Contacts/... one.

If the user deleted the whole calendar or address book, you also can
restore its settings afterwards with:

usr/sbin/sogo-tool restore -p ./backup/ anna

This will restore all settings, not just the ones for the restored
calendar/addressbook.

If you use SIEVE in SOGo, then you have to use:

usr/sbin/sogo-tool restore -p -c /etc/sogo/sieve.creds ./backup/ anna

This will also restore all SIEVE rules in your IMAP/SIEVE server.



I forgot 2 things ;-)

1) After restore operations always restart memcached, or you will get
strange effects.

2) If you want to restore all calendars and addressbooks of user anna, 
use:


/usr/sbin/sogo-tool restore -F ALL ./backup/ anna


With that you can restore all users with a loop over all users for
restoring their calendars and addressbooks.
Restarting memcached.
Then another loop over all users for restoring their privileges and
SIEVE rules.
Restarting memcached again.


Kind regards,
Christian Mack


Thanks, Christian,

This is very very helpful.

I will test and integrate this.

Kind regards,
André

--
https://github.com/progmaticltd/homebox
--
users@sogo.nu
https://inverse.ca/sogo/lists


Re: [SOGo] Extracting address books and calendars content

2019-06-14 Thread Christian Mack
Am 13.06.19 um 17:59 schrieb André Rodier (an...@rodier.me):
> On Thu, 2019-06-13 at 17:33 +0200, Christian Mack wrote:
< ... >
>>
>> You know sogo-tool backup?
>>
> 
> Thanks, Christian, I will use this.
> 
> I have successfully tested it, and it works. I had trouble the last
> time I tested, with AppArmor.
> 
> However, how can I restore a backup for some users, now?
> 

When you have a sogo-tool backup for user anna in directory ./backup/
you can list her calendars and addressbooks with:

/usr/sbin/sogo-tool restore -l ./backup/ anna

This will give you something like this:

<0x0x191ea60[SOGoCache]> Cache cleanup interval set every 900.00 seconds
<0x0x191ea60[SOGoCache]> Using host(s) 'localhost' as server(s)
2019-06-14 09:31:43.685 sogo-tool[26667] Restorable folders:
2019-06-14 09:31:43.688 sogo-tool[26667]
Calendar/2013-5614DA00-3-4EA7FE00 (Import Example)
2019-06-14 09:31:43.688 sogo-tool[26667]
Calendar/55D4-57CD2C80-47-7C164080 (Superduper)
2019-06-14 09:31:43.689 sogo-tool[26667]
Calendar/c81a287ec3c4719de08fae31306f851d (Pickwick)
2019-06-14 09:31:43.689 sogo-tool[26667]
Calendar/e6dd60a375bd4c01a6416cacf763b33a (Normal-Tasks)
2019-06-14 09:31:43.689 sogo-tool[26667]   Calendar/personal
(Persönlicher Kalender)
2019-06-14 09:31:43.689 sogo-tool[26667]   Contacts/collected
(Gesammelte Adressen)
2019-06-14 09:31:43.689 sogo-tool[26667]   Contacts/personal
(Persönliches Adressbuch)

If you want to restore calendar "Import Example" to the state of your
backup and discard all changes made to it since then, use:

/usr/sbin/sogo-tool restore -F Calendar/2013-5614DA00-3-4EA7FE00
./backup/ anna

If you just want to restore accidently deleted events and keep all
changes made since your backup, use:

/usr/sbin/sogo-tool restore -f Calendar/2013-5614DA00-3-4EA7FE00
./backup/ anna

For addressbooks you just have to exchange the Calendar/... part with
Contacts/... one.

If the user deleted the whole calendar or address book, you also can
restore its settings afterwards with:

usr/sbin/sogo-tool restore -p ./backup/ anna

This will restore all settings, not just the ones for the restored
calendar/addressbook.

If you use SIEVE in SOGo, then you have to use:

usr/sbin/sogo-tool restore -p -c /etc/sogo/sieve.creds ./backup/ anna

This will also restore all SIEVE rules in your IMAP/SIEVE server.


Kind regards,
Christian Mack
-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature