Cron jobs are not worked

[bigroll]

Hello, I followed the tutorial exactly, but the cron jobs do not appear to be working. Please see the images below. Can anyone here solve this issue for me?
I use Ubuntu 20.04.5, PHP 7.4, nginx 1.23.2.
Thanks in advance!

 

[laurentiu]

Hello, I followed the tutorial exactly, but the cron jobs do not appear to be working. Please see the images below. Can anyone here solve this issue for me?
I use Ubuntu 20.04.5, PHP 7.4, nginx 1.23.2.
Thanks in advance

Can you check if your cron are the same like in Backend > Miscellaneous > Cron Jobs List ? Also can you check if php path is correct?

 

[bigroll]

Can you check if your cron are the same like in Backend > Miscellaneous > Cron Jobs List ? Also can you check if php path is correct?

Thanks for your response. Yeah I copy exactly from Backend > Miscellaneous > Cron Jobs List. How to check if php path is correct? I'm noob.

 

[laurentiu]

Thanks for your response. Yeah I copy exactly from Backend > Miscellaneous > Cron Jobs List. How to check if php path is correct? I'm noob.

You need to login on your server with ssh credentials and type in command line: which php, this will print path for php.

 

[bigroll]

You need to login on your server with ssh credentials and type in command line: which php, this will print path for php.

Yes it's correct as well

 

[laurentiu]

Yes it's correct as well

Can you try this https://www.mailwizz.com/kb/debug-send-campaigns-command/ and see what it's happening?

 

[bigroll]

I ran this command. What's problem?

 

[laurentiu]

This error: CDbConnection failed to open the DB connection happens for 2 reason:
1. The number of allowed mysql connections is too small, so adjust this in your mysql configuration.
2. MySQL cannot cope with the load and gives up. Add more RAM to the mysql server.

Check this article: https://kb.mailwizz.com/articles/mysql-mariadb-optimisations/

 

[bigroll]

There are more than 2000 connections and 6GB RAM for mySQL but still not working. Do you know something else which can cause this problem?

 

[laurentiu]

Do you know something else which can cause this problem?

can you show a screenshot with Backend->Settings->Cron->Delivery settings ?

Also can you try increase the number of connections, then restart mysql and check it.
You can also look in mysql logs for anything that looks related.

 

[bigroll]

This is my Cron -> Delivery settings
i tried increase the number of connections but still not working

 

[twisted1919]

@bigroll - You might be using a different PHP version in command line than the one in your web server, which means they might be configured differently.
If you run the command /usr/bin/php -v from command line what do you get and how does the version output compares with what you see in your application in Backend > Misc > PHP Info?

 

[bigroll]

they are same version

 

[twisted1919]

That's great then!
Maybe open a support ticket for us to take a look? Include backend url and login to your app and ssh to the server.

 

[bigroll]

That's great then!
Maybe open a support ticket for us to take a look? Include backend url and login to your app and ssh to the server.

Yes. Please let me know how to open a ticket and inform me what information you need to fix this issue.

 

[laurentiu]

Yes. Please let me know how to open a ticket and inform me what information you need to fix this issue.

Use https://forum.mailwizz.com/support-tickets/open to open a support ticket. Add there your application url with access credentials also include ssh access to your server.

 

[bigroll]

Use https://forum.mailwizz.com/support-tickets/open to open a support ticket. Add there your application url with access credentials also include ssh access to your server.

Thank you. I opened a ticket and provided the necessary credentials for you.