Issues migrating local copy + reseting a password

[George Clooney]

So I have a local copy of prestashop (~Sites/shop) and my /etc/hosts set up so that 'localhost/shop' lets me develop on it. I'm ready to push it to the server, where its temporary spot is (http://66.206.84.189/~walnutci/shop). It isn't an entire site, just the shop sub-pages. The main site content will need to be static, so I need this contained within the 'shop' folder.

 

I tarred the thing up, moved it into my /shop subfolder, created an empty database of the same name as my local copy with a identically named user and permissions, imported the database (so I shouldn't have to mess with config/settings.inc.php) and...

 

Home page redirects me to localhost/shop, my local copy. So, I go try to log in to change it in Preferences > SEO&URL and http://66.206.84.189...hop/adminfolder properly forwards me to back-end log in. However, it's not taking my admin email and password. Same database != same credentials? I updated it with "UPDATE ps_employee SET passwd = md5('7uSpY718uKjnAOOH367gbVzzjm5StzLyfIBpSDsdI5FwxVq84UD4tPdMpassword') WHERE email = '[email protected]';" and zilch. I hit Enter at it refreshes the page, ignoring my input. The URL displays the email address I'm trying to log in with, but no red error. If I put in garbage for the password it throws the proper error "wrong password". My password, and manually updating it in the database work fine locally.

 

So, am I manually updating my admin password wrong? Can I hard-code the site URL somehow? I thought by keeping the folder names the same and using my Apache /etc/hosts I wouldn't run into any redirection errors (Friendly URLs are turned off, so there is no .htaccess anywhere).

 

Running 1.4.6.2. Mac OSX 10.7.2 locally, server is CentOS 5.7.

 

Thank you so much. This is my first time developing a custom theme for Prestashop and honestly coding the front-end, despite the occasional wrestling match with module positioning, has been a real joy.

 

Best,

 

Joel

[tomerg3]

Did you try to have PS regenerate the password for you?

[George Clooney]

Did you try to have PS regenerate the password for you?

 

I have. It regenerates one for me, emails it just fine, but continues to not accept the password. I hit Log In and it seems to just refresh the page. I tried this on the production site. Thanks though.

[George Clooney]

Alright. Was able to manually update ps_configuration table, setting ps_shop_domain = "66.206.84.189/~walnutci". Still can't log in. Are there security aspects of an installation that are dependent upon ones environment? Thx.

[tomerg3]

can you try to do a fresh install of PF and see if you can login to the BO, that would let us know if it is related to anything on your server, or the specific installation.

[George Clooney]

can you try to do a fresh install of PF and see if you can login to the BO, that would let us know if it is related to anything on your server, or the specific installation.

 

I did that back on 1.4.5 and upgraded to 1.4.6. Hope it's not the upgrade... I'll see if I can find time to do a fresh 1.4.6 install.

[George Clooney]

Fresh install of 1.4.6.2. I can now log in. Manually re-configuring my theme and products. Really annoyed. It has worked on this exact server before and I have no idea why the new copy is working... Alright - thanks man for the help troubleshooting.