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

HomeHomeDNN Open Source...DNN Open Source...Provider and Extension ForumsProvider and Extension ForumsAuthenticationAuthenticationUpgraded to 4.5.1, and now site is down!Upgraded to 4.5.1, and now site is down!
Previous
 
Next
New Post
6/8/2007 1:49 PM
 

Before purging the domain accounts, I thought it "might" be useful to capture what the database says about a particular account beforehand.  So, I picked one user that I know wasn't able to work right, did SQL queries on all the relavant user tables and posted it here.  (Note: I change the user info to firstname/lastname to make it easier to decipher.)

dbo.users

UserID
Username
FirstName
LastName
IsSuperUser
AffiliateId
Email
DisplayName
UpdatePassword
30
mapsnet\flastname
Firstname
Lastname
False
 
flastname@DOMAIN.ORG
Lastname, Firstname
False
 
dbo.userroles
 
UserRoleID
UserID
RoleID
ExpiryDate
IsTrialUsed
EffectiveDate
64
30
1
 
 
 
65
30
2
 
 
 
 
dbo.userprofile
 
ProfileID
UserID
PropertyDefinitionID
PropertyValue
PropertyText
Visibility
LastUpdatedDate
16482
30
27
 
 
0
7/18/2005 6:51:03 PM
172354
30
21
Firstname
 
2
2/6/2007 4:10:55 PM
149096
30
33
 
 
0
7/18/2005 6:51:03 PM
8906
30
25
 
 
0
7/18/2005 6:51:03 PM
191299
30
28
 
 
0
7/18/2005 6:51:03 PM
88472
30
31
 
 
0
7/18/2005 6:51:03 PM
198875
30
29
 
 
0
7/18/2005 6:51:03 PM
46786
30
35
 
 
0
7/18/2005 6:51:03 PM
114999
30
21
Firstname
 
2
11/30/2006 1:29:22 PM
152884
30
32
 
 
0
7/18/2005 6:51:03 PM
202663
30
31
 
 
0
7/18/2005 6:51:03 PM
176146
30
23
Lastname
 
0
7/18/2005 6:51:03 PM
92260
30
33
 
 
0
7/18/2005 6:51:03 PM
58163
30
21
Firstname
 
0
7/18/2005 6:51:03 PM
156672
30
34
 
 
0
7/18/2005 6:51:03 PM
31634
30
31
 
 
0
7/18/2005 6:51:03 PM
206451
30
33
 
 
0
7/18/2005 6:51:03 PM
118791
30
23
Lastname
 
0
7/18/2005 6:51:03 PM
96048
30
32
 
 
0
7/18/2005 6:51:03 PM
27846
30
29
 
 
0
7/18/2005 6:51:03 PM
160460
30
35
 
 
0
7/18/2005 6:51:03 PM
61955
30
23
Lastname
 
0
7/18/2005 6:51:03 PM
210239
30
32
 
 
0
7/18/2005 6:51:03 PM
5117
30
23
Lastname
 
2
4/26/2007 3:24:09 PM
99836
30
34
 
 
0
7/18/2005 6:51:03 PM
122580
30
25
 
 
0
7/18/2005 6:51:03 PM
20270
30
28
 
 
0
7/18/2005 6:51:03 PM
164251
30
37
0
 
0
7/18/2005 6:51:03 PM
65744
30
25
 
 
0
7/18/2005 6:51:03 PM
214027
30
34
 
 
0
7/18/2005 6:51:03 PM
103624
30
35
 
 
0
7/18/2005 6:51:03 PM
126368
30
26
 
 
0
7/18/2005 6:51:03 PM
168043
30
38
 
 
0
7/18/2005 6:51:03 PM
50577
30
37
0
 
0
7/18/2005 6:51:03 PM
69532
30
26
 
 
0
7/18/2005 6:51:03 PM
107415
30
37
0
 
0
7/18/2005 6:51:03 PM
217815
30
35
 
 
0
7/18/2005 6:51:03 PM
12694
30
26
 
 
0
7/18/2005 6:51:03 PM
130156
30
27
 
 
0
7/18/2005 6:51:03 PM
54369
30
38
 
 
0
7/18/2005 6:51:03 PM
111207
30
38
 
 
0
7/18/2005 6:51:03 PM
133944
30
28
 
 
0
7/18/2005 6:51:03 PM
221606
30
37
0
 
0
7/18/2005 6:51:03 PM
35422
30
33
 
 
0
7/18/2005 6:51:03 PM
73320
30
27
 
 
0
7/18/2005 6:51:03 PM
137732
30
30
 
 
0
7/18/2005 6:51:03 PM
225398
30
38
 
 
0
7/18/2005 6:51:03 PM
77108
30
28
 
 
0
7/18/2005 6:51:03 PM
179935
30
25
 
 
0
7/18/2005 6:51:03 PM
24058
30
30
 
 
0
7/18/2005 6:51:03 PM
39210
30
32
 
 
0
7/18/2005 6:51:03 PM
141520
30
29
 
 
0
7/18/2005 6:51:03 PM
183723
30
26
 
 
0
7/18/2005 6:51:03 PM
1325
30
21
Firstname
 
2
4/26/2007 3:24:09 PM
80896
30
30
 
 
0
7/18/2005 6:51:03 PM
145308
30
31
 
 
0
7/18/2005 6:51:03 PM
187511
30
27
 
 
0
7/18/2005 6:51:03 PM
42998
30
34
 
 
0
7/18/2005 6:51:03 PM
84684
30
29
 
 
0
7/18/2005 6:51:03 PM
195087
30
30
 
 
0
7/18/2005 6:51:03 PM
 
dbo.userportals
 
UserId
PortalId
UserPortalId
CreatedDate
Authorised
30
0
27
7/18/2005 2:51:03 PM
True
 
 
 
New Post
6/8/2007 2:33 PM
 

And here is the same account after it was re-created: 

 

dbo.users
UserID
Username
FirstName
LastName
IsSuperUser
AffiliateId
Email
DisplayName
UpdatePassword
4820
DOMAIN\flastname
Firstname
Lastname
False
 
jlastname@DOMAIN.ORG
Lastname, Firstname
False

 
dbo.userroles

 
UserRoleID
UserID
RoleID
ExpiryDate
IsTrialUsed
EffectiveDate
105479
4820
1
 
 
 
105480
4820
2
 
 
 
105481
4820
43
 
 
 
 
dbo.userprofile
ProfileID
UserID
PropertyDefinitionID
PropertyValue
PropertyText
Visibility
LastUpdatedDate
230739
4820
21
Firstname
 
2
6/8/2007 2:07:56 PM
230740
4820
23
Lastname
 
2
6/8/2007 2:07:56 PM
 
dbo.userportals
UserId
PortalId
UserPortalId
CreatedDate
Authorised
4820
0
4836
6/8/2007 2:07:56 PM
True
 

 Notice a difference?  *grin*

If I had to take a guess, I'd say the DNN upgrade process is leaving a lot of excess account information laying around... 

 
New Post
6/12/2007 12:52 AM
 

Hi, I am having problems with Active Directory single sign-on in DNN 4.5.1. Users are not able to login automatically and now users are getting request timed out when accessing the WindowsSignin.aspx page. Can anyone confirm if upgrading to 4.5.3 will solve this problem?

 

 
New Post
6/12/2007 7:44 AM
 

Are you getting the same errors as described in this thread?  If so, then upgrading to 4.5.3 won't help.  It won't hurt (some bug fixes), but it won't solve log-in problems.

 
New Post
6/20/2007 2:23 AM
 
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Provider and Extension ForumsProvider and Extension ForumsAuthenticationAuthenticationUpgraded to 4.5.1, and now site is down!Upgraded to 4.5.1, and now site is down!


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