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.

how password are en...
 
Notifications
Clear all

how password are encrypted

7 Posts
4 Users
0 Reactions
8,334 Views
(@sogeti)
Posts: 135
Active Member
Topic starter
 
[#6090]

Hi,

Im searching how password are encrypted in the table [resource], column [password] in projeqtor database (mh5, sh256..)

Could you help me ?

Benjamin


 
Posted : 25 Jun 2019 11H45
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

They are encrypted in a non bijective way : you cannot decrypt passwords.
To check password, we encrypt password given by user with same method and compare result with stored encrypted value (it is same process as for credit card code)


 
Posted : 25 Jun 2019 13H58
(@sogeti)
Posts: 135
Active Member
Topic starter
 

Thanks for your reply.
For explication : We want to create a new application using informations in the report view (work planned, work imputed...) and use the login/password in the projeqtor database
This is why we want to use the same encryption method.


 
Posted : 25 Jun 2019 15H59
Paul Ghobril
(@envergus)
Posts: 46
Active Member
 

MD5


 
Posted : 25 Jun 2019 17H46
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

MD5

No, not so easy.
it is sha256 encryption of password with extra "salt" (randow key stored on user to reduce brute force attacks efficiency)

$this->password=hash('sha256',$paramDefaultPassword.$this->salt);


 
Posted : 25 Jun 2019 18H24
(@gohrner)
Posts: 74
Active Member
 

How about a future switch to the secure password hashing and verification functions PHP now offers?

https://secure.php.net/manual/en/function.password-hash.php https://secure.php.net/manual/en/function.password-verify.php

This will be significantly more secure, as sha256 hashes are comparatively quickly computed using modern graphics cards, allowing to break even non-trivial salted passwords just by brute-forcing them.


 
Posted : 26 Jun 2019 1H44
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Is there really any interest ?
We are dealing with Project Management Tool, not NSA nor Bank, nor credit card. 👿
Moreover, the passwords are stored in the DB, so best security will be to protect your DB access 😉
And you can also switch to LDAP authentication, or, since V8.1, SSO SAML authentication.


 
Posted : 26 Jun 2019 1H51
Share:

Scroll to Top