Need help resetting InvoicePlane password as a non-technical user

Support
1

Hello, I am a new user of InvoicePlane and I don’t have a lot of technical expertise, but I was able to successfully install it on my server after a few weeks of figuring it out.

During the initial InvoicePlane setup, I was able to configure the login email and password, and I was able to log in without any issues. However, the other day when I tried to log in again, it failed. I suspect I may have typed the wrong password.

The most concerning part is that I’ve now forgotten my password. InvoicePlane does have a “I forgot my password” option that is supposed to send a password reset email, but this isn’t working for me because I haven’t set up the email settings in InvoicePlane yet.

I’m not very familiar with programs like this or the underlying technical aspects. Is there a file I can delete in the server folder to reset my password? Or will I have to completely reinstall InvoicePlane from the beginning? If I do need to reinstall, should I change any of the settings in the MySQL database that I had set up previously?

I know my questions may seem a bit basic, but any guidance or hints you can provide would be greatly appreciated. Thank you very much for your help!

1 Like
2

Hi there, Welcome

You don’t need to reinstall. There are a few steps and i would use something like phpMyAdmin to help you with that.
The steps are:

  • Open phpMyAdmin
  • Go to the users table
  • Find the user that you created
  • Click on the edit link, to edit the user
  • Scroll to the user_password field
  • The contents of user_password just delete that
  • to the left of the empty field, you’ll see a select option, select the most bottom selection, password
  • In your empty field type your new password

Save and let’s see if that helped

3

Thank you so much for the detailed instructions! Really appreciate you taking the time to walk me through this.

I just logged into phpMyAdmin and found the ip_users table. I have only one user account, and there are a few relevant columns:

user_password: This is a type “varchar(60)” field that contains a long string of characters.
user_password_token: This is a type “varchar(100)” field, also contains a long string of characters.

Could you please clarify which password field I should delete the contents of? Should I delete the contents of the user_password field?

Also, you mentioned to select the “most bottom selection”, I found that it is
“password_hash() PHP function”. Should I select that option before entering my new password?

Thank you again for your help - it’s greatly appreciated!

4

Yes, that’s the field

Yes, exactly that.

5

Hello, I went ahead and deleted the password in the user_password field, and then selected the “most bottom selection” (which I believe is the password_hash() function) from the options on the left. I then entered my new password in the field and saved the changes.

However, even after doing this, I’m still unable to log in. Is there anything else I should be doing?

Should I also be deleting the contents of the user_password_token field? Just want to make sure I’m resetting everything properly so I can regain access to my InvoicePlane account.

Thanks again!

1 Like