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.

Lost password for a...
 
Notifications
Clear all

Lost password for admin

3 Posts
2 Users
0 Reactions
19.9 K Views
(@personne001)
Posts: 3
Active Member
Topic starter
 
[#4752]

Hello,

I ve forgot my admin password (it s idiot i didn t notice it somewhere, i know). Is it possible to reset it somewhere ?

I ve found in Resources Database my username and i ve applied an SQL update at Projeqtor : UPDATE resource SET PASSWORD='newPassword', crypto=NULL
to try to reset Password ... But it didnt work. In the section Password (SQL Database) it s writing newpassword.

Thanks a lot

ES


 
Posted : 03 Nov 2017 0H09
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

You must update table resource, set password="yourpassword", crypto=null for your admin user (default is id=1)


 
Posted : 03 Nov 2017 1H23
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

This will work

UPDATE resource SET password='newPassword', crypto=Null, isLdpa=0 where id=1;

Then be sure to clean your browser cache and cookies and test.


 
Posted : 03 Nov 2017 10H19
Share:

Scroll to Top