Hello,
I'm KO for this install of this tools, which seems quite cool for my project management. Here are my actions
- download last version 5.5.3 : OK
- ftp on my site en database provider (OVH) : OK
- connect to the first page, parameters entry : OK, all controls OK (green) : PHP 7.0.23, modules PDO OK, database OK, ...
- clic to "continue" : acces to the page "update in progress, admin only allowed"
and then, when I try to log "admin/admin", it's KO : "incorrect connexion parameters".
I konw my database parameters are OK , they are used with others softs on the same server (Wordpress, Owncloud, ...) and all is right with these softs.
The log after install is very short :
2018-01-19 09:38:52.693 ..... SCRIPT .... 194.167.140.1 =====/projeqtor/view/index.php
2018-01-19 09:38:52.970 ..... SCRIPT .... 194.167.140.1 =====/projeqtor/view/main.php
2018-01-19 09:38:52.977 ..... SCRIPT .... 194.167.140.1 Page=main.php
2018-01-19 09:38:52.978 ..... SCRIPT .... 194.167.140.1 ->/view/login.php
2018-01-19 09:38:53.778 ..... SCRIPT .... 194.167.140.1 =====/projeqtor/tool/saveDataToSession.php
2018-01-19 09:38:53.785 ..... SCRIPT .... 194.167.140.1 Page=saveDataToSession.php
2018-01-19 09:38:53.795 ..... SCRIPT .... 194.167.140.1 =====/projeqtor/tool/saveDataToSession.php
2018-01-19 09:38:53.801 ..... SCRIPT .... 194.167.140.1 Page=saveDataToSession.php
2018-01-19 09:38:53.811 ..... SCRIPT .... 194.167.140.1 =====/projeqtor/tool/saveDataToSession.php
2018-01-19 09:38:53.817 ..... SCRIPT .... 194.167.140.1 Page=saveDataToSession.php
2018-01-19 09:38:53.827 ..... SCRIPT .... 194.167.140.1 =====/projeqtor/tool/saveDataToSession.php
2018-01-19 09:38:53.833 ..... SCRIPT .... 194.167.140.1 Page=saveDataToSession.php
2018-01-19 09:38:53.843 ..... SCRIPT .... 194.167.140.1 =====/projeqtor/tool/saveDataToSession.php
2018-01-19 09:38:53.849 ..... SCRIPT .... 194.167.140.1 Page=saveDataToSession.php
2018-01-19 09:38:53.859 ..... SCRIPT .... 194.167.140.1 =====/projeqtor/tool/saveDataToSession.php
2018-01-19 09:38:53.865 ..... SCRIPT .... 194.167.140.1 Page=saveDataToSession.php
And here is the log when I try to connect :
Page=loginCheck.php
2018-01-19 09:40:19.563 ..... SCRIPT .... 194.167.140.1 ->/tool/loginCheck.php
2018-01-19 09:40:19.566 ----- DEBUG ----- loginCheck : current db version = ''
2018-01-19 09:40:19.567 ----- DEBUG ----- login for maintenance with 'Ο7(b' / 'admin'
2018-01-19 09:40:19.567 ----- DEBUG ----- login for maintenance with other than 'admin' / 'admin'
2018-01-19 09:40:19.569 ===== TRACE ===== Migrating from version authenticate('Ο7(b', 'admin')
2018-01-19 09:40:19.570 ----- DEBUG ----- User->authenticate : no user id (exit)
2018-01-19 09:40:19.571 ----- DEBUG ----- loginCheck : unidentified incorrect authentification
2018-01-19 09:40:19.571 ===== TRACE ===== Login error for user 'Ο7(b'
Well, when I go to PhpMyAdmin to see my database, nothing has been created (no table with the prefix thet I gave) : is it the right situation after the first step ?
Any idea ?
Thanks
Denis
First, try and clear cookies and try again.
Then ,search for errors in browser console.
But what is stange is that login received is "Ο7(b" instead of "admin"
Please check that your browser does not have an encryption plugin.
Thank you for your quick answer.
Well, I do not understand where is the problem :
- cookies cleaned (CCleaner, parameters of my explorer, ...)
- tried under 3 explorer : Firefox, Chrome, IE - with 2 differents PC (Windows 10, SEVEN)
- no plugin with for encryption
- tried with http or https (security is on with my site)
... always same pb, and each time a different user (not admin) which is used to try to connect to the database ... unbelievable
(NB : latest version is 6.5.3, not 5.5.3 )
2 warnings in the console of Firefox :
- using XMLHttpRequest is obsolete : negative impact with user navigation
- using "getAttributeNode() is obsolete, you should use getAttribute()
I'll try this week-end at home, with still another PC (and maybe another server too, in localhost ?)
maybe the problem is the version of PHP ? or MySQL ?
to be continued ... 🙂
Denis
Hi,
I just tried again new install to be sure : works like a charm.
What is weird, is that on my log file I have things like :
User->authenticate('admin', 'c596eab2825e4097f1e683faba15f65e')
with user not encrypted, and password encrypted, whoch is expoected behavior
On your side you have
User->authenticate('Ο7(b', 'admin')
with user ebcrypted and password not encrypted...
It seems some encryption on javascript side failed (but error on console does not seem to point out any issue)
Hello,
Still KO for me : I tried with my home PC this week-end, same result.
I didn't had enough time to try a local install (no LAMP or WAMP ready), I'm now going to try with another website provider, to see where if the problem ! 🙂
I'll post results of my new tests.
Thank you again for your posts
Denis
So it seems issue is on serveur side (provider constraint ?) and not on client side (browser)
Well, just an other question : may the database be created before or after this first connexion : when I am on this page, all parameters have been registered (and they seem to be correct, all is in green on the previous screen), but there is no table created in my database ... strange, no ?
Well, just an other question : may the database be created before or after this first connexion : when I am on this page, all parameters have been registered (and they seem to be correct, all is in green on the previous screen), but there is no table created in my database ... strange, no ?
This is normal.
Database will be populated on first connection of admin.
(and upgrades work the same easy way)
Hello,
I have exactly same problem, I tried an older version and it's same...
Here my logs :
2018-02-01 15:16:19.568 ** ERROR ** [V0.3.0] Exception-[42S02] SQLSTATE[42S02]: Base table or view not found: 1146 Table 'projeqtor.user' doesn't exist
2018-02-01 15:16:19.568 ** ERROR ** [V0.3.0] For query : select * from user where user.name='admin' and user.isUser = '1'
2018-02-01 15:16:19.568 ** ERROR ** [V0.3.0] Strack trace :
2018-02-01 15:16:19.568 ** ERROR ** [V0.3.0] #0 Sql->query called at [D:xampphtdocsprojeqtorprojeqtormodelpersistenceSqlElement.php:2261]
2018-02-01 15:16:19.568 ** ERROR ** [V0.3.0] #1 SqlElement->getSqlElementsFromCriteria called at [D:xampphtdocsprojeqtorprojeqtortoolloginCheck.php:67]
2018-02-01 15:16:19.568 ===== TRACE ===== Login error for user 'admin'
Looks to be table 'projeqtor.user' problem ?
How is your database ?
Full with tables, empty ?
Please post Apache error log file
Hi, I am new to Projeqtor, and cannot complete the install. I am getting that situation where the 'admin' password is showing up clear, and the login encrypted.
Did you find what is creating this?
I am on most recent stable release. Got same issue with most recent release candidate.
Steph
Answering my own post in case that may help someone else.
After hours of debug, it looks like a session issue in tool/loginCheck.php
getSessionValue('sessionSalt') does not fetch the session key to decrypt the login when it does several lines down the script for password, leading to wrong decrypted login, but correct password.
moving "$dbVersion=Sql::getDbVersion();" before login decrypt fixed the issue, both login and password come decrypted and install goes through with admin / admin.
Now I still have an issue as I cannot log in. Admin / admin says correct login and log says admin user is logged in, but GUI stays on the login page.
Definitely an issue with how the session is managed. Any idea where could be the issue? I have been looking at server set up, but can't find issue.
Moving line
$dbVersion=Sql::getDbVersion();
uppur in script does not change behavior...
I guess your db is partly populated.
Drop all tables and retry.
alright, I found what is the culprit.... other may have same issue.
Bug is due to incorrect management of uppercase in the parameter file. I have been using "Sch_" as a prefix for the tables in the database which resulted in the tool generating two session one for "Sch_" and one for "sch_".
Probably a bug that need to be addressed in future releases.
Hope that helps.
Stephane
OK,
Ticket #3581 recorded