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

HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How to stop scam registrations - junk in profile?How to stop scam registrations - junk in profile?
Previous
 
Next
New Post
6/28/2014 1:42 AM
 
Bruce Chapman wrote:
@matthew - the registrations are obviously using some type of list of harvested email addresses, which is why they look like real users to the uninitiated. They also use generated usernames which look kind-of-real.

This is the script I used to soft-delete all the users that were spam registered:

update Users set IsDeleted = 1
where UserName = displayname and (LastIPAddress is null or LastIPAddress = '') and FirstName = '' and LastModifiedByUserId = -1
and CreatedOnDate > '2014-05-12'

The date was one in which I detected the spam registrations starting - this might be different for different sites. The definining signature of the spam registrations is the lack of activity after the registration. I would use a select statement with the same 'where' clause to see if it is picking up only the bot registrations and leaving your actual users alone.

 I tried this script on one of my sites and it didn't work.

Is there a script I can run that will delete all users that are not members of the "Administrators" security role and registered after a certain date?

Thanks


Hawaii Web Design and SEO by One Wave Designs
 
New Post
6/29/2014 2:23 AM
 
I have been able to use and after market module to delete 43,000 of the spam registrations, but they're not fully removed. Nothing I try removes them, not a module, not clicking on "Remove Deleted Users" nothing.
Any sql scripts I can run to just permanently delete ALL users? This is killing an important site.
Thanks,

Hawaii Web Design and SEO by One Wave Designs
 
New Post
6/29/2014 6:12 PM
 
Last question, I've made user registration "None" but they're still trying to login, which is tying up so much resources I can't delete all of the users.
How do I totally delete the login page so www.myurl.com/login.aspx

I've put a login module at a page within the site that has no links to it, so their bots can't find it (hopefully) but they're still trying at the normal /login.aspx
So how do I delete this page or at least remove the login control from it? Thank you

Hawaii Web Design and SEO by One Wave Designs
 
New Post
6/29/2014 8:39 PM
 
Hi Paul,

Bruce's article worked great for me. One thing I also did was use the Custom URL Rewriter module in IIS to do redirections for those specific login URL's. Though you could also make them 404-out.

HTH,
Kelly

Create simple forms or build complete module solutions XMod Pro is the best-selling forms and views module of all time.
 
New Post
7/10/2014 12:36 PM
 
I've seen more issues related to this. My client cleaned out 180,000 spam registrations. We made registration private and that has prevented any more coming in.

His site is *still* battered by requests for the registration page and also attempts to make profile updates. Presumably the bot comes back to freshen up the spam sites. This causing a massive rise in EventLog and SiteLog entries.

Finally we have 180,000 empty profile folders. :-( Whilst they don't hog much actual space they are annoying.

Best wishes,
- Richard
Agile Development Consultant, Practitioner, and Trainer
www.dynamisys.co.uk
 
Previous
 
Next
HomeHomeUsing DNN Platf...Using DNN Platf...Administration ...Administration ...How to stop scam registrations - junk in profile?How to stop scam registrations - junk in profile?


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