vBouncer: reduce server load by unsubscribing bouncing members from threads

vBouncer is a handy tool for busy forums (or those that do not require email verification) to control the amounts of bogus emails sent from and to your server.

What vBouncer does: vBouncer monitors your mail spool file, and identifies members responsible for large amounts of bounced emails. It then issues a PM warning, and when the unsubscribe threshold is met, it will will unsubscribe them for all threads, and sets them to the "no email" subscription level.

After a couple of runs, this should significantly reduce your server load.

Features:
o Manual or auto processing option
o Collect logs via IMAP/POP or mail spool file
o Custom filters to match patterns in bounced emails
o Uses vB's cron files (Scheduled tasks)
o Uses encrypted header for authentication (suggested by Paul M).
o Stats on members with bouncing emails, and error codes
o Tuning options
o Verbose cron logs for diagnostics
o Option to send PM warning prior to reaching the limit
o Option to send PM notifications after reaching the limit
o Option to change the member's subscription default
o Option to all thread subscriptions to "no email"
o Option to all forum subscriptions to "no email"
o Option to move offenders to a different primary usergroup
o Option to process 5.0.0/550 errors (email unknown) upon a single email, isntead of observing the bounce limit

Installation:
1. Extract the files into the corresponding directories (admincp => admincp, includes => includes)
2. Run the installation script in the admincp
3. Fill out the settings menu in the vBouncer section of the admin panel (see the how-to post below)
4. Import and activate the plugin file through the plugin manager.
5. Once ready, add the cron scripts to your scheduled tasks: vbouncer-collect.php (should be run daily, or more frequently) and vbouncer-clean.php (weekly, equal to Bounce limit period)
6. If you are using vB's SMTP email option, make sure to also enable the "-f" option.

Change log:

- August 12, 2005 v1.3 Update to the cron files to match new changes in vB's cron/tasks. To upgrade, just re-upload the contents of includes/cron.

- July 11, 2005 v1.2 Bug fix for some server/PHP setups; resolve aliases for return keys, otherwise some aliases would be considered forged.

- July 5, 2005 v1.1 Bug fix in standard report pattern matching

- July 4, 2005 v1.0 Added encrypted header for authentication (suggested by Paul M).

- July 3, 2005 v0.9.1 fixed a bug preventing IMAP/POP log collection.

- July 2, 2005 v0.9 added IMAP/POP option and custom filters file vbouncer.ini

- June 27, 2005 v0.5 Added custom header setting option, for re-written headers.

- June 26, 2005 v0.4 Found a way to make it work as a plugin, without code edits (thanks to Paul M)

- June 26, 2005 v0.3 No changes, just removed the plugin

- June 25, 2005 v0.2 Added NDR/Reply code errors to stats, and option to act upon 5.0.0/550 (user unknown)

- June 21, 2005: v 0.1 Initial release. Marked beta, but it's working fine on PostFix and SendMail. Need to hear from those who tried on QMail and Exim

[Eagle Creek]

Originally Posted by GNDI

Not at all



it is working when you manually use your "fake" e-mail address as sender, ex. when you use the "Send e-mail to users" function under "users" in admincp, then it is a powerful tool

Ok.. That's nice.
But of course I also want to use the notify-function.

[GNDI]

well then i suppose you re-write it all I wouldn't mind if you did

[Eagle Creek]

Originally Posted by GNDI

well then i suppose you re-write it all I wouldn't mind if you did

I can't my friend . Otherwise it was done already .

[CNBAforo]

Can`t even install it. Step 1 gives me this db error:

Database error in vBulletin 3.6.4:

Invalid SQL:
REPLACE INTO foro_phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'vbouncer', 'vBouncer', '1');

MySQL Error : Unknown column 'phrasetypeid' in 'field list'
Error Number : 1054

[dcevoclub]

Originally Posted by CNBAforo

Can`t even install it. Step 1 gives me this db error:

I get the same error.

[GNDI]

i remember there should be a solution to this issue earlier this thread, go search and you'll find it

[dcevoclub]

Originally Posted by GNDI

i remember there should be a solution to this issue earlier this thread, go search and you'll find it

i did search. and the only reply i found was the one above my last post. so i guess i'll start digging through all the pages.

[dcevoclub]

Originally Posted by GNDI

i remember there should be a solution to this issue earlier this thread, go search and you'll find it

Found it on like 19, however after step one now i get

Invalid SQL:
INSERT INTO settinggroup (grouptitle, displayorder, volatile) VALUES ('vBouncer', '999', '0');

MySQL Error  : Duplicate entry 'vBouncer' for key 1
Error Number : 1062
Date         : Wednesday, December 6th 2006 @ 11:13:48 AM
Script       : http://forums.dcevoclub.com/admincp/vbouncer_install.php?do=install&step=2
Referrer     : http://forums.dcevoclub.com/admincp/vbouncer_install.php?do=install&step=1

[GNDI]

Originally Posted by dcevoclub

Found it on like 19, however after step one now i get

Invalid SQL:
INSERT INTO settinggroup (grouptitle, displayorder, volatile) VALUES ('vBouncer', '999', '0');

MySQL Error  : Duplicate entry 'vBouncer' for key 1
Error Number : 1062
Date         : Wednesday, December 6th 2006 @ 11:13:48 AM
Script       : http://forums.dcevoclub.com/admincp/vbouncer_install.php?do=install&step=2
Referrer     : http://forums.dcevoclub.com/admincp/vbouncer_install.php?do=install&step=1

lol this is also described in a earlier post clean your DB for Vbouncer tables, and run the installer again.

The problem is that you all ready have run some of the installation.

[DannyITR]

I use vBouncer and I'm not satisfied. Its very limited in that it will only inform users who bounce emails from thread subscriptions. That means whenever I send out a mass email, all of those bounces are not caught by vbouncer.

Is it working properly?