View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Authentication problem - Page 2 - ProjeQtOr

Prochaines Sessions

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

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)
 

13 mai 2025 (10h30-12h)

5 juin 2025 (16h-17h30)

 
 

Planifiez avec ProjeQtOr

14 et 15 mai 2025 (9h-12h30)

18 et 19 juin 2025 (9h-12h30)

 
 

Administrez avec ProjeQtOr

20 et 21 mai (9h-12h30)

25 et 26 juin (9h-12h30)

 

 

 

Authentication problem

More
24 Jan 2014 18:24 #7 by babynus
Replied by babynus on topic Authentication problem
Hi,
You had 2 issues when creating talbes Issue and Risk.
Other issues are link to the faul of these creations.

But these should not be blocking.

Could you try :
- check content of table "resource" (it replaces table user)
- clean log file, try to connect with admin.admin, snd new log file.

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

Please Connexion or Create an account to join the conversation.

More
24 Jan 2014 18:37 #8 by marouta
Replied by marouta on topic Authentication problem
Thank you ! :)

It worked when i change the parameters in the table "parameter" :

id idUser idProject parameterCode parameterValue
1 NULL NULL dbVersion V4.1.2

Instead of :

id idUser idProject parameterCode parameterValue
1 NULL 0 dbVersion V4.1.2

Please Connexion or Create an account to join the conversation.

More
16 Mar 2014 02:44 #9 by nanthigna
Replied by nanthigna on topic Authentication problem
Hi everybody,

I have the same problem when trying to authenticate on the Login form:

Invalid login parameters

Here is the content of my log file:

2014-03-16 02:06:00 ***** ERROR ***** Error on SqlElement to get 'loginTry' for Class 'User' : field 'loginTry' not found in Database.
2014-03-16 02:06:00 ***** ERROR ***** Error on SqlElement to get 'isLdap' for Class 'User' : field 'isLdap' not found in Database.
2014-03-16 02:06:00 ***** ERROR ***** Error on SqlElement to get 'isContact' for Class 'User' : field 'isContact' not found in Database.
2014-03-16 02:06:00 ***** ERROR ***** Error on SqlElement to get 'initials' for Class 'User' : field 'initials' not found in Database.
2014-03-16 02:06:00 ***** ERROR ***** Error on SqlElement to get 'salt' for Class 'User' : field 'salt' not found in Database.
2014-03-16 02:06:00 ***** ERROR ***** Error on SqlElement to get 'crypto' for Class 'User' : field 'crypto' not found in Database.
2014-03-16 02:06:00 ***** ERROR ***** Error on SqlElement to get 'cookieHash' for Class 'User' : field 'cookieHash' not found in Database.
2014-03-16 02:06:00 ***** ERROR ***** Error on SqlElement to get 'passwordChangeDate' for Class 'User' : field 'passwordChangeDate' not found in Database.
2014-03-16 02:06:01 ***** ERROR ***** Error on SqlElement to get 'loginTry' for Class 'User' : field 'loginTry' not found in Database.
2014-03-16 02:06:01 ***** ERROR ***** Error on SqlElement to get 'isLdap' for Class 'User' : field 'isLdap' not found in Database.
2014-03-16 02:06:01 ***** ERROR ***** Error on SqlElement to get 'isContact' for Class 'User' : field 'isContact' not found in Database.
2014-03-16 02:06:01 ***** ERROR ***** Error on SqlElement to get 'initials' for Class 'User' : field 'initials' not found in Database.
2014-03-16 02:06:01 ***** ERROR ***** Error on SqlElement to get 'salt' for Class 'User' : field 'salt' not found in Database.
2014-03-16 02:06:01 ***** ERROR ***** Error on SqlElement to get 'crypto' for Class 'User' : field 'crypto' not found in Database.
2014-03-16 02:06:01 ***** ERROR ***** Error on SqlElement to get 'cookieHash' for Class 'User' : field 'cookieHash' not found in Database.
2014-03-16 02:06:01 ***** ERROR ***** Error on SqlElement to get 'passwordChangeDate' for Class 'User' : field 'passwordChangeDate' not found in Database.
2014-03-16 02:06:01 ===== TRACE ===== Login error for user 'admin'

I could find nowhere in projeqtor database the mentioned fields.

I installed Wampserver 2.4 with PHP 2.4.4 and MySQL 5.6.12 on my PC.
Is it the right version of Web server required?

Please Connexion or Create an account to join the conversation.

More
16 Mar 2014 20:48 - 16 Mar 2014 20:48 #10 by babynus
Replied by babynus on topic Authentication problem
Hi,

I think your PHP version is not 2.4.4, as current deployed version are 5.x, I guess it is 5.4.4.

I think you had an issue when upgrading database.
Could you retrieve the log file of database upgrade and post it here ?

The mentioned fileds should exist in table 'resource'.

Babynus
Administrator of ProjeQtOr web site
Last edit: 16 Mar 2014 20:48 by babynus.

Please Connexion or Create an account to join the conversation.

More
17 Mar 2014 08:33 #11 by nanthigna
Replied by nanthigna on topic Authentication problem
To be correct this is my first installation (not an upgrade) of ‘Projeqtor’ (V4.2.1) and the web server installed is Wampserver 2.4 with:

• Apache 2.4.4
• PHP 5.4.16 (you guessed it!)
• MySQL 5.6.12

The structure of table ‘resource’ in ‘projeqtor’ database includes the following fields:

1) Id
2) Name
3) fullName
4) email
5) description
6) password
7) idProfile
8) isResource
9) isUser
10) locked
11) idle
12) phone
13) mobile
14) fax
15) idTeam

So, what’s wrong with table 'resource'?

Please Connexion or Create an account to join the conversation.

More
17 Mar 2014 12:26 #12 by babynus
Replied by babynus on topic Authentication problem
Your Resource table is not as expected on a V4.2.1 version.

It seems some database update failed.
(for information, set-up of database is incremental and reproduces step by step upgrade from first to latest version)
Could you please try and retrieve install logs ?

Or maybe you can try another install (on new database) and post logs here.
To re-run the set-up is easy : just delete /tool/parametersLocaton.php file.

My first idea is that install stopped before end of process.
Maybe your php configuration refuses the set_time_limit at runtime, and then you got a timeout.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

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