Force changing admin account

[Xevalous]

Basicly i kinda forgot my admin account in local pb when going to log in & i dont wanna my db gone, i know its dumb, i have tried to reset password from login page, but there is none email sended

soo, is there a other method to reset admin pass?

[ganigeorgiev]

In the future there will be a console command(s) to interact with the Admin APIs, but for now if you want to reset your password you can directly update the _admins table entry in your database:

sqlite3 pb_data/data.db 'UPDATE _admins SET passwordHash="$2a$10$xWbkSks7OiTmrri2DU6QSe6OAekcdqkOrkcI1wi4uiv9SU2HTlHoq" where email="test@example.com"'

The above will set a 123456 password for the admin with email test@example.com (you can remove the where ... part if you don't remember your email).

Update: I've inversed the quotes in the above command to prevent the command line to interpret the password hash as env variable.

[ganigeorgiev]

@grabbels The database currently contains no critical data whatesoever so I could just as well reinstall pocketbase alltogether, but I just want to make sure this is not some kind of unexpected behavior that might be rooted in a bug of some sort.

As mentioned, I'm not able to reproduce it. There is something strange happening in your environment, but there are not enough details to help you debug it.

[grabbels]

I understand, is there any information I could dig up for you that might help?

# delete all admins and then go to http://127.0.0.1:8090/_/?installer sqlite3 pb_data/data.db 'delete from _admins'
http://127.0.0.1:8090/_/?installer redirects to http://127.0.0.1:8090/_/#/login. I'm kind of at a loss here, everything seems to be properly working except for these weird things happening. I haven't had any other problems with pocketbase in the few months I've been testing it now so I'm quite confused. I'll go for a full reinstall I suppose as I of course understand there's not much you can do to help me in this situation.

[ganigeorgiev]

@grabbels If the installer redirects to login then this means that the above command didn't delete your admins, aka. you are not making changes to the database that the PocketBase executable use.

Are you sure that your PocketBase executable uses the pb_data directory you are modifying?

You can specify an explicit pb_data directory using the --dir flag:

./pocketbase serve --dir="/path/to/pb_data"

[grabbels]

Alright, that did it. Somehow it defaulted to using pb_data located in /root, which is very confusing to me. Not sure how that happened.
Thank you so much for your help and I'm sorry to take up your time like this!

[ganigeorgiev]

@grabbels

Somehow it defaulted to using pb_data located in /root

This is because by default the executable uses (creates) the pb_data directory in the same parent directory of the executable, aka. most likely your executable is located inside /root.