Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ...Trying To Force DNN 6.2.x to FORCE SSL page to "SECURE"Trying To Force DNN 6.2.x to FORCE SSL page to "SECURE"
Previous
 
Next
New Post
8/4/2014 6:24 PM
 
Reginald Thomas


www.extremefx.net
Joined: 8/2/2004
Posts: 220

Need some help on this one.

Recently in 6.2.x  even after you enforce SSL on the entire site, you often have to go to individual pages and click the check box AGAIN on each separate page as "SECURE". Which is very time consuming for larger sites... sure SSL in forced but some individual pages are still not SSL.

What would be a sure fix to force SSL on all pages without "Admin" having to go to every single page and clicking on the SSL check box under "page settings" again?

If possible, is there a DB script that can be run that would prevent me from having to physically go and change every single page to click the "Secure" checkbox?

Please Advise as soon as possible... 
Thanks..
 
New Post
8/4/2014 6:45 PM
 
Mike Ryckman


Joined: 4/17/2011
Posts: 519
Hello,

I might be wrong about this, but I think that "Enforce SSL" doesn't do what you're thinking... I think that it just means that DNN will force the user into the state set on the page. So, if you have "Enforce SSL" set, then a user who browses to a non-secure page over https will get it over http.

If that's right, then you'd need to just mark all the tabs as "Secure" - you're right that can be easily done with an SQL script. It would be a very simple script, actually... something like "update Tabs set IsSecure = 1"

But, you might hold off on executing that and see if somebody else has a different thought on this.

Mike
 
New Post
8/4/2014 7:34 PM
 
cathal connolly


cathal connolly's Avatar

www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676

What happens is when a page request is made DNN evaluates what protocol it currently is (i.e. http or https), and whether the page is marked as secured or not. It then uses the values for ssl enabled and ssl enforced to determine the final page url using these rules:

• if ssl enabled for a site and a page that is loading is marked as secure but is currently loading as http, it will redirect to the https equivalent

• if ssl enforced for a site, and a page that is loading is not secure but is currently loading as https, it will redirect to the http equivalent

In other words if a site is ssl enforced it will only load pages marked as secure via HTTPS, all other pages will load as HTTP

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US
 
New Post
8/5/2014 1:39 AM
 
Reginald Thomas


www.extremefx.net
Joined: 8/2/2004
Posts: 220
Okay understood and thanks for the explanation... but what would be the quickest way to mark all my pages as secure with a SQL script like Mike was saying?

I am aware I would have to back my site up first before running such a script but i like Mikes idea. I just need help with the exact SQL script syntax that would do the trick and mark all my pages as SECURE without having to go to each page. 

Please advise with a safe script I can use.

 
 
New Post
8/5/2014 2:52 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212
you may run the following statement in Host > SQL to enable SSL for all pages of a website (replace trailing 0 with ID of your website):
UPDATE {databaseOwner}[{objectQualifier}Tabs] SET IsSecure = True WHERE PortalID = 0
Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...Trying To Force DNN 6.2.x to FORCE SSL page to "SECURE"Trying To Force DNN 6.2.x to FORCE SSL page to "SECURE"


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