[Solved] Universal XML Importer: connection reset by peer when importing ads.

[ismael.ifh]

Hello all,

I am having a problem when trying to import ads with the plugin Universal XML Importer. The thing is that after 7-8 minutes importing ads, my server suddenly stops the connection and cannot finish the import to Osclass.

I use PHP version 5.6.17 with FastCGI. Here is my php info: http://ibelinmo.com/info.php

I have increased all PHP functions such as max_execution_time, input_time, etc. but the connection with the server is still terminated.

Here is the log from Plesk:

2016-08-19 12:01:20   Error   62.57.133.235   500   POST /oc-admin/index.php HTTP/1.0   http://ibelinmo.com/oc-admin/index.php?page=plugins&action=renderplugin&file=universal_xml_importer/admin/upload.php   Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36   1.57 K   Apache access

2016-08-19 12:08:39   Warning   62.57.133.235      (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server, referer: http://ibelinmo.com/oc-admin/index.php?page=plugins&action=renderplugin&file=universal_xml_importer/admin/upload.php            Apache error

2016-08-19 12:08:39   Error   62.57.133.235      Premature end of script headers: index.php, referer: http://ibelinmo.com/oc-admin/index.php?page=plugins&action=renderplugin&file=universal_xml_importer/admin/upload.php            Apache error


I have read that adding FcgidBusyTimeout to apache.conf could solve things. Still haven't tried, cause I don't wanna mess it up and would like a second opinion.

If you need any more information, please ask and I will provide everything that I can.

Thank you very much.

Ismael Fernández.

[teseo]

Hi,

Nver had that problem myself, but looks like FcgidBusyTimeout is the way to solve it:

https://techjourney.net/mod_fcgid-error-reading-data-from-fastcgi-server-premature-end-of-script-headers/

Regards

[ismael.ifh]

Hello Teseo,

As you suggested, it works now perfectly with FcgidBusyTimeout.

For those who might be interested in the future, the link provided by teseo is very useful. However, I did it directly through Plesk panel. In the domain setting, go to Apache & Nginx settings and in the section Additional Apache Directives I added the following in "Additional directives for HTTP" and "Additional directives for HTTPS":

FcgidIOTimeout 6000
FcgidBusyTimeout 6000

You then change the seconds you want to configure the timeout with.

[ismael.ifh]

I don't know if I should open a new thread or not, but I have another question.

Is there any way to speed up the import process? Right now it imports around 9-10 ads per minute, but it would be great if it could be faster.

Thank you again!