Gsyfuy

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

Significance of Cersei's obsession with elephants?

What is the chair depicted in Cesare Maccari's 1889 painting "Cicerone denuncia Catilina"?

What order were files/directories output in dir?

Amount of permutations on an NxNxN Rubik's Cube

What makes a man succeed?

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

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

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

Dyck paths with extra diagonals from valleys (Laser construction)

What does this say in Elvish?

Does the Mueller report show a conspiracy between Russia and the Trump Campaign?

Is there public access to the Meteor Crater in Arizona?

Crossing US/Canada Border for less than 24 hours

Draw 4 of the same figure in the same tikzpicture

Random body shuffle every night—can we still function?

Intuitive explanation of the rank-nullity theorem

Should a wizard buy fine inks every time he want to copy spells into his spellbook?

What is an "asse" in Elizabethan English?

How to identify unknown coordinate type and convert to lat/lon?

Why do early math courses focus on the cross sections of a cone and not on other 3D objects?

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

How many time has Arya actually used Needle?

What is the meaning of 'breadth' in breadth first search?

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