Announcement

**Maximus** · 07-02-2019, 09:28 AM

Hello.
Test your connection with this script https://forum.espocrm.com/forum/gene...9685#post49685. Create a PHP file and run it from CLI. If it will fail, this means that there is some restriction on your VPS.

**robson** · 07-02-2019, 10:41 AM

Hi Max,
I think ?> is missing in the end of the script... I ran it and I got this:
PHP Warning: fsockopen(): unable to connect to 1.1.1.1:9998 (Connection timed o ut) in /var/www/crm.szybkieskladki.pl/public_html/test.php on line 6
(110) Connection timed out

I agree that this is VPS issue but how to find it? Why Test connection works, Espo sends emails but does not want to Fetch emails? It is not logical. Connection is established on one occasion and is not on the other. Is it the same php method used for test connection/send email and Fetch?

The same is Campaigns/Mass Emails. If I use Send Test it sends email perfectly but normal campaign for sending emails produces FAILS. Why only test works? There has to be some difference in the code that could explain this behavior.

I also did the test using:

Code:

<?php

$host = "www.google.com";
$port = "80";

$checkconn = fsockopen($host, $port, $errno, $errstr, 5);
if (!$checkconn){
echo "($errno) $errstr";
} else {
echo 'ok';
}

?>

And it said "ok" Why it conects to google on port 80 and does not want to connect to cloudflare on 9998? Using 1.1.1.1:80 also produces ok... Why have you proposed port 9998?

I also used the script to try $host = "imap.gmail.com"; $port = "993"; and got OK.. It is very strange as in your logs it says "cannot connect to host ; error = fsockopen(): unable to connect to ssl://imap.gmail.com:993"

**Maximus** · 07-02-2019, 11:29 AM

You have to set the ip and port parameters of the email server. The parameters 1.1.1.1:9998 it is just an example. You can contact your hosting support service and describe them this issue.

**robson** · 07-02-2019, 11:36 AM

I used the script to try $host = "imap.gmail.com"; $port = "993"; and got OK.Please note that my Espo log says: "cannot connect to host ; error = fsockopen(): unable to connect to ssl://imap.gmail.com:993"
How is it possible that your script establishes connection and Espo cannot? It is not hosting issue, it is pure VPS with all ports open. On my server FSOCKOPEN works in CLI but does not work in Espo... How is it possible?

**Maximus** · 07-02-2019, 01:28 PM

I know that EspoCRM works with ssl://imap.gmail.com:993 perfectly. I suppose that the port 993 is blocked on your VPS.

**robson** · 07-02-2019, 01:38 PM

Max, why do you suggest that VPS is blocked if your script returns OK on "imap.gmail.com"; $port = "993"?

**Maximus** · 07-03-2019, 12:03 PM

Hi. Sorry for my delayed reply.
Could you check your CLI PHP version on your VPS? We need to check it, cause when you are making a test connection from the EspoCRM it uses PHP of the web server where your EspoCRM instance is installed, but when the cron runs a job, it uses a CLI PHP.

**robson** · 07-03-2019, 12:18 PM

No problem Max, I'm happy that you are still with me. It is strange but my CLI version is:

$ php -v
PHP 7.3.6-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: May 31 2019 11:06:26) ( NTS ) Copyright (c) 1997-2018 The PHP Group Zend Engine v3.3.6, Copyright (c) 1998-2018 Zend Technologies with Zend OPcache v7.3.6-1+ubuntu16.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies

However the Apache says: PHP Version 7.1.30-1+ubuntu16.04.1+deb.sury.org+1

**robson** · 07-03-2019, 12:29 PM

I have used sudo update-alternatives --config php to switch CLI to 7.1, now php -v gives:

PHP 7.1.30-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: May 31 2019 11:43:14) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.1.0, Copyright (c) 1998-2018 Zend Technologies
with Zend OPcache v7.1.30-1+ubuntu16.04.1+deb.sury.org+1, Copyright (c) 1999-2018, by Zend Technologies

Fetching still down (Failed)

Announcement

Espo is not fetching emails

Espo is not fetching emails

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment