E-mail Fetching cron job no longer works

dedwards

Here's the server info:
Server Information
osTicket Version v1.12 (a076918) — Up to date
Web Server Software Apache/2.4.29 (Ubuntu)
MySQL Version 5.7.27
PHP Version 7.2.19-0ubuntu0.18.04.2

I setup a cron job to fetch e-mail from our IMAP server and it has been working with no problem. Yesterday I decided to enable to LDAP plugin and now the cron job no longer works. When I run the command line manually I get absolutely no output, it looks like it's working since no error is generated but when I check the mail server logs we don't even see an attempt to login from Os Ticket. Here's the command I run manually which used to work up until yesterday:

/usr/bin/php /var/www/html/osticket/api/cron.php

If I enable Fetch on Auto Cron, it works. Obviously, that's not ideal since we are not logged in the system all the time. We need to get the cron job working again.

I would appreciate some help on this.

Thanks

ntozier

I would recommend that you upgrade to current and re-test. I've run many different versions of osTicket and have been using the Authentication::LDAP plugin for many years and never had this problem.

dedwards

so you suggestion is to upgrade to the latest version from Oct 2, which REQUIRES php 7.3, which would force me to upgrade my php on Ubuntu (that's always a joy) so I can possibly fix some issue that may or may not be related to my Os Ticket version?

dedwards

So I followed you suggestion and upgraded to the latest version of Os Ticket, please see below:

Server Information
osTicket Version v1.12.3 (bcf1a6f) — Up to date
Web Server Software Apache/2.4.29 (Ubuntu)
MySQL Version 5.7.27
PHP Version 7.3.10-1+ubuntu18.04.1+deb.sury.org+1
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching

Yet the cron job is still not working. The Auto-fetch still works but like I mentioned it's not ideal. Does anyone have any idea where to look to figure out this problem? As I previously mentioned the cron job worked fine until I installed the LDAP plugin. I'm not necessarily blaming the plugin, it's just simply the last thing that changed on the server before I started having problems. I disabled the plugin but the problem still remains.

I looked at the other methods of triggering the polling but /api/tasks/ does not seem to exist. The documentation does not seem to be correct.

dedwards

bump.

ntozier

Well since you upgraded osTicket and disabled the plugin and are still having the problem then I would say that the plugin was never the problem to begin with.

Does your command line php's php.ini have error logging enabled? If so have you checked the error logs?

dedwards

Yes, log_errors = On is set in my /etc/php/7.3/cli/php.ini file. There are no errors anywhere. There is no indication of a problem, it simply doesn't work.

ntozier

Do you have more than one version of PHP installed?
Check /usr/bin and see if there is more than one php there.
You may find that PHP 7.x is there.

dedwards

I don't have any other php versions installed. I removed them when I installed php7.3.

Here's what's in /usr/bin:

ls -l /usr/bin/ | grep php
lrwxrwxrwx 1 root root 21 Jun 5 08:28 php -> /etc/alternatives/php
-rwxr-xr-x 1 root root 4683512 Oct 8 01:33 php7.3
lrwxrwxrwx 1 root root 25 Jun 5 09:20 php-cgi -> /etc/alternatives/php-cgi
-rwxr-xr-x 1 root root 4576680 Oct 8 01:33 php-cgi7.3

Here's /etc/alternatives/php:

/etc/alternatives# ls -l | grep php
lrwxrwxrwx 1 root root 15 Oct 12 06:45 php -> /usr/bin/php7.3

ntozier

Hmm.

So whats the actual cron job configuration that you are using?
And what is the settings in your Admin panel -> Emails -> Emails -> your email (that you should be checking). (Easiest if you post a screen shot.

dedwards

Here are the screenshots

Cronjob setting:

*/5 * * * * /usr/bin/php /var/www/html/osticket/api/cron.php

As I previously mentioned the cron job was working and then it just stopped working. I even installed a brand new installation of Os Ticket and I just copied ost-config.php to the new installation but still no joy.

Even running it like below from the command line yields the same results:

sudo -u www-data /usr/bin/php /var/www/html/osticket/api/cron.php

KevinTheJedi

@dedwards

Well, being that your return value for # ls -l | grep php was php -> /usr/bin/php7.3 I'd suggest changing your Cron Entry to the following:

*/5 * * * * /usr/bin/php7.3 /var/www/html/osticket/api/cron.php

*/5 * * * * php /var/www/html/osticket/api/cron.php

If that doesn't help see if uninstalling and deleting the plugin makes it work again (since you said the issue occurred after installing the plugin). If so, re-install and re-enable the plugin and ensure you have the php-ldap extension installed and enabled as well.

Cheers.

dedwards

Okay I got it figured out.

The Force SSL entry that I put in ost-config.php file seems to have broken the cron job. I removed it and it started working again.

Thanks for the help