I believe the error was server side and fixed from Godaddy rather than it being a cart or PayPal issue.

Andy

Please feel free to review / rate our software

Did anyone state what it was that was needed to fix this issue? I would love to switch hosts, but my clients are wanting to stay put. There are a few different variations on the hosting plans between the sites that work and the one that has started the error. TLS 1.2, PHP 7.0, and Cpanel appear to be okay for now. Its the PHP 5.6, TLS 1.1, and regular linux hosting that has the current error. Your thoughts? I know the issue is not with ECT, if this is beyond the scope of support I understand :)

When it gets late at night, go to bed... try again tomorrow.

Could it have anything to do with the following information (could be antiquated, but this is all I could find about the IPN issues and coding required by godaddy/paypal to work together? )?

"i was running with same issue, and found out i was missing a line of code which they want you to put.
i hope it helps.
{
$ch = curl_init();
$url = "https://{website you are trying to connect to}";
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); ////// i was missing this line.
$response = curl_exec($ch);
curl_close($ch);
}

"

When it gets late at night, go to bed... try again tomorrow.

Also found this link https://www.paypal.com/us/selfhelp/article/how-do-i-troubleshoot-instant-payment-notification-%28ipn%29-ts2082

When it gets late at night, go to bed... try again tomorrow.

I'll have to check with Sinbad but in the meantime did you try the test here https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107642

Andy

Please feel free to review / rate our software

Vince,

I believe that I have found the godaddy/paypal IPN and site failure issues. After trying everything I could find for four hours, and continually getting no communication between paypal and godaddy, after being on the phone for hours with everyone, and digging into every file I could find that may be associated... the problem and the solution ended up being so clear. Yet, it needs some attention to be resolved for good. Godaddy is deleting files it finds as vulnerable from the server. Updating the site doesn't work for ECT clients because godaddy blocks those files from being FTP'ed back onto their servers. They deleted my ppconfirm.php file on December 15th, along with ncconfirm.php and many others. That is the same date that my IPN issue arose. I was able to re-upload those files by using godaddy file management system from my godaddy admin. Tested after doing this and EVERYTHING tested great, problem solved, back up and running... smooth.

The issue: Godaddy says that the code written is very vulnerable in those files (among others), and that the system will continually routinely delete these files as it scans the server (this is why my site had no issues and other people did, the scan hadnt reached me yet)

The resolution: Communication from Godaddy to you as to which parts they consider vulnerable so that it can be fixed. Once fixed, these files wont be considered vulnerable anymore (they have been marked as phishing, backdoor, and other such things)

I have a pitbull of a support tech who has bravely stated that the site failures are godaddy's fault, but is also stating that it is in everyones best interest that the vulnerabilities are resolved. She is also fighting tooth and nail to get godaddy to react to this issue and hopefully open up communication with the ECT team to clearly state which parts of the code it has found to be the problem code and in which files specifically. They have not yet checked out the new 6.8.4 updated code, but I have updated my personal site in my account for them to scan over.

All this time, and all this headache... to learn that the files were simply disappearing.

Currently, my site is fine, IPN checks smooth, and all IPNs received. Until godaddy deletes the files again.



When it gets late at night, go to bed... try again tomorrow.

Hi Drivers,
I have a client who is hosting with Go Daddy and is experiencing exactly the same problem with her site and still has the problem.
I've just logged in via FTP and the vsadmin/ppconfirm.php file is present on the server and always has been.

So I'm not too sure what's going on as she's not been in touch for a while after speaking with Go Daddy support, but I'm still seeing 'no ipn' on her PayPal orders.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Check that the rest of the sites files are there. Godaddy cURL is configured to TLS, no firewalls, and such... pretty clean set up if they would quit deleting and/or blocking files they feel are vulnerable. Of course, could be another issue with her settings. The sites run smoother on their Cpanel hosting versus their legacy hosting (im using legacy currently, their older hosting plans on older servers). It was insane to watch the files I tried to upload to update the site instantly disappear in front of my eyes. Uploaded them internally using godaddy admin and they stayed and now the site is passing all test and IPNs are reporting fast. note: I am on linux/php.

When it gets late at night, go to bed... try again tomorrow.

Hi Drivers,
All the files are on the server as they should be and on testing - https://www.carpatina.com/dolls/vsadmin/ppconfirm.php?ppdebug=tls

Everything is fine, that test url above has been fine all along.

As I said, I've spoken to the client for a while so I think she's given up even discussing the issue with Go Daddy.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

Hi,
Phil is right that I gave up in solving the IPN issue.
I have done everything that was suggested by Godaddy without success so I’m now considering changing host.

Mihaela
Carpatina.com

That is frustrating. Have you tried this link https://www.paypal.com/us/selfhelp/article/how-do-i-troubleshoot-instant-payment-notification-%28ipn%29-ts2082

I am speaking with godaddy about the large number of clientelle they are going to lose due to this issue, however, I finally have them documenting that their system is deleting and/or blocking those files from working because they are saying the code is highly vulnerable. Getting godaddy to state which parts of the code, so Vince can fix it (if necesary) is essential in ending this drama.If the code is not vulnerable, godaddy is looking at adding ecommercetemplates values to trusted carts to clear this up.

With one of my customers I had to turn of the https rewrite in htaccess and that worked (after re uploading all missing files of course)

What hosting plan/ server are you on with godaddy?

When it gets late at night, go to bed... try again tomorrow.

Would any of this have anything to do with this issue? This is an old post from ages ago from oscommerce:



GoDaddy does not allow outbound http, https, or SSL socket connections from a hosted site. The first thing the ipn.php module attempts to do is establish an SSL socket connection back to PayPal. The attempted socket connection eventually times out (in 30 seconds) since GoDaddy does not allow outbound connections. The ipn.php module next attempts to establish a cURL connection with PayPal. This connection works if you have added the GoDaddy proxy server patch to the ipn.php module. Once a connection with PayPal is established, the module retrieves the data and happily goes about it's business.



The MySQL database timeout appears to be a side effect of the 30 second delay caused by the attempted SSL connection. When I shorten the SSL socket timeout to 5 seconds, the MySQL database timeout error does not occur; however, I don't want my customers to wait even 5 seconds when they don't have to so I modified the code to eliminate the SSL connection attempt.



The original socket connection code was (near line 33):



if ( (PHP_VERSION >= 4.3) && ($fp = @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30)) ) {
$fsocket = true;
} elseif (function_exists('curl_exec')) {
$curl = true;
} elseif ($fp = @fsockopen($server, 80, $errno, $errstr, 30)) {
$fsocket = true;
}


I modified it to be:



// Start of GoDaddy patch
// GoDaddy does not allow outbound SSL connections; you must use cURL via a proxy server.
// The SSL has been commented out to avoid the 30 second timeout delay (and the odd side effect
// of MySQL database timeout on session related data generated from appication_bottom.php
// if ( (PHP_VERSION >= 4.3) && ($fp = @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30)) ) {
// $fsocket = true;
// } elseif (function_exists('curl_exec')) {
if (function_exists('curl_exec')) {
// End of GoDaddy patch
$curl = true;
} elseif ($fp = @fsockopen($server, 80, $errno, $errstr, 30)) {
$fsocket = true;
}


You'll also need to add the patch so that the cURL protocol uses the GoDaddy proxy server (not my original work - you can search the forum and find it). Near line 72 you will find the following code:



curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$result = curl_exec($ch);


Just add the cURL proxy option before the curl_exec line:



curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
// GoDaddy hosted website proxy patch
curl_setopt($ch, CURLOPT_PROXY, "http://proxy.shr.secureserver.net:3128");
// End of GoDaddy proxy patch
$result = curl_exec($ch);

When it gets late at night, go to bed... try again tomorrow.

Thank you drivers for all your advise.
My site is designed on WordPress and hosted by GoDaddy on Ultimate Linux Hosting with cPanel

I'll look into it a little more.

Best,
Mihaela

My site is currently working properly again (after 4.5 hours on the phone with godaddy and 1 hour on the phone with paypal. I do not use wordpress so I am not familiar with the settings and such, but it does look to be a couple things... I will stay on this until I understand, and I do have a godaddy ticket in and have cced Vince (the best solution finder I know!) on that ticket. Hopefully the elusive and confusing issue can be resolved so that godaddy can remain an option for hosting ECT. I have found their very strict security protocols absolutely annoying and frustrating, but also I have found these same security protocols comforting as they have higher standards than many hosts. Their tech support is hit and miss. I consider their Cpanel deluxe or ultimate sufficient for ECT, once settings are set :)

When it gets late at night, go to bed... try again tomorrow.

Has anyone using godaddy shared hosting found a solution to this or got it working? I've been having the same issue since December 2017.

Version: Ecommerce Plus PHP v6.7

This is my personal opinion and in no way is this post endorsed by ecommerce templates.
Godaddy should never be used to host an ecommerce website.
They restrict all kinds of things (supposedly for your own good) that will sometimes prevent things from working.
I am actually a godaddy reseller because I own so many domain names, and I get a better price on them and that savings multiplied by the number of products I have, more than pays for the reseller program. However, my ecommerce websites are hosted at servelink.
Servelink knows the ecommerce platform very well and their hosting works great. Yes, it's slightly more expensive than GD, but it's not that much more and you will never have to deal with GD's support staff who often it seems, just sends you in circles pointing fingers at your code and whoever else they can.

Recently I setup a .php test site on their servers and I had a terrible time getting the site working and I had to go as far as setting up a test script to show them the problem was on their end. Even after doing that, I had to stay on the phone for nearly two hours with them until someone finally flipped the switch to make it work.

So when I see this question

quote:

---

Has anyone using godaddy shared hosting found a solution to this or got it working?

---

My response is, yes, there is a solution. It's change hosts.

quote:

---

Has anyone using godaddy shared hosting found a solution to this or got it working? I've been having the same issue since December 2017.

---

Just take Daves advice and move to another reputable host, it takes no time at all to move and all your problems will be over.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

SOLUTION that seems to be working.
Two things:
1. I was still on php 5.6 and I changed that to 7.0 and
2. I updated the script in the db_conn_open.php as advised for php 7

<?php

// You host should be able to provide you with these settings if you do not know them already

$db_username = "****"; // Your database login username
$db_password = "***"; // Your database login password
$db_name = "****"; // The name of the database you wish to use
$db_host = "****"; // The address of the database. Often this is localhost, but may be for example db.yoursite.com

//////////////////////////////////////////////////
// Please do not edit anything below this line. //
//////////////////////////////////////////////////

$GLOBALS['ectdatabase'] = new mysqli($db_host, $db_username, $db_password, $db_name);
if(mysqli_connect_error()){
ob_clean();
print '<html><head><title>Database connect error</title></head><body><div style="margin:20px;clear:both">Database Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error() . '</div>';
print('<div style="margin:20px;clear:both">You need to set your database connection in vsadmin/db_conn_open.php</div>');
print '<div style="margin:20px;clear:both">For help setting your database connection please see...<br />';
print '<a href="https://www.ecommercetemplates.com/phphelp/ecommplus/instructions.asp#dbconn" target="_blank">https://www.ecommercetemplates.com/phphelp/ecommplus/instructions.asp#dbconn</a></div>';
print '<div style="margin:20px;clear:both">We also have a support forum here...<br />';
print '<a href="https://www.ecommercetemplates.com/support/" target="_blank">https://www.ecommercetemplates.com/support/</a></div>';
die('</body></html>');
}
?>


Totally agree that Godaddy is a hassle but in a round-about way (and long time on hold) I got it working again mainly with Godaddy's help--even though the tech support guy was pretty rude, he was also very knowledgable and I guess I lucked out with him.

I still had the old script version in db_con_open.php and the error file was saying
[11-Sep-2018 14:19:57 UTC] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/website/public_html/website.com/vsadmin/db_conn_open.php on line 14
[11-Sep-2018 14:19:57 UTC] PHP Notice: Undefined variable: dbh in /home/website/public_html/website.com/vsadmin/db_conn_open.php on line 14

That is the first thing the Godaddy tech-support checked into and he also informed me that 5.6 will be totally phased out by the end of the year. That either the code or the php version was likely causing the problem.
When I looked into ecommerce templates compatibility with php 7 the first thing Andy had said was that the script of the db_conn_open.php needed to be updated. I updated to php 7 and also changed the script as Andy said and voila, it is working again!







Version: Ecommerce Plus PHP v6.9

Thanks a lot for letting us know and really glad you are up and running again. Godaddy still don't offer more than PHP5.6 on some of their server set ups (I know as I've looked for customers recently) - maybe they are being forced into the change when it's something they should have been offering for quite a while now - the main thing is your problems are solved though.

Andy

Please feel free to review / rate our software