View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Password not working for admin user - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

  
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

  
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

  

 

 
 

Password not working for admin user

More
06 Nov 2017 19:34 #1 by eabjoker
Password not working for admin user was created by eabjoker
Trying to login as admin this morning and login fails with 'Invalid login parameters'.
I thought I forgot the password, so I used the password reset as described in other forum posts.
UPDATE resource SET password='newPassword', crypto=NULL, isLdpa=0 WHERE id=1;

This worked and I was able to login and reset the password.
However, after logging out and trying to login again the password again did not work.
I tried deleting cookies and recent browsing data and also logging in with a completely different web browser, and I still get the same results, 'Invalid login parameters'.

I then dropped the database (I did not have any data in it yet) and upgraded/recreated the install with version 6.4.4. I am still getting the same results. admin/admin does not work for initial login. I had to use the reset code to set a temporary password, then reset it. It allows the login the first time after the reset, but logging out and attempting to login again gives 'Invalid login parameters'.

Please Connexion or Create an account to join the conversation.

More
07 Nov 2017 19:23 #2 by eabjoker
Replied by eabjoker on topic Password not working for admin user
This post probably belongs in the 'Submit Issues' category, is there a way to move it there?

Please Connexion or Create an account to join the conversation.

More
08 Nov 2017 09:49 #3 by babynus
Replied by babynus on topic Password not working for admin user
1) check you PHP installation : are all required modules installed ? (openssl, hash, mbstring mcrypt)
2) check for errors in log file
3) check for errors in browser console
(report here any error)
Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
08 Nov 2017 22:07 - 08 Nov 2017 22:08 #4 by eabjoker
Replied by eabjoker on topic Password not working for admin user
I have 2 installations of Projeqtor. One that is working and the newer one with the above issue.
Here are the differences in the install.

Working version:
Apache Version Apache/2.2.15
PHP Version 7.0.21
OpenSSL 1.0.1e-fips 11 Feb 2013

Problem Version:
Apache Version Apache/2.4.6
PHP Version 7.0.24
OpenSSL 1.0.2k-fips 26 Jan 2017

The other modules hash, mbstring, and mcrypt are identical for each.

From the log file, after changing the password to 'test1', password, salt, and crypto (sha256) updated in database, and then trying to log in again
2017-11-08 12:35:14.170 ..... SCRIPT .... 192.168.1.21 Page=loginCheck.php
2017-11-08 12:35:14.173 ..... SCRIPT .... 192.168.1.21    ->/tool/loginCheck.php
2017-11-08 12:35:14.186 ----- DEBUG ----- loginCheck : current db version = 'V6.4.4'
2017-11-08 12:35:14.189 ----- DEBUG ----- User->authenticate('admin', 'sAJE+4FqA1rZV73brQ==')
2017-11-08 12:35:14.193 ----- DEBUG ----- User->authenticate : sha256 encryption
2017-11-08 12:35:14.193 ----- DEBUG ----- User->authenticate : wrong password 9299877901692c7e3eda27e408f75ff8ec47d4e0590b0396cb84744aa8bbd7ba!=sAJE+4FqA1rZV73brQ== (exit)
2017-11-08 12:35:14.194 ----- DEBUG ----- loginCheck : unidentified incorrect authentification
2017-11-08 12:35:14.194 ===== TRACE ===== Login error for user 'admin'
No errors in browser console.

Any ideas on what else to look at?
Does the Apache version matter?

I will try installing on v6.4.4 on the working version server and see if it works there.
Last edit: 08 Nov 2017 22:08 by eabjoker. Reason: add code block

Please Connexion or Create an account to join the conversation.

More
09 Nov 2017 13:42 - 09 Nov 2017 13:42 #5 by babynus
Replied by babynus on topic Password not working for admin user
Apache version may be source of issue if you are using virtual hosts.
Try and check for errors in apache error log file.
Babynus
Administrator of ProjeQtOr web site
Last edit: 09 Nov 2017 13:42 by babynus.

Please Connexion or Create an account to join the conversation.

More
09 Nov 2017 22:07 #6 by eabjoker
Replied by eabjoker on topic Password not working for admin user
To follow up, I copied the entire installation over to the other server running Apache/2.2.15 and the password issue has gone away. I don't understand what is different that allows this to work on Apache/2.2.15 and not on Apache/2.4.6. If I have time I will try and debug this and figure it out, unless someone already knows the answer.

Please Connexion or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.039 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form