gags_78

Hey Terra and all, Found out what was causing the lost connection to mysql server during query The cause was to do with the following lines in the ipn.php file. 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; } A week ago it became apparent tha the cURL option wasn't working so I removed the option from the if statement. Alas whatever is going on under the hood of the line @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30) was preventing any mysql queries from executing resulting in the above line. I commented it out too and now only have if ($fp = @fsockopen($server, 80, $errno, $errstr, 30)) { $fsocket = true; } and it zips through, updates the order to pending and emails me the order too!!!! So I'm happy as a pig in the perverbial :thumbsup: Thanks a million for the great contrib Terra. If there's any chance you could glance over the @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30) and let me know if you can see how it might be knockin' out the mysql query ability that would be great. Right now my orders are updating to pending. What's the difference between pending and processing? From this point do I have to update the orders manually? I'm going to go about getting encrypted web payments going now. I presume I'll have to uncomment out the first option with the ssl once it's in place?? Any heads up on any problems I'm likely to encounter would be great. Thanks again, Mark.

Incidentally folks the cURL option wouldn't work for me. The following is the code I was using to implement it as per the setup html file in the IPN 2_2 contri. curl_setopt($ch, CURLOPT_VERBOSE, 1); curl_setopt($ch, CURLOPT_URL, 'https://' . $server . '/cgi-bin/webscr'); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_POSTFIELDS, $parameters); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, false); curl_setopt($ch, CURLOPT_TIMEOUT, 300); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); $caller->setOpt('curl', CURLOPT_PROXYTYPE, CURLPROXY_HTTP); $caller->setOpt('curl', CURLOPT_PROXY, "http://proxy.shr.secureserver.net:3128"); $result = curl_exec($ch); Once it wouldn't work I reverted to using option 3 by commenting out the appropriate section in ipn.php if ( (PHP_VERSION >= 4.3) && ($fp = @fsockopen('ssl://' . $server, 443, $errno, $errstr, 30)) ) { tee_log('PP TEST option1 - fsocket is true, port 443'); $fsocket = true; # } elseif (function_exists('curl_exec')) { # $curl = true; } elseif ($fp = @fsockopen($server, 80, $errno, $errstr, 30)) { tee_log('PP TEST option3 - fsocket is true, port 80'); $fsocket = true; } I guess this means that my payment information is going over unsecured? Once I get the unsecured payments working then I'll go about getting the encrypted payments working. In the mean time if anyone has any ideas as to why my cURL isn't working that would be great. Thanks for all the help folks, Mark.

Hey folks, I'm one db call away from getting IPN working on my site. I've the latest version of OsCommerce (oscommerce-2.2rc1) with Terra's osCommerce_PayPal_IPN_v2.2 contribution added. Paypal is returning a VEFIFIED post to my ipn script but when it then attempts to perform the following db call select currency, currency_value from orders where orders_id = '26' and customers_id = '2' I get the following mysql exception 2013 - Lost connection to MySQL server during query Thankfully this happens all the time as opposed to intermittently so it's probably a config issue but if anyone has seen this before could they point me in the right direction for the answer? Thanks, Mark.

Sorry RBA. I know your desperate for some help but I'm pretty much a few steps behind yourself. so near and yet so far. Could you fire on the location of that Debugging Script you mentioned above? In terms of your problem above, the only thing I can tell you is that in the past I've encountered three configure.php files in a running OSC deployment. The ones that are bundled with OSC ./admin/includes/configure.php ./includes/configure.php and then there was one located in either of the following two folders. ./admin/includes/local ./includes/local I think it was created at runtime and I'm not too sure which folder it was in. I'd quickly check in there and ensure that a new version of the configure.php file hasn't been created and placed here that's overwritting your ipn location HTH, Mark.

Hey jillbalkus, I'm getting those exact same Invalid Process notification mails? I've made the amendments that you suggest here and as per the setup guide that comes with the contrib but to no avail?? Have you any idea why this code was required? I have SSL installed I though OSC would use that instead of cURL if available? Thanks, Mark.

That's Bang on eighteen48. Thanks a million for all your help. Cheers, Mark.

Hey eighteen48, Yer gonna integrate the google checkout?? That google checkout products gonna be big isn't it? Do ye think it'll give paypal a run for it's money in time? Sorry about this now but I'm still confused about the versions. i'm only using OsCommerce recently but I have a programming background so I'm familiar enough with the concepts. When you refer to '1.4' what product are you referring to?? and the same for '2_2'? Are they different versions of the same product or diff products altogether. Apologies for asking this again but you're referring to '1.4' and '2.2' and I'm a shade lost as I'm not too familiar with the different modules/contribs yet. Any chance ye might be putting a wee contrib together for the google checkout?? :-" Thanks, Mark.

Thanks a million 1848. Cheers for getting back to me. I got a bit confused with the last section there on the easiest integration? You mentioned the best version to use was 1.4 and not 2.2?? But their different projects aren't they? Paypal contrib v1.4 and OsCommerce2_2? Thanks, Mark.

Hey folks, I recently upgraded my site to oscommerce-2.2rc1 and noted that the ext directory associated with the IPN contribution is already there? What's the story?? Has Terra's IPN contrib been merged into the head project? If so does the vanilla paypal method now support credit card processing? Thanks, Mark.

Hi Terra, Thanks a mill for the contribution. I was hoping you could let me know if upon receipt of an ipn should the status of the order automatically change in the orders section of the admin? Also what do you find is the best way to debug the php in the OSCommerce project? Do you send emails for everything as per the IPN setup? Thanks, Mark.

Hey folks, Sorry about this now, I posted this in the main forum for payment modules without realising there was a specific IPN support thread. I installed the IPN 2_2 contribution there last week!! It's a great contrib and the fact that we can start our business and gauge the demand without having to go through the rigmarole of opening merchant accounts and setting up payment gateways is fantastic. Thanks for a great contrib. I've encountered a few problems and think I can shoehorn em into a couple of questions for folks whom have the time. Setup ======== Hosting - godaddy.com Linux shared hosting Mysql 5.0 php version 4.3.11 Godaddy turbo SSL cert installed Currently testing against paypal's sandbox. 1. Once the order has been placed and I guess the ipn has been received in the background should the order status change to something else other than Preparing [Paypal IPN] ?? 2. I was successfully testing the credit card functionality with numbers I was generating using code I retrieved from paypals code sample section. Then yesterday when I felt I wasn't getting any IPN notifications at all I had a look at my IPN URL and sure enough there was a typo there. So i fixed it up and since then no credit card numbers work and then no longer go through even if I change it back. Could this be to do with paypal or is it my changing the URL? Thanks for all and any help, Mark.

Hey folks, I installed the IPN 2_2 contribution there last week!! It's a great contrib and the fact that we can start our business and gauge the demand without having to go through the rigmarole of opening merchant accounts and setting up payment gateways is fantastic. Thanks for a great contrib. I've encountered a few problems and think I can shoehorn em into a couple of questions for folks whom have the time. Setup ======== Hosting - godaddy.com Linux shared hosting Mysql 5.0 php version 4.3.11 Godaddy turbo SSL cert installed Currently testing against paypal's sandbox. 1. Once the order has been placed and I guess the ipn has been received in the background should the order status change to something else other than Preparing [Paypal IPN] 2. I was successfully testing the credit card functionality with numbers I was generating using code I retrieved from paypals code sample section. Then yesterday when I felt I wasn't getting any IPN notifications at all I had a look at my IPN URL and sure enough there was a typo there. So i fixed it up and since then no credit card numbers work and then no longer go through even if I change it back. Could this be to do with paypal or is it my changing the URL? Thanks for all and any help, Mark.

Hey folks, It turns out that hte whole file wasn't uploaded correctly using filezilla. This happens all the time with godaddy and filezilla. Ftp uploads are interrupted all the time and sometimes although I've set it to 1, the server rejectss the ftp connection as it says that there are two connections established from the machine already, hence maxing the connections. Does anyone have a better ftp tool available or someway of clarifying that the oscommerce installation was ftped up correctly? Thanks, Mark.

Hey folks, I installed contribution,2679 osCommerce_PayPal_IPN_v2.2 yesterday. When I go to the Admin section in order to install the mod I get the following exception. Parse error: parse error, unexpected $ in /home/content/catalog/includes/modules/payment/paypal_ipn.php on line 570 My site's hosted on Godaddy's linux economy hosting which is php enabled. Any help would be greatly appreciated. Thanks, Mark.