Context:
We forgot the password to the main account of the system. SMTP was not set, so we tried taking a shortcut. We found someone’s advice online to delete both role and user tables, then update the Settings table on “isInstanceOwnerSetUp” to false. Worst shortcut ever. Mistakes were made and we should have set SMTP instead.
What we tried:
- Manually, we managed to recreate most settings that were erased, such as the tables themselves and some content, but we cannot recreate the original user’s UUID (obviously). The Role table had default roles and the User table had only one user.
- Forced a relation between the projectId and the only user in the system through the “project_relations” table.
- Copied the tables from a different n8n project, hence the different UUID
- Set up SMTP after messing up to change the password. This did not work as we still cannot log in. Therefore we know that the issue is no longer related to the password.
Problem:
We are currently stuck without access to our workflows. When trying to log in with the new fabricated credentials we get the error below. What can we do to recover our workflows?
Errors:
In the OperaGX browser console:
“Could not find a personal project for this user”
n8n setup:
- n8n version: latest
- Database: PostgreSQL
- n8n EXECUTIONS_PROCESS setting (default: own, main): unknown
- Running n8n via: Portainer Docker
- Operating system: Windows 11