vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Anti-Spam Options - [GlowHost] Spam-O-Matic - Spam Firewall stops forum spam (https://vborg.vbsupport.ru/showthread.php?t=248042)

JorgeX 10-29-2010 06:52 PM

Nothing, error.

GlowHost.com 10-29-2010 09:40 PM

@alpha1 if you have profile spam for users who are part of the group that is pending activation (e.g. those bots that did not click the email link) then permission them with lower options in that group so that they can do basically nothing. We don't allow such things especially signatures unless they are a member of the registered user group.

That stuff is all part of vBulletin, not this mod.

@JorgeX yes I can add it if it becomes a popular request sometime in version 2.

PossumX 11-01-2010 08:54 PM

Why are these errors occurring? the registrations are stopped, but I am getting these dB errors for some of them....
Code:

Invalid SQL:
  INSERT HIGH_PRIORITY IGNORE INTO glowhostspamomatic_remotecache(`date`, `data`, `is_spambot`, `field`) VALUES (now(), "HowardLumet", "0", "username");;
 
  MySQL Error  : MySQL server has gone away
  Error Number  : 2006
  Request Date  : Monday, November 1st 2010 @ 07:58:08 AM
  Error Date    : Monday, November 1st 2010 @ 07:58:46 AM
  Script        : >>removed<<
  Referrer      : >>removed<<
  IP Address    : >>removed<<
  Username      : HowardLumet
  Classname    : vB_Database
  MySQL Version :


Code:

 
Database error in vBulletin 4.0.8:
 
  Invalid SQL:
  SELECT DATEDIFF(NOW(), "2010-11-01 12:09:51") AS DAYS;
 
  MySQL Error  : MySQL server has gone away
  Error Number  : 2006
  Request Date  : Monday, November 1st 2010 @ 12:32:08 PM
  Error Date    : Monday, November 1st 2010 @ 12:32:52 PM
  Script        : >>removed<<
  Referrer      : >>removed<<
  IP Address    : >>removed<<
  Username      : Unregistered
  Classname    : vB_Database
  MySQL Version :

vBulletin 4.0.8, no other dB errors exist except these. Additionally, should there be an index on the glowhostspamomatic_remotecache table?, as there is none after install.

GlowHost.com 11-01-2010 09:11 PM

That is an error generated by the MySQL server not the script itself. The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection.

You can read more about this problem and ask your host to increase the timeout if it is set too low. There can be other reasons as well. Here is a link that explains the error.

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

As for the index, probably I will look at it a little closer later today and add it into the 2.0 version if its not there already.

PossumX 11-01-2010 09:21 PM

Quote:

Originally Posted by GlowHost.com (Post 2116914)
That is an error generated by the MySQL server not the script itself. The most common reason for the MySQL server has gone away error is that the server timed out and closed the connection.

You can read more about this problem and ask your host to increase the timeout if it is set too low. There can be other reasons as well. Here is a link that explains the error.

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

As for the index, probably I will look at it a little closer later today and add it into the 2.0 version if its not there already.

My database is highly tuned, and there are no timeouts that occur on anything except this mod. I have a deep DBA background and have tuned as much as can be on MySQL dB. This is not a shot at you, by any means, however, I am quite sure my dB parameters are all in proper order, and considering the tables for this mod are very small, a simple insert or select should not induce the classic "MySQL has gone away errors". The question remains as to why this is only occurring against tables for this mod. None are crashed, however, I will re-analyze & check to ensure I am correct.

Thanks for your response, along with this mod, it is quite effective.

<<update>> I increased the wait timeout too see if that addresses the issue, and will refine from there if it does.

rootsxrocks 11-04-2010 11:11 PM

I seem to be getting a lot of excess hits to my database from reported spammer IPs who are not logged but have a lot of page views this is causing long delays for legitimate users , will this mod address that ? As small as my forum is I hate to go to a virtual dedicated server to accommodate spammers. Or should I just blame Network solutions for their poor service since April .

GlowHost.com 11-05-2010 05:53 AM

Quote:

Originally Posted by rootsxrocks (Post 2118090)
I seem to be getting a lot of excess hits to my database from reported spammer IPs who are not logged but have a lot of page views this is causing long delays for legitimate users , will this mod address that ? As small as my forum is I hate to go to a virtual dedicated server to accommodate spammers. Or should I just blame Network solutions for their poor service since April .

Sorry, I am not following. Can you describe in more detail what you mean about hits to your database from reported spammers? Do you mean they are being blocked but still are looking at your site which is overloading it?

Why not block the IPs using .htaccess or if NetSol is that terrible, I know of a great host...

ekool 11-05-2010 02:55 PM

Quote:

Originally Posted by GlowHost.com (Post 2095386)
Anyone else?

Having the same issue. Actually, similar. The submit button does nothing when you click on it... doesnt appear to be "pressed" or anything.

VB 4.0.6

iwvnews 11-05-2010 08:14 PM

Spam-O-Matic has caught and nailed about 50 fake spammer registration attempts since I installed it. I could not be happier. I am running 4.0.8 and since I have installed the mod, not one phony spammer has gotten through, yet not one legitimate participant's registration has been blocked.

Thanks for the great spam-roller!

Gary V 11-05-2010 09:02 PM

+1 Great work!

Zombo 11-09-2010 02:40 AM

hi, is there a feature to scan the current database and remove spambots before the mod was installed?

leigh123@linux 11-11-2010 03:16 PM

There is a path error when checking the log

Quote:

2010-11-11 10:18:46 ********** weazuul Found in Akismet Database. Held for moderation: here it is http://pastebin.com/1FGA7SSC
http://forums.fedoraforum.org/adminc...e.php?do=posts

It has a extra modcp in the path

rootsxrocks 11-12-2010 02:08 PM

Quote:

Originally Posted by GlowHost.com (Post 2118176)
Sorry, I am not following. Can you describe in more detail what you mean about hits to your database from reported spammers? Do you mean they are being blocked but still are looking at your site which is overloading it?

Why not block the IPs using .htaccess or if NetSol is that terrible, I know of a great host...

I do not have any blocking Agents installed however like you said they are looking at the site and overloading the already over sold network solutions database. .
basically what I was asking is if this mod did the .htaccess function or would help to make it. I am still enough of a noob to not know how to do that yet.

I have turned my blog off because of the lack of mod tools and it attracts spammers like flies.

I think I read this before starting this comment but I also want to Know if there is a feature that will alert me to spam registered IPs with current members so I can go back and delete them.

rootsxrocks 11-12-2010 02:09 PM

Quote:

Originally Posted by Zombo (Post 2119739)
hi, is there a feature to scan the current database and remove spambots before the mod was installed?

yeah what he ask ?

sarangan 11-12-2010 06:39 PM

1 Attachment(s)
You forgot to change version number to 1.2.8 in xml file.

Brandon Sheley 11-12-2010 06:49 PM

just added this, hope it works :)

[high]* Brandon Sheley clicks install[/high]

GlowHost.com 11-18-2010 05:44 AM

Quote:

Originally Posted by Zombo (Post 2119739)
hi, is there a feature to scan the current database and remove spambots before the mod was installed?

No, because on very large boards that would mean submitting one query for each existing user to StopForumSpam.com. They have a 5000 query per day limit so that would end up getting the larger boards banned from using their service. Unless, we built in some queue mechanism to send batches of users for checking against their database, but that is a bit out of the scope of what we want to do with this mod, plus it is not nice to submit huge batches to a service like SFS.

Quote:

Originally Posted by leigh123@linux (Post 2120582)
There is a path error when checking the log

http://forums.fedoraforum.org/adminc...e.php?do=posts

It has a extra modcp in the path

That has been addressed in the upcoming 2.x series.

Quote:

Originally Posted by sarangan (Post 2121087)
You forgot to change version number to 1.2.8 in xml file.

Yes, that was addressed a few posts ago, but thanks for the reminder :)

GlowHost.com 11-18-2010 06:02 AM

Quote:

Originally Posted by rootsxrocks (Post 2120970)
I do not have any blocking Agents installed however like you said they are looking at the site and overloading the already over sold network solutions database. .
basically what I was asking is if this mod did the .htaccess function or would help to make it. I am still enough of a noob to not know how to do that yet.

I have turned my blog off because of the lack of mod tools and it attracts spammers like flies.

I think I read this before starting this comment but I also want to Know if there is a feature that will alert me to spam registered IPs with current members so I can go back and delete them.

This mod does not alter htaccess or ban any IPs. it checks a remote database for known spammers and prevents them from registering.

Permanently banning IPs is not usually a great thing since you can end up blocking legitimate traffic to your site.

rootsxrocks 11-18-2010 10:26 AM

Thank you, I didn't really think banning Ips was a great Idea but there are certily blocks that have no business on my local site.

It would be nice to have the ability to scan several users Far under the 5k limit, for example I currently have 256 users I suspect about 70 of them are bots. Perhaps there is a seperate tool that might do that.

GlowHost.com 11-18-2010 05:01 PM

Quote:

Originally Posted by rootsxrocks (Post 2123117)
Thank you, I didn't really think banning Ips was a great Idea but there are certily blocks that have no business on my local site.

It would be nice to have the ability to scan several users Far under the 5k limit, for example I currently have 256 users I suspect about 70 of them are bots. Perhaps there is a seperate tool that might do that.

You could create another usergroup in vBulletin and give that group low permissions like inability to do anything other than post, move those 70 users to the new group, then use the promotion system to change them to the regular registered members group after 10 posts or so that way you will be able to tell if they are doing anything bad or not because the only way they would get full permissions is by making legitimate posts. And I don't think many spammers or bots will waste their time writing 10 legit posts because it is easier to just find another forum to spam from.

The 2.0 version of this mod actually does that part automatically for new registrations. But no plans for making it process existing users as it is generally pointless to try to go back in time and out if old registrations even exist on the blacklist anymore, which they probably do not.

In my experience, in general your bot registrations are going to not be doing much of anything if you do not see spam from them within the day or so after they register.

rootsxrocks 11-19-2010 12:24 AM

thats true, and It puzzles me as to why they bother, they just become these old sleepers that skew the statistics and inflate the membership numbers.

scourge 11-23-2010 03:39 PM

1.2.7 works well on 3.8.6 Patch Level 1 with renamed admincp and modcp directories.

I downloaded 1.2.8 but my admin cp reports 1.2.7 installed.

GlowHost.com 11-23-2010 05:37 PM

Quote:

Originally Posted by rootsxrocks (Post 2123358)
thats true, and It puzzles me as to why they bother, they just become these old sleepers that skew the statistics and inflate the membership numbers.

Not all bots are spambots. Some are there to spread malware. That is why they are quiet.

rootsxrocks 11-25-2010 02:48 PM

Ahh, I do know that some malware misdirects google ads to display the smiley central banner, I hate that Ad HELLLLLLLLLLO

GlowHost.com 11-26-2010 01:05 AM

Quote:

Originally Posted by Loco.M (Post 2121091)
just added this, hope it works :)

[high]* Loco.M clicks install[/high]

I read something on google today says that it does work, posted by you :)

Can you confirm for the rest of us that you like it, or it has helped, or is useful in some way?

Feedback here is what drives this mod.

Everyone, Let us know what you think please :)

Alibass 11-29-2010 06:24 PM

Quote:

Originally Posted by GlowHost.com (Post 2125801)
I read something on google today says that it does work, posted by you :)

Can you confirm for the rest of us that you like it, or it has helped, or is useful in some way?

Feedback here is what drives this mod.

Everyone, Let us know what you think please :)

Since I've installed this mod my spammers have gone to zero. Not one have gotten past the registration much less a chance to post.

Cheers and thanks for sharing this great mod with the vB community. :):up:

torcidas 11-30-2010 07:17 AM

Since spamers are using almost standard emails i put only to search email and in that way until now (100 spamers) didn't break into forum...

And if someone break I have 10 messages without able to post URL. That should be enough to remove them.

Thnx for good work

Bluemax712 12-01-2010 01:10 PM

Installed on 4.07 ...amazed at how many spambots it has stopped in less than a day

but noticed in the logs a lot of email addresses which don't include an "@" symbol
yet they still get passed on to the vB registration system
is this normal?

Edit: never mind found answer in your previous post - hey i'm a noob :)
https://vborg.vbsupport.ru/showpost....9&postcount=92

Bluemax712 12-02-2010 12:10 AM

Additionally
Is there a way to get as good a log from the Vbulletin Registration system
as this mod provides?

tomarsyd 12-03-2010 02:30 AM

I am getting this:
"Spam-O-Matic Tagged ip - 95.67.80.146 REMOTE_ERROR: Unverfied but allowed by policy"

It still seems to be allowing the registration though it's a known spammer on stopforumspam.com

Any ideas as to the problem. I have both my akismet api key and my stopforumspam api key set in the configuration.

tomarsyd 12-03-2010 11:40 AM

This Mod is not working for me. As far as I can tell, I've got everything configured correctly. I'm close to uninstalling as the StopForumSpam mod worked well for me before.

Does anybody have any info on the REMOTE_ERROR posted above?

Thanks!

tomarsyd 12-03-2010 09:38 PM

Spammers are getting in so I had to uninstall. Was hoping for great things.

If that process would log what the error is and not just that there WAS an error it would be more helpful. I found the code where the error is getting thrown but I don't know enough about the expected contents of the call to stopforumspam.

I have the vbStopForumSpam standalone installed now. I had it before and it was working great, so I'll go back to it for now until I hear some feedback.

Bluemax712 12-04-2010 05:07 PM

Is there a way to have individual minimum postcount settings for keyword vs URL moderation?

It appears both are tied to this one setting:
Minimum postcount required to avoid keyword and URL moderation

ie: I would like to auto-moderate All user's posts for keywords
but only auto-moderate new member's URLs who are under minimum post count

GlowHost.com 12-05-2010 10:42 PM

Quote:

Originally Posted by tomarsyd (Post 2128672)
I am getting this:
"Spam-O-Matic Tagged ip - 95.67.80.146 REMOTE_ERROR: Unverfied but allowed by policy"

It still seems to be allowing the registration though it's a known spammer on stopforumspam.com

Any ideas as to the problem. I have both my akismet api key and my stopforumspam api key set in the configuration.

In your settings for either mod, you have it set to allow registrations if your server cannot connect to stopforumspam.com. You can disable registrations if you cannot connect to stopforumspam.com but then you probably will have no registrations at all.

My guess is your site is firewalled by the stopforumspam.com site itself, or your server is blocking stopforumspam.com

Ask your host to help you figure out why your server cannot connect.

Quote:

Originally Posted by apsrfvb4 (Post 2129275)
Is there a way to have individual minimum postcount settings for keyword vs URL moderation?

It appears both are tied to this one setting:
Minimum postcount required to avoid keyword and URL moderation

ie: I would like to auto-moderate All user's posts for keywords
but only auto-moderate new member's URLs who are under minimum post count

keyword moderation only works onusers who have not met the postcount minimum.

tomarsyd 12-06-2010 04:15 PM

Thanks GlowHost.

I posted my findings to this issue over on the SFS thread.

Here is a link for anyone who'd like to read on.

https://vborg.vbsupport.ru/showpost....&postcount=240

I will be reinstalling S-O-M for its extra features.

GlowHost.com 12-10-2010 10:04 PM

You are welcome, thanks for posting your results. S-O-M should not be affected by this problem as this setting is not an option. Though the SFS option is supposed to not rely on this option if CURL is not available. Perhaps something changes at the SFS site that requires CURL.

tommac3 12-12-2010 08:28 PM

Request for a new feature!
Can this flag a thread for spam IF ...
A new user creates a link in his signature ... and then posts.
OR
A new user adds a html link but doesnt post.

GlowHost.com 12-12-2010 08:34 PM

Auto-moderation does this already.

tommac3 12-12-2010 08:41 PM

Quote:

Originally Posted by GlowHost.com (Post 2133003)
Auto-moderation does this already.

Really ... it doesnt seem to be working for me.

The test I ran was :
1) create an account
2) post
3) change sig to include a link.

jezza101 12-12-2010 08:57 PM

JUst upgraded from 1.2.4 to 1.2.8 and I'm getting the error:

Warning: require_once(includes/functions_ghsom.php) [function.require-once]: failed to open stream: No such file or directory in [path]/register.php(333) : eval()'d code on line 4

Fatal error: require_once() [function.require]: Failed opening required 'includes/functions_ghsom.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/*MYACCOUNT*/public_html/*MYPATH*/forum/register.php(333) : eval()'d code on line 4

A user reported it when going through resgistration and I got it on the admin CP user page. Any ideas? I 1st tried to overwrite the original install then I uninstalled and reinstalled but still get the error. I have now disabled and the error has gone.

Any ideas what's going on? I can't live without this mod!


All times are GMT. The time now is 02:30 AM.

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.03513 seconds
  • Memory Usage 1,858KB
  • 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
  • (2)bbcode_code_printable
  • (17)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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