Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How Do I Remove Force SSL on Entire Site via SQL2008R2 in DNN 6.2.XHow Do I Remove Force SSL on Entire Site via SQL2008R2 in DNN 6.2.X
Previous
 
Next
New Post
6/12/2014 2:47 PM
 

Our DNN site continues to redirect to HTTPS when moved to a local non SSL box for maintenance.
For our maintenance we have need to have the ability to browse the site without SSL.

We checked the web.config and there is no forcing of SSL within the file…

Therefore, our Question…. How do we remove the FORCE SSL flag via the SQL DB thus setting it to No SSL. In other words what DB query can we execute affecting the correct Table where SSL setting for the site is disabled.

Note: As a test we placed a simple aspx file in the root to test if the temp IP access worked… and it worked the file can be viewed without SSL…. However trying to access the main dnn default.aspx site still redirects to https://testipaddress/defautlt.aspx

Please advise…

Also if this is not the issue causing the site to redirect to https, please advise.
Thanks in advance.

 
New Post
6/12/2014 3:08 PM
 
DO NOT DO THIS ON A PRODUCTION SERVER - MAKE BACKUPS - ETC

UPDATE dbo.PortalSettings SET settingvalue='False' WHERE settingname WHERE settingname='SSLEnabled' OR settingname='SSLEnforced'
 
New Post
6/12/2014 3:54 PM
 
Thank You, However.... after I performed an extensive backup of the database(Backups before messing with SQL DB is always a good thing thanks for the disclaimer reminder.), I took a look at dbo.PortalSettings and found that both SSLEnabled and SSLEnforced are already set to False.
Ran the script anyway just to be sure.... Cleared browser cache, then tried to access the site on local machine via IP and still No DNN Web Site comes up.
Again for testing to make sure i wasn't missing anything, copied a simple HTML and aspx file and they came right up.

But unfortunately No Dnn Site came up.... it still tries to redirect to https://mylocalipaddres/default.aspx when it should just be http

Again thank you but please welcome everyone in the forum to advise on this one.

Still searching for a solution.

This is baffling....

 
New Post
6/12/2014 4:20 PM
 
is your production site perhaps behind a router/firewall that is using ssl-offloading?

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How Do I Remove Force SSL on Entire Site via SQL2008R2 in DNN 6.2.XHow Do I Remove Force SSL on Entire Site via SQL2008R2 in DNN 6.2.X


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out