View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - [SOLVED] Access denied after upgrade to 9.0 - 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)

 

 

 
 

[SOLVED] Access denied after upgrade to 9.0

More
23 Déc 2020 22:26 #1 by sa
Hello
I updated my projeqtor version (8.6.6) to the new version.
After admin login, the update was completed successfully.
The login screen is displayed and I fill in the same login and same password, but this time the application ask me to change the password. I indicate the two textboxes the same new password and I validate and again the same screen that is displayed I cannot go further.

I attach you the logs which indicate that the password has expired.
2020-12-23 20:49:04.273 ===== TRACE =====
2020-12-23 20:49:04.274 ===== TRACE ===== =====================================
2020-12-23 20:49:04.274 ===== TRACE =====
2020-12-23 20:49:04.274 ===== TRACE ===== DataBase actual Version = V8.6.4
2020-12-23 20:49:04.274 ===== TRACE ===== ProjeQtOr actual Version = V9.0.0
2020-12-23 20:49:04.274 ===== TRACE =====
2020-12-23 20:49:04.275 ===== TRACE ===== =====================================
2020-12-23 20:49:04.275 ===== TRACE =====
2020-12-23 20:49:04.275 ===== TRACE ===== VERSION V8.6.5
2020-12-23 20:49:04.276 ===== TRACE =====
2020-12-23 20:49:04.292 ===== TRACE ===== 0 lines updated into table "resource".
2020-12-23 20:49:04.304 ===== TRACE ===== 4 lines updated into table "notifiable".
2020-12-23 20:49:04.305 ===== TRACE =====
2020-12-23 20:49:04.305 ===== TRACE ===== DATABASE UPDATED
2020-12-23 20:49:04.305 ===== TRACE ===== WITH NO ERROR
2020-12-23 20:49:04.305 ===== TRACE =====
2020-12-23 20:49:04.305 ===== TRACE ===== =====================================
2020-12-23 20:49:04.305 ===== TRACE =====
2020-12-23 20:49:04.305 ===== TRACE ===== VERSION V9.0.0
2020-12-23 20:49:04.305 ===== TRACE =====
2020-12-23 20:49:04.345 ===== TRACE ===== Table "navigation" created.
2020-12-23 20:49:04.363 ===== TRACE ===== 283 lines inserted into table "navigation".
2020-12-23 20:49:04.382 ===== TRACE ===== 10 lines updated into table "navigation".
2020-12-23 20:49:04.449 ===== TRACE ===== Table "menucustom" altered.
2020-12-23 20:49:04.452 ===== TRACE ===== 1 lines inserted into table "parameter".
2020-12-23 20:49:04.456 ===== TRACE ===== 22 lines inserted into table "parameter".
2020-12-23 20:49:04.514 ===== TRACE ===== Table "notification" altered.
2020-12-23 20:49:04.523 ===== TRACE ===== 2 lines updated into table "habilitationother".
2020-12-23 20:49:04.530 ===== TRACE ===== 1 lines inserted into table "originable".
2020-12-23 20:49:04.635 ===== TRACE ===== Table "milestone" altered.
2020-12-23 20:49:04.635 ===== TRACE =====
2020-12-23 20:49:04.635 ===== TRACE ===== DATABASE UPDATED
2020-12-23 20:49:04.636 ===== TRACE ===== WITH NO ERROR
2020-12-23 20:49:04.636 ===== TRACE =====
2020-12-23 20:49:06.063 ===== TRACE ===== =====================================
2020-12-23 20:49:06.063 ===== TRACE =====
2020-12-23 20:49:06.064 ===== TRACE ===== DATABASE UPDATE COMPLETED TO VERSION V9.0.0
2020-12-23 20:49:06.064 ===== TRACE =====
2020-12-23 20:49:06.064 ===== TRACE ===== =====================================
2020-12-23 20:49:06.064 ===== TRACE =====
2020-12-23 20:49:12.187 ===== TRACE ===== NEW CONNECTED USER 'admin'
2020-12-23 20:49:12.418 ===== TRACE ===== password expired for user 'admin'
2020-12-23 20:49:12.544 ===== TRACE ===== password expired for user 'admin'


I installed a new v9 instance and this time I can connect

Please Connexion or Create an account to join the conversation.

More
23 Déc 2020 22:47 #2 by sa
logs
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: version in C:\wamp64\www\projeqtor\index.php on line 68
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:\wamp64\www\projeqtor\index.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: build in C:\wamp64\www\projeqtor\index.php on line 68
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:\wamp64\www\projeqtor\index.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: version in C:\wamp64\www\projeqtor\index.php on line 69
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:\wamp64\www\projeqtor\index.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: build in C:\wamp64\www\projeqtor\index.php on line 69
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:\wamp64\www\projeqtor\index.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: firstColor in C:\wamp64\www\projeqtor\index.php on line 105
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:\wamp64\www\projeqtor\index.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: version in C:\wamp64\www\projeqtor\view\index.php on line 64
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:\wamp64\www\projeqtor\view\index.php:0
[23-Dec-2020 20:15:17 UTC] PHP Notice: Undefined variable: build in C:\wamp64\www\projeqtor\view\index.php on line 64
[23-Dec-2020 20:15:17 UTC] PHP Stack trace:
[23-Dec-2020 20:15:17 UTC] PHP 1. {main}() C:\wamp64\www\projeqtor\view\index.php:0
[23-Dec-2020 20:17:53 UTC] PHP Fatal error: Maximum execution time of 30 seconds exceeded in C:\wamp64\www\projectbox\tool\projeqtor.php on line 1634
[23-Dec-2020 20:17:53 UTC] PHP Stack trace:
[23-Dec-2020 20:17:53 UTC] PHP 1. {main}() C:\wamp64\www\projectbox\view\main.php:0
[23-Dec-2020 20:17:53 UTC] PHP 2. require_once() C:\wamp64\www\projectbox\view\main.php:37
[23-Dec-2020 20:17:53 UTC] PHP 3. session_start() C:\wamp64\www\projectbox\tool\projeqtor.php:44
[23-Dec-2020 20:17:53 UTC] PHP 4. spl_autoload_call() C:\wamp64\www\projectbox\tool\projeqtor.php:44
[23-Dec-2020 20:17:53 UTC] PHP 5. projeqtorAutoload() C:\wamp64\www\projectbox\tool\projeqtor.php:44

Please Connexion or Create an account to join the conversation.

More
24 Déc 2020 09:13 #3 by babynus
Hi,

It seems you have expired password : you activated the feature to request password change, and something went wrong when updating password.
We'll analyse that point.

Second log show "old" errors we'll also analyse.

Tickets #5129 and #5130 recorded

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
24 Déc 2020 09:17 #4 by babynus
To fix the password issue, manually change passwordChangeDate in table resource for user admin
You can do this manually (with phpMyAdmin) of with query
update resource set passwordChangeDate = '2020-12-24' where name='admin';

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
24 Déc 2020 09:56 #5 by sa
Hello
It is ok now. thank you
Do i need to update the whole table?

Best regards

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.035 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.