search

turnkeylinux / tracker

TurnKey Linux Tracker
https://www.turnkeylinux.org
70 stars 16 forks source link

Processmaker user login expires - causing Web login to fail #1743

Open JedMeister opened 2 years ago

JedMeister commented 2 years ago

I think that the fix for this is to reset the user expiry date in the inithook - so it is always valid.

It's been brought to my attention that the 'admin' user password (set via inithooks - either pre-set within the Hub or set interactively at firstboot) for our Processmaker appliance does not allow login to the Processmaker web UI.

FWIW, it's because the user has "expired".

To work around the issue, please log in via SSH (either using an SSH client such as OpenSSH or PuTTY; or Webshell) and run the following commands (if not running as root; prefix with sudo):

mysql -e "UPDATE wf_workflow.USERS SET USR_DUE_DATE='2040-01-01' where USR_USERNAME='admin';"
mysql -e "UPDATE wf_workflow.RBAC_USERS set USR_DUE_DATE='2040-01-01' where USR_USERNAME='admin';"

You should now be able to login with the password that you set. If you would like to reset the password, please just re-run the inithook:

/usr/lib/inithooks/bin/processmaker.py
JedMeister commented 1 year ago

I've just updated the subject and added a line to the top of the initial report with a suggested fix.

JedMeister commented 2 months ago

Processmaker has not been updated for v18.0 as there were some difficulties. We'll try again as v18.1