[SOLVED] Can't log into BO

[viktorsundberg]

I have a problem, I can't log inte BO any more. I get the message: "employee does not exist, or bad password" and I've searched for this on the forum, but havn't really found any solution. I have sent for a new password but that doesn't work either :/

Please help me, I have to be able to log in.

Ps: Tonight (when I could log in) I did change my theme and install the Swedish language again etc, can if have to do with that?

[shokinro]

Solution 1. Reset password at database directly.
You need to have access your database and permission to execute SQL

SQL statement

UPDATE ps_employee SET passwd = md5('_COOKIE_KEY_YOUNEWPASSWORD') WHERE email = 'YOUEMAILADDRESS';

_COOKIE_KEY_ is defined in config/setting.inc.php
YOUNEWPASSWORD is your new password
YOUEMAILADDRESS is the email address registered as employee

Solution 2. Bypass authentication, not recommended.
You need to have access your website source code.

change line 52 of admin/login.php file to bypass authentication temporary
line 52 before change

$employee = $employee->getByemail($email, $passwd);

line 52 after change

$employee = $employee->getByemail($email, NULL);

For more detailed, see
http://alvinjiang.blogspot.com/2010/09/prestashop-tips-admin-password-recovery.html

[shokinro]

If your problem has been solved, please mark this thread as "SOLVED" by adding "SOLVED" to the beginning of the subject of your first post.

[viktorsundberg]

Well i'm not sure if it is solved just yet, gimme a few. It might have been a cache thing...

[Kelvin Ong]

Hi,

I've similar problem, I've tried to access /config/setting.inc.php
I can only see the db details and no {UPDATE ps_employee SET passwd = md5('_COOKIE_KEY_YOUNEWPASSWORD') WHERE email = 'YOUEMAILADDRESS';}

Please advise solution.

Thanks & regards,

Kelvin Ong

[sn00]

@Kelvin you take only the value under ('_COOKIE_KEY_', 'THIS IS THE VALUE YOU NEED it looks like this -> avgix5nhD0rrACcBmccAjtNGGcwK3duAP0jK') and insert this value into SQL statement UPDATE ps_employee SET passwd = md5('_COOKIE_KEY(this is where you have to insert that long key)_YOUNEWPASSWORD') WHERE email = 'YOUEMAILADDRESS';

Hope it's more clear now

but actually this haven't worked for me don't know why, cause it should. Anyway...

I went for shokinro solution #2. Bypassed the authentication changed my password in the BACK OFFICE and then restored 52 line and that's it. Problem solved. Thanks a lot shokinro

[shokinro]

I am glad that my solution 2 worked for you, and thanks for your feedback.

[Ubaldo Gulotta]

I must read it