#1
Hello everyone, I had an old DNN forum/portal running DNN 7 and an older version of YAF that fell victim to a massive spambot attack (over 50.000 accounts created) and I had to take it down for some time until I could resolve the issues.

Now it's back on, security issues tightened, upgraded to DNN 8.0.4 and latest YAF. However I have two issues:

a)Avatars are still not syncing with user profiles (they didn't sync before either, but now I'd like to try and fix that)
b)Deleting the spam accounts in DNN did not result in their removal from YAF. I plan to run

select * from yaf_user where [Name] not in (Select Username FROM Users) and userID>1

and run yaf_user_delete from each one. Is this the correct approach? Do I need to take something else into consideration?
Topic Starter
  • oldgeorge
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    52.4%
  • Joined: 05/12/2014
  • Posts: 4
  •  Greece
  • Location: Athens
#2
Originally Posted by: oldgeorge


a)Avatars are still not syncing with user profiles (they didn't sync before either, but now I'd like to try and fix that)



Did you see any issues in the YAF Event log?
Did you disabled hot linking on your server?

Originally Posted by: oldgeorge


b)Deleting the spam accounts in DNN did not result in their removal from YAF. I plan to run



Technically if you upgraded yaf after you upgraded dnn then when you delete a user in dnn it also should delete it in YAF. But is possible that the process changed in dnn. Its possible the injected Stored Procedure doesnt work anymore.


Originally Posted by: oldgeorge


select * from yaf_user where [Name] not in (Select Username FROM Users) and userID>1

and run yaf_user_delete from each one. Is this the correct approach? Do I need to take something else into consideration?



yes if you do that manually that would be the correct way.


UserPostedImage
  • tha_watcha
  • Rank: YAF.NET Project Lead
  • Reputation:
    Exalted
    100%
  • Medals:
    Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.
  • Joined: 06/03/2010
  • Posts: 4,034
  •  Germany
  • Thanks: 73 times
  • Was thanked: 1215 time(s) in 1040 post(s)
#3
Originally Posted by: tha_watcha

[
Did you see any issues in the YAF Event log?
Did you disabled hot linking on your server?


I'm seeing this:

Error while Syncing dnn userprofile with Yaf
System.NullReferenceException: Object reference not set to an instance of an object.
at DotNetNuke.Common.Utilities.UrlUtils.EncryptParameter(String value, String encryptionKey)
at YAF.DotNetNuke.Components.Utils.ProfileSyncronizer.SaveDnnAvatar(String fileId, Int32 yafUserId, Guid portalGUID, YafBoardSettings boardSettings)
at YAF.DotNetNuke.Components.Utils.ProfileSyncronizer.SyncYafProfile(Int32 yafUserId, YafUserProfile yafUserProfile, IUserData yafUserData, UserInfo dnnUserInfo, Guid portalGUID, YafBoardSettings boardSettings)
at YAF.DotNetNuke.Components.Utils.ProfileSyncronizer.UpdateUserProfile(Int32 yafUserId, YafUserProfile yafUserProfile, IUserData yafCurrentUserData, UserInfo dnnUserInfo, MembershipUser membershipUser, Int32 portalID, Guid portalGuid, YafBoardSettings boardSettings, Boolean ignoreLastUpdated)

And also this:

Error In UserCleanUpTask Task
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.SleepInternal(Int32 millisecondsTimeout)
at System.Threading.Thread.Sleep(Int32 millisecondsTimeout)
at YAF.Core.Tasks.UserCleanUpTask.RunOnce()


Originally Posted by: oldgeorge



Also, not sure what you mean about hot linking? Is it a particular DNN or YAF option?

Topic Starter
  • oldgeorge
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    52.4%
  • Joined: 05/12/2014
  • Posts: 4
  •  Greece
  • Location: Athens
#4
What version of YAF are you using?
UserPostedImage
  • tha_watcha
  • Rank: YAF.NET Project Lead
  • Reputation:
    Exalted
    100%
  • Medals:
    Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.
  • Joined: 06/03/2010
  • Posts: 4,034
  •  Germany
  • Thanks: 73 times
  • Was thanked: 1215 time(s) in 1040 post(s)
#5
YAF_DNN_223, upgraded from an early 2.0.X version
Topic Starter
  • oldgeorge
  • Rank: YAF Forumling
  • Reputation:
    Neutral
    52.4%
  • Joined: 05/12/2014
  • Posts: 4
  •  Greece
  • Location: Athens
#6
I uploaded a new build i hope the should fix the issue

https://github.com/YAFNE.../YAF_DNN_2.24.0-5801.zip 
UserPostedImage
  • tha_watcha
  • Rank: YAF.NET Project Lead
  • Reputation:
    Exalted
    100%
  • Medals:
    Medal of Honor: Portal Puzzle Master: Portal Puzzle Master for DNNMedal of Honor Key: Given to pillars of the community who are key players in the YAF community and project.DNN Master: DNN Module ManBug Killer Medal of Honor: Medal for being a kick-ass bug killer!Medal of Honor for the Support King: Support King! Amazing asset to the YAF.NET Community.
  • Joined: 06/03/2010
  • Posts: 4,034
  •  Germany
  • Thanks: 73 times
  • Was thanked: 1215 time(s) in 1040 post(s)
Forum Jump  
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved