[SOGo] BTS activities for Friday, April 02 2021

2021-04-02 Thread SOGo reporter 
Title: BTS activities for Friday, April 02 2021





  
BTS Activities

  Home page: https://sogo.nu/bugs
  Project: SOGo
  For the period covering: Friday, April 02 2021

  
  
idlast updatestatus (resolution)categorysummary
	
	
	  
	
5164
	2021-04-02 09:41:06
	updated (open)
	ActiveSync
	Duplicated items in activesync client calendar
	
	  
	
5292
	2021-04-02 06:08:11
	updated (open)
	Web Mail
	SAML auth seems to have stopped working between 5.0.1-1 and 5.1.0-1
	
	  
	
  
  


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

Re: [SOGo] change password won't update mailserver database

2021-04-02 Thread Odhiambo Washington 
PS: I am not so used to top-posting on MLs.

My question is - what is the problem with using the same DB? SOGo uses it'd
own tables, which you can drop at will.
After all, it's the same DB server!
You will not _easily_ achieve what you want with two separate databases.
Note *easily*. And I can assure you there isn't already a solution in the
public domain.
If you create the VIEW as I shared before, your problem is solved and you
are home and dry. In fact even this discussion would have ended :-)


On Fri, Apr 2, 2021 at 11:11 PM DEPRÉ Gaëtan - NGServers . com <
users@sogo.nu> wrote:

> >> If my understanding is correct, You are using multiple (probably two)
> user databases? Different for SOGo and different for IMAP server (probably
> Dovecot/Courrier)?
>
>
>
> You’re right. I didn’t want to use my mailserver database, because of
> populating of SOGo (it creates 3 tables per user especially terminating
> with ‘_acl’ & ‘_quick’ & I wanted to keep my mailserver database clean).
>
>
>
> The two databases used are ‘mailserver’ & ‘sogo’.
>
>
>
> I realize with your answers that we have no other choice than using the
> same DB. Creating custom script that would be executed while doing an
> action could help 😊
>
>
>
> Another idea would be to create a new directive, telling which is the
> mailserver users Db/password field and allowing SOGo to act in it while
> changing password, for example.
>
>
>
>
>
>
>
> *De :* users-requ...@sogo.nu  *De la part de*
> Patrik Chadima
> *Envoyé :* vendredi 2 avril 2021 16:51
> *À :* SOGo reporter (flachape...@inverse.ca) 
> *Objet :* Re: [SOGo] change password won't update mailserver database
>
>
>
> Hi,
>
>
>
> On Fri, Apr 2, 2021 at 4:37 AM DEPRÉ Gaëtan - NGServers . com <
> users@sogo.nu> wrote:
>
> Hi !
>
>
>
> When a user changes his password via SOGo, SOGo doesn’t update the
> mailserver database to make the both passwords equal ,and the user can
> login but no mailbox will be displayed because of incorrect login on the
> mail server.
>
>
>
> Is there any way to implement a custom script while changing password on
> SOGo, allowing to update another database ?
>
>
>
> Regards,
>
>
>
> Gaetan
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>
>
>
> If my understanding is correct, You are using multiple (probably two) user
> databases? Different for SOGo and different for IMAP server (probably
> Dovecot/Courrier)?
>
> If I'm right I can say that it is a good practice to use only one user
> identity source for both systems.
>
> But we don't have enough information about Your background so there is no
> correct answer to Your question.
>
>
>
> Best regards
>
> Patrik Chadima
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] change password won't update mailserver database

2021-04-02 Thread gde...@ngservers.com 
>> If my understanding is correct, You are using multiple (probably two) user 
>> databases? Different for SOGo and different for IMAP server (probably 
>> Dovecot/Courrier)?

 

You’re right. I didn’t want to use my mailserver database, because of 
populating of SOGo (it creates 3 tables per user especially terminating with 
‘_acl’ & ‘_quick’ & I wanted to keep my mailserver database clean).

 

The two databases used are ‘mailserver’ & ‘sogo’.

 

I realize with your answers that we have no other choice than using the same 
DB. Creating custom script that would be executed while doing an action could 
help 😊 

 

Another idea would be to create a new directive, telling which is the 
mailserver users Db/password field and allowing SOGo to act in it while 
changing password, for example.

 

 

 

De : users-requ...@sogo.nu  De la part de Patrik Chadima
Envoyé : vendredi 2 avril 2021 16:51
À : SOGo reporter (flachape...@inverse.ca) 
Objet : Re: [SOGo] change password won't update mailserver database

 

Hi,

 

On Fri, Apr 2, 2021 at 4:37 AM DEPRÉ Gaëtan - NGServers . com mailto:users@sogo.nu> > wrote:

Hi !

 

When a user changes his password via SOGo, SOGo doesn’t update the mailserver 
database to make the both passwords equal ,and the user can login but no 
mailbox will be displayed because of incorrect login on the mail server.

 

Is there any way to implement a custom script while changing password on SOGo, 
allowing to update another database ?

 

Regards,

 

Gaetan

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

 

If my understanding is correct, You are using multiple (probably two) user 
databases? Different for SOGo and different for IMAP server (probably 
Dovecot/Courrier)?

If I'm right I can say that it is a good practice to use only one user identity 
source for both systems.

But we don't have enough information about Your background so there is no 
correct answer to Your question.

 

Best regards

Patrik Chadima

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

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

Re: [SOGo] change password won't update mailserver database

2021-04-02 Thread Patrik Chadima 
Hi,

On Fri, Apr 2, 2021 at 4:37 AM DEPRÉ Gaëtan - NGServers . com 
wrote:

> Hi !
>
>
>
> When a user changes his password via SOGo, SOGo doesn’t update the
> mailserver database to make the both passwords equal ,and the user can
> login but no mailbox will be displayed because of incorrect login on the
> mail server.
>
>
>
> Is there any way to implement a custom script while changing password on
> SOGo, allowing to update another database ?
>
>
>
> Regards,
>
>
>
> Gaetan
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>

If my understanding is correct, You are using multiple (probably two) user
databases? Different for SOGo and different for IMAP server (probably
Dovecot/Courrier)?
If I'm right I can say that it is a good practice to use only one user
identity source for both systems.
But we don't have enough information about Your background so there is no
correct answer to Your question.

Best regards
Patrik Chadima
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

Re: [SOGo] change password won't update mailserver database

2021-04-02 Thread Odhiambo Washington 
Oops! I just remembered.
SOGo needs to use the same database as your POP3/IMAP4 engine.
I have been using Dovecot for that purpose.

If you are using MySQL you need to create a VIEW for SOGo to use.

Here is what I did in my DB (and it is documented somewhere online):

CREATE VIEW sogo_auth_view AS SELECT user_id AS sogo_id, username AS c_uid,
username AS c_name, crypt AS c_password, realname AS c_cn, username AS
mail, realname AS displayName FROM users WHERE enabled='1';
(of course customize this according to your DB schema)

Then in your authenticators set:

viewURL ="mysql://DBUSER:PASSWORD@127.0.0.1:3306/DBNAME/*sogo_auth_view*";

HTH






On Fri, Apr 2, 2021 at 5:31 PM DEPRÉ Gaëtan - NGServers . com 
wrote:

> Hi !
>
>
>
> My algorithms are well configured. I can login if  I copy/paste hashed
> password from the mailserver database to SOGo’s one.
>
>
>
> Sogo updates his database while changing password, but not mailserver’s
> (dovecot/postfix) one. I would like to know where to implement such an
> update script or add mysql UPDATE in the changing password action.
>
>
>
> Furthermore, if a user updates his password in SOGo, he can login again to
> SOGo, but the mailserver will answer ‘bad login’ because of his password
> not updated.
>
>
>
> *De :* users-requ...@sogo.nu  *De la part de*
> Odhiambo Washington
> *Envoyé :* vendredi 2 avril 2021 12:25
> *À :* users@sogo.nu
> *Objet :* Re: [SOGo] change password won't update mailserver database
>
>
>
>
>
>
>
> On Fri, Apr 2, 2021 at 5:37 AM DEPRÉ Gaëtan - NGServers . com <
> users@sogo.nu> wrote:
>
> Hi !
>
>
>
> When a user changes his password via SOGo, SOGo doesn’t update the
> mailserver database to make the both passwords equal ,and the user can
> login but no mailbox will be displayed because of incorrect login on the
> mail server.
>
>
>
> Is there any way to implement a custom script while changing password on
> SOGo, allowing to update another database ?
>
>
>
> I have SOGo update a MySQL database when users change passwords.
>
> I believe you should look at whether your setting
> for userPasswordAlgorithm matches what is expected by your POP3/IMAP4
> engine.
>
>
>
>
> --
>
> Best regards,
> Odhiambo WASHINGTON,
> Nairobi,KE
> +254 7 3200 0004/+254 7 2274 3223
> "Oh, the cruft.", grep ^[^#] :-)
>
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
> --
> users@sogo.nu
> https://inverse.ca/sogo/lists
>


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists

RE: [SOGo] change password won't update mailserver database

2021-04-02 Thread gde...@ngservers.com 
Hi !

 

My algorithms are well configured. I can login if  I copy/paste hashed password 
from the mailserver database to SOGo’s one.

 

Sogo updates his database while changing password, but not mailserver’s 
(dovecot/postfix) one. I would like to know where to implement such an update 
script or add mysql UPDATE in the changing password action.

 

Furthermore, if a user updates his password in SOGo, he can login again to 
SOGo, but the mailserver will answer ‘bad login’ because of his password not 
updated.

 

De : users-requ...@sogo.nu  De la part de Odhiambo 
Washington
Envoyé : vendredi 2 avril 2021 12:25
À : users@sogo.nu
Objet : Re: [SOGo] change password won't update mailserver database

 

 

 

On Fri, Apr 2, 2021 at 5:37 AM DEPRÉ Gaëtan - NGServers . com mailto:users@sogo.nu> > wrote:

Hi !

 

When a user changes his password via SOGo, SOGo doesn’t update the mailserver 
database to make the both passwords equal ,and the user can login but no 
mailbox will be displayed because of incorrect login on the mail server.

 

Is there any way to implement a custom script while changing password on SOGo, 
allowing to update another database ?

 

I have SOGo update a MySQL database when users change passwords.

I believe you should look at whether your setting for userPasswordAlgorithm 
matches what is expected by your POP3/IMAP4 engine. 




 

-- 

Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)

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

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

Re: [SOGo] change password won't update mailserver database

2021-04-02 Thread Odhiambo Washington 
On Fri, Apr 2, 2021 at 5:37 AM DEPRÉ Gaëtan - NGServers . com 
wrote:

> Hi !
>
>
>
> When a user changes his password via SOGo, SOGo doesn’t update the
> mailserver database to make the both passwords equal ,and the user can
> login but no mailbox will be displayed because of incorrect login on the
> mail server.
>
>
>
> Is there any way to implement a custom script while changing password on
> SOGo, allowing to update another database ?
>

I have SOGo update a MySQL database when users change passwords.
I believe you should look at whether your setting for userPasswordAlgorithm
matches what is expected by your POP3/IMAP4 engine.


-- 
Best regards,
Odhiambo WASHINGTON,
Nairobi,KE
+254 7 3200 0004/+254 7 2274 3223
"Oh, the cruft.", grep ^[^#] :-)
-- 
users@sogo.nu
https://inverse.ca/sogo/lists