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

Reply via email to