Campaign mail are not sending automatically

šŸ’¬ General Discussion
21

Check that your db credentials are correct in config.php. Ensure that your database server is running.

Also could this be a firewall issue?

Check your database config file. Add the following

[mysqld]
bind-address = 0.0.0.0

Keep in mind that this will allow anyone to connect to your mysql server.

22

What config file will I need to add the code and where do I need to put the code?

23

You need to create a my.cnf file in /Applications/MAMP/conf/

and add

[mysqld]
bind-address = 0.0.0.0

Then restart the mysql server.

Ref:
https://stackoverflow.com/questions/678645/does-mysql-included-with-mamp-not-include-a-config-file

24

How do I create a .cnf file?

25

I have added the my.cnf file. But Mamp canā€™t make connection with MySQL server anymore.

These are the errors in mysql_error_log.err:

170808 17:08:50 mysqld_safe Logging to ā€˜/Applications/MAMP/logs/mysql_error_log.errā€™.

170808 17:08:51 mysqld_safe Starting mysqld daemon with databases from /Applications/MAMP/db/mysql56
error: Found option without preceding group in config file: /Applications/MAMP/conf/my.cnf at line: 1
Fatal error in defaults handling. Program aborted

170808 17:08:51 mysqld_safe mysqld from pid file /Applications/MAMP/tmp/mysql/mysql.pid ended

26

Have you tried copying on of the standard files from the /Applications/MAMP/Library/support-files/ directory and restarting your mysql server?

27

You mean editing a copy of this file:

For advice on how to change settings please see

http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

*** DO NOT EDIT THIS FILE. Itā€™s a template which will be copied to the

*** default location during install, and will be replaced if you

*** upgrade to a newer version of MySQL.

[mysqld]

Remove leading # and set to the amount of RAM for the most important data

cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

innodb_buffer_pool_size = 128M

Remove leading # to turn on a very important data integrity option: logging

changes to the binary log between backups.

log_bin

These are commonly set, remove the # and set as required.

basedir = ā€¦ <= [color=#bb0000]What goes here?[/color]

datadir = ā€¦<= [color=#bb0000]What goes here?[/color]

port = ā€¦ <= [color=#bb0000]8889? Default port?[/color]

server_id = ā€¦<= [color=#bb0000]What goes here?[/color]

socket = ā€¦<= [color=#bb0000]What goes here?[/color]

Remove leading # to set options mainly useful for reporting servers. [color=#bb0000]Should I just remove the #? From joinā€¦ till read?[/color]

The server defaults are faster for transactions and fast SELECTs.

Adjust sizes as needed, experiment to find the optimal values.

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

28

yes.

If that works, try and add the bind-address = * to the end of the file

Remember to restart your mysql server.

29

Great that worked! Should cron be running now as well?

30

Yes, the cron service needs to run for the campaign and other schedulers to work.

31

Yes, the cron service needs to run for the campaign and other schedulers to work.

32

I think the cron doesnā€™t activate the php file, my campaign isnā€™t running. Even when I hit the button ā€˜send as testā€™ nothing happens.

33

I am having a similar issue, if anyone can help please? I didnā€™t understand most of what is written above and I have never had to edit or create any code in SuiteCRM to make it do its thing before.

Firstly, I have successfully sent campaign emails before so I know it used to work. Not sure what has changed.
I can send emails to clients and do so all the time.
When I sent a test email from the campaign it works flawlessly.
My Crontab is setup
I have changed all my permissions to 777
I have done a quick repair and cleared my browser cache

When I click on the ā€œSend mail at scheduled timeā€ I get the ā€œEmails Scheduledā€ confirmation but nothing happens. All the emails are still in the queue.

I am getting this errorā€¦

[Tue Aug 15 00:00:07 2017] [error] [client MYIPADDRESS] [client MYIPADDRESS] ModSecurity: Warning. detected XSS using libinjection. [file "/services/mod_security-rules/12_asl_adv_xss_rules.conf"] [line "37"] [id "341256"] [rev "2"] [msg "Atomicorp.com WAF Rules: Possible Cross Site Scripting attack (detectXSS)"] [data "11196,ARGS:mce_0"] [severity "CRITICAL"] [hostname "MYSITE.com.au"] [uri "/SuiteCRM/index.php"]

Please someone, I have wasted enough time on this stupid problem!