Ask questions about installing and configuring ProcessMaker 3

Moderator: ArturoRobles

By benoitp
#827289
Hello

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
#827290
Hi,
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';
https://pmlearning.info
Thanks
Last edited by programerboy on Wed Apr 07, 2021 1:09 am, edited 1 time in total.
By benoitp
#827291
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
#827474
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
#827547
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','','admin@processmaker.com','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','','admin@processmaker.com','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',' ',  'admin@processmaker.com','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',' ',  'admin@processmaker.com','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
#829512
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.
https://cookieclicker2.io

Where can I download ProcessMaker 3.6.5 Open Sou[…]

Hello, I have the same problem. :( :(

You there, this is really good post here. Thanks f[…]

Is it possible to view HTML codes of a DynaForm an[…]