Joobi

On Linux, check to make sure the mysql daemon didn't die. If you have shell access, from a command line:

ps -ef|grep mysql

Should return at least two instances of mysql. If not, the service needs to be restarted. Google start mysql linux for detailed instructions.

Or on Windows, restart the mysql service. Google for instructions if you have desktop access to your server, otherwise let your hosting service know.

I manage a corporate intranet with tons of php/mysql apps, and that message invariably means that mysql has crashed.

Hi miha. Your article helped a little bit. I had to reduce the e-mails sent per batch to 10 instead of 50. The e-mails then were sent out fine but stopped at 512 where they shoud have gone to 651. Also SENT report was sent and the newsletter symbol still shows "unpublished".

Why did it not go past 412? Wondering if it has to do with the webhost settings. Maybe they changed something.

At least by the way it works, I doubt that it has to do with the MYSQL.

Let me know what you think.

Hi,

I still think that this is your database server mistake. You could also try to use cron job task to send out your mailings.

I installed the new version of acajoom 3.0.9

I also posted a ticket to my webhost and got the answer that
no more than 400 e-mails can be sent per hour. This explains the cap around after the 412.

I hate to make smaller e-mail lists since they automatically grow and will reach the 400 number anyway.

So can I set up a CRON JOB that would do 400 E-mails and then wait an hour before it sends the next batch?

Can you send me the technical link "On how to create a CRON JOB" out of the knowledge base?

Best regards
Hanspeter Tschupp

I tried to setup the CRON JOB on my Server (Siteground).

I setup an E-mail report when the CRON is executed.

This comes back:

/bin/sh: /root/index2.php?option=com_acajoom: Permission denied

Do I have to change some permissions or is something with my Acajoom config. which has to be changed so the CRON is executed correctly?

Thanks for the suggestions. None of them works.

Let me first understand the basics:

1. What exactly should this CRON job do? Apparently there is a file index2.php in the joomla root directory of my server. It has the permissions 644. So it cannot be executed.

So does the CRON has to trigger this php file?

2. ?option=com_acajoom -> what does this do? Apparently it addresses the component acajoom?

What does it do then? Does it trigger the acajoom queue of unpublished newsletters and send them in batches to the e-mail recipients of corresponding list?

Then I went into a video-tutorial of Sitegrund on how to setup a CRON. There are two options (tabs):

a) Standard
b) Advanced (Unix Style)

They suggest only to use the Standard variant unless one has
knowledge on how to handle standard Linux RedHat programming.

So the STANDARD tab has an entry field with the "Command to run"-field.

They make an example on how to run a cgi script in the cgi-bin folder. They enter into the "Command to run" field:

home/panfloet/public_html/cgi-bi/clients.cgi

So let's get some clarity into the picture and then try it again.

There must be a way to get this CRON working.