Dfrnhjy

Does "shooting for effect" have contradictory meanings in different areas?

Trademark violation for app?

Lagrange four-squares theorem --- deterministic complexity

Why are vacuum tubes still used in amateur radios?

What is an "asse" in Elizabethan English?

What makes a man succeed?

If Windows 7 doesn't support WSL, then what is "Subsystem for UNIX-based Applications"?

Do I really need to have a message in a novel to appeal to readers?

The test team as an enemy of development? And how can this be avoided?

Project Euler #1 in C++

Most bit efficient text communication method?

How does light 'choose' between wave and particle behaviour?

Significance of Cersei's obsession with elephants?

How often does castling occur in grandmaster games?

How many morphisms from 1 to 1+1 can there be?

How does Belgium enforce obligatory attendance in elections?

Would it be easier to apply for a UK visa if there is a host family to sponsor for you in going there?

Karn the great creator - 'card from outside the game' in sealed

Flash light on something

Do wooden building fires get hotter than 600°C?

In musical terms, what properties are varied by the human voice to produce different words / syllables?

Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?

C's equality operator on converted pointers

Why is it faster to reheat something than it is to cook it?

Reset “Use Secure in Front End or Admin” in Database is not working

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have carefully follow instruction to setup SSL in Front-end and Admin panel by using

System -> Configuration -> Web -> Use Secure URLs in Frontend

and

System -> Configuration -> Web -> Use Secure URLs in Frontend

to "Yes"

After that I can't access my Administrator Panel anymore, it always redirected to https.

I have tried to revert the config. But still no luck, I also have change database table : core_config_data. web/secure/use_in_frontend and web/secure/use_in_adminhtml to 0 and web/secure/offloader_header is SSL_OFFLOADED.

Also, remove cache and session data. Still no luck.

I using Magento 1.9 and Nginx.

I got it, it was the Magento cache problem, somehow it was cache inside the folder /tmp/magento/var/cache of my Linux (not Magento tmp folder). After I delete it, I can finally access my adminhtml using HTTP.

magento-1.9 ssl https

share|improve this question

edited Jun 25 '17 at 2:06

Rafael Corrêa Gomes

4,73523366

asked Sep 21 '16 at 6:37

WilliamWilliam

613

bumped to the homepage by Community♦ 26 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How many stores are there?
  
  – Kalyan Chakravarthi V
  Jul 8 '18 at 13:12
  

  
  
  
  

add a comment | 

1

I have carefully follow instruction to setup SSL in Front-end and Admin panel by using

System -> Configuration -> Web -> Use Secure URLs in Frontend

and

System -> Configuration -> Web -> Use Secure URLs in Frontend

to "Yes"

After that I can't access my Administrator Panel anymore, it always redirected to https.

I have tried to revert the config. But still no luck, I also have change database table : core_config_data. web/secure/use_in_frontend and web/secure/use_in_adminhtml to 0 and web/secure/offloader_header is SSL_OFFLOADED.

Also, remove cache and session data. Still no luck.

I using Magento 1.9 and Nginx.

I got it, it was the Magento cache problem, somehow it was cache inside the folder /tmp/magento/var/cache of my Linux (not Magento tmp folder). After I delete it, I can finally access my adminhtml using HTTP.

magento-1.9 ssl https

share|improve this question

edited Jun 25 '17 at 2:06

Rafael Corrêa Gomes

4,73523366

asked Sep 21 '16 at 6:37

WilliamWilliam

613

bumped to the homepage by Community♦ 26 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How many stores are there?
  
  – Kalyan Chakravarthi V
  Jul 8 '18 at 13:12
  

  
  
  
  

add a comment | 

I have carefully follow instruction to setup SSL in Front-end and Admin panel by using

System -> Configuration -> Web -> Use Secure URLs in Frontend

and

System -> Configuration -> Web -> Use Secure URLs in Frontend

to "Yes"

After that I can't access my Administrator Panel anymore, it always redirected to https.

I have tried to revert the config. But still no luck, I also have change database table : core_config_data. web/secure/use_in_frontend and web/secure/use_in_adminhtml to 0 and web/secure/offloader_header is SSL_OFFLOADED.

Also, remove cache and session data. Still no luck.

I using Magento 1.9 and Nginx.

I got it, it was the Magento cache problem, somehow it was cache inside the folder /tmp/magento/var/cache of my Linux (not Magento tmp folder). After I delete it, I can finally access my adminhtml using HTTP.

magento-1.9 ssl https

share|improve this question

edited Jun 25 '17 at 2:06

Rafael Corrêa Gomes

4,73523366

asked Sep 21 '16 at 6:37

WilliamWilliam

613

share|improve this question

edited Jun 25 '17 at 2:06

Rafael Corrêa Gomes

4,73523366

asked Sep 21 '16 at 6:37

WilliamWilliam

613

share|improve this question

edited Jun 25 '17 at 2:06

Rafael Corrêa Gomes

4,73523366

asked Sep 21 '16 at 6:37

WilliamWilliam

613

edited Jun 25 '17 at 2:06

Rafael Corrêa Gomes

4,73523366

edited Jun 25 '17 at 2:06

Rafael Corrêa Gomes

4,73523366

asked Sep 21 '16 at 6:37

WilliamWilliam

613

asked Sep 21 '16 at 6:37

WilliamWilliam

613

1 Answer
1

active

oldest

votes

0

I can tell you one solution I dont know you have tried or not But you can try below solution

go to your mysql

fire this query SELECT * FROM mgnt_core_config_data WHERE path='web/unsecure/base_url'

and change your unsecure base url to your url without https, so it would be http://your_base_url

Try And let me know if it works

share|improve this answer

answered Sep 21 '16 at 7:01

Murtuza ZabuawalaMurtuza Zabuawala

12.7k73363

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you for you reply, I have tried to change the url to http, but still no luck
  
  – William
  Sep 21 '16 at 7:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You using any cdn ? if yes then try to purge that cdn
  
  – Murtuza Zabuawala
  Sep 21 '16 at 7:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I currently didnt use any cdn. By the way, this problem also occurred in Front-end pages which has any textbox or input such as Login and Signup page.
  
  – William
  Sep 21 '16 at 7:17
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f137347%2freset-use-secure-in-front-end-or-admin-in-database-is-not-working%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I can tell you one solution I dont know you have tried or not But you can try below solution

go to your mysql

fire this query SELECT * FROM mgnt_core_config_data WHERE path='web/unsecure/base_url'

and change your unsecure base url to your url without https, so it would be http://your_base_url

Try And let me know if it works

share|improve this answer

answered Sep 21 '16 at 7:01

Murtuza ZabuawalaMurtuza Zabuawala

12.7k73363

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you for you reply, I have tried to change the url to http, but still no luck
  
  – William
  Sep 21 '16 at 7:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You using any cdn ? if yes then try to purge that cdn
  
  – Murtuza Zabuawala
  Sep 21 '16 at 7:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I currently didnt use any cdn. By the way, this problem also occurred in Front-end pages which has any textbox or input such as Login and Signup page.
  
  – William
  Sep 21 '16 at 7:17
  

  
  
  
  

add a comment | 

0

I can tell you one solution I dont know you have tried or not But you can try below solution

go to your mysql

fire this query SELECT * FROM mgnt_core_config_data WHERE path='web/unsecure/base_url'

and change your unsecure base url to your url without https, so it would be http://your_base_url

Try And let me know if it works

share|improve this answer

answered Sep 21 '16 at 7:01

Murtuza ZabuawalaMurtuza Zabuawala

12.7k73363

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thank you for you reply, I have tried to change the url to http, but still no luck
  
  – William
  Sep 21 '16 at 7:06
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  You using any cdn ? if yes then try to purge that cdn
  
  – Murtuza Zabuawala
  Sep 21 '16 at 7:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I currently didnt use any cdn. By the way, this problem also occurred in Front-end pages which has any textbox or input such as Login and Signup page.
  
  – William
  Sep 21 '16 at 7:17
  

  
  
  
  

add a comment | 

I can tell you one solution I dont know you have tried or not But you can try below solution

go to your mysql

fire this query SELECT * FROM mgnt_core_config_data WHERE path='web/unsecure/base_url'

and change your unsecure base url to your url without https, so it would be http://your_base_url

Try And let me know if it works

share|improve this answer

answered Sep 21 '16 at 7:01

Murtuza ZabuawalaMurtuza Zabuawala

12.7k73363

share|improve this answer

answered Sep 21 '16 at 7:01

Murtuza ZabuawalaMurtuza Zabuawala

12.7k73363

answered Sep 21 '16 at 7:01

Murtuza ZabuawalaMurtuza Zabuawala

12.7k73363

answered Sep 21 '16 at 7:01

Murtuza ZabuawalaMurtuza Zabuawala

12.7k73363