[heemalkumar]

Morning Team
I have a whole lot of users expiring end of this month.
Would anyone have the script so I can extend the users by a couple of years.

[amosbatto]

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.

[rohitambre]

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.

[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','','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','',''),

[jiuer7845]

https://yeezy-350.fr/ Yeezy 350
https://www.nikeairvapormax.us/ Nike Air VaporMaxm
https://www.nike-270.us/ Nike 270
https://www.nikeairforce-1.us.com/ Nike Air Force 1
https://www.nikevapormax.org/ Nike Vapormax
https://www.nikevapormaxflyknit.com/ Nike Vapormax Flyknit
https://www.airjordan1-mid.com/ Air Jordan 1 Mid
https://www.yeezy-shoes.co/ Yeezy Shoes
https://www.nikestoreoutlet.us.com/ Nike Outlet
https://www.yeezy-350.org/ Yeezy 350
https://www.yeezy-shoess.us/ Yeezy Shoes
https://www.yeezys.co/ Yeezys
https://www.air-jordan1.com/ Air Jordan 1
https://www.nike-jordans.com/ Nike Jordans
https://www.jordan-1s.com/ Jordan 1s
https://www.nikejordan1.com/ Nike Jordan 1
https://www.yeezycinder.us/ Yeezy Cinder
https://www.yeezys.org.uk/ Yeezy
https://www.yeezyadidas.de/ Adidas yeezy
https://www.adidasyeezy.co/ Adidas yeezy
https://www.yeezyshoess.com/ Yeezy Shoes
https://www.adidasyeezyofficialwebsite.us/ Adidas Yeezy Official Website
https://www.discountuggsoutlet.us/ Discount UGG Outlet
https://www.uggoutlet.store/ UGG Outlet
https://www.yeezy350.me.uk/ Yeezy 350
https://www.adidasyeezy.me.uk/ Adidas Yeezy
https://www.ugguk.org.uk/ UGG UK
https://www.yeezy350.de/ Yeezy 350
https://www.uggsoutlet.us/ UGGS Outlet
https://www.timberlands.me.uk/ Timberland
https://www.timberlandshoes.org.uk/ Timberland Shoes
https://www.airmax97.us.com/ Air Max 97
https://www.max270.us.com/ Nike Air Max 270
https://www.supplyyeezy.us.com/ Yeezy Supply
https://www.kobebryant-jersey.us/ Kobe Bryant Jersey
https://www.kobebryantjerseysforsale.us/ Kobe Bryant Jerseys For Sale
https://www.kobebryantjersey24.us/ Kobe Bryant Jersey 24
https://www.kobebryantwebsiteofficial.us/ Kobe Bryant Website Official
https://www.yeezy-shoe.us.com/ Yeezy
https://www.yeezymafia.us.com/ Yeezy
https://www.nikes.us.com/ Nike Shoes
https://www.nikeshoes.us.org/ Nike Shoes
https://www.nfl-jerseys.us.org/ NFL Jerseys
https://www.yeezyboost350.us.com/ Yeezy Boost 350
https://www.yeezy.com.co/ Yeezy Shoes
https://www.nikeoutletstoreonlineshopping.us/ Nike Outlet
https://www.yeezy380.us/ Yeezy 380
https://www.yeezy380.us.com/ Yeezy 380
https://www.nikefactory.us.com/ Nike Outlet
https://www.humanraces.us.com/ Human Races
https://www.humanracesshoes.us/ Human Race Shoes
https://www.basketball-jerseys.us.com/ Basketball Jerseys
https://www.jerseysbasketball.us/ Basketball Jerseys
https://www.jerseys-nba.us/ Cheap NBA Jerseys
https://www.nikes-shoes.us.com/ Nike Outlet
https://www.yeezy-shoe.us.com/ Yeezy Shoes
https://www.yeezymafia.us.com/ Yeezy Mafia
https://www.yeezy350v2.us/ Yeezy 350 V2
https://www.yeezysofficialsite.us/ Yeezys Official Site
https://www.yeezyslides.us/ Yeezy sliders
https://www.jerseys-nba.us.com/ NBA Jerseys
https://www.jerseysnba.us.com/ NBA Jerseys
https://www.nikeairvapormaxflyknit3.us/ Nike Air VaporMax Flyknit 3
https://www.nikeairmax270react.us/ Nike Air Max 270 React
https://www.nikeoutlets.co/ Nike Outlet
https://www.niketrainers.co/ Nike Trainers
https://www.nikeoutletstore.co/ Nike Outlet Store
https://www.jordan-1.org/ Jordan 1
https://www.jordan11.org/ Jordan 11
https://www.nike-jordan.us/ Nike Jordan
https://www.uggsclearancesaleoutlet.us/ UGGS Clearance Sale Outlet
https://www.uggsofficialsite.us/ UGGS Official Site
https://www.nbastores.us/ NBA Store
https://www.nbaoutletstore.us/ NBA Store
https://www.yeezystore.us.com/ Yeezy
https://www.yeezyssneakers.us.com/ Yeezy Sneaker
https://www.adidasyeezyofficialwebsite.com/ Adidas Yeezy Official Website
https://www.adidasyeezyonlinestore.us/ Adidas Yeezy Online Store
https://www.airmaxclearancesale.us/ Air Max Clearance Sale
https://www.nflshopofficialonlinestore.com/ NFL Shop Official Online Store
https://www.nikeuk.uk.com/ Nike UK
https://www.adidasyeezy.uk.com/ Adidas Yeezy
https://www.yeezy.uk.com/ Yeezy
https://www.yeezy350.uk.com/ Yeezy 350
ウレ