Back office won't log in on my local computer after cloning from remote

[beoutside]

Hello,

 

I have a website on pre-production on OVH with Prestashop 1.6.1.10.

I want to clone it so I can use it on my local computer. I did it but it won't log in. The front is displaying correctly as the preprod website - except for the menu (a module added) that is broken on my local and not on preprod.

• I git cloned the entire website from the remote with ssh (.gitignore added after)
• I imported the database 
• I changed the seetings.inc.php file
• I removed the smarty cache file except the indexes

For the DataBase, I tried changing the URLs manually before importing and then I tried on PMA after the import.

I then touch the ps_employee table. I tried the solution I saw everywhere, that is to update the password with the cookie key in MD5, but it won't log in. I also changed the ps_employee password varchar to 64 because the cookiekey was too long but it didn't change anyting. I tried creating other employee but they won't log in too. I tried flushing the browser cache and cookies, changing browsers...

 

I don't know what's wrong.

[JeredBolton]

 

For the DataBase, I tried changing the URLs manually before importing and then I tried on PMA after the import.

 

Which URLs? In other words which tables did you update?

 

Have you disconnected your machine from the internet to prove that the site is being served locally and that login authentication is definitely being done locally?

[beoutside]

Which URLs? In other words which tables did you update?

 

Have you disconnected your machine from the internet to prove that the site is being served locally and that login authentication is definitely being done locally?

Thank you for your reply.

 

I updated a bit more than URLs but not the employee table at first. 

 

On ps_configuration :

• PS_SHOP_DOMAIN to localhost
• PS_SHOP_DOMAIN_SSL to localhost
• PS_SSL_ENABLED_EVERYWHERE to 0 because the remote has SSL (I also tried login before touching SSL but it didn't work)
• PS_SSL_ENABLED to 0
• PS_SHOP_ENABLE to 1

On ps_shop_url (1, 1, 'localhost', 'localhost', '/nameofthefile/', '', 1, 1);

 

Yes I tried disconnecting but it didn't do anything.

[beoutside]

I did it! I logged in!

 

I cloned the preprod website on the same ovh server on another file (and another subdomain).

I copied the database from preprod to this new website, changing the URLs and I changed the settings.inc.php file too.

When I went to the back office of the new website, the same problem appeared of course but I clicked password forgotten as I was online. A pity we can't do it on local (or can we ?).

I recieved the new password and was able to log in, I then changed this password to the one I want.

I went on PhpMyAdmin of the new website on the ps_employee table and copied the crypted key for the password, I paste it on the local database and I was able to log in on my local computer...

 

 

I tried to copy the crypted key before from the preprod database but it didn't work... 

Maybe the algorithm for the crypted key change everyday or hour (I don't know). That's why I was able to log with the crypted key that was just generated with the new website and not with the preprod one that is old.

Edited February 1, 2017 by beoutside (see edit history)

[JeredBolton]

Excellent! Glad you got it fixed.