Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] Connexion ...
 
Notifications
Clear all

[SOLVED] Connexion on Projeqtor after installation (incorrect id or password indication)

16 Posts
3 Users
0 Reactions
9,018 Views
(@jdi)
Posts: 9
Active Member
Topic starter
 
[#5599]

Projeqtor version: V7.2.7
Xampp version: 7.2.12 / PHP 7.2.12
Windows 8.1 and 10

Hello,

I have recently dowloaded an placed my Projeqtor's installation in Xampp folder. When i launched the URL adress "http://localhost/projeqtor", I obtained the different elements of configuration from the database informations.

I had to correct the password database (i put it in blank) and 2 others parameters which were indicated in the resume i saw appear in the configuration screen. After validation, I was unable to connect to the Projeqtor application despite i changed the database password user in MySql dashboard (In Xamp Dashboar): incorrect id or password indication.

I do not understand exactly what is the problem because i restart numerous times apache, mysql and the computer without any success.

Thank you a lot for your help that i'm sure you will provide me.

Cordially,

Didier


 
Posted : 04 Dec 2018 15H47
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

If you change password to DB, you must change value in parameters.php


 
Posted : 04 Dec 2018 17H53
(@jdi)
Posts: 9
Active Member
Topic starter
 

When i change the password in the file parameters.php, projeqtor is not accessible. Impossible to put any credentials. Error messages.

When i let the parameters.php in the first version, i have the connection fields but the same problem to access.


 
Posted : 04 Dec 2018 21H03
(@jdi)
Posts: 9
Active Member
Topic starter
 

Is there a difference between the Data base credentials and the users in the resource's table ?

Data base credentials

root /

Users declared in table "resource":

admin / ****
guest /
*****


 
Posted : 04 Dec 2018 21H07
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Yes, credential to DB is different from credentials of each user.

Credential to db is correct (otherwise you would not have access to login page)

Login for admin uses default password "admin".
If this does not work, try and update table "resource", line with id=1 and name='admin', set password='admin', crypto=null.
Then connect with admin/admin.


 
Posted : 04 Dec 2018 23H23
(@jdi)
Posts: 9
Active Member
Topic starter
 

Thank you for your answer but i updated the password using the sql console or editing directly the field password.

Despite i put "admin", this password doesn't work with user "admin". I'm desesperated...


 
Posted : 05 Dec 2018 2H25
(@jdi)
Posts: 9
Active Member
Topic starter
 

I used this command in SQL command from PhpMysql console :

UPDATE resource SET `password` = 'admin' WHERE `id`='1' AND `name`='admin';


 
Posted : 05 Dec 2018 2H55
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

You must also set crypto to null

UPDATE resource SET `password` = 'admin', crypto=null WHERE `id`='1' AND `name`='admin';

 
Posted : 05 Dec 2018 11H18
(@jdi)
Posts: 9
Active Member
Topic starter
 

The field crypto seems not existing. Look this error message i obtain executing SQL command you gave me:

Erreur

Requête SQL :

UPDATE resource SET `password` = 'admin', crypto=null WHERE `id`='1' AND `name`='admin'

MySQL a répondu : Documentation
#1054 - Champ 'crypto' inconnu dans field list


 
Posted : 05 Dec 2018 14H15
(@emmanoueli)
Posts: 9
Active Member
 

Excuse for my intervention, I have the exact same issue. I have changed the password to admin or to another value with no result. Login page continues to respond "Invalid login parameters"

What else should i check ?


 
Posted : 05 Dec 2018 14H53
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Sure field crypto exists.
Try with

UPDATE resource SET `password` = 'admin', `crypto`=null WHERE `id`='1' AND `name`='admin'

 
Posted : 05 Dec 2018 18H12
(@jdi)
Posts: 9
Active Member
Topic starter
 

I tried this command without any success an other time. I have the same answer: the field dosn't exit 🙁


 
Posted : 05 Dec 2018 20H51
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

please show desc of table resource.


 
Posted : 05 Dec 2018 21H05
(@jdi)
Posts: 9
Active Member
Topic starter
 

Structure of table 'resource' as you asked.


 
Posted : 05 Dec 2018 21H30
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

This structure is valide for version ... V2.0.0
So your setup was not complete.


 
Posted : 05 Dec 2018 23H07
(@jdi)
Posts: 9
Active Member
Topic starter
 

I reinstalled the software using the latest stable version 3.0. Everything is ok. I'm really happy that it works now. Thank you a lot for your precious help !!!


 
Posted : 06 Dec 2018 5H43
Share:

Scroll to Top