Login issues since upgrading to Timetrex 16 from v 15
Posted: Mon Nov 28, 2022 6:49 pm
I was running Linux Mint XFCE v 20.3
when I received an email notification from the timetrex server that an automatic "upgrade failed",
so I went straight to the installer where I was notified my php requirements were not met.
In order to upgrade my PHP, I had to upgrade from Linux Mint v 20 to Mint 21. I used "mintupgrade" to complete this and all went well.
I then installed Timetrex 16 from the deb file, and all went well.
I restored my timetrex database and I copied my old timetrex.php.ini file into the /usr/share/timetrex/interface folder, rebooted everything, and ran the installer, which went well. No errors are reported in the database restore log (I do use PgAdmin)
The installer didn't appear to upgrade the database at all, it happened very quickly. After the installer was successfully finished, it took me to the login page and now I can't login. I get the error:
"The network connection was lost. Please check your network connection then try again"
I ensured the firewall is configured as it was before the upgrade (it is), but I disabled it completely for testing. That's not the issue.
I've tested my php-pgsql connection and that's all working fine
I'm not getting incorrect username or password, so I'm confident the database is ok.
I looked in the timetrex log file, and nothing new is posting there since the initial install.
My postgresql logfile isn't showing any errors for timetex at all
I've tried scram-sha-256, md5 and password methods for IPv4 local connections in my pg_hpa.conf
I configured my postgresql.conf listen_addresses = '*'
I tried password_encryption + scram-sha-256 and md5
I'm completely at a loss here :(
That being said, I've attached my apache2 error log file. I don't have cookies disabled????
For background, we started using Timetrex 7 years ago on linux with a manual install. I setup the PHP, Postgresql, apache2 and timetrex manually.
I've done total clean installs of brand new OS versions, new postgres/apache/timetrex installed and restored the database successfully everytime. I'm not a complete "newb", but this is baffling. Any help I can get will be greatly appreciated.
Note to self TURN OFF AUTO UPDATES. This can't be happening just days before payday :(
when I received an email notification from the timetrex server that an automatic "upgrade failed",
so I went straight to the installer where I was notified my php requirements were not met.
In order to upgrade my PHP, I had to upgrade from Linux Mint v 20 to Mint 21. I used "mintupgrade" to complete this and all went well.
I then installed Timetrex 16 from the deb file, and all went well.
I restored my timetrex database and I copied my old timetrex.php.ini file into the /usr/share/timetrex/interface folder, rebooted everything, and ran the installer, which went well. No errors are reported in the database restore log (I do use PgAdmin)
The installer didn't appear to upgrade the database at all, it happened very quickly. After the installer was successfully finished, it took me to the login page and now I can't login. I get the error:
"The network connection was lost. Please check your network connection then try again"
I ensured the firewall is configured as it was before the upgrade (it is), but I disabled it completely for testing. That's not the issue.
I've tested my php-pgsql connection and that's all working fine
I'm not getting incorrect username or password, so I'm confident the database is ok.
I looked in the timetrex log file, and nothing new is posting there since the initial install.
My postgresql logfile isn't showing any errors for timetex at all
I've tried scram-sha-256, md5 and password methods for IPv4 local connections in my pg_hpa.conf
I configured my postgresql.conf listen_addresses = '*'
I tried password_encryption + scram-sha-256 and md5
I'm completely at a loss here :(
That being said, I've attached my apache2 error log file. I don't have cookies disabled????
For background, we started using Timetrex 7 years ago on linux with a manual install. I setup the PHP, Postgresql, apache2 and timetrex manually.
I've done total clean installs of brand new OS versions, new postgres/apache/timetrex installed and restored the database successfully everytime. I'm not a complete "newb", but this is baffling. Any help I can get will be greatly appreciated.
Note to self TURN OFF AUTO UPDATES. This can't be happening just days before payday :(