PHP 7.2 Environment
Debian 9 Apache Server.
Projeqtor Version 7.2.7
Hi, I keep having Projeqtor lose it's connection. Here is details from the web server log:
root@jacob2:/var/www/garethbaileygroup.com/log# tail -40 error.log
[Sun Nov 25 15:23:46.178838 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: PHP Warning: session_start(): Failed to decode session object. Session has been destroyed in /var/www/clients/client1/web3/web/workflow/projeqtor/tool/projeqtor.php on line 39
[Sun Nov 25 15:23:46.178872 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: PHP Fatal error: Uncaught Error: Call to undefined function htmlGetErrorMessage() in /var/www/clients/client1/web3/web/workflow/projeqtor/model/persistence/Sql.php:272
[Sun Nov 25 15:23:46.178880 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: Stack trace:
[Sun Nov 25 15:23:46.178887 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: #0 /var/www/clients/client1/web3/web/workflow/projeqtor/model/persistence/Sql.php(84): Sql::getConnection()
[Sun Nov 25 15:23:46.178893 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: #1 /var/www/clients/client1/web3/web/workflow/projeqtor/model/persistence/SqlElement.php(2371): Sql::query('select * from p...')
[Sun Nov 25 15:23:46.178900 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: #2 /var/www/clients/client1/web3/web/workflow/projeqtor/model/Parameter.php(982): SqlElement->getSqlElementsFromCriteria(NULL, false, ' (idUser is nul...')
[Sun Nov 25 15:23:46.178907 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: #3 /var/www/clients/client1/web3/web/workflow/projeqtor/tool/projeqtor.php(2308): Parameter::getGlobalParameter('logLevel')
[Sun Nov 25 15:23:46.178914 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: #4 /var/www/clients/client1/web3/web/workflow/projeqtor/tool/projeqtor.php(2422): logTracing('Impossible to l...', 1)
[Sun Nov 25 15:23:46.178920 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: #5 /var/www/clients/client1/web3/web/workflow/projeqtor/tool/projeqtor.php(1435): errorLog('Impossible to l...')
[Sun Nov 25 15:23:46.178927 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: #6 [internal function]: projeqtorAutoload('BreadCrumbStack')
[Sun Nov 25 15:23:46.178933 2018] [fcgid:warn] [pid 20262] [client 192.168.1.254:40844] mod_fcgid: stderr: #7 [internal function]: spl_autoload_call('BreadCru in /var/www/clients/client1/web3/web/workflow/projeqtor/model/persistence/Sql.php on line 272
Any help would be greatly appreciated. Any questions, please feel free, anything complicated, please would you give a step by step to either try a fix or provide useful information (that saves ping pong).
Thanks very much,
Kind Regards.
indieben.
Session was killed.
Please check projeqtor log file.
Thanks but this has even less info:
2018-11-25 15:24:01.613 ===== TRACE ===== Login error for user 'bgareth'
2018-11-25 15:24:05.770 ===== TRACE ===== NEW CONNECTED USER 'admin'
2018-11-25 15:26:08.287 ===== TRACE ===== NEW CONNECTED USER 'admin'
2018-11-25 15:29:27.661 ===== TRACE ===== NEW CONNECTED USER 'admin'
2018-11-25 15:30:14.908 ===== TRACE ===== NEW CONNECTED USER 'admin'
Right, nothing from ProjeQtOr.
So you may be facing PHP or Apache session timeout.
Does diconnection occur after some time, after some inactivity time, or quickly after connection ?
After some time i'd say. At first I thought it was after some inactivity (i.e. a few minutes) but I had to select a few things fairly quickly and it still kicked me off.
I'm not having any other issues like this across the domain though. Just in case, do you have a list of any necessary and preferable PHP mods that need to be installed? I'd be more than happy to double check all the necessary mods are installed for PHP 7.2. Thanks 🙂
Required modules are listed on website : https://www.projeqtor.org/en/product-en/technical-en/64-setup-en/412-product-prerequisites-en
They are also controlled during setup.
Thank you.
These are the modules I have installed, would there be any issue with what I have please? php7.2
php7.2-bz2
php7.2-cgi
php7.2-cli
php7.2-common
php7.2-curl
php7.2-fpm
php7.2-gd
php7.2-imap
php7.2-intl
php7.2-json
php7.2-mbstring
php7.2-mysql
php7.2-opcache
php7.2-pspell
php7.2-readline
php7.2-recode
php7.2-soap
php7.2-sqlite3
php7.2-tidy
php7.2-xml
php7.2-xmlrpc
php7.2-xsl
php7.2-zip
root@jacob2:/#
Thanks 🙂
Seems OK.
Maybe your issue come from php and/or Apache configuration (cookie lifetime, session_lifetime, ...)
Thanks man,
Interestingly, with absolutely no changes it's running as sweet as a nut today... it's installed on a local server so i'm a bit lost but obviously it's a pain for the system not to be reliable. Not sure where to start really - I have double checked but I emphasise that I have not made any server changes.
Kind Regards,
indieben.
I have double checked but I emphasise that I have not made any server changes.
Maybe just a restart of processes ?