Hello. Does anyone have any ideas? I’m effectively locked out. I was able to change the mail server so that I can get a Password Reset email but the link always results in me entering the new password, then the login screen terminating in “Invalid One Time Password”. Isn’t there some way to rectify this from the local command line?
To be clear, running the bcrypt command doesn’t modify the DB, it just tells me what to put into the corresponding username entry? The output of the command looks like a hash.
Thanks. How do I edit the database? I tried installing PHPMyAdmin using sudo apt install phpmyadmin. I saw no errors during the installation. When I tried the local address 192.168.1.99/phpmyadmin, I get a not found message with interface dressing from InvoiceNinja.
I was able to get phpmyAdmin running by creating a symbolic link from the phpMyAdmin install directory to the InvoiceNinja document root directory. I was able to get into the DB. I ran
php artisan tinker
bcrypt(‘new_password’)
It gave an output string.
I saved the output string into the database (‘users’ table → ‘password’ field).
Still I got the same errors… invalid one time password, wrong password.
I noticed these fields were also populated so I cleared them: