DNN Security Roles Problem - Administration and Configuration

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

Home All Forums

Home

Using DNN Platf...

Administration ...

DNN Security Roles Problem

12/1/2015 5:00 PM

Joseph Craig

Joined: 7/24/2006

Posts: 1441

DNN Security Roles Problem

I have a DNN installation that doesn't want to assign some of the standard security roles to pages or modules.

The roles are: Subscribers and Unauthenticated Users.

If I go to a page or module and the Permissions section, these roles have not been assigned. The roles exist, and if I attempt to add them, they are not added, and no error is generated. I can add Unverified Users to a page.

Any ideas where I should look for this?

Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)

12/1/2015 5:05 PM

Joseph Craig

Joined: 7/24/2006

Posts: 1441

Re: DNN Security Roles Problem

I should have added that the Event Log shows entries like this one:

AbsoluteURL /Default.aspx DefaultDataProvider DotNetNuke.Data.SqlDataProvi

AbsoluteURL:/Default.aspx

DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke

ExceptionGUID:be389cf0-10fc-4b59-a5ab-6a8b9086f4ba

AssemblyVersion:7.4.1

PortalId:3

UserId:1

TabId:1293

RawUrl:/Home/ctl/Tab/action/edit/activeTab/permissionsTab

Referrer:http://ummedicareadvantage.org/Home/ctl/Tab/action/edit/activeTab/permissionsTab

UserAgent:Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36

ExceptionHash:hNEgJxt69kyO/fLtO0O+aA==

Message:Object reference not set to an instance of an object.

StackTrace:

InnerMessage:Object reference not set to an instance of an object.

InnerStackTrace:

   at DotNetNuke.Security.Permissions.PermissionProvider.DefaultImplicitRoles(Int32 portalId)
   at DotNetNuke.Security.Permissions.Controls.TabPermissionsGrid.GetEnabled(PermissionInfo objPerm, RoleInfo role, Int32 column)
   at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.BindRolesGrid()
   at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.BindData()
   at DotNetNuke.Security.Permissions.Controls.PermissionsGrid.AddRole(Object sender, EventArgs e)
   at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Joe Craig
Patapsco Research Group, Ellicott City, MD
DotNetNuke Development and Services (http://patapscorg.com)

12/3/2015 4:48 AM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: DNN Security Roles Problem

check the roles table, I provide a fix script for roles and one for permissions on dnnscript.codeplex.com, which might help to adjust data-

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

9/7/2018 10:41 AM

ROB AX

Joined: 9/3/2004

Posts: 2185

Re: DNN Security Roles Problem

Hi Sebastian, are you around?

I've got the exact same issue on my DNN 804 instance as Joseph has in this thread.

I've found and read many posts that refer to your script that inserts a dummy portal zero, but I find I am unable to run the script due to "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Portals_Roles". and it does that for each of the inserts. I'm wondering how i can run it and create the dummy portal. There's definitely a zero portal missing in my db. I'm hoping you might be able to tell me how to make it happen.

I'm also unable to use the proper reply editor in the forum here as it seems to be broken. So I'm using the quick-reply and hopefully it will work.

Regards
Rob

9/24/2018 3:57 PM

Sebastian Leupold

www.dnnwerk.de
Joined: 3/8/2004

Posts: 46212

Re: DNN Security Roles Problem

Hi Rob,

sorry, I just noticed your post. I was of the impression, that Portal 0 is no longer needed in DNN 8.0.4 - but I might be wrong.

I just checked a local install and could't find a foreign key "FK_Portals_Roles", only "FK_RolesPortals". Which columns does it link?

Cheers from Germany,
Sebastian Leupold

Speed up your DNN Websites with TurboDNN

Page 1 of 1

Home

Using DNN Platf...

Administration ...

DNN Security Roles Problem

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:

No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
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.
Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
No Flaming or Trolling.
No Profanity, Racism, or Prejudice.
Site Moderators have the final word on approving / removing a thread or post or comment.
English language posting only, please.

Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

DNN Corp. (DotNetNuke)