Jump to content

Mail Bouncer - Automated Bounce Management


Recommended Posts

Besides this error, also cron errors:

Hello,

 


this error is caused by the DB Table field "bouncer_warning" which isn't part of the core software.
Do you have any 3rd party applications or plugins, which could cause this?
If yes, i would suggest to contact the 3rd party developer for further support.

 

 

Regards,

 

Daniel Fatkic
Invision Power Services, Inc.

The errors:

Cron <user@xeon> /usr/local/bin/php -d memory_limit=-1 -d max_execution_time=0 /home/user/public_html/forum/applications/core/interface/task/task.php b221a0031452bc26ba11ab19dc169a32
Exception:
IPS\Db\Exception Object
(
    [query] => UPDATE `core_members` core_members  SET `allow_admin_mails`=?,`bouncer_warning`=?,`bouncer_disabled`=?,`members_cache`=?,`members_bitoptions`=?,`members_bitoptions2`=? WHERE member_id=?
    [binds] => Array
        (
            [0] => 1
            [1] =>
            [2] => 1
            [3] => a:3:{s:7:"friends";a:0:{}s:13:"msgAlertReset";i:1338561989;s:7:"bouncer";a:1:{s:12:"disabledTime";i:1398656257;}}
            [4] => 1073807360
            [5] => 0
            [6] => 2
        )

    [message:protected] => Unknown column 'bouncer_warning' in 'field list'
    [string:Exception:private] =>
    [code:protected] => 1054
    [file:protected] => /home/user/public_html/forum/system/Db/Db.php
    [line:protected] => 386
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/user/public_html/forum/system/Db/Db.php
                    [line] => 817
                    [function] => preparedQuery
                    [class] => IPS\_Db
                    [type] => ->
                    [args] => Array
                        (
                            [0] => UPDATE `core_members` core_members  SET `allow_admin_mails`=?,`bouncer_warning`=?,`bouncer_disabled`=?,`members_cache`=?,`members_bitoptions`=?,`members_bitoptions2`=? WHERE member_id=?
                            [1] => Array
                                (
                                    [0] => 1
                                    [1] =>
                                    [2] => 1
                                    [3] => a:3:{s:7:"friends";a:0:{}s:13:"msgAlertReset";i:1338561989;s:7:"bouncer";a:1:{s:12:"disabledTime";i:1398656257;}}
                                    [4] => 1073807360
                                    [5] => 0
                                    [6] => 2
                                )

                        )

                )

            [1] => Array
                (
                    [file] => /home/user/public_html/forum/system/Patterns/ActiveRecord.php
                    [line] => 442
                    [function] => update
                    [class] => IPS\_Db
                    [type] => ->
                    [args] => Array
                        (
                            [0] => core_members
                            [1] => Array
                                (
                                    [allow_admin_mails] => 1
                                    [bouncer_warning] =>
                                    [bouncer_disabled] => 1
                                    [members_cache] => a:3:{s:7:"friends";a:0:{}s:13:"msgAlertReset";i:1338561989;s:7:"bouncer";a:1:{s:12:"disabledTime";i:1398656257;}}
                                    [members_bitoptions] => 1073807360
                                    [members_bitoptions2] => 0
                                )

                            [2] => Array
                                (
                                    [0] => member_id=?
                                    [1] => 2
                                )

                        )

                )

            [2] => Array
                (
                    [file] => /home/user/public_html/forum/system/Member/Member.php
                    [line] => 295
                    [function] => save
                    [class] => IPS\Patterns\_ActiveRecord
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [3] => Array
                (
                    [file] => /home/user/public_html/forum/applications/bouncer/extensions/core/Queue/PostThreeUpgrade.php
                    [line] => 120
                    [function] => save
                    [class] => IPS\_Member
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [4] => Array
                (
                    [file] => /home/user/public_html/forum/applications/core/tasks/queue.php
                    [line] => 113
                    [function] => run
                    [class] => IPS\bouncer\extensions\core\Queue\_PostThreeUpgrade
                    [type] => ->
                    [args] => Array
                        (
                            [0] => Array
                                (
                                    [maxMember] => 130780
                                )

                            [1] => 0
                        )

                )

            [5] => Array
                (
                    [file] => /home/user/public_html/forum/system/Task/Task.php
                    [line] => 172
                    [function] => execute
                    [class] => IPS\core\tasks\_queue
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [6] => Array
                (
                    [file] => /home/user/public_html/forum/system/Task/Task.php
                    [line] => 141
                    [function] => run
                    [class] => IPS\_Task
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

            [7] => Array
                (
                    [file] => /home/user/public_html/forum/applications/core/interface/task/task.php
                    [line] => 58
                    [function] => runAndLog
                    [class] => IPS\_Task
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] =>
)

 

Link to comment
On 01 October 2015 2:03:33, sobrenome said:

Could not upgrade:


1S111/1 file_put_contents(/home/xxx/public_html/forum/plugins/hooks.txt): failed to open stream: Permission Denied

 

The file should be writable in all IPS4 installations, this is unrelated to this app.
 

17 hours ago, sobrenome said:

Besides this error, also cron errors:

This suggests that the IPS4 upgrader didn't create the columns, the support tool should fix this.
 

17 hours ago, sobrenome said:

Sorry, there is a problem
The page you are trying to access is not available for your account.
Error code: 2S100/2

 

Sorry, I didn't realise the link had been mangled, for future reference it's Mandrill Bouncer Support

Link to comment
On 13 October 2015 5:48:04, sobrenome said:

Another error:


Fatal error: Cannot use object of type stdClass as array in /home/user/public_html/forum/applications/bouncer/extensions/core/Queue/ProcessRejects.php on line 53

 

Please use the ticket system, support issues like these usually require access to see what's going on.
 

46 minutes ago, Kjell Iver Johansen said:

In my errorlog file there is an error coming all the time. Is there an issue there?

2015-10-16 18:23:31]: error: file is writable by others: (xxx/applications/bouncer/interface/mandrill/webhooks.php)

I assume this is suphp or something not liking the default permissions apps are installed with. You should post this in IPS technical support, it would affect any app you install via ACP.

Link to comment
  • 2 weeks later...
  • 2 weeks later...

Hello - I get the following email from mandrill. Theres also an error in ACP when enabling this hook (EX28 error)

Your Mandrill webhook at URL http://www.xxx.no/interface/bouncer/mandrill.php has failed with the following error: POST to http://www.xxx.no/interface/bouncer/mandrill.php failed with 503: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" /> <meta http-equiv="Pragma" content="no-cache" /> <meta http-equiv="Cache-Control" content="no-cache" /> <meta http-equiv="Expires" content="Fri, 01 January 1999 01:00:00 GMT" /> <title>www.xxx.no Driver Error</title> <style type='text/css'> body,div,dl,dt,dd,ul,ol,li,h1,h2,h3,h4,h5,h6,pre,form,fieldset,input,textarea,p,blockquote,th,td { margin:0; padding:0; } table {	border-collapse:collapse; border-spacing:0; } fieldset,img { border:0; } address,caption,cite,code,dfn,em,strong,th,var { font-style:normal; font-weight:normal; } ol,ul { list-style:none; } caption,th { text-align:left; } h1,h2,h3,h4,h5,h6 { font-size:100%;	font-weight:normal; } q:before,q:after { content:''; } abbr,acronym { border:0; } hr { display: none; } address{ display: inline; } body { font-family: arial, tahoma, sans-serif; font-size: 0.8em; width: 100%; } h1 { font-family: arial, tahoma, "times new roman", serif; font-size: 1.9em; color: #fff; } h2 { font-size: 1.6em; font-weight: normal; margin: 0 0 8px 0; clear: both; } a { color: #3e70a8; } a:hover { color: #3d8ce4; } a.cancel { color: #ad2930; } #branding { background: #484848; padding: 8px; } #content { clear: both; overflow: hidden; padding: 20px 15px 0px 15px; } * #content { height: 1%; } .message { border-width: 1px; border-style: solid; border-color: #d7d7d7; background-color: #f5f5f5; padding: 7px 7px 7px 30px; margin: 0 0 10px 0; clear: both; } .message.error { background-color: #f3dddd; border-color: #deb7b7; color: #281b1b; font-size: 1.3em; font-weight: bold; } .message.unspecific { background-color: #f3f3f3; border-color: #d4d4d4; color: #515151; } .footer { text-align: center; font-size: 1.5em; } .database-error { padding: 4px 0px 10px 80px; margin: 10px 0px 10px 0px; } textarea { width: 700px; height: 250px; } </style> </head> <body id='ipboard_body'> <div id='header'> <div id='branding'> <h1>www.fjellforum.no Driver Error</h1> </div> </div> <div id='content'> <div class='message error'> There appears to be an error with the database. </div> <p class='message unspecific'> If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again. <br /><br /> You can try to refresh the page by clicking <a href="#" onclick="window.location=window.location; return false;">here</a> </p> <p class='message unspecific footer'> ← <a href='/index.php' title='Go to home page'>Return to the index</a> </p> </div> </body> </html> . 

 

Link to comment
  • 4 weeks later...

Hi. I loved the idea of this plugin. However, I don't use Mandrill as of yet. So, I have two questions:

1. Do you know of a plugin to handle bounces through IMAP/POP3, as we run our own servers?

2. If that doesn't exist, I can even consider moving to Mandrill just to automate this whole process. However, I have no idea of how much that would cost me because I don't know who many emails per month goes out of our current server, so it is a little bit tricky to budget this functionality. Since you have way more experience managing large forums, any input about this would be highly appreciated.

Link to comment

@sto2000

Hi, I decided to give Mandrill a shot. Since it gives me 2,000 free email sends, I think I can test it for a couple of days to see the email volume we generate. I've just bought your app, I think it is a good investment, even if just for trying it out.

I have an interesting question.

I have a list of users who have broken emails from a previous tool I was using before with 3.4.x (https://community.invisionpower.com/files/file/6846-sd-outdate-emails/). The structure of this other tools is as follows:

mysql> describe sd_outdate_emails;
+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| outdate_id           | int(11)      | NO   | PRI | NULL    | auto_increment |
| outdate_member_id    | mediumint(9) | NO   |     | NULL    |                |
| outdate_member_email | varchar(255) | NO   |     | NULL    |                |
| outdate_time         | int(11)      | NO   |     | NULL    |                |
| outdate_set_member   | mediumint(9) | NO   |     | NULL    |                |
| outdate_ip_address   | varchar(46)  | NO   |     | NULL    |                |
+----------------------+--------------+------+-----+---------+----------------+

This table has over 70,000 records (all hard bounces), so if I could import them it would be super, as it would save us time, bandwidth, and money with Mandrill!

I see your structure uses core_members with three rows:

| bouncer_disabled          | tinyint(1)          | NO   | MUL | 0       |                |
| bouncer_warning           | tinyint(1)          | NO   | MUL | 0       |                |
| bouncer_spam              | tinyint(1)          | NO   | MUL | 0       |                |

Please advise if all I need to do is to set bouncer_disabled to 1 on the records of members that match my old tool.

I will leave this here also as a suggestion for you to add a conversion script for users like myself upgrading from this other tool.

Thank you in advance,

Gabriel.

Edited by Gabriel Torres
Link to comment
17 minutes ago, Gabriel Torres said:

@sto2000

Hi, I decided to give Mandrill a shot. Since it gives me 2,000 free email sends, I think I can test it for a couple of days to see the email volume we generate. I've just bought your app, I think it is a good investment, even if just for trying it out.

I have an interesting question.

I have a list of users who have broken emails from a previous tool I was using before with 3.4.x (https://community.invisionpower.com/files/file/6846-sd-outdate-emails/). The structure of this other tools is as follows:


mysql> describe sd_outdate_emails;
+----------------------+--------------+------+-----+---------+----------------+
| Field                | Type         | Null | Key | Default | Extra          |
+----------------------+--------------+------+-----+---------+----------------+
| outdate_id           | int(11)      | NO   | PRI | NULL    | auto_increment |
| outdate_member_id    | mediumint(9) | NO   |     | NULL    |                |
| outdate_member_email | varchar(255) | NO   |     | NULL    |                |
| outdate_time         | int(11)      | NO   |     | NULL    |                |
| outdate_set_member   | mediumint(9) | NO   |     | NULL    |                |
| outdate_ip_address   | varchar(46)  | NO   |     | NULL    |                |
+----------------------+--------------+------+-----+---------+----------------+

This table has over 70,000 records (all hard bounces), so if I could import them it would be super, as it would save us time, bandwidth, and money with Mandrill!

I see your structure uses core_members with three rows:


| bouncer_disabled          | tinyint(1)          | NO   | MUL | 0       |                |
| bouncer_warning           | tinyint(1)          | NO   | MUL | 0       |                |
| bouncer_spam              | tinyint(1)          | NO   | MUL | 0       |                |

Please advise if all I need to do is to set bouncer_disabled to 1 on the records of members that match my old tool.

I will leave this here also as a suggestion for you to add a conversion script for users like myself upgrading from this other tool.

Thank you in advance,

Gabriel.

Are you sure they're all valid?, that seems like a VERY high number.

Import them into Mandrill ( Settings > Rejection Lists > Rejection Blacklist ) and then they'll sync into the app as emails are sent.

Link to comment
On 18/12/2015 at 3:12 PM, wsf said:

what do you mean by "verify existing members" exactly? Check if all the email addresses of your members are valid, without sending them an email (or without using Mandrills service previously)?

Yes we want to check our 50.000 members email, its possible to do with your app ?

Link to comment
12 hours ago, Janyour said:

Yes we want to check our 50.000 members email, its possible to do with your app ?

Well, it's not my app, we're using this app too. Over time it is possible to check all members emails. We also have 50.000 members, but this (nor any other) tool can't magically tell if an email address is valid or not. A mail has to be sent out (via Mandrill) in order to be able to catch the reply (bounce), if any. See the opening post of this topic for details.

Link to comment
On 17 December 2015 at 5:00 PM, Janyour said:

Hi everybody, hi @stoo2000

is there an admin feature to verify the existing members email and show them in a list ? i think its very usefull for big communities to verify et filter emails to be always up to date.

 

5 minutes ago, wsf said:

Well, it's not my app, we're using this app too. Over time it is possible to check all members emails. We also have 50.000 members, but this (nor any other) tool can't magically tell if an email address is valid or not. A mail has to be sent out (via Mandrill) in order to be able to catch the reply (bounce), if any. See the opening post of this topic for details.

@wsf's reply is accurate, the best way to verify all emails would be to send out a bulk email to everyone. I generally wouldn't recommend sending emails to members that haven't visited in over a year though.
 

23 hours ago, Gabriel Torres said:

@stoo2000Opened a ticket on your bug tracker. I hope I did the right thing (opening there instead of posting here). Thanks.

Thanks, I'll see to that as soon as possible.

Link to comment

@sto2000 

Was my bug tracker deleted? I can't find it.

Found another bug.

If I disable your application, the 'queue' task gives an error:

PHP Fatal error:  Call to undefined method IPS\Member::bouncerHardBounce() in /#######/applications/bouncer/extensions/core/Queue/ProcessRejects.php on line 73

So, the background task your app adds doesn't check if the app is actually enabled or disabled...
 

Link to comment
16 minutes ago, Gabriel Torres said:

@sto2000

Was my bug tracker deleted? I can't find it.

Found another bug.

If I disable your application, the 'queue' task gives an error:

PHP Fatal error:  Call to undefined method IPS\Member::bouncerHardBounce() in /#######/applications/bouncer/extensions/core/Queue/ProcessRejects.php on line 73

So, the background task your app adds doesn't check if the app is actually enabled or disabled...
 

You submitted a support ticket (which is private).

I have also included the above information in the ticket so that it can be addressed.

Link to comment
  • 1 month later...

I purchased and installed your Mandill Bouncer. I set-up our Mandrill account. Sent out the bulk email. Why is the Mandrill Bouncer not working?

We sent over 48,000 emails via mandrill. Key was provided. I then went in as a member whose email hard bounced and saw no notification. We are aslo getting no stats in the Mandrill Bouncer - Statistics link in AdminCP.

Please advise.

everything required to be verified by mandrill was verified on mandrill as well.

Link to comment
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...