inbound mails not visible but scheduled jobs show success

[sguptajpr]

Hi,

I installed espocrm 2 days ago and have been trying to get the mails through imap since then.
I have successfully setup smtp for outbound mails and is working beautifully.
However for inbound emails something is not right it seems. I have configured inbound mail and can select the folders I want monitored.
However when I run the cron job using the command

C:\php\php.exe -f C:\bitnami\wampstack-5.4.30-0\apps\espocrm\htdocs\cron.php

but nothing happens.
However, my scheduled jobs log shows success but no mails are visible.
I can't understand what I am doing wrong.

Regards
Satish Gupta

[yuri]

Hi

Can you check data/logs?

[sguptajpr]

Yes I have checked. I doesn't give any error.

[sguptajpr]

To add. Earlier the logs gave me the following error:

[2014-10-07 04:08:21] Espo.ERROR: Uncaught exception {"exception":"[object] (PDOException: could not find driver at C:\\bitnami\\wampstack-5.4.30-0\\apps\\espocrm\\htdocs\\application\\Espo\\ORM\\ EntityManager.php:82)"} []


I searched a bit on the internet and enabled the following extensions in php:

extension=php_pdo_mysql.dll
extension=php_pdo_odbc.dll
extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll

After enabling these extensions it started giving me the following errors:

[2014-10-07 05:05:01] Espo.ERROR: Uncaught exception {"exception":"[object] (InvalidArgumentException: ***** is not a valid CRON expression at C:\\bitnami\\wampstack-5.4.30-0\\apps\\espocrm\\htdocs\\vendor\\mtdowling\\cron-expression\\src\\Cron\\CronExpression.php:105)"} []
[2014-10-07 05:05:55] Espo.ERROR: Uncaught exception {"exception":"[object] (InvalidArgumentException: /10**** is not a valid CRON expression at C:\\bitnami\\wampstack-5.4.30-0\\apps\\espocrm\\htdocs\\vendor\\mtdowling\\cron-expression\\src\\Cron\\CronExpression.php:105)"} []
[2014-10-07 05:13:01] Espo.ERROR: Uncaught exception {"exception":"[object] (InvalidArgumentException: 0**** is not a valid CRON expression at C:\\bitnami\\wampstack-5.4.30-0\\apps\\espocrm\\htdocs\\vendor\\mtdowling\\cron-expression\\src\\Cron\\CronExpression.php:105)"} []
[2014-10-07 05:14:23] Espo.ERROR: Uncaught exception {"exception":"[object] (InvalidArgumentException: */10**** is not a valid CRON expression at C:\\bitnami\\wampstack-5.4.30-0\\apps\\espocrm\\htdocs\\vendor\\mtdowling\\cron-expression\\src\\Cron\\CronExpression.php:105)"} []
[2014-10-07 05:16:00] Espo.ERROR: Uncaught exception {"exception":"[object] (InvalidArgumentException: \\10**** is not a valid CRON expression at C:\\bitnami\\wampstack-5.4.30-0\\apps\\espocrm\\htdocs\\vendor\\mtdowling\\cron-expression\\src\\Cron\\CronExpression.php:105)"} []
[2014-10-07 05:18:37] Espo.ERROR: Uncaught exception {"exception":"[object] (InvalidArgumentException: ****** is not a valid CRON expression at C:\\bitnami\\wampstack-5.4.30-0\\apps\\espocrm\\htdocs\\vendor\\mtdowling\\cron-expression\\src\\Cron\\CronExpression.php:105)"} []
[2014-10-07 05:19:39] Espo.ERROR: Uncaught exception {"exception":"[object] (InvalidArgumentException: /10***** is not a valid CRON expression at C:\\bitnami\\wampstack-5.4.30-0\\apps\\espocrm\\htdocs\\vendor\\mtdowling\\cron-expression\\src\\Cron\\CronExpression.php:105)"} []

I just deleted the scheduled job which was already there and created a new one with the cron expression ***** and it worked.
I am no longer getting any errors and it is showing success in scheduled jobs logs but I can't see my mails.


Regards

[yuri]

By default only emails assigned to you are shown? Are you sure there is no other emails?


Could you make some debug if you are familiar with php? File application/Espo/Modules/Crm/Services/InboundEmail.php method fetchFromMailServer

[sguptajpr]

Hi

Thanks for the reply.

I am the only user and have assigned the mails to that user. I am not sure what do you mean by "other emails". I have only one email configured for inbound and outbound mails.

I am not a programmer and have downloaded the software from bitnami. However, I sure can follow a step by step guide.

[sguptajpr]

something else I noticed.
I am in the +5.30 time zone and I have selected it in the preferences.
However, the logs in htdocs/data are still showing time stamps of some other timezone?
Why is it so? Could it also possibly be related to my emails not fetching?

[sguptajpr]

Another update.
From my limited understanding I think that if my inbound email is inactive, the UI should throw an error.
However, I tried and nothing of such sorts is happening. The scheduled jobs log still shows success and I don't get any error.

[sguptajpr]

Any guidance on this one??

[jimjones]

Hi Yuri
First, as I use this tool, I start to love it more and more - the fields manager is extremely versatile, the convert function works great and although the workflow (for leads anyhow) would probably benefit from on-lost-focus update, I think it is a powerful job - well done
I am having the same problem as outlined above
- email inbound cron active
- line added to the "cron job" widget on the server
- I also added this line to the start of cron.php, as an attempt to resolve issue "#!/local/bin/php -q" I am unsure of it does, but it was a fix on another project (on another server) - anyhow, it didn't work either
- no mention of cron.php in error log
Any ideas?

[yuri]

I'm not sure what if could be. Is cron.php running?

[jimjones]

I have looked close at this
- cron.php is running, but
- as $sapiName is cgi-fcgi
- there is a fail/die on following statement if (substr($sapiName, 0, 3) != 'cli') {die("Cron can be run only via CLI");}

What is the meaning of cgi versus cli & what do you recommend?

[tarasm]

jimjones, do you use windows-based web server? If yes, please use "php.exe" instead of "php-cgi.exe". Because, CLI is used for command line scripts, CGI - for web requests.

[jimjones]

Nope,Linux based server called Apache running Cent OS

[tarasm]

Could you write the line that you use for cron job. Actually it should be as follows:

* * * * * <PATH_TO_PHP> -f <PATH_TO_ESPOCRM>/cron.php > /dev/null 2>&1

For example,

* * * * * /usr/bin/php -f /var/www/espocrm/cron.php > /dev/null 2>&1