You need to Register for free and Login to post a message in the forum.

Forum

Forums > Users Lounge > DNN Creative Articles
Subject: Issue 26 - Limiting Access Issue
Prev Next
You are not authorized to post a reply.

Author Messages
topoulos
Nuke Active Member
Nuke Active Member
Posts:30
23 Nov 2007 6:45 PM  
Hi guys, I've asked this in the other forums, so forgive me if I seem redundant, but I have a major problem.  After moving the user accounts page from the admin menu to it's own menu for site admins, the login and register links in the skin do nothing.  I researched and tried resetting the skin to the default.  Still the same issue.  I've tried removing all cookies in the cache.  Still nothing.  I've restarted the application.  Notta.  I looked at the portals table, and the logintabid is set to null.  Both areas can be accessed by directly going to http://louangel.com/Home/tabid/140/ctl/Register/Default.aspx and http://louangel.com/Home/tabid/140/ctl/Login/Default.aspx, so I know it's still all there.  Something must be wrong with the database since I've done this move.  Would moving the page back to the admin menu fix this, and if so, how can this be accomplished?  It did me no good to move the user accounts page to it's own menu anyway, because editing the user is restricted to all but actual administrators anyway.  This is only happening in the one portal, and I have 4.

Your help will be extremely appreciated.


Tony
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2371
24 Nov 2007 10:10 AM  
I would try moving the page back to the admin menu by reversing the changes that you made. If that doesn't work, I'm not sure what to suggest to you.
Joe Craig
DNN Creative Support
Subscribe to the website
topoulos
Nuke Active Member
Nuke Active Member
Posts:30
24 Nov 2007 10:37 AM  
Reversing the changes simply moves the page to it's own menu. I cannot figure out how to move it back to the admin menu. Before when I edited the settings for the page, it was set to no page as the parent page. now when doing this it simply sets the page to it's own menu. I am having other errors on the site now, as none of my xmod modules are working either, and the other sites have gone down as well. I will ask for a restore from powerDNN. I would highly recommend because of all this that user accounts not be an option for the limiting access tutorial.

Thanks
Tone
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3375
26 Nov 2007 5:40 AM  
I  added a reply to this question in your other forum post, which outlines how to move it back into the admin menu:
http://www.dnncreative.com/Forum/tabid/88/forumid/1/tpage/1/view/topic/postid/7469/Default.aspx#7485

I will add a note to the tutorial page stating not to apply this to the user accounts page, thanks,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
MrHappy
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:7
21 Jan 2008 1:40 PM  

I tried the Limiting Access procedure using the TABS page but it did not accomplish what I was trying to do so I tried to move the TABS page back into the Admin menu and it would not go. I cannot figure out how to move it back.

I read the note from Lee about accessing the database and moving it but I'm not that well versed with SQL Server 2005 (which is what I'm using) to move it back. Would it be possible to get a step by step outline on how to do that?

I would really appreciate your help! Thanks.
leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3375
22 Jan 2008 3:54 AM  
Open the tabs table in SQL Server
Look at the TabName column
find the entry 'Tabs'
You need to edit this item to match the other pages that are in the admin menu
ie. look at the parent ID - my install is 38 for the 'Site Settings' record, so also change the parentID in the 'Tabs' record to 38
(This places it back in the admin menu)

IconFile will be: icon_tabs_16px.gif
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
MrHappy
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:7
25 Jan 2008 4:20 PM  

I do not see what you are talking about here. Remember, I’m not well versed in MS SQL Server. I can install the server app., create a database and connect to it. That’s about the extent of my SQL knowledge.


So.....
 

I open up MS SQL server management studio,

 

Expand databases

 

Expand the target database

 

Expand “Tables”

 

Browse to the dbo.Tabs table

 

Expand the Columns folder

 

Scroll down to and select the TabName column

 

I right click on the TabName Column and select properties. Another window opens and nothing can be changed. It doesn't show anything about ParentID anyway.

 

I right click on the TabName Column and select Modify. A windows opens and the ParentID does not have a number. It shows a “data type” of “int” and a check box, that is checked to allow “Nulls”

 

I cannot find a place where I can change/modify the ParentID number.

 

What am I doing wrong?

 

Please help.

 

Thanks!
jncraig
DNN Creative Staff
Nuke Master II
Nuke Master II
Posts:2371
25 Jan 2008 7:59 PM  

Browse to the dbo.Tabs table


Right click on the dbo.Tabs table name and select "Open Table."

You will then be able to look through the data in the tabke and (very carefully, and only if needed) type over the entries that you need to change.

Then, click the red "X" in the upper right corner to close the table.  At that point, you should go back to your DNN site, refresh the pages and your changes should have taken effect. 

If you aren't sure, go to the Host Settings page and restart the application.
Joe Craig
DNN Creative Support
Subscribe to the website
tjthay
DNN Creative Magazine Subscriber
Nuke Newbie
Nuke Newbie
Posts:8
15 May 2008 11:27 AM  
This is a feature I would really like to provide to a segment of my clients. I am hesitant to grant full admin access to most clients as there is too much damage they can do in the site. For most of the popular functions (i.e., newsletters) there are affordable 3rd party modules that replicate the function. The only area I have not been able to replicate is the User Accounts area. Like above I tried to grant access to a limited admin role and messed everything up. Does anyone know of a good 3rd party module that would allow another role (other than admin) to access, update, edit roles, delete, etc. the User Accounts. Thanks in advance for any assistance.

Travis

leesykes
DNN Creative Staff
Nuke Master III
Nuke Master III
Posts:3375
19 May 2008 7:49 AM  
I have not come across one for user accounts, let us know if you find one,

Thanks,
Lee Sykes
Site Administrator
Subscribe to the website : DotNetNuke Video Tutorials : The Skinning Toolkit : DotNetNuke Podcasts

Twitter: www.twitter.com/leesykes

Lee Sykes's Facebook Profile
You are not authorized to post a reply.
Forums > Users Lounge > DNN Creative Articles > Issue 26 - Limiting Access Issue


ActiveForums 3.7

Latest Forum Posts

RE: Email Set UP per Portal by jncraig
I think that the answer depends on how email is configured at your host. You'll probably have to co...
RE: skin/container error load by jncraig
I would suggest checking permissions for directories. Does this occur only when you upload a skin...
RE: Add New Profile Properties by jncraig
Hmmm ... I don't have an answer. Does anyone else?
RE: No Access for me too by ristori
it is ok now. Thanks for this action.
skin/container error load by islandman
Has anyone else run across this error when loading skins or containers from site settings?I am using...
Email Set UP per Portal by islandman
How do I set up a unique email address per domain name off 1 hosting environment. for example...m...
RE: localhost Install issues by cdees
Lee: I wanted to follow up on this for anyone following this thread. I have been unable to solve t...
RE: Add New Profile Properties by WSI
HI Joe, The DNN version is 4.5.5. Thanks, Cliff
Change Skin on URL by vinita
Hi,Can the skin be changed based on the url used to access a portal. Multiple portal aliases may be ...
problem creating child portal by kabamaro
  Hello all i have 4 Aliases for my parent portal , lets call them X,y,Z,WIn all Aliases i can creat...
problem creating child portal by kabamaro
  Hello all i have 4 Aliases for my parent portal , lets call them X,y,Z,WIn all Aliases i can creat...
Best DNN portal ever! by derpir
I have been a subscriber since august 2008, and DNNCreative.com is simply the best DNN Portal, their...
RE: skinning trouble by derpir
Hello Yes could you be so kind and take a look att the htm-file and css-file.I would be very gratef...
Search function is not working by kishorpawar
I am using Seach module in my project but not working, i have set   host setting alsoHost --> Schedu...
RE: backend is changing from sql2005 to sql2008 by leesykes
hello,There should not be any code changes needed, but you'll need to make sure that SQL 2008 upgrad...
RE: skinning trouble by leesykes
Hello,I would need to see your code to help you with this one, you can zip up your files and attach ...
RE: Installing DotNetNuke 4.9.00 on VWD 2005 w/ SQL server 2008 by leesykes
I have run a test with SQL Server 2008 express and DotNetNuke installed in exactly the the same way ...
RE: Issue 39 Interview by leesykes
thanks Bill, glad it was useful, we will have a think about the best way to approach this,Thanks,
RE: Issue 39 Authentication by leesykes
yes I have a live site in 4.9.0 at it seems stable as well.
backend is changing from sql2005 to sql2008 by meenu
hi all advance thanks. in my DNN0408 website am using sql2005 as backend.now planning to remove sq...
AppTheory
RSS Feeds