I think I am missing something in the installation. Have done a few hundred different web app installations and most of them get figured out eventually but this one has me stumped.
When I first open the site to the log in screen I get a message "Upgrade in progress Only admin user can connect". When I enter admin/admin it stays on the log in page and I get a message that says "Upgrade in currently running. Wait until it ends" and there are concentric circles indicating the system is working. 81 tables are created in the database.
No logs are made in files/logs when first connecting to the login page. However, after attempting to log in with admin/admin a date stamped log file is created showing that the database is build. However there is no errors.
Here is my current configuration:
MySQL -> 5.7.29
PHP -> 7.4
Apache -> 2.4.38
ProjeQtOr -> 9.2.4 {have also tried 9.3.1 and 9.3.2}
I have checked with several ProjeQtOr installation prerequisite pages (including https://www.projeqtor.org/en/product-en/technical-en/64-setup-en/412-product-prerequisites-en) and the readme.txt file in the installation and my installation seems to conform to these.
I have removed the MIGRATION file and tried to log in based on solutions I have found in the forum to what seems to be the same issue but the same thing happens on the front and and the log file seem to fill with errors because the database has been built already.
Any thoughts on what could be going on or what I may have missed?
I have been testing different project tools for our company since we have outgrown the desktop only tools. From what I have been able see, this looks like it may do what we need if I can get it to work.
Thank you.
Hi,
First, try and re-run configuration step : remove the file tool/parametersLocation.php for this.
Ensure you specify a correct location for log file, where php user can write.
Remove (if exists) the files/cron/MIGRATION flag.
Empty the DB (delete existing talbes)
Then run config again (call projeqtor URL).
You should have traces in the log file for each DB update (incremental upgrades for each version from V0.3.0 to V9.3.2)
If you son't get logs, have a look at PHP and Apache error log files.
Babynus,
Thank you for the help. Here are the steps that I took:
[list=1]
I am still getting the same messages on the log in and not able to get in. I have attached the log file.
Thank you,
Allan
Hi,
Check you PHP and Apache error log file.
Maybe you have a Timeout Error.
Your server seem very slow.
It traces updates during more than 2 minutes for upgrades from V0.3.0 to V2.0.0 (and script V2.0.0 is not completely executed)
For information, on my servers, complete migration from V0.3.0 to V9.3.2 takes about 15 seconds, and even on my laptop less than 30 seconds.*
Increase max_execution_time to 1 hour (set value to 3600 in php.ini)
Babynus,
Thank you for the help. I did implement all the ideas from your message but still had issues. However, I finally found the issue. The https log showed an error:
"mod_fcgid: read tat timeout"
After some hunting around I found others that had similar issues. It was caused by using FastCGI (FCGI) protocol. So I switched to standard CGI. I did have remove the MIGRATION file but once I did that, the install sees to be working.
Now on to testing. Again, thank you for your help.
Allan