View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Authentication problem - Page 2 - ProjeQtOr
 

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 Log in 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 Log in 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 Log in 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 Log in 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 Log in 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 Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.069 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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