How to set bulk accounts to change password in next login?

grochap 2024-09-16 11:28:27 UTC #1

Hello,

I am trygin to update accounts trough DB in order to update ~1600 accounts to change their password in the next login. Not found a clearly DB set for this, anyone can point this parameter in the DB, so we can handle it?

As information, we tested the interface in admin area, however there we can select a few users, cannot select groups neither all users, or massive users.

Any tip will be great.

StefanU 2024-09-16 13:07:56 UTC #2

Hi grochap.

You can select a group on the left, select all users on the right (from-to) and then call up the function via the context menu. Then you have the users in the selection.

Ctrl-A (select all) does not currently work at this point. No users are transferred.
I have noted this as a bug.

Doing this directly for groups is not implemented and I wouldn’t like it either.

Stefan

RalfBecker 2024-09-16 18:16:13 UTC #3

Your can do it in the DB for all users:

UPDATE egw_accounts SET account_lastpwd_changed=0 WHERE account_type='u';

Ralf

grochap 2024-09-17 13:01:38 UTC #4

Hello Ralf,

amazing, thank you a lot.

RalfBecker 2024-09-17 13:22:42 UTC #5

The original problem is now also fixed:

Ralf

StefanU 2024-09-17 17:44:26 UTC #6

Installed:

https://help.egroupware.org/t/installing-a-patch-from-github-19-1/74033

tested and found to be good.

Stefan