Ask questions about installing and configuring ProcessMaker 3

Moderator: ArturoRobles

By benoitp

This morning on my test platform, i can't login with the "admin" account : WARNING: User's account has expired

I tried this in mysql :
Code: Select all
MariaDB [wf_workflow]> update USERS set USR_DUE_DATE='2050-01-01';
But without success.

Any tips ?
Last edited by benoitp on Thu Jan 02, 2020 6:13 am, edited 1 time in total.
User avatar
By programerboy
You can use these queries :
Code: Select all
UPDATE `wf_workflow`.`rbac_users` SET `USR_DUE_DATE` = '2030-01-01' WHERE `USR_UID` = '00000000000000000000000000000001';
UPDATE `wf_workflow`.`users` SET `USR_DUE_DATE` = '2030-01-01' WHERE `USR_UID` = '00000000000000000000000000000001';
Last edited by programerboy on Wed Apr 07, 2021 1:09 am, edited 1 time in total.
By benoitp
Hello Programerboy,

Thank you for the tip !

I found another way to unlock the account, i changed the date of the system, login into PM, change the expiration date of the "admin" account, and reboot the system.
By rohitambre
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
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','','','2020-01-01','2007-08-03 12:24:36','2008-02-13 07:24:07',1,'MYSQL','00000000000000000000000000000000','',''),
Code: Select all
('00000000000000000000000000000001','admin','21232f297a57a5a743894a0e4a801fc3','Administrator','','','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',' ',  '','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','',''),
Code: Select all
('00000000000000000000000000000001','admin','21232f297a57a5a743894a0e4a801fc3','Administrator',' ',  '','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','',''),
By aricjoshua
I install numerous instances for development purposes every day, thus changing the USR DUE DATE value in the database for each new instance is quite inconvenient.

Hello Thanks for Sharing this Information https://[…]

ProcessMaker 3.6 open source

I can see the version 3.7 is available on the link[…]

Community vs Enterprise

Dear PM Forum Admins, Additional question on Comm[…]