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:
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.