Others

How to access and query PostgresSQL(jiffy) Database?

• Jiffy DB details are stored in the 'app.properties' file. Execute the following command to read the contents of the file.
head -15 $JIFFY_HOME/app.properties
  
  
• Execute the following commands to connect the jiffy DB using above DB details.
psql -h localhost -p 1234 -U username -d schema_name
  Where:
  • -h: Host name
  • -p: DB port
  • -U: username
  • -d: Schema name.
• Press the enter key.
• Enter the DB password to access the DB.
• Use '\\q' to exit the DB.
  Note: Don't run alter/update statements. It may affect the Jiffy application.

How to unlock a jiffy account?

Cause: This error occurs if wrong password is entered multiple times (default retry limit=3) while logging in.

Solution:

• Click the Forgot Password button to reset password and login with new password.
• If the user knows the existing password and wants to unlock the account without resetting it, do the following:
  • Log in to the application server as a jiffyapp-usr (application user).
  • Run the following commands:
    • Change the directory to jiffy folder:
      cd $JIFFY_HOME/deploy/jiffy/src
    • Activate the python environment:
      source $JIFFY_HOME/.envs/jiffyEnv/bin/activate
    • Unlock the user account:
      python manage.py axes_reset_user <user_name>
      Example: python manage.py axes_reset_user Jiffy_user
• Login with the existing password.