'User Name or Password is incorrect' after upgrade
Posted: Wed May 13, 2020 12:12 pm
Hi everyone,
I'm getting stuck with a recent migrate + upgrade we did.
I had an timetrex running on CentOS7 with PGSQL 9.2... it started prompting to upgrade a few months back and one fine day it just stopped working. The admin of our TT "not so techie" tried to upgrade but then it got stuck on the database upgrade, because New TT is not compatible below PGSQL version 9.4
So I took over with this non functioning Timetrex trying to resurrect it. For safety and to get things onto latest greatest version, I setup a complete new VPS with Debian 10 & PostgresSQL 12. I backed up (pg_dumpall) and restored the Database to it and then downloaded fresh Timtrex and connected it to the database successfully. Upon running the installer it said Installing/upgrading database may take upto 10 mins, hit yes, gave me Congratulations, successfully timetrex to 12.1.3 and gave me note: in order to access new features, you may need to apply Administrator permissions preset to each administrator employee, then I got a final congratulations, you have successfully upgraded Timtrex, you may now login...
However, I can't seem to login with any of the user/passwords that were working before. I set the logging in ini file, here is the log attached just to keep the thread clean, but I'll paste in the "error" lines here for attention:
Also I see a few Warnings for Write Permissions:
while /tmp/timetrex is there and writeable by everyone (777)
I tried the command line but it could not find any such user (tried with multiple users)
I went into PGSQL DB into USERS table and I can see the 7 Users there. It also shows reset token for one of those I tried to reset passwords with.
Can you hint me what could the issue so I can fix the login ?
Many thanks
I'm getting stuck with a recent migrate + upgrade we did.
I had an timetrex running on CentOS7 with PGSQL 9.2... it started prompting to upgrade a few months back and one fine day it just stopped working. The admin of our TT "not so techie" tried to upgrade but then it got stuck on the database upgrade, because New TT is not compatible below PGSQL version 9.4
So I took over with this non functioning Timetrex trying to resurrect it. For safety and to get things onto latest greatest version, I setup a complete new VPS with Debian 10 & PostgresSQL 12. I backed up (pg_dumpall) and restored the Database to it and then downloaded fresh Timtrex and connected it to the database successfully. Upon running the installer it said Installing/upgrading database may take upto 10 mins, hit yes, gave me Congratulations, successfully timetrex to 12.1.3 and gave me note: in order to access new features, you may need to apply Administrator permissions preset to each administrator employee, then I got a final congratulations, you have successfully upgraded Timtrex, you may now login...
However, I can't seem to login with any of the user/passwords that were working before. I set the logging in ini file, here is the log attached just to keep the thread clean, but I'll paste in the "error" lines here for attention:
Code: Select all
APIAuthentication::getCompanyName(): ERROR: Primary Company does not exist!
Validator::Error(): Validation Error: Label: user_name Value: "0" Msg: User Name or Password is incorrect
Array: APIFactory::returnHandler(): returnHandler v2 ERROR: 0
ProgressBar::error(): error: 'xxxx Key: xxx.5449) Message: INVALID DATA
Code: Select all
Factory::saveCache(): WARNING: Unable to write cache file, likely due to permissions or locking! Cache ID: registration_key Table: system_setting File: /tmp/timetrex/cache_6/cache_system_setting_registration_key
I tried the command line but it could not find any such user (tried with multiple users)
Code: Select all
su www-data -c "php tools/set_admin_permissions.php ari"
This account is currently not available.
Can you hint me what could the issue so I can fix the login ?
Many thanks