JackGoa
Member
Hi, I've been experiencing issues with cron emails that don't all go out anymore and I don't know exactly how to go about troubleshooting it. I'll try to explain what I've found.
First of all (not related to this issue, but an issue nevertheless), the time of the crons seem to be on universal time, they don't use the server's time. It's a small thing, but I have noticed this on all sites where I use cron emails.
So, on one site, I have 12 crons setup. 10 are email crons and 2 are php crons. From what I can tell, since the J3.6/Fabrik3.5 update, my email crons will only get about halfway and then the rest don't run. As far as configuration or anything goes, nothing has changed from my side. they were literally working one day, then not the next day.
It seems that sometimes only 4 email crons will run and only 1 php cron, sometimes 6 or only 5, there does not seem to be any consistency like before.
The only entries I can find in the logs are:
Fabrik DB log:
- 8192,mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead,/var/www/xxx/xxxx/httpdocs/libraries/joomla/database/driver/mysql.php,89
- 8,Undefined index: rowid,/var/www/xxx/xxxx/httpdocs/components/com_fabrik/router.php,231
Server error log (a Joomla error. I think the slash before /media/ should not be there, not sure?):
mod_fcgid: stderr: PHP Warning: is_file(): open_basedir restriction in effect. File(/media/system/js/caption.js) is not within the allowed path(s): (/var/www/xxx/xxxx/:/tmp/) in /var/www/xxx/xxxx/httpdocs/libraries/joomla/filesystem/file.php on line 626
Other than that, I have no idea where else to look to troubleshoot this issue? I've been monitoring it for a few days now, and it's definitely an ongoing problem.
I also found this in Fabrik's logs, but fixed it by changing the SMTP settings in Joomla's config. Even though, I don't understand why it suddenly insists on using SSL now? But obviously unrelated to the cron thing, just thought to mention it in case:
2,stream_socket_enable_crypto(): Peer certificate CN=`my.sslserveraddress.com' did not match expected CN=`localhost',/var/www/xxx/xxxx/httpdocs/libraries/vendor/phpmailer/phpmailer/class.smtp.php,344
First of all (not related to this issue, but an issue nevertheless), the time of the crons seem to be on universal time, they don't use the server's time. It's a small thing, but I have noticed this on all sites where I use cron emails.
So, on one site, I have 12 crons setup. 10 are email crons and 2 are php crons. From what I can tell, since the J3.6/Fabrik3.5 update, my email crons will only get about halfway and then the rest don't run. As far as configuration or anything goes, nothing has changed from my side. they were literally working one day, then not the next day.
It seems that sometimes only 4 email crons will run and only 1 php cron, sometimes 6 or only 5, there does not seem to be any consistency like before.
The only entries I can find in the logs are:
Fabrik DB log:
- 8192,mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead,/var/www/xxx/xxxx/httpdocs/libraries/joomla/database/driver/mysql.php,89
- 8,Undefined index: rowid,/var/www/xxx/xxxx/httpdocs/components/com_fabrik/router.php,231
Server error log (a Joomla error. I think the slash before /media/ should not be there, not sure?):
mod_fcgid: stderr: PHP Warning: is_file(): open_basedir restriction in effect. File(/media/system/js/caption.js) is not within the allowed path(s): (/var/www/xxx/xxxx/:/tmp/) in /var/www/xxx/xxxx/httpdocs/libraries/joomla/filesystem/file.php on line 626
Other than that, I have no idea where else to look to troubleshoot this issue? I've been monitoring it for a few days now, and it's definitely an ongoing problem.
I also found this in Fabrik's logs, but fixed it by changing the SMTP settings in Joomla's config. Even though, I don't understand why it suddenly insists on using SSL now? But obviously unrelated to the cron thing, just thought to mention it in case:
2,stream_socket_enable_crypto(): Peer certificate CN=`my.sslserveraddress.com' did not match expected CN=`localhost',/var/www/xxx/xxxx/httpdocs/libraries/vendor/phpmailer/phpmailer/class.smtp.php,344