After looking at the database and how the cron works:
note that run ID 19 is "download tickets" as below:
mysql> SELECT * FROM cron_tasks WHERE `id` = 19;
+----+--------------+-----------------+------------------+------------------------------------------------------------------------------------+---------+----------+
| id | key | plugin_dir | name | description | is_lang | type |
+----+--------------+-----------------+------------------+------------------------------------------------------------------------------------+---------+----------+
| 19 | poll_tickets | support_manager | Download Tickets | Connects to the POP3/IMAP server to download emails and convert them into tickets. | 0 | interval |
+----+--------------+-----------------+------------------+------------------------------------------------------------------------------------+---------+----------+
1 row in set (0.00 sec)
mysql>
Then I found in another thread to look for cron_logs without a finish time:
mysql> SELECT * FROM `log_cron` WHERE `run_id` !=0 AND `end_date` IS NULL ORDER BY `start_date` DESC;
+--------+-------+----------------------------------+----------------------------------------------------------+---------------------+----------+
| run_id | event | group | output | start_date | end_date |
+--------+-------+----------------------------------+----------------------------------------------------------+---------------------+----------+
| 19 | | bfcafb10b07f574e429303fd1b4f46a8 | Attempting plugin cron for support_manager poll_tickets. | 2015-02-23 09:20:02 | NULL |
| 19 | | 5706097d22923690b0d0eed4effd07dd | Attempting plugin cron for support_manager poll_tickets. | 2015-02-23 03:20:01 | NULL |
| 19 | | d9ac43b45eee404ef29fe0a03478f484 | Attempting plugin cron for support_manager poll_tickets. | 2015-02-22 20:55:01 | NULL |
| 19 | | 2aa266c0262becd70a1ea157fd6c8368 | Attempting plugin cron for support_manager poll_tickets. | 2015-02-22 10:35:02 | NULL |
| 19 | | a303667c33f8715ec85957819c00f42a | Attempting plugin cron for support_manager poll_tickets. | 2015-02-22 04:30:02 | NULL |
+--------+-------+----------------------------------+----------------------------------------------------------+---------------------+----------+
5 rows in set (0.01 sec)
mysql>
Then deleting them:
mysql> DELETE FROM `log_cron` WHERE `run_id` !=0 AND `end_date` IS NULL ORDER BY `start_date` DESC;
Query OK, 5 rows affected (0.04 sec)
mysql> SELECT * FROM `log_cron` WHERE `run_id` !=0 AND `end_date` IS NULL ORDER BY `start_date` DESC;
Empty set (0.01 sec)
Now when the cron runs I can see the connection to google imap
root@blesta:~# tcpdump -npi eth0 port 993
tcpdump: verbose output suppressed, use -v or -vv for full protocol decode
listening on eth0, link-type EN10MB (Ethernet), capture size 65535 bytes
15:35:01.840128 IP 192.168.10.114.42386 > 74.125.136.109.993: Flags [S], seq 2150746609, win 29200, options [mss 1460,sackOK,TS val 2057746 ecr 0,nop,wscale 7], length 0
15:35:01.846315 IP 74.125.136.109.993 > 192.168.10.114.42386: Flags [S.], seq 2080383863, ack 2150746610, win 42540, options [mss 1380,sackOK,TS val 1611920504 ecr 2057746,nop,wscale 7], length 0
15:35:01.846361 IP 192.168.10.114.42386 > 74.125.136.109.993: Flags [.], ack 1, win 229, options [nop,nop,TS val 2057747 ecr 1611920504], length 0
15:35:01.846801 IP 192.168.10.114.42386 > 74.125.136.109.993: Flags [P.], seq 1:306, ack 1, win 229, options [nop,nop,TS val 2057748 ecr 1611920504], length 305
15:35:01.852916 IP 74.125.136.109.993 > 192.168.10.114.42386: Flags [.], ack 306, win 341, options [nop,nop,TS val 1611920511 ecr 2057748], length 0
15:35:01.854500 IP 74.125.136.109.993 > 192.168.10.114.42386: Flags [.], seq 1:2737, ack 306, win 341, options [nop,nop,TS val 1611920512 ecr 2057748], length 2736
15:35:01.854549 IP 192.168.10.114.42386 > 74.125.136.109.993: Flags [.], ack 2737, win 271, options [nop,nop,TS val 2057750 ecr 1611920512], length 0
........ output cut
77 packets captured
77 packets received by filter
0 packets dropped by kernel
root@blesta:~#
I can also see the email import is now working :-)
Please see attached / below the final working settings for google apps hosted domain IMAP, don't forget to enable IMAP support under your google account also.
OK I found the issues
root@blesta:~# php -v
PHP 5.5.21-1+deb.sury.org~trusty+2 (cli) (built: Jan 26 2015 19:57:37)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
with the ionCube PHP Loader v4.7.3, Copyright (c) 2002-2014, by ionCube Ltd., and
with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2014, by Zend Technologies
with Xdebug v2.2.5, Copyright (c) 2002-2014, by Derick Rethans
ioncube was enable for the web but not for the cli
I had to add the below:
zend_extension = /usr/lib/php5/20121212/ioncube_loader_lin_5.5.so
into
/etc/php5/cli/php.ini
as it already existed in
/etc/php5/fpm/php.ini
Regards, Daniel
