Unable to log into back office

[irlguy]

Hi,

I installed prestashop today but I'm unable to log into the backoffice. I've read other posts on the forum regarding the issue but I haven't been able to solve the problem.

I've checked the permissions (I'm using cuteFTP) and the following folders are set to '777':
/config, /upload, /download & /tools/smarty/compile

The following folders permissions are also set to '777' as well as their subfolders:
/img, /mails, /modules, /themes/prestashop/lang & /translations

After checking the premissions I ran the install wizard. There were no errors or warnings during the install. When I was finished the install i deleted the '/install' folder and I renamed the '/admin' folder.

Next I tried to log into the back office but the following error message appeared: "employee does not exist, or bad password." When I tried to recover my password the following error message appreared: "this account doesn't exist"

My host is www.godaddy.com. Next thing I did was log into the mySQL Database in my www.godaddy.com account manager. I manually added myself as an employee in the 'ps_employee' table ,then I retried to to log into the back office. The "employee does not exist, or bad password" appeared again. This time when I tried to retrieve my password it says it has been emailed to me, however I no email arrived in my inbox. The following are the entries in the 'ps_employee' table:


id_employee: 1
id_profile: 1
lastname: *****
firstname: *****
email: *****
passwd: *****
last_passwd_gen: *****
stats_date_from: *****
stats_date_to: *****
active: 1

I'm not sure how to resolve the problem any further. Any help will be appreciated.


Regards,
Niall

[Patric]

The password in the passwd field mustn't be filled clearly, this must be a MD5 hash. Have a look here to learn how to create it :
http://www.prestashop.com/forums/viewreply/100141/

[irlguy]

How did you regenerate your MD5 hash ?

* Copy your cookie key from /config/settings.inc.php, for example :
zhNXco9AkmOMkXSA1UJvRLT0oy1K0bImRwhAjXHdIVexfO18ZyFzwsLL
* Go to http://www.md5.fr/
* In the field, paste the cookie key and type IMMEDIATELY after, without space, your password, for example :
zhNXco9AkmOMkXSA1UJvRLT0oy1K0bImRwhAjXHdIVexfO18ZyFzwsLLadminshop
* Generate the MD5 hash.
* Copy it.
* Paste it in the passwd field of the ps_employee table, for your admin user.

I am unable to follow the instructions in the link you sent. because i have no /config/settings.inc.php file.
My /config folder constists of the following files:

/config/config.inc.php
/config/index.php
/config/smarty.config.inc.php

I've checked all of these for a cookie key but cannot see one. Where should I go from here?

Regards,
Niall

[Patric]

This file is normally created during the install process. Verify the /config folder permissions and try a new install.

[irlguy]

I reinstalled and followed your instructions and it worked this time.

Thanks,
Niall

[gbaby]

YEAH! It worked for me too! Thx!

[KMiDigital]

No didn't work for me...I still can't access my admin panel

[Patric]

No didn't work for me...I still can't access my admin panel

What happens?
What did you do?

[KMiDigital]

Hi I did what they said above and I even tried the following:

update ps_employee set passwd=md5("hgI3M9S1Uv45wDqkqvGNYF.xAamJY9.zKpykqHCgCxE5m1ozAtQBjFIiprestashop") where email="[email protected]"

but still no joy and I know its the password I originally used.

It still won't let me in even when I change the password to something else?

[Patric]

But are you sure about the login ?
You should verify in the ps_employee table.

[KMiDigital]

How do I do that?

[Patric]

With PHPMyAdmin.
If you do not know that, you surely did not do what is mentioned in the #2 post of this topic.

[KMiDigital]

I did exactly what it said in post #2 and still no good?

[Patric]

So, if you can dothat, you can also open the ps_employee table and check if the username you use to log in is the good one.

Also, try to empty your cache and delete the cookie.

[KMiDigital]

Yeah checking on phpmyadmin the username is correct I have cleared my cache and deleted all cookies but I still can't get in?

[KMiDigital]

I used the following on another site and it worked without incident:

update ps_employee set passwd=md5(“hgI3M9S1Uv45wDqkqvGNYF.xAamJY9.zKpykqHCgCxE5m1ozAtQBjFIiprestashop”) where email=“[email protected]”

So not really sure why it hasn't worked this time?

[KMiDigital]

So what do I do if this won't work as the client has spent a lot of time adding data to the site and I need to get in to make changes before it goes live?

Is there a way of carrying out a fresh install without losing all the products and categories etc that the client has added so far?

:-S

[Patric]

There is no reason that you cannot regenerate the admin password by using the hack mentioned in the 3rd post of that topic.

Try from another browser/computer.

[KMiDigital]

I got it sorted,finally, not 30mins ago. I was updating the wrong file in phpmyadmin I should have been updating the ms_employee file and ps_employee so now everything works a treat

[mazzy2k]

Hi,

Sorry but i am new to this. My BO stopped letting me in, i have created an MD5 and found PS_employee but all the fields were empty.

I dont know what to do, and i do not really understand alot of what you are saying in previous posts. If you could help me it would be much appreciated.

M

[gdinari]

This should help, check this link out (here)

[mazzy2k]

Thank you for your help, i found this earlier and it worked! im back in. Could you explain why this happened? and can it happen again?

[gdinari]

I really cant say what caused it. Prestashop can be like the twilight zone sometimes. Maybe it was because of some conflicting codes or some hard code changes that you made. I like the flexibility of prestashop, but when you chop n screw the code you're gonna have problems.