vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Administrative and Maintenance Tools - vbStopForumSpam - known spammer lookup for new registrations (https://vborg.vbsupport.ru/showthread.php?t=176481)

skippybosco 02-09-2009 11:01 PM

Will do. Like magic it went away shortly after posting here yesterday..

pedigree 02-10-2009 06:55 AM

Then it almost certainly was due to the sfs mysql server running slow working with php/curl and mysql/vbulletin timeouts.

skippybosco 02-10-2009 07:29 AM

I'll leave the setting as is right now and if the problem comes back adjust the timeout to see what effect it has.

mmurtha 02-25-2009 03:04 AM

Hey pedigree,

When is this mod going to get to be the Mod of the month?

Lol, I have to admit it's one of the best spam fighters in this foum-bar none.

Btw, thanks a lot for that explaination you gave to Skipper for furture up grade. That helped me figure a couple of other things out.

skippybosco 02-25-2009 03:20 AM

mmurtha, agreed.. I've tried to campaign for motm a couple of times..

Love to see you take the rally for April!

pedigree 02-25-2009 10:33 AM

It would be nice to see a motm against the mod :) But as the rules state, Im not allowed to nominate it myself or /poke people into nominating or voting for it.

Just that people think its good enough for motm is a great pat on the back.

I am working on 0.7 (to be v1.0) but Im so very busy at work, have a young son and, shamefully, starting playing Evercrack 2 again.

boatswife 03-01-2009 11:17 PM

*Installed and voted*

Thank you so much and to wired1 for the plug in! By the time I installed and added the API key, I had one already in the log.

Peaches 03-02-2009 02:24 PM

Are there any known issues with vbulletin ver 3.8.0?

elrafei 03-02-2009 05:23 PM

Good work, thanks

BadgerDog 03-03-2009 11:45 AM

Just got this error when trying to read the last 15 entries in the log? :erm:

Quote:

<script language="JavaScript"><!-- // Start of AdSubtract JavaScript block; you can ignore this. // It is used when AdSubtract blocks cookies or pop-up windows.document.iMokie = "cookie blocked by AdSubtract";document.iMfe
What is it?

Never had a problem before, but more importantly, how to I clean it up and continue using this excellent mod? I'm unable to read past the 2nd item in the list.....

Thanks for any feedback... :)

Regards,
Badger

pedigree 03-03-2009 01:11 PM

Quote:

Originally Posted by BadgerDog (Post 1759213)
Just got this error when trying to read the last 15 entries in the log? :erm:
What is it?

Never had a problem before, but more importantly, how to I clean it up and continue using this excellent mod? I'm unable to read past the 2nd item in the list.....

Its a plugin in your browser I guess. Its nothing to do with the mod in vbulletin.

mmurtha 03-06-2009 08:02 PM

Hey Skippy,

Quote:

mmurtha, agreed.. I've tried to campaign for motm a couple of times..

Love to see you take the rally for April!
Consider it done then for April! I know I've been posting this Mod on other forums every chance I get. If a couple of us do that, people will install it and then see how good it really is. ;)


Hey Pedigree,

Quote:

It would be nice to see a motm against the mod But as the rules state, Im not allowed to nominate it myself or /poke people into nominating or voting for it.

Just that people think its good enough for motm is a great pat on the back.

I am working on 0.7 (to be v1.0) but Im so very busy at work, have a young son and, shamefully, starting playing Evercrack 2 again.
Yeah, I understand that you aren't allowed to rally people to vote, but this Mod is well worth it and then some to us who use it. I have thousands of spammers now in my logs and I've only been using this mod for a couple of months. It seems to me that the people who install it and use it could ralley for you. ;)

Btw, I knew you mentioned you were working on another update, and that's great! You'll get to it when you get to it, and I think most people know how valuable your times is too, so don't fret. It'll come. ;)

I wanted to ask you something to - Would you mind if I posted a link to your mod on my forum? I'm thinking of creating a mod section in one of the moduels in the left column. I'd love to post this one as the leading mod.


Mary

adamskiii 03-07-2009 01:49 AM

thank you. works great with 3.8.1

pedigree 03-07-2009 09:07 AM

mmurtha, you post away :)

Lahoria 03-07-2009 03:30 PM

Quote:

Originally Posted by adamskiii (Post 1762194)
thank you. works great with 3.8.1

nice then I will install it

BadgerDog 03-09-2009 11:43 PM

Has anyone else begun experiencing an inordinate amount of legitimate AOL members attempting to register on their sites, but the mod "bags" them as spammers?

Almost every one from AOL seems to get stopped because their IP address is in the database.

Is there a reason for this I'm missing?

Sure creates some unhappy campers and a lot of manual work adding them later after they complain and you find out they're legit.

Do the spammers have access to blocks of IP addresses that AOL uses and that's why we're seeing this?

Thanks for any feedback.... great mod btw ... :up:

Regards,
Badger

skippybosco 03-10-2009 12:05 AM

Quote:

Has anyone else begun experiencing an inordinate amount of legitimate AOL members attempting to register on their sites, but the mod "bags" them as spammers?
I do not see this in my environment, but each of our niches draws different users. If this creates a impact for you, you can set StopForumSpam from blocking on IP and still catch a number of spammers (31% of all blocked spammers on my site are from username (21%) and email (10%)

BadgerDog 03-10-2009 12:19 AM

I think I'll try that and see what happens ... :)

Thanks for the advice....

Regards,
Badger

pedigree 03-10-2009 10:48 AM

AOL forces most of its users out via proxy servers. As AOL do practically nothing to curtail spammers, innocents users are being caught up in that mess. If youre an AOL user, I think youll have to come to expect trouble in the future, not just for the sfs database but from projecthoneypot, spamhaus etc etc etc.

pyro.699 03-15-2009 03:03 AM

Any reason this wont work on 3.6.0? I tried installing it on a test board and it seemed to work fine.

skippybosco 03-15-2009 03:18 AM

I used the current version of this plugin (.61) on 3.6.0 for a while with no issues..

Alfa1 03-15-2009 02:57 PM

A lot of registrations are blocked because they seem to be using the name 'unregistered'. But it seems to be 1 in every 10 registrations. Something seems wrong. Do you have any idea what could be the problem?

Sym0n 03-15-2009 05:34 PM

Quote:

Originally Posted by Alfa1 (Post 1768737)
A lot of registrations are blocked because they seem to be using the name 'unregistered'. But it seems to be 1 in every 10 registrations. Something seems wrong. Do you have any idea what could be the problem?

I've not had this on the forum I admin. :confused:

Alfa1 03-15-2009 06:09 PM

Maybe its a conflict between this and vMail ?

jwocky 03-18-2009 04:17 PM

Quote:

Database error in vBulletin 3.8.0:

Invalid SQL:
INSERT HIGH_PRIORITY IGNORE INTO vbstopforumspam_remotecache (date, data, spambot, field) VALUES (now(), 'tvgxi489i@moreprobe.com', '0', 'email');;


MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, March 18th 2009 @ 06:10:18 AM
Error Date : Wednesday, March 18th 2009 @ 06:10:55 AM
Script : http://www.com/forums/register.php?do=addmember
Referrer : http://www.com/forums/register.php?do=register
IP Address : 116.32.228.134
Username : V4ibWDcO
Classname : vB_Database

I got this SQL error today.

Is there a possible SQL injection vulneralbility with this mod or an error with the code?

skippybosco 03-18-2009 10:19 PM

We've seen that error in the past:

Quote:

Originally Posted by pedigree (Post 1738844)
Im guessing that mysql is closing pages due to the unsually long period of time that its taking to query lookups due to the slow remote database server. If youre using cUrl for your lookups, try lowering the timeout period so that mysql doesnt close its connections or increase the timeout period for mysql.


pedigree 04-01-2009 09:44 PM

As the API is becoming very popular, more and more people are writing interfaces to it and some are very very bad. As some of the implementation do no caching, the API is getting hammered by some forums.

Because of this, we have had to add rate limiting (currently 1000 per day but thats not set in stone). This hasnt gone live yet but I will be checking how the mod will handle this.

Read more here http://www.stopforumspam.com/forum/t573-Rate-Limiting

Alfa1 04-03-2009 06:07 AM

I tried to update from 0.60 to 0.61 by uploading the product. This is the error that I got:
HTML Code:

Database error in vBulletin 3.8.2:

Invalid SQL:
ALTER TABLE vb5_usergroup ADD vbstopforumspamviewpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'vbstopforumspamviewpermissions'
Error Number  : 1060
Request Date  : Friday, April 3rd 2009 @ 09:00:57 AM
Error Date    : Friday, April 3rd 2009 @ 09:00:57 AM
Script        : /forum/admincp/plugin.php?do=productimport
Referrer      : /forum/admincp/plugin.php?do=productadd
IP Address    : xxx.xxx.xxx.xxx
Username      : Alfa1
Classname    : vB_Database
MySQL Version : 5.0.77


pedigree 04-03-2009 10:10 AM

You need to uninstall and reinstall the mod. Prior to 0.61, there is no upgrade path without a reinstall Im afraid.

You could edit the XML file and remove the line of code that does the sql query directly under that if you wish to maintain you logs. You dont need to upgrade from 0.60 to 0.61 unless you manually editted your templates to include the faulty vB conditions.

peterle1 04-03-2009 08:26 PM

Installed this as 0.61 but it only shows up as 0.6.
It doesn't seem to work with 3.8.1. Log is empty and today the first mail adress mentioned in the blacklist came through.

Any hints would be nice. Thanks.

skippybosco 04-03-2009 11:18 PM

peterle1, I have it working on 3.8.1 on one of my sites with no issue.

DFW Auto Club 04-07-2009 12:56 AM

I have 3.8.1 seems to work fine for me. Thx great mod. :)

gsk8 04-07-2009 12:10 PM

Anyone having any problems on 3.8.2 on this?

skippybosco 04-07-2009 12:22 PM

Not at all... working fine on 3.8.2

Titania 04-26-2009 08:33 AM

As others have mentioned, this is an AWESOME mod. In fact, it is probably the most useful mod I have installed, hence nominating it for MOTM.

I read elsewhere in this topic that there has been some recent issues with server response and I have been getting the "[REMOTEERR] Unverfied and rejected by policy" timeout on a number of registrations.
I do not have admin access to the server configuration with my host (shared server) so I am wondering if there is something I can do to reduce these errors from the client side?
I have access to MySQL and ftp access to the server (obviously) so if there is anything I can do with either editing any of the php files in this mod or something I can change in the database via MySQL, that would be very much appreciated.

Regardless of this issue, I still rate this as an essential mod. :up:

pedigree 04-28-2009 10:54 AM

This error presents itself when a couple of things happen.
1. Your forum cant contact the remote database in the allowed period of time
2. Our database is down (cough, it happens, I blame Russ :) )
3. Youve exceeded the (newly implemented) limit of 5,000 queries in a 24 hour period (which is unlikely).

Are you using cURL for doing the queries? Its one of the options in vbStopForumSpam configuration. With cURL, you can control the timeout time window a little more but thats often at the cost of risks a "mysql has disapeared" error.

Madmark 04-29-2009 11:05 PM

Love this mod. This is has kept the hundreds of spammers out everyday.

Savrik 05-02-2009 06:00 AM

Mod classification - MUST HAVE! Great Work! 10x!

Lowestoft Life 05-02-2009 11:40 AM

Does this work on vb 3.8.2 does anyone know?

thbertram 05-03-2009 01:18 PM

Works perfectly well on 3.8.2.


All times are GMT. The time now is 05:55 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02315 seconds
  • Memory Usage 1,827KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_html_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete