Updating any encrypted database password of database.yml files can be done following the below steps.
Login to Support repo and check out 'db-password-encrypt' task from below path.
Copy DBPasswordEncryptTask.class.php to:
- <web root>/symfony/plugins/orangehrmCorePlugin/lib/task/
Run the below symfony command
- sudo php symfony cc
Run the following symfony task with the new password. --new-username option is optional, use it when you need to change the username as well
- sudo php symfony orangehrm:DBPasswordEncrypt --new-password="[password here]" --new-username="root"
Remove the DBPasswordEncryptTask.class.php from <web root>/symfony/plugins/orangehrmCorePlugin/lib/task/ and run the following Symfony commands:
- sudo php symfony cc
- sudo php symfony d:build-model
- sudo php symfony o:publish-assets
Open the database.yml file and check if the password and/or username is updated.