[DBTech] vBMail v2 (vB4)

[DragonByte Tech]

vBMail: What is it?
vBMail is a professional mailing list mod with Bounced Mail handling and advanced subscription management features.

Uses

vBMail is the perfect solution for any forum who wish to send out large quantities of mail to users on a mailing list. It lets admins and users have fine-grained access to subscriptions, and also automatically handles bounced mail.

-------------------------------------------------------------------------------------------

If you like this mod please hit the https://vborg.vbsupport.ru/external/2015/08/1.png button to the right ---->

Please remember to click the, https://vborg.vbsupport.ru/external/2015/08/2.png button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!
-------------------------------------------------------------------------------------------

Priority support & Product Demos available at: http://www.dragonbyte-tech.com/

-------------------------------------------------------------------------------------------

Translations available @ our forum (http://"http://www.dragonbyte-tech.com/f91/)
Support for translations handled by the translator in its respective threads only.

-------------------------------------------------------------------------------------------

Major Features:

Bounced Mail Handling: Once configured, it will (if so desired) automatically track and handle bounced mail. Alternatively, you can manually handle bounced mail if you so wish.

Automatic "Unsubscribe" Link Creation: If the user receiving the mail has access to unsubscribing, a secure link to unsubscribe themselves from the mailing list will be automatically added to the bottom of the mail. It does not require the user to be logged in, so it complies with spam policies set forth by mail providers.

Mail History: Each past sent mail can be viewed at any time from the front-end.

Advanced Subscription Management: Users can quickly and easily (un)subscribe from the mailing list via the mailing list directory, or the admin can manually change the subscription status in the AdminCP.

Bounced Mail Threshold: When an admin-configured number of mails bounce from the same email address, the user is automatically removed from mailing lists and all other email-related vBulletin features, and notified via PM what happened to their account, as well as directions to change their email addresses.

Complete Feature List (Lite)


Mailing List Directory

List all mailing lists
Links to send mail / view mail history / (un)subscribe
Unsubscription stats


Send Mail

Uses the full editor in vBulletin
Works with 4.1.4's CKEditor
Uses vBulletin's Mail Queue system to avoid overloading servers / avoid "maximum mails per hour" server restrictions


Mail History

Displays a list of all mail from that mailing list
View the mail in full HTML
Unsubscription stats


(Un)subscribe

One-click to add or remove from a mailing list


AdminCP

Create unlimited mailing lists with per-list usergroup permissions
Create keywords for people to subscribe to
View list of bounced mail
Prune list of bounced mail
Permissions for who can view unsubscription stats


Scheduled Tasks

Hourly collection of bounced mail
Hourly checks for number of bounces above the threshold




Complete Feature List (Pro)

Send Mail

Subscribe to an external mailing list via the vBulletin Sidebar (vB4 only)
Override SMTP settings per mailing list


AdminCP

Ability to create External mailing lists, powered by emails not found in vBulletin user accounts



-------------------------------------------------------------------------------------------
This mod displays a copyright notification in the footer of pages generated by this mod which includes:
1 Link to DragonByte Technologies homepage
1 Link to Product Description page of this modification

[Hornstar]

I'll be the first to reply saying awesome work! A mailing mod that complies with spam rules has been long needed by my community and this does that perfectly. Nice work!

I'm still on vb3 tho, so will a vb3 version be made as well :)

[BaanFarsang]

It make the mod of "product-blackthorn_whos_online_admincp" and some above link of "Check Version For All Hacks" have been disappeared.

[mokonzi]

I'll be the first to reply saying awesome work! A mailing mod that complies with spam rules has been long needed by my community and this does that perfectly. Nice work!

I'm still on vb3 tho, so will a vb3 version be made as well :)

I think it's on the cards. :)

[Kaspersku]

Nice work, it is useful !
I have a suggestion I want to translate your product into Vietnamese, Are you agree ?

[mokonzi]

I think translations can be uploaded to this forum: http://www.dragonbyte-tech.com/forums/91-Translations

Belazor or Decado would know more about it when they come back online, though I'm sure they'll welcome all translations. :)

[reddyink]

Can someone please educate me on the differences between this VbMail mod and ForoMail
https://vborg.vbsupport.ru/showthread.php?t=256110&highlight=foroMail

Thank you!

[yahooooh]

thanks i will test it

[Trek]

Can someone please educate me on the differences between this VbMail mod and ForoMail
https://vborg.vbsupport.ru/showthread.php?t=256110&highlight=foroMail

Thank you!

Support, coding practices and overall product quality. Those are the primary reasons I'd choose this mod. I can't say I've used ForoMail (as I got ripped off there on the last mail mod the author wrote and never got a reply when they moved to this one), but I have used the old mail mod and a couple other of those mods and well, the code is (IMO) really bad.

On the support aspect of things, the author of Foromail has (over the years) pulled her mods from vb.org a couple of times, rarely answers support questions on her site, always some reason (whether or not they might be valid is anyone's guess), but regardless of the reasons, support lacks there. (I just checked the foromail thread and the mod was free, but now isn't and this time there's yet another reason as to why, again, regardless of the validity of reasons, it's always SOMETHING)

Product Quality, DBT takes users suggestions into consideration and more often than not, they get implemented. They are fast to fix issues and honestly, are easily the best vB mod company I have purchased from (which is why I own many of their products).

These are just my personal opinions and observations from using the DBT products for over a year now I think and also from my personal interactions with their staff. Take 'em how you will. =)

[silpher]

how to send mail using it?

[kameraderie]

It will be cool to use this with a feature to send automatic Private Message notification to each users

[Alfa1]

Very nice to see somethign like this.

How does this addon decide which bounces to act upon? Is it only the number of bounces or does this actually check why an email is bouncing? Even if thats just for email delayed, inbox full and other trivial bounces?

What effect do bounces have on other vbulletin emails to the user? (birthdays, notifications, member email, etc, etc.) If it doesn't affect this, then it only decreases bounced email problems, but doesnt resolve it. Websites would still get blacklisted as spammers if email is still sent to inactive email accounts.

[mokonzi]

vBMail has a threshold feature, meaning an email address can bounce x amount of times before it will be unsubscribed. It uses the standard bounce header to control what it classes as 'real' bounces, but also (as it uses an IMAP email address) list all emails coming to the bounce email address and allows you to manually mark it as 'bounced' mail (for example mailbox full problems don't count as a bounced mail, but you could set it to bounced after the 72 hours mail that often comes).

Once it's marked a user as bounced and processed them (by hourly cron jobs) it then unsubscribes them from all mail lists AND turns off all the email related features within vB's standard install (I'm not sure how it would fare with any non DBTech mod's email features atm).

[DragonByte Tech]

1.0.2 Beta 3:
* Fixed a critical security issue regarding guest permissions

Fillip

[Ocean-Wonders]

Can you import a mailing list into it i.e a mailing list generated by vb ?

[TheLastSuperman]

* TheLastSuperman tags :D

[DragonByte Tech]

Can you import a mailing list into it i.e a mailing list generated by vb ?Not yet, in the future we will be looking to adding support for more types of mailing lists, and that's when we'll be looking at importers :)


Fillip

[Alfa1]

vBMail has a threshold feature, meaning an email address can bounce x amount of times before it will be unsubscribed. It uses the standard bounce header to control what it classes as 'real' bounces, but also (as it uses an IMAP email address) list all emails coming to the bounce email address and allows you to manually mark it as 'bounced' mail (for example mailbox full problems don't count as a bounced mail, but you could set it to bounced after the 72 hours mail that often comes).

Once it's marked a user as bounced and processed them (by hourly cron jobs) it then unsubscribes them from all mail lists AND turns off all the email related features within vB's standard install (I'm not sure how it would fare with any non DBTech mod's email features atm).
Thanks Mokonzi. Thats very helpful. Could you elaborate on how it use the bounce header to define a bounce? Does it look for certain phrases? Many bounce headers do not have useful information anymore these days and many email providers use their own system/way to alert about bounced email.

Once vbmail marks a user as having an invalid email account, then is there a possibility for the admin to restrict the account? Such accounts are mainly from inactive users or from spammers / trolls.
My site benefited greatly from restricting accounts with inactive email addresses. Spam and trolling went down drastically.

[doopz]

Great! Will be testing this out later this week

[DragonByte Tech]

Thanks Mokonzi. Thats very helpful. Could you elaborate on how it use the bounce header to define a bounce? Does it look for certain phrases? Many bounce headers do not have useful information anymore these days and many email providers use their own system/way to alert about bounced email.The most common form of bounced mail is one that sends back all the headers that were sent with the original mail.

vBMail adds a specific header which it then checks for in the bounced mail body. If found, it does some validation checks, and if it's valid it flags it as a bounced mail.

Those bounces that do not follow this standard are either discarded (Automatic mode) or flagged as Unknown Mail (Manual mode).

For maximum "cleanliness" you would set it to Manual mode, then manually edit each mail that did not follow the aforementioned standard, ensuring the mail address is correct (for instance, mails that have been delayed 24/48/72 hours will show as originating from Mailer-Daemon@yourdomain.com instead of the bouncee) and setting the bounce flag to yes.

Once vbmail marks a user as having an invalid email account, then is there a possibility for the admin to restrict the account? Such accounts are mainly from inactive users or from spammers / trolls.
My site benefited greatly from restricting accounts with inactive email addresses. Spam and trolling went down drastically.That is not currently possible, due to the fact that there's a chance for false positives (i.e. people using their own domain name's emails, and their site had a temporary problem, or their data center has issues receiving mails from any IP from another data center - this is a real concern, we had this exact issue with Mokonzi himself over there) which would have an adverse effect on a forum.


Fillip

[Alfa1]

Thanks for your explanation.

[DragonByte Tech]

vBMail v1.0.3 (Gold)
* Feature: "Can View Mailing List" permission that acts as an override for the "Cannot View Mailing List" permission for those with strange usergroup matrices
* Change: There's now a link to the Manage Keyword Subscriptions page in the footer of an email
* Change: Moved permission checks out of the mailinglist_bit template to make updates easier


Fillip

[maximutt]

Can anyone post some screenshots of what a finished newsletter looks like using this mod?

Thanks. :)

[DragonByte Tech]

Any way you want them to look :)


Fillip

[DragonByte Tech]

vBMail v1.0.4
* Fix: Users with "Receive Admin Emails" turned off will no longer receive any emails regardless of their subscription status, for real this time.
* Fix: Valid Fields error on saving UserCP options

Fillip

[wampforum]

Can I ask whether its possible for people to sign up to this mailing list without been a forum member?

[DragonByte Tech]

It is not, though a future Pro version will support external mailing lists :)


Fillip

[Alecsmith]

Tagged for now will install after upgrading VB 4.1.4 :D

[stemmy]

Why does the cron job return a fatal error even though all my email settings are correct ??

[DragonByte Tech]

I don't know, you didn't post an error message so I can't advise.

Fillip

[stemmy]

Warning: imap_open() [function.imap-open]: Couldn't open stream {mail.photography-forum.org:143/imap}Inbox in [path]/dbtech/vbmail/includes/class_imap.php on line 98

Fatal error: Could not open the connection to the mailbox, please check your configuration. in [path]/dbtech/vbmail/includes/class_imap.php on line 103

This is the beginning then pages of text following - sorry for not posting earlier. - i can PM you the whole text if you need it.

[DragonByte Tech]

Please try alternative settings, like the IP address, and/or use port 993 with SSL enabled.

Fillip

[stemmy]

Swaping to port 993 with SSL has removed the error - brilliant support Fillip :)

[DragonByte Tech]

v1.1.0
* Feature: "Last Mail Sent" column in the Mailing List directory
* Fix: Saving options in the UserCP didn't always work as intended

Fillip

[Vick98]

When I used this mailing mod I didn't see an option to 'Preview'. Is this option available?

[DragonByte Tech]

Unfortunately not, no :( It's something we'll be looking to add to a future version :)


Fillip

[Vick98]

Unfortunately not, no :( It's something we'll be looking to add to a future version :)


Fillip

Thank you the reply and I am looking forward in seeing it in an update. Excellent mod!

[BCP Hung]

@DragonByte Tech : I got an data error when use : http://forum.domain/vbmail.php (direct link), please give me a solution :
Database error in vBulletin 4.1.4:

Invalid SQL:
SELECT mailid, subject FROM dbtech_vbmail_mail WHERE mailid IN();

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Error Number : 1064
Request Date : Sunday, July 17th 2011 @ 06:05:00 PM
Error Date : Sunday, July 17th 2011 @ 06:05:00 PM
Script : http://forum.domain/vbmail.php
Referrer : http://forum.domain/forum.php
IP Address : 123.45.678.900
Username : User Name
Classname : vB_Database
MySQL Version : 5.0.92-community

[DragonByte Tech]

For those who upgraded to v1.1.0, there was an issue with the installer not working correctly on vBulletin 4.x systems.
To fix the database errors you will be encountering, please perform the following steps:

1) In your Product Manager, edit the vBMail product and set the Version Number to 1.0.4 manually.
2) Re-download the product
3) Re-import the new product XML file

Sorry for the inconvenience :(


Fillip

[DragonByte Tech]

@DragonByte Tech : I got an data error when use : http://forum.domain/vbmail.php (direct link), please give me a solution :
Zip updated :)


Fillip

[BCP Hung]

For those who upgraded to v1.1.0, there was an issue with the installer not working correctly on vBulletin 4.x systems.
To fix the database errors you will be encountering, please perform the following steps:

1) In your Product Manager, edit the vBMail product and set the Version Number to 1.0.4 manually.
2) Re-download the product
3) Re-import the new product XML file

Sorry for the inconvenience :(
Zip updated :)
Thanks for update ! It work correctly !

[CharlieDelta]

I have upgraded to the new version and when I "view subscribed users" or "view unsubscrided users" the usernames a blank.
Will I have to recreate these mailing lists?

[mcyates]

Just added a mailing list with everyone subscribed by default. Wrote and email sent it, received nothing. Also when I look at the "[View Subscribed Users]" all it shows is [Unsubscribe] instead of a username and it says there are 1,433 total entries.

Any ideas?

Thanks

[CharlieDelta]

Just added a mailing list with everyone subscribed by default. Wrote and email sent it, received nothing. Also when I look at the "[View Subscribed Users]" all it shows is [Unsubscribe] instead of a username and it says there are 1,433 total entries.

Any ideas?

Thanks

Same here. It was working fine before the update.:confused:

[DragonByte Tech]

I'll release an update today to address this.

Fillip

[CharlieDelta]

I'll release an update today to address this.


Fillip

Great! Thanks Fillip. :D

[DragonByte Tech]

vBMail v1.1.1
Feature: Unsubscribe stats on the Mailing List and Mail History pages
Feature: New Per-Mailing List permission for who can see Unsubscribe stats (default to off for all)
Fix: (Lite) Mail sending and viewing subscribed users will no longer fail due to incompatibility with a Pro-only feature
Fix: (vB4) Database errors for the early adopters of v1.1.0 who were hit with an incorrect installer file

Fillip

[mcyates]

Just added a mailing list with everyone subscribed by default. Wrote and email sent it, received nothing. Also when I look at the "[View Subscribed Users]" all it shows is [Unsubscribe] instead of a username and it says there are 1,433 total entries.

Any ideas?

Thanks

Still have these problems with the new update.

I uninstalled and installed it. The problem still exists!

Cheers

Michael

[DragonByte Tech]

I forgot to mention, you need to edit and save each mailing list you had created prior to this problem arising in order for the fix to take effect.

Fillip

[DragonByte Tech]

vBMail v1.1.2
Fix: Unsubscribe link will now properly allow for per-mail unsubscribe stats.

Fillip

[TEMPESTADE]

tanks for this update!

[CharlieDelta]

When I used this mailing mod I didn't see an option to 'Preview'. Is this option available?
Fillip please seriously consider adding this. No, actually please add this. This is a great mod but this feature would make it spectacularific!! :D

[dai-kun]

Does the bounce mail work on e-mail confirmation links and other stock vb features? Thanks

[CK]

When a users email is removed from the mailing list and a PM is sent, can you nominate the account this is sent from? With Foromail it was hard coded to be UserID 1, took me a while to find the relevant code.

[DragonByte Tech]

Does the bounce mail work on e-mail confirmation links and other stock vb features? ThanksNot currently, no.

When a users email is removed from the mailing list and a PM is sent, can you nominate the account this is sent from? With Foromail it was hard coded to be UserID 1, took me a while to find the relevant code.It will show to the end-user as coming from themselves.


Fillip

[CK]

Not currently, no.

It will show to the end-user as coming from themselves.


Fillip

Ah smart :)

Can the newsletters be automatically generated like the way Foromail worked? You could just set some options and then schedule a recurring email once a week or whatever.

[DragonByte Tech]

Not currently, it's one of the planned features for the future though.

Fillip

[CK]

I'll keep an eye on this then, thank you for answering my questions. Tagged.

[Scalemotorcars]

Will this mod include any forum details automatically.

New posts
New members
Polls
CMS content

You get the ideal, or do I have to add all those myself?

I was using Commbul but since the upgrade it stopped working for me.

[DragonByte Tech]

It does not add any such details no, we plan to make Widget support for content like that as a Pro feature in the future :)


Fillip

[sgbmad]

Installed but guest users can view everything!! :(

Also, in the settings page of any mailing list does not appear the guest group...

How I can fix it?

(fresh install 1.1.2 version)

[Scalemotorcars]

Thanks Fillip.

[sc123]

is it to possible to automatic email a post?

[DragonByte Tech]

Installed but guest users can view everything!! :(

Also, in the settings page of any mailing list does not appear the guest group...

How I can fix it?

(fresh install 1.1.2 version)This is intended behaviour, so there's no fix :)

is it to possible to automatic email a post?Not in the current version, no.


Fillip

[sgbmad]

This is intended behaviour, so there's no fix :)

Not in the current version, no.


Fillip

Then, is there no way to have a mailing list "private" for certain groups?

I think it would be very interesting for many communities.

Thanks.

[DragonByte Tech]

I believe there is, but I'll look into it for the next version :)
There's no ETA for the next version yet.


Fillip

[sgbmad]

Thanks Fllip.

[pedroenf]

Hi. I've installed this mod and when trying to ad a mailing list got this error:

Database error in vBulletin 4.1.5:

Invalid SQL:
INSERT INTO vbdbtech_vbmail_mailinglist
(title, description, active, displayorder, ownerid, fromemail, external, permissions, bitfield)
VALUES
('Mailing List', 'A mailing list that notifies people of wonderous things.', '1', 10, 0, 'mail@mail.com', '0', 'a:14:{i:7;i:89;i:5;i:89;i:11;i:89;i:23;i:89;i:12; i:65;i:2;i:65;i:13;i:65;i:9;i:65;i:21;i:65;i:20;i: 65;i:6;i:89;i:25;i:89;i:10;i:65;i:19;i:65;}', 1);

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

Could you help me?

[DragonByte Tech]

Run this query:
ALTER TABLE vbdbtech_vbmail_mailinglist ADD `external` ENUM('0', '1') NOT NULL DEFAULT '0'


Fillip

[pedroenf]

Thanks fillip, that worked for the mailing list ad. But another problem came up. When trying to change one user email in the CP this MySQL error showed up:

Database error in vBulletin 4.1.5:

Invalid SQL:
UPDATE vbuser SET
### Bitfield: vbuser.adminoptions ###
adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
usertitle = '<font color=#C8ABDE size=2><b>G6 Iniciado</b></font>',
customtitle = 0,
email = '********@live.com',
languageid = 0,
birthday_search = '****-**-**',
birthday = '**-**-***',
referrerid = 0,
joindate = 1220931960,
lastactivity = 1221240900,
lastpost = 0,
dbtech_vbmail_bounceflag = '0',
membergroupids = ''
WHERE userid = ******;

MySQL Error : Unknown column 'dbtech_vbmail_bounceflag' in 'field list'
Error Number : 1054
Request Date : Monday, August 15th 2011 @ 12:00:27 AM
Error Date : Monday, August 15th 2011 @ 12:00:27 AM
Script :
Referrer :
IP Address : *********
Username : PedroEnf
Classname : vB_Database
MySQL Version : 5.5.15

Even when the plugin is disabled the error persists.


PS: Tested after the last plugin update

[DragonByte Tech]

Are you using a 3rd party plugin manager? It looks like your product manager is incapable of correctly running install scripts :p

You might want to try a reinstall.


Fillip

[pedroenf]

And another one when editing the mailing list activating the Default Subscribed or creating one with Default subscribed field selected:

Database error in vBulletin 4.1.5:

Invalid SQL:

INSERT IGNORE INTO vbdbtech_vbmail_subscription
(userid, mailinglistid)
(
SELECT userid, 1 AS mailinglistid
FROM vbuser AS user
WHERE (
FIND_IN_SET(6, membergroupids)
OR usergroupid IN(6)
)
AND user.dbtech_vbmail_bounceflag = '0'
);

MySQL Error : Unknown column 'user.dbtech_vbmail_bounceflag' in 'where clause'
Error Number : 1054
Request Date : Monday, August 15th 2011 @ 12:20:20 AM
Error Date : Monday, August 15th 2011 @ 12:20:21 AM
Script :
Referrer :

MySQL Version : 5.5.15


Too many errors in the plugin. I would like to try it before consider buying it but probably will unninstall it. Sorry :(

[pedroenf]

Are you using a 3rd party plugin manager? It looks like your product manager is incapable of correctly running install scripts :p

You might want to try a reinstall.


Fillip

Never thought of that. yes i am. Let me disable it and try reinstall. I'll let you know in just a moment :D

[pedroenf]

Well, the mailing list problem is solved (but had exec that bd query for the 'external' column anyway), but the member email editing in CP remains :(

[DragonByte Tech]

Well the problem isn't this mod - or you'd be seeing 5 pages of people complaining about this error.

ALTER TABLE vbuser ADD dbtech_vbmail_bounceflag ENUM('0', '1') NOT NULL DEFAULT '0'


Fillip

[pedroenf]

Well the problem isn't this mod - or you'd be seeing 5 pages of people complaining about this error.

ALTER TABLE vbuser ADD dbtech_vbmail_bounceflag ENUM('0', '1') NOT NULL DEFAULT '0'
Fillip

No doubt about that neither i said that :) Just asked for help and thank you for it :up:
Member email edit in CP solved.

But i have another question, isn't supposed to have all member in mailing list if selected in Default Subscribed option?

[DragonByte Tech]

It wouldn't have, because of the aforementioned error. Delete the mailing list and re-create it, then it will work :)


Fillip

[pedroenf]

It worked :) Thanks

[Goatpod]

Having a problem with the Editor; I'm presuming that all controls should be showing when creating mail and not just two arrows, and I'm presuming that there may be a problem with my installation (I've disable all hacks except vbMail and still get the same result). Any pointers where to look next would be appreciated. Image attached shows what I'm seeing. Thanks in advance for any help.

[DragonByte Tech]

Have you customised any templates? We've received no reports of similar issues appearing on 4.1.5 (and we're running it on DBTech as well), so I'm rather stumped...

Fillip

[Goatpod]

Have you customised any templates? We've received no reports of similar issues appearing on 4.1.5 (and we're running it on DBTech as well), so I'm rather stumped...


Fillip

Thanks for getting back to me Fillip. I've got one or two minor customised templates. I'll have a root around and see what I find :) Cheers, Dave.

[Ichigo88]

hi!
is possible to traduct this?
Mailing system by vBMail. Copyright © DragonByte Technologies Ltd.

i need to traduct in jap lang!

[DragonByte Tech]

It is not possible to translate that at this time, sorry :(


Fillip

[Ichigo88]

ok not problem :) thanks very nice mod!!

[SeanMT]

I have set up a test mailing list where only Admins should be able to subscriber. But new members are automatically joining it when they register. Same goes for another mailing list where I have it so only Premium Members should be able to join.

Screenshot of how the mailing list settings:

https://vborg.vbsupport.ru/external/2011/08/1.png

[SeanMT]

Also when sending the emails out does the browser have to be open or are the emails scheduled and then sent by a cron?

[DragonByte Tech]

I have set up a test mailing list where only Admins should be able to subscriber. But new members are automatically joining it when they register. Same goes for another mailing list where I have it so only Premium Members should be able to join.

Screenshot of how the mailing list settings:Could you please re-post this over at our support forums? I'm massively swamped with a new version of our site's shopping cart system, so I won't be able to look into this for a few days, in which time it may be buried already.

Also when sending the emails out does the browser have to be open or are the emails scheduled and then sent by a cron?The browser has to stay open until it redirects you back to the mailing list directory. After which, the vBulletin mailqueue system takes over :)


Fillip

[SeanMT]

Thanks for the reply. I have had to uninstall the mod as it was causing issues with the Paid Subscription system.

[DragonByte Tech]

Those issues have been fixed in a hotfix, but I'm not sure if they made it to the Lite version yet.

Fillip

[CharlieDelta]

I have a newsletter set up and working great.
I have registered users checked as default subscribed but all newly registered members are not being subscribed. I have to create a new newsletter to make sure all members get added but this would reactivate members who have unsubscribed.

Is this by design or can newly registered members be added automatically?

[DragonByte Tech]

The flag is working fine for me in my local test build, there's an update coming out today so maybe that'll fix it for you :)


Fillip

[CharlieDelta]

The flag is working fine for me in my local test build, there's an update coming out today so maybe that'll fix it for you :)


Fillip

Thanks Fillip I will wait for the update.

Just for clarification, in case I was not describing the issue properly.: When I create a newsletter it adds all registered users fine but anyone who registers on the site after the creation of the newsletter does not get added as subscribed.

[DragonByte Tech]

vBMail v1.1.3
Fix: Notification links should now hopefully work with vBSEO even when its "Rewrite Member URLs" setting set to No
Fix: Any un-recorded hotfixes since the last version released.
Change: You should now be able to change -some- permissions for usergroups that were previously unaccessible
Change: The products now support the Product URL and Version Check features of the vBulletin Product Manager

Fillip

[CharlieDelta]

Hi Fillip I applied the update and newly registered users are still not showing up in the subscribed list.:confused:

[DragonByte Tech]

They will not be retroactively added, so that's not unexpected :)


Fillip

[CharlieDelta]

They will not be retroactively added, so that's not unexpected :)


Fillip
I thought this might be the case.
So to make sure I get all new members added I have to constantly create new mailing lists. Doesn't this defeat the purpose of unsubscribing?

[DragonByte Tech]

No it doesn't mean that :p

You can try unticking default subscribed, saving, re-ticking it and saving again.

I added another hotfix just now to deal with email verification, as you never told me if you had that enabled so I forgot to check that, but I believe that should be working now :)


Fillip

[DragonByte Tech]

If you got a SQL error applying the previous hotfix, grab the new zip, as I updated part of the email verification code.

Fillip

[brandon515]

Does this mod create the newsletters for you...in other words, can you tell it to send the newsletters to include recent threads from specified forums?

Also, does it allow for scheduling...like send them every 7 days at a specified time?

Thanks

[CharlieDelta]

No it doesn't mean that :p

You can try unticking default subscribed, saving, re-ticking it and saving again.

I added another hotfix just now to deal with email verification, as you never told me if you had that enabled so I forgot to check that, but I believe that should be working now :)


Fillip
Thanks Fillip.
Unticking and saving the re-ticking worked.:up: I have not applied the hotfix yet however.
The answer is yes, I do require email confirmation.:D

[CharlieDelta]

Fixed. :D

[Logician]

Firstly thanks for the great hack. It is well written, has a clean code and from checking the source code, I can confirm that a lot of work is put into the project so frankly speaking I believe it is not appreciated enough. So I wanted to tell my appreciation for your work first! :-)

I installed it in a friend's board. He wants to use for bounce email management and not interested in email listing features so my comments are regarding this part only. During installation I had some issues, glitches and fixes for them so I wanted to share with you considering you might want to know about them.

ISSUE 1:

During the initial installation the hack didn't work first. It gave no signal but it was not processing any bounced emails. After some debugging, I noticed that imap_open() was failing with error:
Warning: imap_open() [function.imap-open]: Couldn't open stream {mail.___.com:143/imap}Inbox in [path]/dbtech/vbmail/includes/class_imap.php on line 98
Although all login details were correct.

After some work I noticed our server is requiring /novalidate-cert parameter otherwise, it is dieing with error:
Certificate failure for
___.com: self signed certificate:
/C=US/ST=Unknown/L=Unknown/O=Unknown/OU=Unknown/CN=server1.____/emailAddress=ssl@server1.___"

So changing the line in dbtech/vbmail/includes/class_imap.php:

self::$connection = imap_open(
'{' . self::$vbulletin->options['dbtech_vbmail_imap_host'] . ':' . self::$vbulletin->options['dbtech_vbmail_imap_port'] . '/imap' .
(self::$vbulletin->options['dbtech_vbmail_imap_ssl'] ? '/ssl/novalidate-cert' : '') .
(self::$vbulletin->options['dbtech_vbmail_imap_tls'] ? '/tls/novalidate-cert' : '') .
'}' . self::$vbulletin->options['dbtech_vbmail_imap_mailbox'],
self::$vbulletin->options['dbtech_vbmail_imap_username'],
self::$vbulletin->options['dbtech_vbmail_imap_password']
);
as

//Logician Hack : Added /novalidate-cert as mail server is rejecting connection without this
self::$connection = imap_open(
'{' . self::$vbulletin->options['dbtech_vbmail_imap_host'] . ':' . self::$vbulletin->options['dbtech_vbmail_imap_port'] . '/novalidate-cert/imap' .
(self::$vbulletin->options['dbtech_vbmail_imap_ssl'] ? '/ssl/novalidate-cert' : '') .
(self::$vbulletin->options['dbtech_vbmail_imap_tls'] ? '/tls/novalidate-cert' : '') .
'}' . self::$vbulletin->options['dbtech_vbmail_imap_mailbox'],
self::$vbulletin->options['dbtech_vbmail_imap_username'],
self::$vbulletin->options['dbtech_vbmail_imap_password']
);
//Logician Hack : Added /novalidate-cert as mail server is rejecting connection without this
fixed this issue for us.

I think it might be a good idea to:
1- Add a hack setting to enter custom parameters there. Alternatively you can make "IMAP Port" setting inputbox "string", instead of "number" which will then allow entering values like: 143/novalidate-cert
2- In part:

if (!self::$connection)
{
// We couldn't open the mailbox
trigger_error($vbphrase['dbtech_vbmail_cannot_open_mailbox'], E_USER_ERROR);
}
It might be helpful to vbmail() admin with the value of imap_last_error() variable as it will help debugging connection problems when hack can't connect to the mail server. ATM admin is in dark when a connection problem occurs as no error etc. are returned. (Even when scheduled task is run manually in admin cp)

ISSUE 2:

In dbtech /vbmail/cron/threshold.php, this part:

$users = $vbulletin->db->query_read_slave("
SELECT
user.userid,
user.username,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid" . ($vbulletin->products['dbtech_vbshop'] ? ", user.dbtech_vbshop_purchase" : '') . "
FROM `" . TABLE_PREFIX . "dbtech_vbmail_message` AS dbtech_vbmail_message
INNER JOIN " . TABLE_PREFIX . "user AS user ON(user.email = dbtech_vbmail_message.fromaddress)
WHERE dbtech_vbmail_message.fromaddress != ''
AND dbtech_vbmail_message.bounce = '1'
AND user.dbtech_vbmail_bounceflag = '0'
GROUP BY dbtech_vbmail_message.fromaddress
HAVING COUNT(*) >= " . intval($vbulletin->options['dbtech_vbmail_bounce_threshold'])
);
Should be replaced as:

$users = $vbulletin->db->query_read_slave("
SELECT
user.userid,
user.username,
user.email,
user.usergroupid,
user.membergroupids,
user.infractiongroupid,
user.displaygroupid" . ($vbulletin->products['dbtech_vbshop'] ? ", user.dbtech_vbshop_purchase" : '') . "
FROM `" . TABLE_PREFIX . "dbtech_vbmail_message` AS dbtech_vbmail_message
INNER JOIN " . TABLE_PREFIX . "user AS user ON(user.email = dbtech_vbmail_message.fromaddress)
WHERE dbtech_vbmail_message.fromaddress != ''
AND dbtech_vbmail_message.bounce = '1'
AND user.dbtech_vbmail_bounceflag = '0'
GROUP BY dbtech_vbmail_message.fromaddress
HAVING COUNT(*) >= " . intval($vbulletin->options['dbtech_vbmail_bounce_threshold'])
);
Otherwise email part in the user pm is blank.

ISSUE 3:

The hack is not unflagging user if vb option "verifyemail" is turned off since you tied unflagging only to register.php user activation screen. I added this pluggin to correct this issue for boards which does not use email confirmation:

HOOK LOCATION: profile_updatepassword_complete
PHP CODE:

//Logician Hack : If user is not banned AND changed his email correctly AND email verification is OFF, THEN unflag dbtech_vbmail_bounceflag setting
if ($permissions['genericoptions'] & $vbulletin->bf_ugp_genericoptions['isnotbannedgroup'] AND ($vbulletin->GPC['email'] != $vbulletin->userinfo['email'] AND $vbulletin->GPC['email'] AND $vbulletin->GPC['emailconfirm'] == $vbulletin->GPC['email']) AND !$vbulletin->options['verifyemail'])
{

$onoff = '0';
$userdata->set('dbtech_vbmail_bounceflag', $onoff);
}
This fixed the issue for such boards.

If I run into other issues, I'll keep reporting.

And once again, thanks for the great hack and efforts put into it! ;)

[DragonByte Tech]

Firstly thanks for the great hack. It is well written, has a clean code and from checking the source code, I can confirm that a lot of work is put into the project so frankly speaking I believe it is not appreciated enough. So I wanted to tell my appreciation for your work first! :-)Thank you! You're actually the first person (outside the DBTech team :p) that's complimented me on my code quality, so it really means a lot :D

ISSUE 1:

[...]

I think it might be a good idea to:
1- Add a hack setting to enter custom parameters there. Alternatively you can make "IMAP Port" setting inputbox "string", instead of "number" which will then allow entering values like: 143/novalidate-certI presume there's no downside to adding novalidate-cert for everyone? Surely no servers can be set up to hard reject a connection that tries to skip certificate validation as opposed to simply ignoring that directive... Thinking out loud here. I'd prefer to have it working without requiring admins to edit the port like that :)

I've added the novalidate-cert and the imap_last_error() to the file and it'll be updated with the next version :)

ISSUE 2:

In dbtech /vbmail/cron/threshold.php, this part:
[...]

Otherwise email part in the user pm is blank.Whoops xD

ISSUE 3:

The hack is not unflagging user if vb option "verifyemail" is turned off since you tied unflagging only to register.php user activation screen.And this is the kicker that requires a new version number as opposed to a hotfix xD

I'll release it later tonight alongside a vBActivity & Awards update, thanks :D


Fillip

[Logician]

I've been reported that sometimes this error shows up for admin:

Fatal error: Class 'VBMAIL' not found in /home/..../public_html/forum/dbtech/vbmail/hooks/mail_send.php on line 10
I traced it a little and noticed it could only happen during vb cron mailing. You include the class in "global_bootstrap_init_complete" hook so it should be there in all page visits but there must be a vb section which triggers vb mail cron for admin visitor without initializing "global_bootstrap_init_complete" hook to produce this error. I'm still working on it to find where but wanted to report here in case you also have an idea. :)

[DragonByte Tech]

My guess is that the Cron doesn't use vB's bootstrap to initialise. Since cron mailing don't need vBMail stuff anyway, I'll edit the mail_send hook with this if (class_exists('VBMAIL') AND VBMAIL::$pluginglobals['mailinglist'])

That should work :)


Fillip

[Logician]

My guess is that the Cron doesn't use vB's bootstrap to initialise. Since cron mailing don't need vBMail stuff anyway, I'll edit the mail_send hook with this if (class_exists('VBMAIL') AND VBMAIL::$pluginglobals['mailinglist'])That should work :)

Why doesn't cron mailing need vbmail stuff? Daily/weekly digest, birthday greetings, event reminder are performed via cron. Actually so is ALL mailing process if "Use Mailqueue System" setting is turned on in vb. Am I missing something? :)

[DragonByte Tech]

Because bounced mail collection is not strictly dependent on anything in that hook, the headers simply help it identify the source :)

Not to mention anything within that if condition I posted is only supposed to happen on vBMail's own pages anyway :)


Fillip

[Logician]

Because bounced mail collection is not strictly dependent on anything in that hook, the headers simply help it identify the source :)

Not to mention anything within that if condition I posted is only supposed to happen on vBMail's own pages anyway :)

Yes collecting is not needing that hook but I assumed email sending depended on that since it needs to check if bounce flag is for the TO: user on. But I guess I'm safe to assume this class is not needed during that process, right? :)

[DragonByte Tech]

Correct :)


Fillip

[Logician]

ok thanks! :)

And one more issue I pulled from PHP error log: When threshold.php runs on cron, it is producing "PHP Fatal error: Call to undefined function print_cp_message() in /home/.../public_html/forum/includes/class_dm.php on line 1092"

When I run the cron in scheduled tasks, it does not produce the error so I believe it only happens when it runs on its own.

[DragonByte Tech]

Change line 152 of /dbtech/vbmail/cron/threshold.php to $pmdm =& datamanager_init('PM', $vbulletin, ERRTYPE_SILENT);

I'll just wait a few more days for you to finish reporting these before releasing the bugfix version :p

I'm happy for you and imma let you finish, but this bugfix version will be the biggest bugfix release of all time.


Fillip

[weindians]

if i turn off mailqueue option in email setting all mails will be sent straight away? is that correct? n i can get warning from host! vbmail uses queueing only if that option is turned on?? i sent one set after turning off cron based email mod( have been using) with mailqueue still on but still not delivered ( week) i assume that is because if that user visits only email sent in that case..

[DragonByte Tech]

If you turn mailqueue off, you will receive warnings from hosts if they are prone to do that :p

I'm not sure what vB chooses to do if you turn off mailqueue, tbh. I support it, but I'm unsure if it ignores the setting or not.


Fillip

[Logician]

I made a small change in dbtech/vbmail/actions/admin/bounce.php:

Before line:

print_submit_row($vbphrase['view'], 0);

I added:

//Logician Hack : Show total flagged
$totalflagged = $db->query_first("
SELECT COUNT(*) as count
FROM " . TABLE_PREFIX . "user
WHERE user.dbtech_vbmail_bounceflag = '1'
");
print_description_row("Total Flagged Members: ".intval($totalflagged[count]));
//Logician Hack : Show total flagged

So now I can monitor flagged user count easily without needing phpmyadmin. :)

[DragonByte Tech]

vBMail v1.1.4:
Fix: In some rare cases, connection to the IMAP server could fail
Fix: The PM sent to a user when the bounce flag in effect will now correctly display the email
Fix: Forums without email verification would not properly un-flag a user when they changed their email
Change: IMAP connection errors are now displayed in the error message

Fillip

[CharlieDelta]

Thank you for the update to this great product. My navbar issue is now fixed!!
Good work DBT!

[snowlion]

I'd received 2000+ emails back with this message included
Domain bentinhyeu.info (http://bentinhyeu.info/) has exceeded the max emails per hour (500) allowed. Message discarded.

I used Paul M's Cron based e-mail sending so the Mailqueue System has enabled.

[DragonByte Tech]

vBMail uses vBulletin's Mailqueue system, there's nothing more I can do on my end :(


Fillip

[Dadoo]

I've been reported that sometimes this error shows up for admin:

Fatal error: Class 'VBMAIL' not found in /home/..../public_html/forum/dbtech/vbmail/hooks/mail_send.php on line 10
I traced it a little and noticed it could only happen during vb cron mailing. You include the class in "global_bootstrap_init_complete" hook so it should be there in all page visits but there must be a vb section which triggers vb mail cron for admin visitor without initializing "global_bootstrap_init_complete" hook to produce this error. I'm still working on it to find where but wanted to report here in case you also have an idea. :)

My guess is that the Cron doesn't use vB's bootstrap to initialise. Since cron mailing don't need vBMail stuff anyway, I'll edit the mail_send hook with this if (class_exists('VBMAIL') AND VBMAIL::$pluginglobals['mailinglist'])That should work :)


Fillip

Unfortunately, that problem still exist with 1.1.4 version, but in "actions/admin/mailinglist.php on line 19"

[DragonByte Tech]

No, in that script it happens because of the i.s.s.w. "security" product. Please either disable that or set its admin_global hook to 65535 so it stops breaking every other product.

Fillip

[Dadoo]

Ohhh sorry to have missed that...

Thanks a lot Filip !

[chrisbjax]

Hi Fillip,
Is there any word yet on importing a mail list from vb? or perhaps controlling distribution from vb groups?

[DragonByte Tech]

Not yet, unfortunately.

Feature requests posted at our forum has a higher chance of being included, since vBulletin.org threads often grow to such lengths we can't reasonably track old feature requests.

Fillip

[chrisbjax]

I posted the request on your support forum.
Thank you Fillip. :)

[arkueckelhan]

Am I correct in assuming that if I send an email out from my normal vbulletin mailing system, this mod won't capture the bounces, etc.?

I ask because I need mailings going out to only those that accept admin emails currently and don't know how to get those into this system. I then want to delete emails that bounce.

(I think this will be a great system for other mailing lists I create as well!)

[Alan_SP]

I think that it should get bounced mail.

You setup which mail address you want to use as bounce email. After mail is bounced, it returns to bounce email and this mod checks this email address through IMAP protocol (you need to set it up so in settings, of course).

So, you'll have all bounced mail there and you could check it automatically or manually, as you wish.

At least I think that it should work in this way. Filip will know more.

[DragonByte Tech]

Am I correct in assuming that if I send an email out from my normal vbulletin mailing system, this mod won't capture the bounces, etc.?


I ask because I need mailings going out to only those that accept admin emails currently and don't know how to get those into this system. I then want to delete emails that bounce.


(I think this will be a great system for other mailing lists I create as well!)If you configured the "Bounce Email Address" setting then yes I do believe that it will grab those bounced mail.


Fillip

[manuelmalin]

Hi,

The mod, each time bounced emails cron runs, copies all the data from "vb_dbtech_vbmail_message" table into the "datastore" table :

datastore / dbtech_vbmail_message / data

After about 200 bounced emails, the cron sends me a MySQL error :

Got a packet bigger than 'max_allowed_packet' bytes

One solution is to change my mysql settings, adding more memory, but the problem will happen again maybe after 200 bounced emails more...

Can you help me please ?

Regards,
Manuel

[DragonByte Tech]

Whoops, that was an oversight, that should not happen. Thanks for letting me know :)

Open /dbtech/vbmail/includes/class_dm_message.php and comment out both instances of the following code: VBMAIL_CACHE::build_cache('message');

Feel free to delete that datastore entry via DELETE FROM vb_datastore WHERE title = 'dbtech_vbmail_message' to save some database space :)


Fillip

[manuelmalin]

It worked, thank you Fillip ! :)

Manuel

[astdirect]

Installed and all looks good. Can you tell me how quickly this sends the emails out ? I am only allowed 500 per hour but i have a mailing list of 1000+. How can i achieve this ? I have mailqueue on in email options and set batch to 10, but no idea if this is correct.

Also, when does a user receive a PM ? Is it after emails bounce a certain amount of times or after first bounce ?

[DragonByte Tech]

It sends out mailqueue amount of emails every page load.

He receives a PM when the amount of bounces match the threshold set in the options.

Fillip

[RedPoint]

Hi, the Check 4 Hacking vers. 1.0 addon say:
infect in dbtech_vbmail_message module

Its true? Please check!

Regards

[DragonByte Tech]

That would mean that someone has tried to send an email containing an infection. It is not an infection in this mod, as that is not a module but a database table. Database tables created via a SQL command cannot be infected :)


Fillip

[RedPoint]

Hi Fillip,
I use Check 4 Hacking - Test the datastore for infects. Today when i run manual the cron, i become this message:

found infect in dbtech_vbmail_message modul - the forum language was in german and in german, a module is mean a addon. Now i repeat the task, nothing to see - its bizzare :D

[DragonByte Tech]

Seems like there's nothing to worry about then :)


Fillip

[DragonByte Tech]

vBMail v1.1.5:
Fix: Adding "too many" keywords produced unexpected results when saving a draft or template and opening it again later

Fillip

[chrisbjax]

Hi Fillip,
Is there any special way vbmail is hooking the navbar?
I am having an issue with another mod (Tournaments, Ladders & Leagues Manager, by Bananalive)

When vbmail is disabled, the navbar appears with all options visible for TLLM.
https://vborg.vbsupport.ru/

However, when I enable vbmail, I lose most of the options for TLLM.
https://vborg.vbsupport.ru/

Any ideas on what may be causing this?
Here's a link to my site, if you'd like to look.
http://forums.usmilitarygamers.com/competitions.php

[DragonByte Tech]

They must be using an incorrect method of hooking into the navbar then, I use the only method known to me that will work around the design flaw in vB4's navbar creation code and won't break the Home tab :(


Fillip

[chrisbjax]

ok, thank you Fillip, I will ask over on the other mod.

[chrisbjax]

Hi Fillip,
After some tinkering, changing the "Navbar Link" Plugin Hook location for vbmail from "global_bootstrap_complete" to "process_templates_complete" - the issue appears to have gone away.

[DragonByte Tech]

But doing so many break the Home tab, which is why I put it where I did :)


Fillip

[chrisbjax]

yes sir, understood.
Disclaimer - I only posted what worked for me. :D


Is there anyway to throttle the messages sent per hour?

[DragonByte Tech]

vBMail uses the vBulletin Mail Queue system, I'm not sure if that has this feature but if it doesn't, then neither does vBMail :)


Fillip

[Alan_SP]

I think that vB Mail Que system sends specified amount of mails (in settings) every page load of front end.

So people should use very low numbers there if they have very busy forums. Or higher, if on small ones.

[stemmy]

I seem to have an issue.

This system was working fine (ish) a few weeks ago.

This system did have an issue with my members subscription system. When the mail program was running and a member paid an upgrade subscription they would not be moved to the new usergroup. Not a real issue as I now leave the mail program disabled until I need to send a message and then activate it, send the message, then de activate it again.

The new issue is this - when the system sends the emails I then get the returned (bounced) emails. I have set up an IMAP email to receive the mail. This system used to work correctly. When I activated the mail program I would then go to the scheduled tasks section and run the two mail program tasks - collect mail and remove members from list. When the tasks ran it would list the members that had been removed from the list and then delete the email from the mailbox.

If I run the system now all seems to work - I get no error messages. When I hit the scheduled task it used to list the members it had removed, I now get no members names in that list, it still shows that its done what it was supposed to do but no names are listed.

If I send another message I still get loads of bounced messages - if the system was working shouldn't these member have been removed from the list already ??

Any help would be appreciated.

Thanks in advance.

[DragonByte Tech]

This system did have an issue with my members subscription system. When the mail program was running and a member paid an upgrade subscription they would not be moved to the new usergroup. Not a real issue as I now leave the mail program disabled until I need to send a message and then activate it, send the message, then de activate it again.That issue has already been fixed a few versions ago, it was an issue with the mail_send hook.

You can check if your version is "safe" by opening /dbtech/vbmail/hooks/mail_send.php and check that the code is wrapped in if (THIS_SCRIPT != 'payment_gateway')

Deactivating the product after sending emails means that the unsubscribe link will not work, plus many other features of the mailing list that is integral for the functionality of the mod.

The new issue is this - when the system sends the emails I then get the returned (bounced) emails. I have set up an IMAP email to receive the mail. This system used to work correctly. When I activated the mail program I would then go to the scheduled tasks section and run the two mail program tasks - collect mail and remove members from list. When the tasks ran it would list the members that had been removed from the list and then delete the email from the mailbox.

If I run the system now all seems to work - I get no error messages. When I hit the scheduled task it used to list the members it had removed, I now get no members names in that list, it still shows that its done what it was supposed to do but no names are listed.

If I send another message I still get loads of bounced messages - if the system was working shouldn't these member have been removed from the list already ??Are you sure you don't deactivate the product before doing that? To my knowledge, nobody else are having these issues.

In addition, you should always check your Bounced Mail list (DBTech - vBMail -> Bounced Mail List -> Show Only Entries Generated By: Unknown Mail -> Submit) - cPanel will not correctly flag certain emails as bounced; example of one email is this:
Subject Warning: message 1SBG4k-0004tb-10 delayed 24 hours
Message This message was created automatically by mail delivery software.
A message that you sent has not yet been delivered to one or more of its
recipients after more than 24 hours on the queue on server.dragonbyte-tech.com.

The message identifier is: 1SBG4k-0004tb-10
The date of the message is: Sat, 24 Mar 2012 01:47:26 +0000
The subject of the message is: Update Galore: vBShout / vBAvatars (+Lite) / vBMail / vBArcade / vBAnalytics / vBNominate

The address to which the message has not yet been delivered is:

kortton+gaiffibre@gmail.com
Delay reason: SMTP error from remote mail server after RCPT TO::
host alt4.gmail-smtp-in.l.google.com [173.194.70.26]:
452-4.2.2 The email account that you tried to reach is over quota. Please direct
452-4.2.2 the recipient to
452 4.2.2 http://support.google.com/mail/bin/answer.py?answer=6558 7si7316708wel.122

No action is required on your part. Delivery attempts will continue for
some time, and this warning may be repeated at intervals if the message
remains undelivered. Eventually the mail delivery software will give up,
and when that happens, the message will be returned to you.
As it's showing as coming from Mailer-Daemon@server.dragonbyte-tech.com instead of the actual email address seen in the email itself.

There is nothing vBMail can do about that, as it's not feasible to try to detect an email address from the error message - there may be multiple matches in these error messages, leading to confusion.

These emails will still show up as Bounced, but the users won't be flagged - thus explaining your issue.

You can fix it by going to the list I suggested, then editing each email taking the email from the message body and putting it in the field that has Mailer-Daemon@server.dragonbyte-tech.com in it, setting Is Bounced Mail to Yes, then saving the message.

Repeat for each email, then run the 2nd scheduled task again. It will then function correctly :)


Fillip

[KGodel]

When attemtping to add a new mailing list, I receive this error:

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT `bitfield`
FROM `mytablehere`
ORDER BY `bitfield` DESC
LIMIT 1;

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

[Pandemikk]

When attemtping to add a new mailing list, I receive this error:

Please don't remove the table and column names. That makes it virtually impossible to fix.

[snowlion]

This is full message
Database error in vBulletin 4.1.4:

Invalid SQL:

SELECT `bitfield`
FROM `sty_dbtech_vbmail_mailinglist`
ORDER BY `bitfield` DESC
LIMIT 1;

MySQL Error : Unknown column 'bitfield' in 'field list'
Error Number : 1054
Request Date : Thursday, March 29th 2012 @ 12:46:16 AM
Error Date : Thursday, March 29th 2012 @ 12:46:17 AM
Script : http://forum.bentinhyeu.info/.../vbmail.php?do=mailinglist
Referrer : http://forum.bentinhyeu.info/.../vbmail.php?do=mailinglist
IP Address : ...
Username : kisibachda
Classname : vB_Database
MySQL Version : 5.1.56

[DragonByte Tech]

Files updated, please re-download and re-upload the files. Re-importing the XML is not necessary :)


Fillip

[snowlion]

Fixed. Thanks Fillip :D

[wat3v3r]

This sounds like a nice mod, I got a query though. We do not send a lot of mails out but we do send the occasional birthday emails. Would this addon be able to handle the bounced emails from the birthday cron too ?

[DragonByte Tech]

Yeah it will :)


Fillip

[mescalin]

We use gmail and this mod can't connect to gmail imap. Is there a way to connect gmail imap servers and fetch bounced mails?

[DragonByte Tech]

It should be possible, though I would very strongly not recommend using the same email as you use for actual communication (if you have already set up a separate "bounce" GMail account for your forum then I apologise for the emphasis, I just wanted to prevent possible data loss should you get it working) - vBMail will delete all the email it has collected from the mail server in order to speed up future fetching.

Without seeing an error message (you can see any connection errors by manually running the collect bounced mail scheduled task) I can't help, unfortunately :(


Fillip

[mescalin]

Thank you for the emphasis. We use seperate bounced mail account for gmail.

Here is the error:

Warning: imap_open() [function.imap-open]: Couldn't open stream {imap.gmail.com:993/novalidate-cert/imap/ssl/novalidate-cert}INBOX in [path]/dbtech/vbmail/includes/class_imap.php on line 98


I guess imap function is different for gmail.

http://www.electrictoolbox.com/php-imap-download-email-gmail/


So isn't it possible to use VbMail with gmail?

Thanks..

[DragonByte Tech]

From what I can tell, you entered 1 as the IMAP Port in DragonByte Tech: vBMail - Bounced Mail Settings.

Please correct that to 993, which is the correct port for connecting to GMail's IMAP server, then let me know if that works :)


Fillip

[mescalin]

I saw 1 and edited my post immediately after posting. 993 does not work.

I tried to enter "imap.gmail.com:993/ssl" and many combinations left port number blank if it helps. Thats why you saw 1 as the port. before my edit.

Ps. I tried vbmail with a regular imap server and collected emails.

[DragonByte Tech]

Try these exact settings:

IMAP Host: imap.gmail.com
IMAP Port: 993
Use SSL: Yes

I'm not sure whether you just told me you tried to enter "imap.gmail.com:993" in the port field, but try these settings regardless :)


Fillip

[mescalin]

Problem was CFS firewall was blocking port 993 in my server. And when i open that port it collects them. Sorry about that, i couldnt think of firewall im using.

Now i collected bounced mails then i ran "Bounced Mail Threshold" it sent members pms and changed their setting. When i rerun it it sends same pms to these same users again and again in each "Bounced Mail Threshold" run. Shouldnt it send pm only once and process one member only once?

my "Bounced Mail Threshold" is 1

[DragonByte Tech]

It will only send it to them once, unless for some reason it fails to set dbtech_vbmail_bounceflag to 1 for those users. Check that it has correctly flipped to 1 for those users :)


Fillip

[elsparkodiablo]

I've installed this and am running into a problem. We use google as our mail server with mail.(ourdomain).com aliased to google. I've set up a bounced email address - bounced@(ourdomain).com through google, but I'm not sure what to put in the vbmail settings in order to get this active and working. When I attempt to run the cron task for bounced mails, it times out and gives me weird error messages.

[DragonByte Tech]

You can get the answer for this 3 posts above yours :)

IMAP Host: imap.gmail.com
IMAP Port: 993
Use SSL: Yes


Fillip

[elsparkodiablo]

Thanks for the fast followup, I had to put the bounced@(ourdomain).com instead of just bounced in the email field. Sorry.

I have 180k users, with probably tens of thousands who are orphaned, spammers, etc. Is there going to be a way to mass delete bounced emails?

[DragonByte Tech]

vBMail will collect the bounced mail from your server and store it on your server - it's not supposed to be deleted from vBMail's database :)


Fillip

[elsparkodiablo]

Fillip, just wanted to say that I'm pretty impressed with this. I'll probably be buying a lifetime version shortly.

Have you given any thought to extending this to handle unsubscribing members from threads & forums as well, making it an all in one program?

[DragonByte Tech]

It already does, if they reach the bounced mail threshold they will be unsubscribed from those parts as well to avoid future bounced mail :)


Fillip

[elsparkodiablo]

Whoa, really? It removes their thread / forum subscriptions? You should REALLY list that as a feature above then, that makes this a MUST HAVE. Great work, and thank you again for a good piece of software.

[DragonByte Tech]

It doesn't remove them, simply turns off email notification for them :)

Removing them outright would be disruptive to users who then proceed to change their email address to a valid one.


Fillip

[elsparkodiablo]

Is there a way to have this automatically notify the member in question that their email has bounced?

[DragonByte Tech]

Not straight away, but once they have reached the threshold they will receive a PM stating what has happened and what they need to do :)


Fillip

[Tri@de]

There's a way to use html code to make newsletter?

[DragonByte Tech]

Yeah, you can use HTML code :)


Fillip

[Martyn1983]

Can the number of emails sent per hour be altered?

Our server has a limit off 200 and at the moment my email is being swamped with auto-responses saying mail cannot be sent :(

[DragonByte Tech]

vBMail uses vBulletin's mailqueue system and I don't believe it supports email per hour limit at this time. Any modification that implements this (if it exists) will work with vBMail, though :)


Fillip

[Martyn1983]

vBMail uses vBulletin's mailqueue system and I don't believe it supports email per hour limit at this time. Any modification that implements this (if it exists) will work with vBMail, though :)


Fillip

Ah - that's a pity :(

Will the bounced message re-send of their own accord? We really do need to get mails sent out to get old members back on the site again, but to up the email limit will cost money we simply don't have :(

[DragonByte Tech]

It will not, no.

There are plenty of shared hosts that don't impose an email per hour limit, so I suggest you shop around if your current host is unwilling to accomodate you :)


Fillip

[Martyn1983]

Damn.

We just moved hosts due to our hold hosts server continually dying on us.

[Tri@de]

Yeah, you can use HTML code :)


Fillip

I tried but i had some odd behaviour:
i have to write on the editor without spaces like this

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Alteregonline Newsletter</title><link rel="Shortcut Icon" href="favicon.ico" type="image/x-icon" /></head><body ><center><!-- Table for background color when body tags are stripped --><table align="center" width="98%" bgcolor="#000000" cellpadding="0" cellspacing="0"><tbody>


instead of:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Alteregonline Newsletter</title>
<link rel="Shortcut Icon" href="favicon.ico" type="image/x-icon" />
</head>
<body >
<center>
<!-- Table for background color when body tags are stripped -->
<table align="center" width="98%" bgcolor="#000000" cellpadding="0" cellspacing="0">
<tbody>



There's a way to avoid this?
If i use spaces the newsletter appear messed up.

[Logician]

Whoops, that was an oversight, that should not happen. Thanks for letting me know :)

Open /dbtech/vbmail/includes/class_dm_message.php and comment out both instances of the following code: VBMAIL_CACHE::build_cache('message');Feel free to delete that datastore entry via DELETE FROM vb_datastore WHERE title = 'dbtech_vbmail_message' to save some database space :)


Fillip
Thanks for this fix. After a while, it was also producing Fatal Error Allowed memory size of ... exceeded error as well. :)

[DragonByte Tech]

I tried but i had some odd behaviour:
i have to write on the editor without spaces like this

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Alteregonline Newsletter</title><link rel="Shortcut Icon" href="favicon.ico" type="image/x-icon" /></head><body ><center><!-- Table for background color when body tags are stripped --><table align="center" width="98%" bgcolor="#000000" cellpadding="0" cellspacing="0"><tbody>


instead of:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Alteregonline Newsletter</title>
<link rel="Shortcut Icon" href="favicon.ico" type="image/x-icon" />
</head>
<body >
<center>
<!-- Table for background color when body tags are stripped -->
<table align="center" width="98%" bgcolor="#000000" cellpadding="0" cellspacing="0">
<tbody>



There's a way to avoid this?
If i use spaces the newsletter appear messed up.That's probably because we convert new lines to <br /> tags. This is essential in order to allow non-HTML only mails to be sent.

Unfortunately to my knowledge there is no way around this :(


Fillip

[DragonByte Tech]

vBMail v1.1.6
Feature: Now compatible with vBulletin 4.2.0's Navigation Manager.

Fillip

[mescalin]

i use that mod for only bounced mail handling but have a problem with it. it changes user group of banned members too. So their bans are lifted because of bounced mails.

[DragonByte Tech]

Could you please re-create this as a new bug report over at our forum? Sadly it's too easy for posts here on vb.org to get lost / missed :(

Thanks :)


Fillip

[John Lester]

Fillip I have a question about the unsubscribe part. When they click the link at the bottom of the email, what happens next? Does it take them to a page where they enter their email address and click a button? Does it send them another email with another link to click?

I'm having serious problems with my host (hostmonster) and finding an appropriate opt out solution :(

Hmmm does this handle ALL outgoing emails? IE birthday emails, thread subscriptions, new pm notifies? Or are those still handled by vBulletin? Reason I ask is that hostmonster requires a 1 click opt out for all emails. Meaning that after the user clicks the link in the email, they enter their email addy in a box and click a link/button and be completely done with the unsubscribing process.

[DragonByte Tech]

Fillip I have a question about the unsubscribe part. When they click the link at the bottom of the email, what happens next? Does it take them to a page where they enter their email address and click a button? Does it send them another email with another link to click?

I'm having serious problems with my host (hostmonster) and finding an appropriate opt out solution :(They will be unsubscribed as soon as they click the link, no need to enter email address or click anything else on the page :)

Hmmm does this handle ALL outgoing emails? IE birthday emails, thread subscriptions, new pm notifies? Or are those still handled by vBulletin? Reason I ask is that hostmonster requires a 1 click opt out for all emails. Meaning that after the user clicks the link in the email, they enter their email addy in a box and click a link/button and be completely done with the unsubscribing process.No vBMail doesn't handle those. Also, those emails are opt-in so they should be exempt from those requirements.


Fillip

[John Lester]

I agree with you Fillip that the birthday emails and such are all opt in and should be exempt, but my retarded host says no.

I don't send out mass emails so I probably won't install this mod, but if it's like any of your other mods I'm sure it rocks :) Thank you for taking the time to answer my questions.

[cisoprogressivo]

I uninstalled vBmail and sometime I get this database error:

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_dbtech_vbmail AS phrasegroup_dbtech_vbmail,
phrasegroup_user AS phrasegroup_user,
phrasegroup_album AS phrasegroup_album,
phrasegroup_posting AS phrasegroup_posting,
phrasegroupinfo AS lang_phrasegroupinfo,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM forumvb_language
WHERE languageid = 1;

MySQL Error : Unknown column 'phrasegroup_dbtech_vbmail' in 'field list'
Error Number : 1054
Request Date : Friday, July 13th 2012 @ 12:22:08 PM
Error Date : Friday, July 13th 2012 @ 12:22:08 PM
Script : http://www.androidworld.it/forum/vbmail.php?langid=1
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version :

[DragonByte Tech]

You need to delete the files from this mod once you've uninstalled it.

Fillip

[cisoprogressivo]

I decided to reinstall vBMail and I get a lot of this error:
Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE forumvb_user SET
usergroupid = 2,
usertitle = 'Baby Android',
customtitle = 0,
dbtech_vbmail_bounceflag = '0',
displaygroupid = 0
WHERE userid = 49125;

MySQL Error : Unknown column 'dbtech_vbmail_bounceflag' in 'field list'
Error Number : 1054
Request Date : Monday, July 16th 2012 @ 12:08:37 PM
Error Date : Monday, July 16th 2012 @ 12:08:38 PM
Script : http://www.androidworld.it/forum/register.php?a=act&u=49125&i=3fe412579898eb91d9ebed96f6fd9295a3ac9827
Referrer :
IP Address : ***
Username : ste9822
Classname : vB_Database
MySQL Version :

[DragonByte Tech]

Run these 2 queries:
alter table forumvb_dbtech_vbmail_mailinglist add external enum('0', '1') not null default '0'
alter table forumvb_user add dbtech_vbmail_bounceflag enum('0', '1') not null default '0'


Fillip

[cisoprogressivo]

Run these 2 queries:
alter table forumvb_dbtech_vbmail_mailinglist add external enum('0', '1') not null default '0'
alter table forumvb_user add dbtech_vbmail_bounceflag enum('0', '1') not null default '0'


Fillip
Thank you!

[dany_danay]

Sorry, but i want to send an HTML email, but when i put it in the ck editor, obviously, it doesnt parse... I can send html mail?

[DragonByte Tech]

Yeah, you can send HTML email :)

You can test it by creating a new mailing list only you have access to, then send a test HTML email :)


Fillip

[rebelde]

Fillip,

Great job with the bounced email handling. I'm not sure you understand what a big deal this is. Building on your code, we can now block a lot of outgoing emails that will bounce.

I just created an add-on modification (the Poor Man's Bounced Email Handler (https://vborg.vbsupport.ru/showthread.php?t=286441)) that uses your vBMail as a basis to block "new post" notifications. I hope you don't mind and that people find it useful.

[DragonByte Tech]

I had a quick look at your code, unless I'm reading it wrong I think it's already covered by vBMail :)

The hook you used is executed in exec_send_notification, and the query only returns users that match subscribethread.emailupdate IN (1, 4) whereas part of vBMail's "remove the user from everything email related" cron job code is setting that column to 0 - so in theory it shouldn't fetch users vBMail has dealt with :)

For the record; we'll never give permission to re-use our code :)


Fillip

[rebelde]

unless I'm reading it wrong I think it's already covered by vBMail
There might be a bug. Without my small bit of code, emails were still being sent out to users whose emails were bouncing. With my code, those emails stopped going out.

[DragonByte Tech]

vBMail v1.1.7:
Feature: The Affiliate ID setting now properly integrates with the link-back

Fillip

[DragonByte Tech]

Affiliate ID link hotfix

Fillip

[Glockie]

Hi, does this mod have a HTML feature by any chance?
That admins can add HTML into their pm's to users?

[DragonByte Tech]

vBMail does not deal with PM sending at all.

The mails you send in the Mailing Lists created by this mod are HTML enabled, though :)


Fillip

[Glockie]

Aha!

Yes, my bad, I meant email - I'm also looking for a PM HTML enabled system too and was thinking about it when typing this out :D

Thanks for the quick reply and info! ;)

[lazytown]

What exactly happens when a bounced email is detected? Several older mods handled this by disabling all their subscriptions and email notifications, and sending the user a PM why that has been done.

Does this handle bounced emails from things like thread subscriptions, or only newsletters sent out?

[DragonByte Tech]

What exactly happens when a bounced email is detected? Several older mods handled this by disabling all their subscriptions and email notifications, and sending the user a PM why that has been done.That's exactly what this mod does :)

Does this handle bounced emails from things like thread subscriptions, or only newsletters sent out?It can only automatically handle emails sent via the script itself, I believe. However, it will still collect other bounced email and store them (presuming you have not enabled Automatic handling, in which case it will discard them).

In addition, we have a new feature in private Beta over at DBTech which seems to be correctly handling ALL bounced email :)


Fillip

[lazytown]

That's exactly what this mod does :)

It can only automatically handle emails sent via the script itself, I believe. However, it will still collect other bounced email and store them (presuming you have not enabled Automatic handling, in which case it will discard them).

In addition, we have a new feature in private Beta over at DBTech which seems to be correctly handling ALL bounced email :)


Fillip
I'm really only interested in the bounced mail handling. I'm even willing to pay for that, but I assume private Beta means it's not even in a paid version?

[jdj]

I'm currently looking at this mod to see whether it can produce HTML emails with images inserted from vBulletin 4 in much the same way that e.g. MailChimp or Vertical Response can.

The responses do say "html enabled" but I'm not clear what this means. Does this mean that you can design an email in this mod once it's installed in vBulletin 4, add some images and then send? Or do you have to manually add the html code yourself?

[DragonByte Tech]

I'm really only interested in the bounced mail handling. I'm even willing to pay for that, but I assume private Beta means it's not even in a paid version?Correct, but it will be rolling out to all versions in the not too distant future as it seems pretty stable :)

The responses do say "html enabled" but I'm not clear what this means. Does this mean that you can design an email in this mod once it's installed in vBulletin 4, add some images and then send? Or do you have to manually add the html code yourself?This mod uses the CKEditor as its editor, there's absolutely not a HTML designer included. You should be able to paste HTML code, though :)


Fillip

[killerford]

Does this send messages to all usergroups on the forum or via email?

[DragonByte Tech]

I'm getting the warning that I have Suhosin set as too restrictive to allow vbMail to work properly.

Is this a major issue? What should I be changing?This means you may not be able to configure usergroup permissions for this mod correctly, as Suhosin will in its infinite wisdom decide to crop off the remaining form elements until it's below it's arbitrary limits.

The error message advises you what to change - if that doesn't work, you will need to contact your host for advice on how to configure Suhosin as I unfortunately don't know :(

Does this send messages to all usergroups on the forum or via email?Email :)


Fillip

[oddmud]

It's not marking people with bounced email for some reason? I've sent out two emails and have had multiple bounces, but those users aren't marked with the bounce flag. What am I doing wrong?

[DragonByte Tech]

By default, it takes 5 bounced emails before they are marked. You can change this setting in the vBulletin Options for this mod.

Fillip

[oddmud]

By default, it takes 5 bounced emails before they are marked. You can change this setting in the vBulletin Options for this mod.


Fillip

I set it to two. Still not changing anything.

[DragonByte Tech]

You'll need to re-run the Threshold Scheduled Task for vBMail to flag the new users.

Fillip

[oddmud]

Just ran it, still those users aren't showing as flagged when I look them up.

Also when I look at the Bounce Mail List, it's showing nothing.

[DragonByte Tech]

Please try running the Collect Bounced Mail scheduled task.

It's possible there may be a misconfiguration that's preventing vBMail from fetching the bounced emails, or you're using the Automatic handling and the receiving mail server stripped vBMail's headers before returning the email.

In the case of the latter, when vBMail sends emails it adds 2 special headers to the email that lets it know who it bounced from and from what mailing list.

In the Automatic mode, if those headers are missing from the return email, it will discard the email outright (it will believe the email is an email manually sent to your bounce email address).

Also, you should ensure that in Email Options (vBulletin, not vBMail) you set the Bounced Email Address setting to the same email you've configured for vBMail.

Fillip

[oddmud]

There we go it's having some serious issues with collecting... I manually tried to run it and got a huge error.

Fatal error: Could not open the connection to the mailbox, please check your configuration.
in [path]/dbtech/vbmail/includes/class_imap.php on line 87
#0 vb_error_handler(256, Could not open the connection to the mailbox, please check your configuration.

It looks like it's trying to log in, and not getting anywhere.

[DragonByte Tech]

If you're running a cPanel based server, try running with IMAP port 993, Mailbox INBOX and Use SSL Yes.

Also, the IMAP User Name is bounce+yourdomain.com (assuming bounce@yourdomain.com is the actual email you created, of course).

You have no idea how much grief I had trying to log on from my email app before I learned to put a + in the login name instead of the @ :(


Fillip

[oddmud]

Really? Wow, you learn something new every day. It's not cPanel, it's Plesk. I'll dig a little deeper, thanks for your help thus far. Appreciated.

[DragonByte Tech]

I have no experience with emails in Plesk unfortunately :(

If it's anything like cPanel, it'll have instructions for how to log in using an email app like the one on your smartphone or Thunderbird, Outlook etc. The same login name that works for those apps should work here :)


Fillip

[oddmud]

I guess this can't be used with the internal PHP mail() function.

[DragonByte Tech]

I'm not 100% certain about that tbh, I guess that would depend on whether it's passing the headers correctly.

I tend to recommend using SMTP anyway since it's more robust.

Fillip

[lazytown]

Correct, but it will be rolling out to all versions in the not too distant future as it seems pretty stable :)



Can you tell me if there have been any updates from the beta in Oct (1.1.7) to now? I was asking previously about it handling bounced emails from all emails sent out (pm notifications, threads subscriptions, etc). I was sent a beta link that supposedly did so, but haven't seen any progress or since then. I haven't tried the beta due to concerns it wasn't ready. Does the live pro version on dbtech include the ability to handle bounces from outside just this script's mailing list?

[DragonByte Tech]

I haven't updated the files here on vBulletin.org, but the people who have tried out the cPanel/WHM mail server failure catcher code have not reported any problems, nor have we on DBTech :)


Fillip

[dog-tag]

Really? Wow, you learn something new every day. It's not cPanel, it's Plesk. I'll dig a little deeper, thanks for your help thus far. Appreciated.

With plesk use -
user+domain.com
SSL yes

I've just got it connected using that, waiting to see if the bounces process now.

[DragonByte Tech]

You can test it by manually sending an email to your bounce handler (use an email not connected to your forum, or create a new one off your server) then manually re-run the Collect Bounced Mail scheduled task - if it catches the email you should be good to go :)


Fillip

[marup]

Hi

i installed VbMail 1.1.7 on Vbulletin 4.2.0
when i try to run Manually Scheduled Option "DragonByte Tech: vBMail - Collect Bounced Mail" i have this error:

DragonByte Tech: vBMail - Collect Bounced Mail Fatal error: Could not open the connection to the mailbox, please check your configuration.

Imap user account is ok, i tried to configure in Mozilla Thunderbid and i can receive mail.
I don't use Plesk, but a dedicated server.

can you help me ?

Tnx

[DragonByte Tech]

IMAP settings used for vBMail are different than SMTP settings which you use to receive mail.

Can you show me a screenshot of your settings - redact the password, obviously.

Fillip

[marup]

Ok, see screenshots :)

[DragonByte Tech]

Try the following alterations:
1. Set IMAP Host to localhost
2. Set IMAP Port to 993
3. Replace the @ in IMAP User Name with a +

Let me know if that works for you :)


Fillip

[marup]

localhost ?
imap server is not the same of Vbulletin server forum.

[DragonByte Tech]

Ah okay, disregard that particular change then :)


Fillip

[Morrus]

I'm sure I'm doing something wrong, but I can't for the life of me get these emails to arrive. It says they're being sent, but nothing arrives. I get the other email notifications from the site just fine.

[DragonByte Tech]

Do you have WHM on your server and access to it? If so, you can check for mail delivery reports.

Also, keep in mind that this uses vBulletin's mailqueue system, so you may just have a backlog that the cron job has not processed yet.

Fillip

[DragonByte Tech]

vBMail v1.1.8
Feature: List-Unsubscribe header to allow email providers to aid users in unsubscribing
Change: Altered the language of the Unsubscribe portion of the email to make it more unique to each forum

Fillip

[pgc-cs]

Is there any chance to put sending emails into background? I have almost 100 000 users on my forum and must wait over an hour with open tab to send emails for all of them... Or maybe an chance to speed it up?

[DragonByte Tech]

It already is in the background, the page you see is not email sending but adding the emails to the queue :)

It's important that this is in the front-end so that any issues can be discovered.


Fillip

[pgc-cs]

I know that sending is in background, but this adding take so much time in that amount of users. Maybe there's an option to speed it up?

[DragonByte Tech]

No such option I'm afraid, this is as fast as it'll go :(


Fillip

[lazytown]

Does 1.8 incorporate the 1.7 beta features of eliminated bounces from any type of bounce generated by the forum?

[DragonByte Tech]

It was never about eliminating bounces from any type of bounce generated by the forum - it was catching a specific type of bounced email generated by a specific mail server software such as the one found in cPanel/WHM based servers.

And yes it does :)


Fillip

[lazytown]

Just so I'm sure I understand -- forum is setup on a cpanel/whm server... If the forum sends out an email that generates a bounce from say a yahoo, gmail or hotmail address, this program will then modify the forum account that generated the bounced email: ex: removing subscriptions and notifying member via PM that their email address needs to be updated -- correct? (EXTREMELY USEFUL)

OR does the email receiving server have to also be a cpanel/WHM server (in which case this would be fairly useless).

[DragonByte Tech]

forum is setup on a cpanel/whm server... If the forum sends out an email that generates a bounce from say a yahoo, gmail or hotmail address, this program will then modify the forum account that generated the bounced email: ex: removing subscriptions and notifying member via PM that their email address needs to be updated -- correct? (EXTREMELY USEFUL)Correct :)


Fillip

[maria bartolome]

send email HTML ??

[DragonByte Tech]

Yes, this mod supports email sending with HTML :)


Fillip

[DragonByte Tech]

vBMail v1.1.9
Feature: Improved logging details for Control Panel actions
Change: Changed the Branding display method to inject itself into the copyright footer (underneath vBulletin copyright) instead of the page footer.
Change: Changed the Branding Free Key to a more secure key.

Fillip

[maria bartolome]

Yes, this mod supports email sending with HTML :)


Fillip

with images and links ?

[maria bartolome]

how and where to send this email options HTML ??

[Code Monkey]

Nice Mod except all the from addresses are username@com. Which of course sends it into spam folder if your lucky, get's your IP spam flagged if your not lucky. Any ideas?

[Code Monkey]

I was tired when I wrote the above. Let me give more detail.

Everywhere in the app the sender email address is displayed properly. But in the actual email received the domain is missing from the header of the email.

So instead of it showing the sender as username@mysite.com it shows it as username@com with the domain and trailing period removed. This will flag your emails as spam and either send them into a spam folder or most likely get you listed. Either outcome is undesirable but the latter is death to a forum.