inbound mails not visible but scheduled jobs show success

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sguptajpr
    Junior Member
    • Oct 2014
    • 21

    #1

    inbound mails not visible but scheduled jobs show success

    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
    Member
    • Mar 2014
    • 9132

    #2
    Hi

    Can you check data/logs?
    If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

    Comment

    • sguptajpr
      Junior Member
      • Oct 2014
      • 21

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

      Comment

      • sguptajpr
        Junior Member
        • Oct 2014
        • 21

        #4
        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

        Comment

        • yuri
          Member
          • Mar 2014
          • 9132

          #5
          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



          If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

          Comment

          • sguptajpr
            Junior Member
            • Oct 2014
            • 21

            #6
            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.

            Comment

            • sguptajpr
              Junior Member
              • Oct 2014
              • 21

              #7
              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?

              Comment

              • sguptajpr
                Junior Member
                • Oct 2014
                • 21

                #8
                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.

                Comment

                • sguptajpr
                  Junior Member
                  • Oct 2014
                  • 21

                  #9
                  Any guidance on this one??

                  Comment

                  • jimjones
                    Junior Member
                    • May 2014
                    • 18

                    #10
                    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?

                    Comment

                    • yuri
                      Member
                      • Mar 2014
                      • 9132

                      #11
                      I'm not sure what if could be. Is cron.php running?
                      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

                      Comment

                      • jimjones
                        Junior Member
                        • May 2014
                        • 18

                        #12
                        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?

                        Comment

                        • tarasm
                          Senior Member
                          • Mar 2014
                          • 575

                          #13
                          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.
                          Job Offers and Requests

                          Comment

                          • jimjones
                            Junior Member
                            • May 2014
                            • 18

                            #14
                            Nope,Linux based server called Apache running Cent OS

                            Comment

                            • tarasm
                              Senior Member
                              • Mar 2014
                              • 575

                              #15
                              Could you write the line that you use for cron job. Actually it should be as follows:
                              Code:
                              * * * * * <PATH_TO_PHP> -f <PATH_TO_ESPOCRM>/cron.php > /dev/null 2>&1
                              For example,
                              Code:
                              * * * * * /usr/bin/php -f /var/www/espocrm/cron.php > /dev/null 2>&1
                              Job Offers and Requests

                              Comment

                              Working...