Thanks ScottA. I haven't upgraded to 3.0.3 yet, so I've put your instructions into the first post.

What does this mean:

[root@www cgi-bin]# ./vbouncer.pl
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .) at (eval 1) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ExampleP, Pg, Proxy.
at ./vbouncer.pl line 80

Incredible idea for a script - I've been starting to do this manually for the last few weeks to try and cut down on the 100's of messages I've been getting. I was starting to think about automating this, but had no idea where to start.

can someone just clarify what this means: (I presume I can just shove it in any directory that's not in the Apache tree??)
I'll probably move users into a 'moved on' usergroup automatically as well, as I don't want people posting on my board with an invalid address. I've already got this usergroup setup, together with an automatic warning at the top indicating they have been posting with an invalid e-mail address, and asking them to correct it. Members don't seem to mind, and are generally apologetic about this. It looks like automating this will be fairly simple looking at your script.

This means you're Perl is missing some required libraries, like DBD::MySQL. You might want to install them using CPAN.

Correct. It's best to not have it accessable through a browser.

Script works brilliantly. Have added the following sql updates which might be useful to others :

Find :
After, add :
qry4 cleans up any subscribed forums (instead of just subscribed threads)
qry5 moves any user who's e-mails bounce that is currently in usergroup 2 into usergroup 19.

Now I'm off to play around with Perl, and perhaps try to do some automatic e-mail processing routines (such as e-mail messages triggering forum posts! ) - What fun. :D

This sounds cool, and is just what I have been thinking about, well almost. Problem is, I have a paying user group, and I don't want them downgraded to another group. Also will users be upgraded to their previous user group after they fix their email addy?

qry5 above will do the downgrade on a per group basis, so wont downgrade your paying group if you dont want it to.

You cant really tell when someone fixes their e-mail, as no messages will be bounced - this would need to be done manually.

to scarry to install.

Can this be made instead to change "receive emails" from other members and admin? I am getting a load of email back from PM undelivered or other things.