[SOLVED] Moved Database now customers can't login

[notcrack]

Hey all, 

 

I have recently moved my database to a new site and the existing customers can't log in. Can someone please tell me what I need to change because this is causing problems all over.

 

Thanks

 

I went from 1.5.3.1 > 1.5.6.2

 

Everything else seems to work. 

 

I have also changed the URL slightly if that makes a difference. 

[El Patron]

did you move the database to a different ps installation?  each ps has different pwd encrypt keys...so if db moved to different installation then those keys would be different.

[notcrack]

I did move the database to a new installaion. Is there a way to resolve this?

 

Thanks boss

[El Patron]

using google search for moving customers to new installation,  I have to go so don't have the time to look for this now.

 

but there are fixes for this in the forum

[El Patron]

I can share before going to the movies with [spam-filter] that the values are in config/settings.inc.php..

[notcrack]

Hey El Patron, 

 

I think I've found what I need to change, but is it really as simple as putting the orignial cookie key and cookie iv into the setting.inc.php?

Would it harm it being on two separate sites??

 

Cheers boss. 

[El Patron]

Hey El Patron, 

 

I think I've found what I need to change, but is it really as simple as putting the orignial cookie key and cookie iv into the setting.inc.php?

Would it harm it being on two separate sites??

 

Cheers boss. 

 

I don't think it's going to be much of an issue...good luck!

[notcrack]

Last question I promise

 

Do I need to modify the RIJNDAEL_KEY and RIJNDAEL_IV as well. Some people say yes and some say no. 

 

Sorry for this, but I do really appreciate the help. 

[El Patron]

sorry, without doing the research you are (I did this a couple years ago), I would not know the exact change.

[notcrack]

Hey El Patron, 

 

Thanks for the help. Your advice has sorted this situation. 

 

For anyone who might have the same problems here is the process I went through to get this sorted

 

First of all you need to have a backup of your old config/settings.inc.php

 

In that file you will find some code that looks like this 

<?php
define('_DB_SERVER_', 'localhost');
define('_DB_NAME_', 'pruspa_YourDBName');
define('_DB_USER_', 'pruspa_YourDBName');
define('_DB_PASSWD_', 'S7P]4-JU77');
define('_DB_PREFIX_', 'ps_');
define('_MYSQL_ENGINE_', 'InnoDB');
define('_PS_CACHING_SYSTEM_', 'CacheMemcache');
define('_PS_CACHE_ENABLED_', '0');
define('_MEDIA_SERVER_1_', '');
define('_MEDIA_SERVER_2_', '');
define('_MEDIA_SERVER_3_', '');
define('_COOKIE_KEY_', 'n1v4q4q4kchz4zjv1jn1st2wdshw2qc9uxz3r8vam1ownuqsdotjvvmc');
define('_COOKIE_IV_', '6etby8h3');
define('_PS_CREATION_DATE_', '2014-02-26');
define('_PS_VERSION_', '1.5.6.2');
define('_RIJNDAEL_KEY_', 'WVxy1OLbv3sID4aHbfjhgNM05OZpZCBf');
define('_RIJNDAEL_IV_', 'BJ1B545iTmjFRrxQ2rhadw==');

You then want to copy

define('_COOKIE_KEY_', 'n1v4q4q4kchz4zjv1jn1st2wdshw2qc9uxz3r8vam1ownuqsdotjvvmc');
define('_COOKIE_IV_', '6etby8h3');
define('_RIJNDAEL_KEY_', 'WVxy1OLbv3sID4aHbfjhgNM05OZpZCBf');
define('_RIJNDAEL_IV_', 'BJ1B545iTmjFRrxQ2rhadw==');

Over to your new config/settings.inc.php

 

When you have done this you will need to redo your admin password so you can log in to the backoffice. 

 

Take your _COOKIE_KEY_ over to http://www.md5.cz/ and put it into the box provided. Then add your password on the end I.E

 

n1v4q4q4kchz4zjv1jn1st2wdshw2qc9uxz3r8vam1ownuqsdotjvvmcbackofficepassword and then hit the hash darling, hash button. 

 

Take the new md5 checksum and open your phpMyAdmin and select your database (If you don't know which is which it's the one named in your new settings.inc.php file under _DB_NAME_

 

Find the employee table and change the existing passwd entry with your new md5 checksum. Save the entry and the retry logging in. 

 

Hope this helps someone

[oxygen]

hi notcrack,

 

I am installing a new PS 1.6.0.5 and I need to move the customer database from 1.5.

 

I followed your steps which worked. I managed to login as a customer using the old password in PS 1.5.

 

However, when I am in My Account, I clicked the Home button at the bottom, and, the shop logo on the top, the whole screen gone blank, with the logo on top and a black stripe in the middle of the screen.

 

I cleared the browser cache and the Front Office returned. But the same problem appeared whenever I login as customer and click Home button or shop logo.

 

Interestingly the back office is not affected. 

 

I am not sure if you encountered this problem. I am using default-bootstrap theme.

 

Appreciate if you could help if you don't mind.

 

Thank you very much.

 

regards,

[El Patron]

 

hi notcrack,

 

I am installing a new PS 1.6.0.5 and I need to move the customer database from 1.5.

 

I followed your steps which worked. I managed to login as a customer using the old password in PS 1.5.

 

However, when I am in My Account, I clicked the Home button at the bottom, and, the shop logo on the top, the whole screen gone blank, with the logo on top and a black stripe in the middle of the screen.

 

I cleared the browser cache and the Front Office returned. But the same problem appeared whenever I login as customer and click Home button or shop logo.

 

Interestingly the back office is not affected. 

 

I am not sure if you encountered this problem. I am using default-bootstrap theme.

 

Appreciate if you could help if you don't mind.

 

Thank you very much.

 

regards,

 

 

 

please turn on errors anytime you get blank page...if you need help doing so: http://www.prestashop.com/forums/topic/224525-how-to-turn-on-error-reporting-for-debug-information/

 

if the issue has nothing to do with topic, i.e. not part of actual customer move...open new topic...

[lagoacity]

Hi, hi have the same problem when i change the cookyie_key he block my acess to BO can help me? also my customers can enter with is password's