Reset Password

If you forgot your password on a self-hosted instance, you can reset it using the following steps:

Locate PostgreSQL Docker Container:
- Use a command like docker ps to find the PostgreSQL container.
Access the Container:
- Use SSH to access the PostgreSQL Docker container.
docker exec -it POSTGRES_CONTAINER_ID /bin/bash
Open the PostgreSQL Console:
- Inside the container, open the PostgreSQL console with the psql command.
psql -U postgres
Connect to the ActivePieces Database:
- Connect to the ActivePieces database.
\c activepieces
Create a Secure Password:
- Use a tool like bcrypt-generator.com to generate a new secure password, number of rounds is 10.
Update Your Password:
- Run the following SQL query within the PostgreSQL console, replacing HASH_PASSWORD with your new password and YOUR_EMAIL_ADDRESS with your email.
UPDATE public.user_identity SET password='HASH_PASSWORD' WHERE email='YOUR_EMAIL_ADDRESS';

⌘I