Error Meassage Shown "employee does not exist, or bad password"

[Heng]

My site was being hacked. I cleared all the data stored in the database and re-installed the whole prestashop.
However, this time, i was not able to log in and error meassage shown "employee does not exist, or bad password". There was no mail notification from prestashop though i had request during the system setup.
Please advise how to solve this problem

Cheers
Zimy

[andybr1ggs]

If you’re like me and you tried the “lost password” link on prestashop’s backend and never received the email, you might try this solution if you have access to the database. Look in config/settings.inc.php for the _COOKIE_KEY_ as you’ll need that. Run the following SQL and replace the <> variables with your information.

UPDATE employee SET passwd = md5(”<_COOKIE_KEY_>”) WHERE email = “youremailaddress”;

hope that helps



define('__PS_BASE_URI__', '/');
define('_THEME_NAME_', 'prestashop');
define('_DB_NAME_', 'chippedm_andy');
define('_DB_SERVER_', 'localhost');
define('_DB_USER_', 'chippedm_andy');
define('_DB_PREFIX_', 'ps_');
define('_DB_PASSWD_', 'YOUR PASSWORD HERE');
define('_DB_TYPE_', 'MySQL');
define('_COOKIE_KEY_', 'w7n3HwABF81c8KOFYGAuRav9I2TwjN0p3nXV4H0q56HEJFSJKXLiUTO4');
define('_COOKIE_IV_', 'RJMWMUsn');
define('_PS_VERSION_', '1.2.1.0');

[Heng]

Thanks for the info.
under the ps_employee table, the passwd field;
Type:varchar(32)
Collation:utf8_general_ci
Null:No
However, i'm not able to find the column for "variable", so that i can insert the password into it
Please advise!

[Heng]

Hi,

I'm still not able to solve the problem, i'm a novice in this.

Please guide me 'step by step', this would be very helpful to me.

Attached the ps-employee from my database.

Thanks
Heng

[HandyFR]

Hello Newcomer,

COOKIE_KEY: ‘hgI3M9S1Uv45wDqkqvGNYF.xAamJY9.zKpykqHCgCxE5m1ozAtQBjFIi’
New pass: myPasswordWith8Characters
Email: [email protected]

INSERT INTO ps_employee SET passwd=md5("hgI3M9S1Uv45wDqkqvGNYF.xAamJY9.zKpykqHCgCxE5m1ozAtQBjFIimyPasswordWith8Characters") WHERE email="[email protected]"

Password (new as old) must have at least 8 characters!

Handy

[Heng]

Hi Handy,

Still failed to solve the problem, same error message of “employee does not exist, or bad password” appear when logging in.

COOKIE_KEY: ‘wK3dFLohdXUrSCiYQY7dJk3roL8FRIOpEpy1EL9M6mOURsKrtLcAMAVb’
New pass: testing123456
Email: [email protected]

Input SQL query as shown below:

UPDATE ps_employee SET passwd = md5('wK3dFLohdXUrSCiYQY7dJk3roL8FRIOpEpy1EL9M6mOURsKrtLcAMAVbtesting123456') WHERE email = '[email protected]';

[HandyFR]

Hello Heng,

Try this one:

INSERT INTO ps_employee SET passwd=md5("ead3c46b93b49519c0badf5762879711") WHERE email="[email protected]"

Nota Bene:

New pass: testing123456
Email: [email protected]


Handy

[Heng]

Hi Handy,

Thanks a lot for your advise.

However, i still failed to solve the problem. Maybe i should brief you i have done.

- Log in to the database
- click on "SQL" button
- paste the (INSERT INTO ps_employee SET passwd=md5("ead3c46b93b49519c0badf5762879711") WHERE email="[email protected]") into the SQL coloum
- Submit

Go to my site login,
username: [email protected]
password: testing123456
Error message: employee does not exist, or bad password

Would be appreciating, if you could send me your personal e-mail add, so that i can send you all the details for my DB for your easy reference.

Thanks
Heng

[HandyFR]

Hello Heng,

Edit with phpMyAdmin and complete your "ps_employee" table as nice to be.

Please, look attached file!


Handy

[Heng]

Hi Handy,

Attached the file for ps_employee, however, we changing the value of null from 0 to 1, the following error message appears.

Error

SQL query: Edit

INSERT INTO `property666`.`ps_employee` (
`id_employee` ,
`id_profile` ,
`lastname` ,
`firstname` ,
`email` ,
`passwd` ,
`last_passwd_gen` ,
`stats_date_from` ,
`stats_date_to` ,
`active`
)
VALUES (
'1', '1', '', '', '', ' ', '2009-10-10 14:40:47', '2009-10-01', '2009-10-01', '1'
)

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

[Heng]

Hi Handy,

I've solved the problem.

Really thank you a lot.

Regards
Heng

[HandyFR]

Hello Heng,

Fill "lastname", "firstname", "email" and "passwd" fields:

"lastname" field: HENG

"firstname" field: Zimy

"email" field: [email protected]

"passwd" field need to be fill with this MD5 generated password: ead3c46b93b49519c0badf5762879711.

You can use this website to generate your MD5 password:

http://www.md5.cz/

Like that:

COOKIE_KEYNew_Password

For you, it's:

wK3dFLohdXUrSCiYQY7dJk3roL8FRIOpEpy1EL9M6mOURsKrtLcAMAVbtesting123456

Click on "Hash" button. Copy/Paste md5 checksum result on "passwd" field.

Handy

[Heng]

Hi Handy,

You have solved my problem, thanks a lot

Regards
Heng

[HandyFR]

Hello Heng,

It was a pleasure to help you!


Handy

[nikiton92]

Hi guys, I have the same problem. Ive tried to do all the things described, but nothing helps... Please, tell what to do.

[lilaspr]

Hi guys, I have the same problem. Ive tried to do all the things described, but nothing helps... Please, tell what to do.

i had this same problem too. i think there is a bug.
FINALLY this worked for me:
I had to leave the “send email notifications” checkbox at the bottom of step 4. shop configuration UN-CHECKED.
and don't upload logo file.

Later u can upload logo.jpg file in like this img/logo.jpg

Hope it helps u all.

Cheers

[nikmagnus]

Hi there,

This worked for me:
in phpmyadmin under the SQL tab,
type in:
UPDATE ps_employee SET passwd=md5("") WHERE email="[email protected]" then the "GO" button.

Worked a charm! thanks guys!
Nik