Dtjytyk

Significance of Cersei's obsession with elephants?

Is CEO the "profession" with the most psychopaths?

How do I find out the mythology and history of my Fortress?

A letter with no particular backstory

An adverb for when you're not exaggerating

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

One-one communication

What order were files/directories output in dir?

How long can equipment go unused before powering up runs the risk of damage?

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

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

C's equality operator on converted pointers

Why weren't discrete x86 CPUs ever used in game hardware?

How can I set the aperture on my DSLR when it's attached to a telescope instead of a lens?

Did Mueller's report provide an evidentiary basis for the claim of Russian govt election interference via social media?

Why does 14 CFR have skipped subparts in my ASA 2019 FAR/AIM book?

What makes a man succeed?

Flash light on something

How to compare two different files line by line in unix?

How does Belgium enforce obligatory attendance in elections?

Is there hard evidence that the grant peer review system performs significantly better than random?

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

What does this say in Elvish?

What initially awakened the Balrog?

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♦ 25 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♦ 25 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