Problem login in

[prestacad]

I have a website using Prestashop 1.4.4.0.

 

I installed Prestashop 1.4.4.0 on a local computer.

 

Created everything as live website. Installed with same email and password.

 

Imported the database on the local computer, with same name and suffix.

 

When I try to login the BO on local computer it says employee does not exist or invalid password.

 

Checked both databases and they are the same. Same employee, same password.

 

How do I fix this, how can I log in ?

 

How do I import the live database on local computer ?

 

Tried to get into the FO with http://localhost/admin and it tries to go on the live web site.

 

Looks like somewhere in the database it points to the live web site.

 

Where, who knows ? Anybody ?

 

 

Update:

 

Tried a different method but still having problems

 

Copied files from live server to local pc.

 

Changed settings.inc.php to point to database on local pc.

 

Was able to log in BO. Changed SEO & URL in preferences.

 

Problems I'm having : Quick access doesn't work.

 

When I try to go to FO, it still brings me to live website.

 

Is there another file that needs to be changed beside settings.inc.php ?

 

I cleared the history in Firefox and now it doesn't bring me to the live site but

 

get error : The page isn't redirecting properly

 

I'm guessing I need to change something else, but what ?

 

changed "redirect to Canonical URL" to "No," and getting better.

 

I'm able to connect to local site however it looks like a mess

 

no pictures, just writing and anything I click on get message object not found.

 

All I want to do is transfer my web site to my pc is there any easy way to do this without having so many problems ?

[prestacad]

I managed to find out what the problem was.

 

A wrong setting in the settings.inc.php file.

[jcmil]

Decided to experiment with upgrade & backup/restore in a WAMP.

Used EasyPHP 5.3.8.1 installed their preconfig'd 1.4.4.1

 

Imported my existing DB backup - lost ability to login - Employee does not exist or password is incorrect.

 

Cannot access BO with existing PW or WAMP preset PW.

 

Installed bare 1.4.4.1

access to BO OK

Upgraded to 1.4.5.1

- I am unable to login to BO

 

Wiped Dir, clean install of 1.4.5.1 into WAMP modules path with default PS db config.

imported my db - again I am unable to login to BO

 

Thus I can't access either the default installs' BO or my backups' BO (even if DB renamed or imported into default db as per "Connect to "phpMyAdmin" and select your current database

Unless you enabled the "Drop existing tables" option, you must delete all tables from your current database.

)......." method.

 

This is my settings.inc.php - what have I missed....?

<?php
define('_DB_SERVER_', '127.0.0.1');
define('_DB_TYPE_', 'MySQL');
define('_DB_NAME_', 'prestashop');
define('_DB_USER_', 'root');
define('_DB_PASSWD_', '');
define('_DB_PREFIX_', 'ps_');
define('_MYSQL_ENGINE_', 'InnoDB');
define('__PS_BASE_URI__', '/modules/prestashop/');
define('_PS_CACHING_SYSTEM_', 'MCached');
define('_PS_CACHE_ENABLED_', '0');
define('_MEDIA_SERVER_1_', '');
define('_MEDIA_SERVER_2_', '');
define('_MEDIA_SERVER_3_', '');
define('_THEME_NAME_', 'prestashop');
define('_COOKIE_KEY_', '1CyThz1MVpYQdJvsCGzame8uAbvteu20FK9VapqhIPo48B8WHgbqfPcn');
define('_RIJNDAEL_KEY_', 'hQ0v83m3RU5Puh170xmMJT6OHvfo0yno');
define('_COOKIE_IV_', 'uXKnPuTU');
define('_RIJNDAEL_IV_', 'TR/G7ogHqkVd/is/NA5xpQ==');
define('_PS_CREATION_DATE_', '2011-10-24');
define('_PS_VERSION_', '1.4.5.1');
?>

 

 

Wndering if this error would also occur in a live environment.

 

 

Why does db update kill BO access details & PW?

[jcmil]

Should have also mentioned

 

define('_DB_NAME_', 'prestashop');

define('_DB_USER_', 'root');

define('_DB_PASSWD_', '');

 

were adjusted to match the imported db but to no avail.

I cannot get into BO to try anything else.

[jcmil]

Seems the best I can hope for is to be bounced to the live URL once I add the DB backup.

 

Is this purely a WAMP issue?

I'd really like it fixed so I can test run installs & mods I would like to make.

 

Really don't want to be locked out of the live shop

On the positive side - I did try the autoupdater module to upgrade 1441 to 1451 & it worked perfectly. If only I could be confident about the DB as well...

[jcmil]

Following on with the log-in / DB restore/import issue.....

 

Is there no way PS will function fully in a WAMP?

If I created a DB in a WAMP install & then tried to use that DB on a live PS would it also fail & kill the login credentials on the live site? (I can't test this as I don't have a spare & expendable site at the moment.)

 

This seems to be a significant issue if one genuinely wants to test run a PS site in a WAMP, yet there are no responses to this thread....

[prestacad]

For PS to function with WAMP you have to do :

 

Copy all the files from the live environment. (do not use Ftp programs they have a file limit per folder)

Export live database with Phpmyadmin

Import database with Phpmyadmin on local environment

Modify settings.inc.php to point to local database

After logging into BO change setting in SEO & URL to point to localhost

 

 

If you just install PS on local enviromnent and import Database you'll get error :Employee does not exist or password is incorrect. even if you change file settings.inc.php

 

Haven't tried to upgrade yet

[jcmil]

Thank you so much for explaining that, the WAMP vs DB thing was bugging me big-time.

Guess it makes sense security-wise.

& I need to learn more about server code & routing!!