Magento – How to restore Admin access for failed TLS/SSL

accessadminerrorssl

I was configuring Magento CE to use a SSL certificate. I navigated to Configuration / Web / Secure and enabled SSL. Then I did the wrong thing, I think. I changed the secure URL path to https://www.example.com/ and now I am locked out of the back end, showing “SSL connection error”. My website is up, but checkout is not working. I think. I have cleared the cache on my browser, and tried some others.

I did a search on the error, and the fix seems to be: to go into phpmyadmin, find core_config and change the value of web/secure/use_in_adminhtml from 1 to 0.

I cannot find the path web/secure/use_in_adminhtml. The closest I can find is web/secure/base_url. The post is from 2011, so it may have changed since then. You can read the post here http://www.magentocommerce.com/wiki/recover/ssl_access_with_phpmyadmin . I am using Magento 1.8 now. I have a very basic understanding of phpmyadmin, so am much more likely to stuff it further, so please advise me.

Best Answer

You are on right path.

The reason you are not finding the config path web/secure/use_in_adminhtml in the table is because it was never set in admin.

Only values that are adjusted, or have values saved will get set in the table. If they don't exist, the defaults will be used. Defaults can either exist from code, or via the respective module's config.xml in the <defaults> tag (or via the config.xml/local.xml in the etc folder as well)

Since you are using a ssl url, you would want to set the value to 1, not 0 (which is the default)

So, to solve you issue, you have two options:

a. Manually insert the entry for web/secure/use_in_adminhtml into your core_config_data table

The following SQL will do that for you:

INSERT INTO core_config_data (scope,scope_id,path,value) VALUES ('default',0,'web/secure/use_in_adminhtml',1);

b. Change the url in the table back to http://your.domain.com/ (remember the end slash)

In either case, clear the cache (manually by deleting /var/cache)

You should now be able to get back to admin.

Related Topic