Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderator: amosbatto

User avatar
By amosbatto
#815853
To change the expiration date for all the users in PM 3 in the "workflow" workspace, you can do this from the command line of your PM server:
mysql -u root -p
use wf_workflow;
UPDATE USERS SET USR_DUE_DATE='2020-12-31';
UPDATE RBAC_USERS SET USR_DUE_DATE='2020-12-31';


If you only want to change the expiration date for certain users:
UPDATE USERS SET USR_DUE_DATE='2020-12-31' WHERE USR_USERNAME IN ('mary', 'joe', 'sally');
UPDATE RBAC_USERS SET USR_DUE_DATE='2020-12-31' WHERE USR_USERNAME IN ('mary', 'joe', 'sally');



PS: you can change the default expiration date for new users by going to Admin > System and changing the Default User Expiry Date (Years) field.
By rohitambre
#827475
Hi.
I am also facing the same issue.
Can please suggest any solution that can be done through code modification.
For development purpose I install many instances everyday, So it is very annoying to change the USR_DUE_DATE value in DB for every new instance.
By rohitambre
#827546
I found a solution for this issue through code.

Go to insert.sql file In /rbac/engine/data/mysql/ and change the insert value in RBAC_USERS table.
i.e from
Code: Select all
('00000000000000000000000000000001','admin','21232f297a57a5a743894a0e4a801fc3','Administrator','','[email protected]','2020-01-01','2007-08-03 12:24:36','2008-02-13 07:24:07',1,'MYSQL','00000000000000000000000000000000','',''),
to
Code: Select all
('00000000000000000000000000000001','admin','21232f297a57a5a743894a0e4a801fc3','Administrator','','[email protected]','2030-01-01','2007-08-03 12:24:36','2008-02-13 07:24:07',1,'MYSQL','00000000000000000000000000000000','',''),

Go to insert.sql file In /workflow/engine/data/mysql/ and change the insert value in USERS table.
i.e from
Code: Select all
('00000000000000000000000000000001','admin','21232f297a57a5a743894a0e4a801fc3','Administrator',' ',  '[email protected]','2020-01-01','1999-11-30 00:00:00','2008-05-23 18:36:19','ACTIVE',  'US','FL','MMK','','',  '1-305-402-0282','1-305-675-1400','','','Administrator',  '','1999-02-25','PROCESSMAKER_ADMIN','',''),
to
Code: Select all
('00000000000000000000000000000001','admin','21232f297a57a5a743894a0e4a801fc3','Administrator',' ',  '[email protected]','2030-01-01','1999-11-30 00:00:00','2008-05-23 18:36:19','ACTIVE',  'US','FL','MMK','','',  '1-305-402-0282','1-305-675-1400','','','Administrator',  '','1999-02-25','PROCESSMAKER_ADMIN','',''),

Hello, If you are using a version of ProcessMak[…]

I really appreciate the work you did. I got to kno[…]

cam on

hello

Subprocess iteration problem

cam on