ProjeQtOr free project management software - [SOLVED] PHP 7.4 - ProjeQtOr
 

[SOLVED] PHP 7.4

More
07 Jan 2020 11:37 #1 by Thierry94
[SOLVED] PHP 7.4 was created by Thierry94
Hi,
Projeqtor has been installed for several months in an arch linux container that I update regularly.

The PHP packages were updated yesterday to version 7.4.1.
The installed version of projeqtor is 8.3.1.

Since the update, I'm no longer able to connect to projeqtor.
Here is an abstract of the log
[V8.3.1] ERROR *****2020-01-07 10:28:38.962 ***** ERROR ***** [V8.3.1] on file '/srv/http/projeqtor/tool/projeqtor.php' at line (166)
2020-01-07 10:28:38.962 ***** ERROR ***** [V8.3.1] cause = Function get_magic_quotes_runtime() is deprecated

thanks for your help.

Please Connexion or Create an account to join the conversation.

More
07 Jan 2020 12:00 #2 by Flou
Replied by Flou on topic [SOLVED] PHP 7.4
Hello,

Projeqtor is not yet compatible with php 7.4.1.
It will be soon with version 8.4.
The following user(s) said Thank You: Thierry94

Please Connexion or Create an account to join the conversation.

More
10 Jan 2020 09:36 #3 by Thierry94
Replied by Thierry94 on topic [SOLVED] PHP 7.4
Hello
Do you know how soon this version will be available?
I'm just looking for some information to know if I need to spend some time building a new server.

I tried to build one quickly, based on ubuntu LTS with PHP 7.2, attacking the same database. But I can't connect, the password is denied.
I think it's an encryption problem, on the PHP side (the extensions are all present).

Please Connexion or Create an account to join the conversation.

More
10 Jan 2020 12:30 #4 by Flou
Replied by Flou on topic [SOLVED] PHP 7.4
Hi,

The version 8.4 will be available mid-March normally.
Did you change your database password in the Projeqtor parameter.php files, located in the config folder?
The following user(s) said Thank You: Thierry94

Please Connexion or Create an account to join the conversation.

More
10 Jan 2020 13:00 - 10 Jan 2020 16:23 #5 by Thierry94
Replied by Thierry94 on topic [SOLVED] PHP 7.4
thank you for your response.

Yes, the $paramDbPassword parameter is strictly identical on my two machines.

In summary, I have three servers:

1) The old one (let's call it S1), which worked until PHP 7.4.
- arch linux
- apache
- php 7.4
- mariaDB
2) The new (S2)
- ubuntu
- apache
- PHP 7.2
I set up S2 to connect to the database located on S1 but also on S3 (to test more freely).

3) I also have a maria DB server (S3) containing a copy (export/import) of the database located on S1. in order to safely test configuration modifications.

result (log level 4 on S2, attempt to connect to S3 from S2 - the result is the same if I try to connect from 2 on S1) :
2020-01-10 12:52:25.687 ..... SCRIPT .... 192.168.1.13 ->/tool/loginCheck.php
2020-01-10 12:52:25.690
DEBUG
loginCheck : current db version = 'V8.3.1'
2020-01-10 12:52:25.696
DEBUG
User->authenticate('admin', 'WAJDOXllGF4ZnjwY4I+tNBu6f/W69NBLhKM=')
2020-01-10 12:52:25.698
DEBUG
User->authenticate : sha256 encryption
2020-01-10 12:52:25.703 ..... SCRIPT .... 192.168.1.13 getProfile(objectOrIdProject=User #1)
2020-01-10 12:52:25.706 ..... SCRIPT .... 192.168.1.13 getProfile(objectOrIdProject=User #1)
2020-01-10 12:52:25.716 ..... SCRIPT .... 192.168.1.13 getProfile(objectOrIdProject=History #)
2020-01-10 12:52:25.721 ..... SCRIPT .... 192.168.1.13 getProfile(objectOrIdProject=History #)
2020-01-10 12:52:25.944
DEBUG
User->authenticate : wrong password 56d8afdc9f97cdcfb8b6ec662bb7d7be0a84af30bcd1524365f5e1b37193b183!=WAJDOXllGF4ZnjwY4I+tNBu6f/W69NBLhKM= (exit)
2020-01-10 12:52:25.945
DEBUG
loginCheck : unidentified incorrect authentification
2020-01-10 12:52:25.945 ===== TRACE ===== Login error for user 'admin'


here is the list of php extensions installed on S2
php -m
[PHP Modules]
calendar
Core
ctype
date
dom
exif
fileinfo
filter
ftp
gd
gettext
hash
iconv
imap
json
libxml
mbstring
mcrypt
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_mysql
Phar
posix
readline
Reflection
session
shmop
SimpleXML
sockets
sodium
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
zip
zlib

[Zend Modules]

///
I made a new test on S3. i reset the admion password with the update i found here www.projeqtor.org/fr/forum-fr/5-ask-ques...t-password-for-admin
after that, i could login, and projeqtor asked me to change the password.
Then i can see some contents. I disconnected the session and tried to reconnect... no sucess, same error as before...
i think there there is something wrong with apache/php on my S2...
Last edit: 10 Jan 2020 16:23 by Thierry94. Reason: new test / reset admin password

Please Connexion or Create an account to join the conversation.

More
10 Jan 2020 16:51 #6 by babynus
Replied by babynus on topic [SOLVED] PHP 7.4
Take care that ProjeQtOr uses some negociation of hash keys for authentications.
If you try and connect to different servers on same domain you may have session issues, trying to connect on a server with hash key from another one.
Be sure to clean cache and cookies between tests, or test access on different servers from different browsers.

Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: Thierry94

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.051 seconds