CiviCRM Community Forums (archive)

 I'm on www.ho-re-ca.biz with civicrm 2.1 beta3 and drupal 6.4

Outgoing SMTP configuration
SMTP server: Localhost
Authentication: user and password setted as well as the bluehost's helpdesk said
SMTP port: 25

Hack: Return-Path
•   CRM/Mailing/BAO/Mailing.php
•   Comment out line 857 (Reply-to) and 858 (Return-Path)
•   857 addresses the problem where BH no longer allows catchall mail accounts, so there is no way to grab reply-to emails that built with a token value. It simply disables this.
•   858 addresses problem outlined here:
http://www.nabble.com/CiviMail-Bounce-to8427763.html

here are 2 commented lines:
 //       'Reply-To'  => CRM_Utils_Verp::encode($verp['reply'], $email),
 //     'Return-Path' => CRM_Utils_Verp::encode($verp['bounce'], $email),

 I don't have set the cron job yet thus I am forcing the emails sending with this URL: http://www.ho-re-ca.biz/civicrm/mailing/queue?reset=1

So If I send only a single mail from a contact I receive this error message
SMTP: Authentication failed. (code: 221, response: box448.bluehost.com closing connection)

But if I send a bulk mailing, after the forcing, I've got the 100% of bouncing in the report of the sending.
forcing link: http://www.ho-re-ca.biz/civicrm/mailing/queue?reset=1
After that, if I take a look at the bouncing's link I can see this information: Bouncing type Unknown.

then i tryed to use email.it smpt insted of ho-re-ca.biz , always with port 25 and I get this error:
The mail library returned the following error message: Failed to connect to smtp.email.it:25 [SMTP: Failed to connect socket: Connection refused (code: -1, response: )]

then with email admn@ho-re-ca.biz port 25 I get this error:
The mail library returned the following error message: Failed to add recipient: manuel.passarella@gmail.com [SMTP: recipient is not recognized (code: 550, response: Verification failed for No Such User Here Sender verify failed)]

using 26 door I get this error:
The mail library returned the following error message: Failed to add recipient: manuel.passarella@gmail.com [SMTP: recipient is not recognized (code: 550, response: Verification failed for No Such User Here Sender verify failed)]

I have then also changed SMTP address to ho-re-ca.biz and username in admin, but again don't go
then I changed smtp with mail.ho-re-ca.biz
--------------------------------------------------------------
I called again bluehost chat and they told me:
mail.yourdomain.com for the smtp server. Username is your email address and you do need authentication
so now I try in this way and this again don't go..

then I added to my "civicrm.settings.php" file and into /sites/all/default folder.

/**

 * SMTP Server Authentication Password:

 *

 * If your SMTP server requires authentication, you will enable that and enter the

 * Username from Administer CiviCRM >> Global Settings >> SMTP. Then enter the

 * authentication Password below.

 *

 */

define( 'CIVICRM_SMTP_PASSWORD', 'password'    );



/**

You put your account password in where it says 'password'

and then I launched emails with this line:
http://www.example.org/sites/all/modules/civicrm/bin/civimail.cronjob.php?name=USERNAME&pass=PASSWORD

but don't go, so:
I added in this path:
/home1/myaccount/public_html/mydomain/sites/all/default
settings.php
civicrm.settings.php

adding into civicrm.settings.php these lines:
/**

 * SMTP Server Authentication Password:

 *

 * If your SMTP server requires authentication, you will enable that and enter the

 * Username from Administer CiviCRM >> Global Settings >> SMTP. Then enter the

 * authentication Password below.

 *

 */

define( 'CIVICRM_SMTP_PASSWORD', 'password'    );



/**


and then i receive this error message:
backTrace

/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 138

, handle,
/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/packages/DB.php, PEAR_Error, 966


/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/packages/PEAR.php, DB_Error, 574
/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/packages/DB/common.php, raiseError, 1903
/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/packages/DB/mysql.php, raiseError, 898


/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/packages/DB/mysql.php, mysqlRaiseError, 327
/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/packages/DB/common.php, simpleQuery, 1216


/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/CRM/Utils/System/Drupal.php, query, 221
/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/CRM/Utils/System.php(450) : eval()'d code, authenticate, 1

/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/CRM/Utils/System.php, eval, 450
/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/CRM/Utils/System.php, authenticate, 422
/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/bin/civimail.cronjob.php, authenticateScript, 51

/home1/estufeco/public_html/ho-re-ca_biz/sites/all/modules/civicrm/bin/civimail.cronjob.php, run, 57

unrecoverable error
    Sorry. A non-recoverable error has occurred.

    DB Error: no such table

    Database Error Code: Table 'estufeco_civicrmhoreca.users' doesn't exist, 1146

    Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = '7548ccca8900441b22c1675ffe50a01a' AND u.status = 1 [nativecode=1146 ** Table 'estufeco_civicrmhoreca.users' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = '7548ccca8900441b22c1675ffe50a01a' AND u.status = 1 [nativecode=1146 ** Table 'estufeco_civicrmhoreca.users' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = '7548ccca8900441b22c1675ffe50a01a' AND u.status = 1 [nativecode=1146 ** Table 'estufeco_civicrmhoreca.users' doesn't exist]"]
)
next step , copy imap2soap.pl (getting it from here: https://svn.civicactions.net/repos/civicrm/scripts/)
 into path: /usr/local/bin/ or ~/bin/ or #!/usr/bin/perl or #!/usr/local/bin/perl
and try all of these also on civicrm 2.1 beta 5 and drupal 6.4 installed with simple scripts, if this don't go again, I'll try again installing drupal 6.4 by hand hoping something will be different[/code]

after figting so much, I buyed an hosting space here: http://www.drupalvaluehosting.com/members/aff.php?aff=111
where with little $ per month i can send till 4000 email per hour and more

ok, now this send emails, and there are no problems of limit of sending emails, so i have toset a cron job, or it is ok also if i put to send only 1 email per second?
I'll have to send till 45.0000 emails for mailing for now..

for security problems they don't allow to execute wget
wget 'http://your-domain.org/path/to/civicrm/bin/civimail.cronjob.php?name=civimailuser&pass=civimailuserpassword'
so i have to find an alternative method.. which i could?

and they told me that for cron job , I should enter #!/usr/local/bin/php.cli including this line at the beginning of the script I will be running, but which script I'll run?

Using civicrm 2.2 beta 4 with sendmail:
using default path don't go: /usr/bin/sendmail
USING THIS SENDMAIL PATH IS GOING: /usr/sbin/sendmail

-----------Instead with SMTP I get these errors:
Oops. Your SMTP settings are incorrect. No test mail has been sent.

Error message:
Failed to connect to mail.1hotellerie.eu:26 [SMTP: Failed to connect socket: Connection timed out (code: -1, response: )]
-----------------
Oops. Your SMTP settings are incorrect. No test mail has been sent.

Error message:
Failed to connect to mail.1hotellerie.eu:25 [SMTP: Failed to connect socket: Connection refused (code: -1, response: )]
-----------------
Using door 25 and SMTP: localhost  is going with an smtp not into bluehost.com mx recods:

status
    Your SMTP settings are correct. A test email has been sent to your email address.
-----------------------
with a normal domain egistered into bluehost with mx recods into bluehost trough door 26 is all right:
Your SMTP settings are correct. A test email has been sent to your email address.
------------
Using door 25 and SMTP: localhost  (with an smtp not into bluehost.com mx recods) is getting delivered locally
----------
then I have set Mailer Spool Period= 60 seconds= 1 minute
Mailer Batch Limit= 6
60 x6 = 360 emails pe hou, less of the limit of tophost of 500 emails per hour.
anyway bluehost send emails tough a common ip and this easily could go in spam for big amount of emails to send.