Thousands of empty customer records created every day

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
7 years ago
If you are using 3.80 make sure you have browscap.xml file in App_Data directory. For older versions, make sure you have a .ini file in App_Data directory.

To find appropriate file name check your web.config

3.80
 <!-- You can get the latest version of user agent strings at http://browscap.org/ -->
    <UserAgentStrings databasePath="~/App_Data/browscap.xml" />


3.70
    <!-- You can get the latest version of user agent strings at http://user-agent-string.info/ -->
    <UserAgentStrings databasePath="~/App_Data/uas_20140809-02.ini" />
7 years ago
shahdat45ict wrote:
If you are using 3.80 make sure you have browscap.xml file in App_Data directory. For older versions, make sure you have a .ini file in App_Data directory.

To find appropriate file name check your web.config

3.80
 <!-- You can get the latest version of user agent strings at http://browscap.org/ -->
    <UserAgentStrings databasePath="~/App_Data/browscap.xml" />



Hi the below is exactly what i have in my web.config file.


<!-- You can get the latest version of user agent strings at http://browscap.org/ -->
<UserAgentStrings databasePath="~/App_Data/browscap.xml" />


Any idea what else could be going wrong for causing so many guest hits!
7 years ago
I'm having this same problem.  I'm getting up to 45,000 records per day created.  I updated the browscap.xml file, verified the search engine accounts are in the customer file and are active, and verified the line of code for the browscap.xml file is in the web.config file.

The ip addresses that are causing the problem are:

202.46.48.x through 202.46.58.x
All from China

Is there any help for this yet?  I know somebody said you can buy and add on to block specific IP addresses but since this issue is going to affect every single user of NOPcommerce I was hoping there would be a patch or some other fix.

Thanks
7 years ago
Yes, the patch is planned for 3.90. But for now as a work around I'm using the IPblocker plugin. No other way that i found.

By the way 3.90 is around end of march.. and the IP blocker plugin trial is available for 30 days so.. you just need to live with the problem for 30 more days.. so don't expect much of help coming any sooner than 3.90 release.. ofcourse unless you buy the plugin to remove the 30 days limit..
7 years ago
Hi Guys,

WCF service don't send information about user-agent. So every request from service create a new empty customer and this is caused by the method SetWorkingCulture in the GlobalAsax.cs.
Andrei, it would be perfect if you add this line:
if (string.IsNullOrEmpty(this.Request.UserAgent))
  return;

PS. why set the client culture if you don't know what it is :)

Regards
Krzysztof
6 years ago
Hello,

Another solution might be using a DDoS protection, e.g. https://www.cloudflare.com/ddos/. CloudFlare has other several security products which may improve site security and do not take too much time to implement.

PS I do not work for CloudFlare ;-)
6 years ago
I'm stuck.

Have clean install of 3.9. Store is private and not accessible from the outside (so no bots creating guest accounts). "Delete guests" scheduled task is enabled and by the timestamps seems to be running at the scheduled interval. However, I have 242 guest accounts from all of my testing dated back to installation time. Other scheduled tasks run fine but not the "Delete Guests" task. Running the task manually does not produce and error and increments the last run timestamp but the records remain. :/ Something I am missing here?

Regards
6 years ago
Do they have anything in their shopping carts?
6 years ago
New York wrote:
Do they have anything in their shopping carts?


Only a handful. Maybe ten. I ran the maintenance task and that got rid of them. This morning there are more guests and judging by the timestamp, they are created every ten minutes. hmmm.

We have a monitoring service which checks for open ports. In this case port 80. This is creating the guest accounts. So if you have a monitoring service on the site, how can we exclude it?

And the second part is why the scheduled task does not get rid of this type of guest with no cart?

Regards
6 years ago
Found this thread and found that we have 15 million customers in our customers table. I found that we had the two system customers that were mentioned but noticing we are having around 100k new customers created each day. How do we go about cleaning this up and then trying to stop all the creations? We want bots to crawl our site like googlebot and bingbot but how do we resolve the rest?

We are having issues with our site going up and down and we cant find the exact issue but we are thinking it has to do with a plugin. I noticed the customer reminders plugin from foxnetsoft goes through abandoned carts and product reviews every 15 minutes and we were seeing issues around every 10 to 15 minutes. Wondering if that goes through the customers table?
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.