vb.org Archive - Administrative and Maintenance Tools

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Administrative and Maintenance Tools - [DBTech] vBMail v2 (vB4) (https://vborg.vbsupport.ru/showthread.php?t=266142)

Ohhh sorry to have missed that...

Thanks a lot Filip !

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

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

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

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!)

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.

Quote:

Originally Posted by arkueckelhan (Post 2296239)

If you configured the "Bounce Email Address" setting then yes I do believe that it will grab those bounced mail.

Fillip

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

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:

PHP Code:


		
			
VBMAIL_CACHE::build_cache('message');

Feel free to delete that datastore entry via

Code:

DELETE FROM vb_datastore WHERE title = 'dbtech_vbmail_message'

to save some database space :)

Fillip

It worked, thank you Fillip ! :)

Manuel

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 ?

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

Hi, the Check 4 Hacking vers. 1.0 addon say:

Quote:

infect in dbtech_vbmail_message module

Its true? Please check!

Regards

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

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

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

Fillip

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

Fillip

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

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

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

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.

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

Fillip

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

Is there anyway to throttle the messages sent per hour?

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

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.

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.

Quote:

Originally Posted by stemmy (Post 2314153)

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

PHP Code:


		
			
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.

Quote:

Originally Posted by stemmy (Post 2314153)

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:

Code:

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

Code:

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

Code:

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

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

Quote:

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

Quote:

Originally Posted by KGodel (Post 2315241)

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.

This is full message

Code:

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

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

Fillip

Fixed. Thanks Fillip :D

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 ?

Yeah it will :)

Fillip

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?

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

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

Here is the error:

PHP Code:


		
			
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-i...d-email-gmail/

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

Thanks..

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

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.

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02173 seconds Memory Usage 1,846KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_code_printable (3)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: