On Sun, Jul 2, 2023 at 7:38 PM Vilius Baušys <vilius.bau...@gmail.com> wrote:
> Hi Sogo users, > > I'm trying to configure Iredmail plugin sql_force_change_password > <https://docs.iredmail.org/force.user.to.change.password.html#how-to-enable-iredapd-plugin> > to force users to change their passwords. The plugin itself works fine, but > it seems that Sogo does not record password change timestamp: > > Jul 02 19:25:20 sogod [3128203]: |SOGo| starting method 'POST' on uri > '/SOGo/so/changePassword' > Jul 02 19:25:20 sogod [3128203]: |SOGo| request took 0.495773 seconds to > execute > Jul 02 19:25:20 sogod [3128203]: 78.57.31.125 "POST > /SOGo/so/changePassword HTTP/1.0" 204 0/73 0.505 - - 532K - 14 > > I also do not see any related column in the users table: > MariaDB [sogo]> desc users; > +------------+--------------+------+-----+---------+-------+ > | Field | Type | Null | Key | Default | Extra | > +------------+--------------+------+-----+---------+-------+ > | c_uid | varchar(255) | NO | | | | > | c_name | varchar(255) | NO | | | | > | c_password | varchar(255) | NO | | | | > | c_cn | varchar(255) | NO | | | | > | mail | varchar(255) | NO | | | | > | domain | varchar(255) | NO | | | | > +------------+--------------+------+-----+---------+-------+ > 6 rows in set (0.001 sec) > > Maybe I missed some of the configurable option to capture the password > change timestamp? > > Sogo v 5.8.2 (@sogo-build.alinto.int 202305201843) > I found an easy workaround by creating a trigger that updates the corresponding Iredmail column. Not ideal, but it works. -- Vilius