date:20200526

[SOGo] BTS activities for Tuesday, May 26 2020

2020-05-26 Thread SOGo reporter

Title: BTS activities for Tuesday, May 26 2020





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Tuesday, May 26 2020

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5037
	2020-05-26 06:43:47
	updated (open)
	GUI
	Using commas in invitation contact names cause to be badly escaped
	
	  
	
4171
	2020-05-26 10:03:51
	updated (fixed)
	sogo-tool
	sogo-tool manage-acl does not set acl correctly for group
	
	  
	
5036
	2020-05-26 03:21:28
	updated (open)
	Web Mail
	search strings containing ' or " lead to "Internal Server Error" or "not implemented" error message
	
	  
	
  
  


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

Re: [SOGo] SOGo On Centos 8

2020-05-26 Thread Eslam Basyouni

 OK ,lets wait next release 4.3.3.

On Tuesday, May 26, 2020, 10:57:53 AM GMT+2, Christian Mack  
wrote:  

 Hello

Am 26.05.20 um 04:20 schrieb Eslam Basyouni (eslam.basyo...@yahoo.com):
> I hope so.. I will try to send them or report this as bug maybe they see it
> Big thanks to you 
> 
> Sent from Yahoo Mail on Android 
>  
>  On Tue, May 26, 2020 at 4:08 AM, Zhang Huangbin wrote:  
>> On May 26, 2020, at 7:15 AM, Eslam Basyouni (eslam.basyo...@yahoo.com) 
>>  wrote:
>>
>> ... but why i cant see it on https://sogo.nu/download.html  , is this still 
>> not official or not supported 
> 
> I guess SOGo team forgot to update the web page. :)
> 
> BTW, packages for Ubuntu 20.04 are available too:
> https://packages.inverse.ca/SOGo/nightly/4/ubuntu/
> 
> 
> Zhang Huangbin, founder of iRedMail project: https://www.iredmail.org/
> 

I think they will update the webpage, once the first stable release with
support for CentOS 8 and Ubuntu 20.04 is out.
Currently there are only nightlies.

I also assume, that this will be the next release 4.3.3.

But I just found out, that the FAQ section is really outdated.
Newest Debian mentioned is Debian 8 Jessie.
We are on Debian 10 Buster now and where on Debian 9 Stretch before.
So there is no harm in filing some bug reports ;-)

Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416

-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] sogo-tool rename-user erases all acl's

2020-05-26 Thread Philipp Kuehne

Hi Christian,

we have all these settings in our config.

If you want I can anonymize the data and send it to you so you can have
a look!

Thanks in advance.

Kind regards

Philipp

Am 26.05.20 um 16:18 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Hello
>
> Check your configuration in sogo.conf.
> You need the following new settings for 9 table layout:
> OCSStoreURL
> OCSAclURL
> OCSCacheFolderURL
>
> I assume OCSAclURL is missing.
>
>
> Kind regards,
> Christian Mack
>
> Am 26.05.20 um 14:46 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
>> Hi,
>>
>> We did install version 4 with the 9-table layout. However we did not do
>> an upgrade, we exported the data with sogo-tool on the SOGo 2 server and
>> imported with sogo-tool on the SOGo 4 server.
>>
>> So seems like we missed something.
>>
>> Does anyone have an idea how to solve that issue?
>>
>> Kind regards,
>>
>> Philipp
>>
>> Am 26.05.20 um 09:15 schrieb Christian Mack
>> (christian.m...@uni-konstanz.de):
>>> Hi
>>>
>>> When upgrading to Version 4. did you switch from 3 tables per user to 9
>>> tables combined layout?
>>>
>>> This error messeges seem to indicate, you did partly.
>>> If you did, you should do it completely first.
>>>
>>>
>>> Kind regards,
>>> Christian Mack
>>>
>>> Am 25.05.20 um 19:31 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
 Hi,

 we recently upgraded our sogo installation from version 2 to version
 4.3.0 on a debian 10.

 Since the migration worked fine I had a colleague who married and got a
 new surname.

 So I changed all attributes in ldap and used the "sogo-tool rename-user"
 to give him access to his calendar and tasks.

 First thing I noticed was that there were like hundreds of errors
 because the database structure changed and there were no more personal
 tables for each user.

 Here is an example for one of these errors:

 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
  SQL: UPDATE 
 sogosomeposix0014ba520e0_acl SET c_uid = 'newposix' WHERE c_uid = 
 'oldposix';

 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
ERROR: 
 Table 'sogodb.sogosomeposix0014ba520e0_acl' doesn't exist 

 Since these tables didn't exist anymore I wasn't worried and everything
 looked fine.

 Today I got lots of complaints that people couldn't access other
 calendars so i checked the database and saw that all the entries in
 sogo_acl where wrong.

 Here is a short cutout:

 | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someposix    
     | ConfidentialDAndTViewer |
 | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | 
 someotherposix   | PrivateDAndTViewer  |

 All 5600 lines in this table looked exactly like this so I took the
 table from my backup and changed the according lines manually since
 everything else lokked ok.

 So I cloned my Setup to see where things went wrong and found the line:

 root@myserver:~# sogo-tool -v rename-user oldposix newposix
 2020-05-25 18:47:28.915 sogo-tool[21871:21871] MySQL4 connection 
 established 0x0x563777a14170
 ...
 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
  SQL: SELECT 
 c_uid, c_object, c_role FROM sogo_acl WHERE c_folder_id = 424 AND 
 (c_object LIKE '/oldposix/%');
 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
query has 
 results, entering fetch-mode.
 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
  SQL: UPDATE 
 sogo_acl SET c_object = '/newposix/Calendar/5A00-59D22100-1-70F14480';
 ... 

 followed by the errors mentioned above

 Obviously somewhere in this script the update-query is missing the
 where-clause which is used in the query before.

 Is this a known bug and we're just on an old version? Or is this a new
 bug and nobody noticed yet?

 kind regards

 Philipp

>
-- 
___

Philipp Kühne | IT Administrator


indurad GmbH| the industrial radar company

Belvedereallee 5 | 52070 Aachen | Germany
phone: +49 241 538070-103 | front desk: +49 241 538070-0
email: philipp.kue...@indurad.com  |
web: www.indurad.com 


signature.asc
Description: OpenPGP digital signature

Re: [SOGo] Activate two Factor Authentication in SOGo

2020-05-26 Thread Juergen Bruckner

Hello Christian,

you wouldn't believe ... I did read that ticket in the bugtracker 3 or 4
times the past few days, and didnt notice the higher version number :D
*doh!*

Thanks!

Juergen

Am 26.05.20 um 16:22 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Hello
> 
> Am 26.05.20 um 15:06 schrieb Juergen Bruckner (juergen@bruckner.email):
>> Hello List,
>>
>> I am faced with the problem that I want to activate the 2FA in SOGo, but
>> the QR code or the secret is not shown to me (-> see attached screenshot)
>>
>> I use SOGo version 4.3.2, which is installed with the current Docker
>> bundle "mailcow".
>>
>> Does anyone here have any ideas on how to solve this problem?
>>
> < cut >
> 
> That function will be available in 4.3.3 according to
> https://sogo.nu/bugs/view.php?id=2722 ;-)
> 
> 
> Kind regards,
> Christian Mack
> 

-- 
Juergen M. Bruckner
juergen@bruckner.email



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Activate two Factor Authentication in SOGo

2020-05-26 Thread Christian Mack

Hello

Am 26.05.20 um 15:06 schrieb Juergen Bruckner (juergen@bruckner.email):
> Hello List,
> 
> I am faced with the problem that I want to activate the 2FA in SOGo, but
> the QR code or the secret is not shown to me (-> see attached screenshot)
> 
> I use SOGo version 4.3.2, which is installed with the current Docker
> bundle "mailcow".
> 
> Does anyone here have any ideas on how to solve this problem?
> 
< cut >

That function will be available in 4.3.3 according to
https://sogo.nu/bugs/view.php?id=2722 ;-)


Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] sogo-tool rename-user erases all acl's

2020-05-26 Thread Christian Mack

Hello

Check your configuration in sogo.conf.
You need the following new settings for 9 table layout:
OCSStoreURL
OCSAclURL
OCSCacheFolderURL

I assume OCSAclURL is missing.


Kind regards,
Christian Mack

Am 26.05.20 um 14:46 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
> Hi,
> 
> We did install version 4 with the 9-table layout. However we did not do
> an upgrade, we exported the data with sogo-tool on the SOGo 2 server and
> imported with sogo-tool on the SOGo 4 server.
> 
> So seems like we missed something.
> 
> Does anyone have an idea how to solve that issue?
> 
> Kind regards,
> 
> Philipp
> 
> Am 26.05.20 um 09:15 schrieb Christian Mack
> (christian.m...@uni-konstanz.de):
>> Hi
>>
>> When upgrading to Version 4. did you switch from 3 tables per user to 9
>> tables combined layout?
>>
>> This error messeges seem to indicate, you did partly.
>> If you did, you should do it completely first.
>>
>>
>> Kind regards,
>> Christian Mack
>>
>> Am 25.05.20 um 19:31 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
>>> Hi,
>>>
>>> we recently upgraded our sogo installation from version 2 to version
>>> 4.3.0 on a debian 10.
>>>
>>> Since the migration worked fine I had a colleague who married and got a
>>> new surname.
>>>
>>> So I changed all attributes in ldap and used the "sogo-tool rename-user"
>>> to give him access to his calendar and tasks.
>>>
>>> First thing I noticed was that there were like hundreds of errors
>>> because the database structure changed and there were no more personal
>>> tables for each user.
>>>
>>> Here is an example for one of these errors:
>>>
>>> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>>>  SQL: UPDATE 
>>> sogosomeposix0014ba520e0_acl SET c_uid = 'newposix' WHERE c_uid = 
>>> 'oldposix';
>>>
>>> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>>>ERROR: 
>>> Table 'sogodb.sogosomeposix0014ba520e0_acl' doesn't exist 
>>>
>>> Since these tables didn't exist anymore I wasn't worried and everything
>>> looked fine.
>>>
>>> Today I got lots of complaints that people couldn't access other
>>> calendars so i checked the database and saw that all the entries in
>>> sogo_acl where wrong.
>>>
>>> Here is a short cutout:
>>>
>>> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someposix 
>>>    | ConfidentialDAndTViewer |
>>> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | 
>>> someotherposix   | PrivateDAndTViewer  |
>>>
>>> All 5600 lines in this table looked exactly like this so I took the
>>> table from my backup and changed the according lines manually since
>>> everything else lokked ok.
>>>
>>> So I cloned my Setup to see where things went wrong and found the line:
>>>
>>> root@myserver:~# sogo-tool -v rename-user oldposix newposix
>>> 2020-05-25 18:47:28.915 sogo-tool[21871:21871] MySQL4 connection 
>>> established 0x0x563777a14170
>>> ...
>>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>>  SQL: SELECT 
>>> c_uid, c_object, c_role FROM sogo_acl WHERE c_folder_id = 424 AND (c_object 
>>> LIKE '/oldposix/%');
>>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>>query has 
>>> results, entering fetch-mode.
>>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>>  SQL: UPDATE 
>>> sogo_acl SET c_object = '/newposix/Calendar/5A00-59D22100-1-70F14480';
>>> ... 
>>>
>>> followed by the errors mentioned above
>>>
>>> Obviously somewhere in this script the update-query is missing the
>>> where-clause which is used in the query before.
>>>
>>> Is this a known bug and we're just on an old version? Or is this a new
>>> bug and nobody noticed yet?
>>>
>>> kind regards
>>>
>>> Philipp
>>>
>>


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] sogo-tool rename-user erases all acl's

2020-05-26 Thread Philipp Kuehne

Hi,

We did install version 4 with the 9-table layout. However we did not do
an upgrade, we exported the data with sogo-tool on the SOGo 2 server and
imported with sogo-tool on the SOGo 4 server.

So seems like we missed something.

Does anyone have an idea how to solve that issue?

Kind regards,

Philipp

Am 26.05.20 um 09:15 schrieb Christian Mack
(christian.m...@uni-konstanz.de):
> Hi
>
> When upgrading to Version 4. did you switch from 3 tables per user to 9
> tables combined layout?
>
> This error messeges seem to indicate, you did partly.
> If you did, you should do it completely first.
>
>
> Kind regards,
> Christian Mack
>
> Am 25.05.20 um 19:31 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
>> Hi,
>>
>> we recently upgraded our sogo installation from version 2 to version
>> 4.3.0 on a debian 10.
>>
>> Since the migration worked fine I had a colleague who married and got a
>> new surname.
>>
>> So I changed all attributes in ldap and used the "sogo-tool rename-user"
>> to give him access to his calendar and tasks.
>>
>> First thing I noticed was that there were like hundreds of errors
>> because the database structure changed and there were no more personal
>> tables for each user.
>>
>> Here is an example for one of these errors:
>>
>> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>>  SQL: UPDATE 
>> sogosomeposix0014ba520e0_acl SET c_uid = 'newposix' WHERE c_uid = 'oldposix';
>>
>> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>>ERROR: Table 
>> 'sogodb.sogosomeposix0014ba520e0_acl' doesn't exist 
>>
>> Since these tables didn't exist anymore I wasn't worried and everything
>> looked fine.
>>
>> Today I got lots of complaints that people couldn't access other
>> calendars so i checked the database and saw that all the entries in
>> sogo_acl where wrong.
>>
>> Here is a short cutout:
>>
>> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someposix  
>>   | ConfidentialDAndTViewer |
>> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someotherposix 
>>   | PrivateDAndTViewer  |
>>
>> All 5600 lines in this table looked exactly like this so I took the
>> table from my backup and changed the according lines manually since
>> everything else lokked ok.
>>
>> So I cloned my Setup to see where things went wrong and found the line:
>>
>> root@myserver:~# sogo-tool -v rename-user oldposix newposix
>> 2020-05-25 18:47:28.915 sogo-tool[21871:21871] MySQL4 connection established 
>> 0x0x563777a14170
>> ...
>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>  SQL: SELECT 
>> c_uid, c_object, c_role FROM sogo_acl WHERE c_folder_id = 424 AND (c_object 
>> LIKE '/oldposix/%');
>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>query has 
>> results, entering fetch-mode.
>> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>>  SQL: UPDATE 
>> sogo_acl SET c_object = '/newposix/Calendar/5A00-59D22100-1-70F14480';
>> ... 
>>
>> followed by the errors mentioned above
>>
>> Obviously somewhere in this script the update-query is missing the
>> where-clause which is used in the query before.
>>
>> Is this a known bug and we're just on an old version? Or is this a new
>> bug and nobody noticed yet?
>>
>> kind regards
>>
>> Philipp
>>
>
-- 
___

Philipp Kühne | IT Administrator


indurad GmbH| the industrial radar company

Belvedereallee 5 | 52070 Aachen | Germany
phone: +49 241 538070-103 | front desk: +49 241 538070-0
email: philipp.kue...@indurad.com  |
web: www.indurad.com 


signature.asc
Description: OpenPGP digital signature

Re: [SOGo] SOGo On Centos 8

2020-05-26 Thread Christian Mack

Hello

Am 26.05.20 um 04:20 schrieb Eslam Basyouni (eslam.basyo...@yahoo.com):
> I hope so.. I will try to send them or report this as bug maybe they see it
> Big thanks to you 
> 
> Sent from Yahoo Mail on Android 
>  
>   On Tue, May 26, 2020 at 4:08 AM, Zhang Huangbin wrote:   
>> On May 26, 2020, at 7:15 AM, Eslam Basyouni (eslam.basyo...@yahoo.com) 
>>  wrote:
>>
>> ... but why i cant see it on https://sogo.nu/download.html  , is this still 
>> not official or not supported 
> 
> I guess SOGo team forgot to update the web page. :)
> 
> BTW, packages for Ubuntu 20.04 are available too:
> https://packages.inverse.ca/SOGo/nightly/4/ubuntu/
> 
> 
> Zhang Huangbin, founder of iRedMail project: https://www.iredmail.org/
> 

I think they will update the webpage, once the first stable release with
support for CentOS 8 and Ubuntu 20.04 is out.
Currently there are only nightlies.

I also assume, that this will be the next release 4.3.3.

But I just found out, that the FAQ section is really outdated.
Newest Debian mentioned is Debian 8 Jessie.
We are on Debian 10 Buster now and where on Debian 9 Stretch before.
So there is no harm in filing some bug reports ;-)

Kind regards,
Christian Mack

-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416

smime.p7s
Description: S/MIME Cryptographic Signature

Re: [SOGo] Global Sieve Settings

2020-05-26 Thread Christian Mack

Hello

I just saw a typo in that sogo-tool line.
There is an abundant space in '{"SOGoSieveFilters ":
You also have to provide sieve credentials to actually change that value.

So just use:
sogo-tool user-preferences set defaults user -p /etc/sogo/sieve.creds
SOGoSieveFilters '{"SOGoSieveFilters": [{"actions": [{"argument":
"Junk", "method": "fileinto"},{[ {"argument": "", "method":
"stop"}], "name": "Spam2Junk", "rules": [{"field": "header", "operator":
"contains", "custom_header": "X-Spam-Flag", "value": "YES"}], "match":
"all", "active": 1}]}'

The user will perhaps not see that change immediately.
Then she/he can logout and re-login into SOGo web interface in order to
fix that.
(Sometimes it is sufficient to switch out of the "Preferences", e.g.
into "Adress Book", and get back, but not always.)

If you want to let the user choose if she/he wants that filter, you can
set "active": 0
That will insert that filter in inactive state.

Hint:
I usually put that json into a file and use the -f option in sogo-tool.
That way you can easily correct typos and check for valid json.
sogo-tool user-preferences set defaults user -p /etc/sogo/sieve.creds
SOGoSieveFilters -f Spam2Junk_active.json


Kind regards,
Christian Mack

Am 25.05.20 um 23:29 schrieb David Faller (david.fal...@benelog.com):
> Thank you very much,
> " active = <*I1>; " is working for new users, perhaps you have also an idea 
> to handle existing users?
> An existing user do not see this filter on settings page, so the only Idea 
> would be to make pictures for a documentation that users can manually add 
> this filter.
> 
> When there's no other way it would be okay. Really thanks for your help here 
> on this mailing list,
> David
> 
> Am 25.05.20, 18:46 schrieb "Christian Mack
> (christian.m...@uni-konstanz.de)"  users@sogo.nu>:
> 
> Hello
> 
> My bad, exchange
> active = 1;
> with
> active = <*I1>;
> 
> 
> Kind regards,
> Christian Mack
> 
> Am 25.05.20 um 18:15 schrieb David Faller (david.fal...@benelog.com):
> > I had set under sogo.conf this:
> > SOGoSieveFilters = (
> >   {
> > actions = (
> > {
> >   argument = "Junk";
> >   method = "fileinto";
> > },
> > {
> >   argument = "";
> >   method = "stop";
> > }
> >   );
> >   name = "Spam2Junk";
> > rules=  (
> >   {
> > field = "header";
> > operator= "contains";
> > custom_header = "X-Spam-Flag";
> > value = "YES";
> >   }
> > );
> > match = "all";
> > active = 1;
> > }
> > );
> > 
> > 
> > But active =1; will not be set for new created users which login the 
> first time. Under filters the rule is visible but not active, is there a way 
> to enforce this that this setting will be enabled by default?
> > Also I tested it to set active = 0; but for existing users this setting 
> is not visible under the settings / filter tab on sogo.
> > 
> > So here I had 2 different parts for a handling first for new users and 
> the second for existing users.
> > Perhaps you have an idea? 
> > 
> > Best Regards
> > David Faller
> > 
> > 
> > 
> > Am 12.05.20, 11:47 schrieb "Christian Mack
> (christian.m...@uni-konstanz.de)"  users@sogo.nu>:
> > 
> > Hello
> > 
> > Yes, this will set the Spam filter rule for user.
> > 
> > Beware:
> > This will overwrite existing filters the user has defined himself 
> already.
> > I would check for already defined filters first and inject the Spam
> > filter rule before all existing ones.
> > 
> > 
> > Kind regards,
> > Christian Mack
> > 
> > Am 08.05.20 um 18:35 schrieb David Faller 
> (david.fal...@benelog.com):
> > > Thank you for the fast response,
> > > Little question to the end, to use this with sogo-tool would the 
> be the correct way?
> > > 
> > > ->  I would also stop processing SIEVE when encountering a Spam 
> ;-)
> > > Thanks for this tip __
> > > 
> > > sogo-tool user-preferences set defaults user SOGoSieveFilters 
> '{"SOGoSieveFilters ": [{"actions": [{"argument": "Junk", "method": 
> "fileinto"},{[ {"argument": "", "method": "stop"}], "name": 
> "Spam2Junk", "rules": [{"field": "header", "operator": "contains", 
> "custom_header": "X-Spam-Flag", "value": "YES"}], "match": "all", "active": 
> 1}]}'
> > > 
> > > This would be helpful to set existing user configuration, 
> > > Best Regards and wish a good weekend
> > > 
> > > 
> > > Am 08.05.20, 15:31 schrieb "Christian Mack
>

Re: [SOGo] sogo-tool rename-user erases all acl's

2020-05-26 Thread Christian Mack

Hi

When upgrading to Version 4. did you switch from 3 tables per user to 9
tables combined layout?

This error messeges seem to indicate, you did partly.
If you did, you should do it completely first.


Kind regards,
Christian Mack

Am 25.05.20 um 19:31 schrieb Philipp Kuehne (philipp.kue...@indurad.com):
> Hi,
> 
> we recently upgraded our sogo installation from version 2 to version
> 4.3.0 on a debian 10.
> 
> Since the migration worked fine I had a colleague who married and got a
> new surname.
> 
> So I changed all attributes in ldap and used the "sogo-tool rename-user"
> to give him access to his calendar and tasks.
> 
> First thing I noticed was that there were like hundreds of errors
> because the database structure changed and there were no more personal
> tables for each user.
> 
> Here is an example for one of these errors:
> 
> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>  SQL: UPDATE 
> sogosomeposix0014ba520e0_acl SET c_uid = 'newposix' WHERE c_uid = 'oldposix';
> 
> 2020-05-25 18:47:29.064 sogo-tool[21871:21871] 
>ERROR: Table 
> 'sogodb.sogosomeposix0014ba520e0_acl' doesn't exist 
> 
> Since these tables didn't exist anymore I wasn't worried and everything
> looked fine.
> 
> Today I got lots of complaints that people couldn't access other
> calendars so i checked the database and saw that all the entries in
> sogo_acl where wrong.
> 
> Here is a short cutout:
> 
> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someposix   
>  | ConfidentialDAndTViewer |
> | 351 | /newposix/Calendar/5A00-59D22100-1-70F14480 | someotherposix  
>  | PrivateDAndTViewer  |
> 
> All 5600 lines in this table looked exactly like this so I took the
> table from my backup and changed the according lines manually since
> everything else lokked ok.
> 
> So I cloned my Setup to see where things went wrong and found the line:
> 
> root@myserver:~# sogo-tool -v rename-user oldposix newposix
> 2020-05-25 18:47:28.915 sogo-tool[21871:21871] MySQL4 connection established 
> 0x0x563777a14170
> ...
> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>  SQL: SELECT 
> c_uid, c_object, c_role FROM sogo_acl WHERE c_folder_id = 424 AND (c_object 
> LIKE '/oldposix/%');
> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>query has 
> results, entering fetch-mode.
> 2020-05-25 18:47:28.987 sogo-tool[21871:21871] 
>  SQL: UPDATE 
> sogo_acl SET c_object = '/newposix/Calendar/5A00-59D22100-1-70F14480';
> ... 
> 
> followed by the errors mentioned above
> 
> Obviously somewhere in this script the update-query is missing the
> where-clause which is used in the query before.
> 
> Is this a known bug and we're just on an old version? Or is this a new
> bug and nobody noticed yet?
> 
> kind regards
> 
> Philipp
> 


-- 
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung IT-Dienste Forschung und Lehre
78457 Konstanz
+49 7531 88-4416



smime.p7s
Description: S/MIME Cryptographic Signature

[SOGo] BTS activities for Tuesday, May 26 2020

Re: [SOGo] SOGo On Centos 8

Re: [SOGo] sogo-tool rename-user erases all acl's

Re: [SOGo] Activate two Factor Authentication in SOGo

Re: [SOGo] Activate two Factor Authentication in SOGo

Re: [SOGo] sogo-tool rename-user erases all acl's

Re: [SOGo] sogo-tool rename-user erases all acl's

Re: [SOGo] SOGo On Centos 8

Re: [SOGo] Global Sieve Settings

Re: [SOGo] sogo-tool rename-user erases all acl's

10 matches

Site Navigation

Mail list logo

Footer information