migrate magento to local xampp. Problem...

[yapchunhing]

I have installed xampp in Ubuntu and pump in the magento and the sql database. I experiencing difficulty to access admin url despite having configured the URL in SQL database. For the front end page, it is loaded fine. But, backend url is inaccessible and kept redirect to a https:// url.
I have no idea which part couldn't have gone wrong. Have already check file permission and .htaccess aspect, but still have no clues.

Anyone can advise?

[Damian Culotta]

Hi @yapchunhing,

Possibly your store was using SSL on production.

On your local database execute this query:

SELECT * FROM `core_config_data` WHERE `path` LIKE 'web/secure/use_in_adminhtml' 

If column value is equal to 1, please update that value to 0. (Then delete cache and try again to log in)

[joy1212]

Hi,

You can check following

1. Open up your admin panel (cPanel or other)
2. Go to phpMyAdmin (if MySql)
3. Find your Magento Database
4. Find table “core_config_data”
5. Look for the column  “web/secure/use_in_adminhtml”
6. Edit value, make it equal to “0”

Thanks

Jignesh Aakoliya

[yapchunhing]

Thanks. But, this solution doesn't work. Not found in SQL. I think it is at default value.
Correction: Magento community version is 1.8.1.0

What others possibility it can be other than the said configuration?

[joy1212]

Hi,

You can check your rewrite rule in .haccess ,it is possible that .htaccess redirect url to https url.

Thanks