[SOGo] BTS activities for Wednesday, April 22 2020
Title: BTS activities for Wednesday, April 22 2020 BTS Activities Home page: https://sogo.nu/bugs Project: SOGo For the period covering: Wednesday, April 22 2020 idlast updatestatus (resolution)categorysummary 4895 2020-04-22 04:53:18 updated (open) Backend General Argon2id Support 5009 2020-04-22 05:32:57 updated (open) Web Mail Threads for mail do not colapse/expand after a while + colorization on Chrome/Chromium (linux) -- users@sogo.nuhttps://inverse.ca/sogo/lists
Re: [SOGo] Change password with SQL authentication
Hi Lars, thanks for the information. On 22.04.20 08:52, Lars Liedtke (lied...@punkt.de) wrote: * I created a view on the respective table and login works fine. * I set SOGoPasswordChangeEnabled = YES; . OK * I gave the database user UPDATE rights on the view. I don't think that this is necessary. At least I didn't have to do it in my former setups and it works. ;-) Interesting Which privileges did you assign to the sogo db user on the sogo database? In my setups I usually had one database with the accounts for Postfix/Dovecot and a separate database 'sogo' only for SOGo. The sogo db user had all privileges on the 'sogo' database, in which I simply created the necessary view 'sogo_view' to use the respective columns of the account table in the postfix database. What I additionally should add is, that I am using two sources of authentication: AD/LDAP for regular users of our company and SQL for additional users and aliases (Postfixadmin, Postfix/Dovecot). Do the regular (AD/LDAP) users see the 'Password' tab and can they use it? Or isn't it possible for them too? I tested with the two-source version in a vagrant box, I could of course let ansible build a box without the AD/LDAP source. I would test it with only SQL authentication - just to be sure. For such a test it should be sufficient if you disable the LDAP SOGoUserSources = (...) in sogo.conf Regards, Markus -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Change password with SQL authentication
Hello Markus, thx for your answer. > Hi Lars, >> is it possible that users can change their password when they are >> authenticated via SQL (MariaDB)? > > in general: yes > >> * I created a view on the respective table and login works fine. >> * I set SOGoPasswordChangeEnabled = YES; . > OK >> * I gave the database user UPDATE rights on the view. > I don't think that this is necessary. At least I didn't have to do it > in my former setups and it works. ;-) Interesting >> But I cannot see the possibility to change a user's password when >> logging in as that user, so I was not able to test further. Am I >> missing something? > If you're going to Preferences -> General there's no tab 'PASSWORD' or > did I misunderstand? No you did not misunderstand, there is only the one "standard" tab > Are there any errors in sogo.log? Which version of SOGo are you using? > 4.2.0 > Regards, > Markus What I additionally should add is, that I am using two sources of authentication: AD/LDAP for regular users of our company and SQL for additional users and aliases (Postfixadmin, Postfix/Dovecot). For providing mailservers for our customers there is only the SQL source. I tested with the two-source version in a vagrant box, I could of course let ansible build a box without the AD/LDAP source. Cheers Lars -- --- punkt.de GmbH Lars Liedtke .infrastructure Kaiserallee 13a 76133 Karlsruhe Tel. +49 721 9109 500 https://infrastructure.punkt.de i...@punkt.de AG Mannheim 108285 Geschäftsführer: Jürgen Egeling, Daniel Lienert, Fabian Stein -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Change password with SQL authentication
> Hello Markus, > > thx for your answer. > >> Hi Lars, >>> is it possible that users can change their password when they are >>> authenticated via SQL (MariaDB)? >> in general: yes >> >>> * I created a view on the respective table and login works fine. >>> * I set SOGoPasswordChangeEnabled = YES; . >> OK >>> * I gave the database user UPDATE rights on the view. >> I don't think that this is necessary. At least I didn't have to do it >> in my former setups and it works. ;-) > Interesting >>> But I cannot see the possibility to change a user's password when >>> logging in as that user, so I was not able to test further. Am I >>> missing something? >> If you're going to Preferences -> General there's no tab 'PASSWORD' or >> did I misunderstand? > No you did not misunderstand, there is only the one "standard" tab >> Are there any errors in sogo.log? Which version of SOGo are you using? >> Nothing I could see > 4.2.0 >> Regards, >> Markus > What I additionally should add is, that I am using two sources of > authentication: AD/LDAP for regular users of our company and SQL for > additional users and aliases (Postfixadmin, Postfix/Dovecot). For > providing mailservers for our customers there is only the SQL source. I > tested with the two-source version in a vagrant box, I could of course > let ansible build a box without the AD/LDAP source. > > Cheers > > Lars > -- --- punkt.de GmbH Lars Liedtke .infrastructure Kaiserallee 13a 76133 Karlsruhe Tel. +49 721 9109 500 https://infrastructure.punkt.de i...@punkt.de AG Mannheim 108285 Geschäftsführer: Jürgen Egeling, Daniel Lienert, Fabian Stein -- users@sogo.nu https://inverse.ca/sogo/lists