Google Checkout integration....Error

[sippy]

I have made a google checkout payment gateway integration module.

 

I just noticed that we have not been getting notifications of sales through Google Checkout. Means Order details we are no getting there .

i'm getting this error from google checkout account. When i am going tools menu and integration console.

 

 

We encountered an error trying to access your server at

https://www.mysite.com/pay_success.php -- the error we got is

javax.net.ssl.SSLHandshakeException: Remote host closed connection

during handshake

 

I have confirmed from my hosting. They problem is not their side.

 

Please help me . How i can solve this problem .

 

Thanks,

Gagan

Edited April 28, 2009 by sippy

[h2oHOH]

Try the following, go to your google checkout buyers account > settings > preferences > under advanced settings - uncheck - Require notification acknowledgments to specify the serial number of the notification. Then do a test order and see what happens?

[sippy]

thanks for reply,

 

I have tried to do so as you asked me.

 

go to your google checkout buyers account > settings > preferences > under advanced settings - uncheck - Require notification acknowledgments to specify the serial number of the notification.

 

But there is no such option under advanced setting-Require notification acknowledgments to specify the serial number of the notification.

 

Regarding tha when i went in account >setting > preferences ----- i found this page with this information

 

Order processing

here is one radio button which was checked.

When I receive a new order... Automatically authorise the buyer's card for the full amount of the order.

here was one another radio button which was unchecked

Automatically authorise and charge the buyer's card.

 

here is one checkbox which was already checked

Email me each time I receive an order, cancellation or other transaction.

 

Charset preferences

Edit charset settings

 

then here is two submit button naming like:

Save Preferences Cancel

 

 

 

If there is need of any changes that you know, Please tell me...........if there is any other solution then please suggest me.

Thanks,

gagan

Edited April 29, 2009 by sippy

[sippy]

sorry for not getting that page at that time. but now i have got that page as you asked to do changes for some.

 

i got that option which you asked me. I found it buyer's account>setting > integration>integration settings---------but there are many checkboxes

I am sending information of whole page which i am getting on this page:

 

Integration settings

Shopping trolley post security My company will only post digitally signed carts. [?]

 

API callback URL (Level 2 integrations only) [?]Specify a URL for Google to notify you of new orders and changes in order state. You must provide the URL of a server running 128-bit SSLv3 or TLS. [?] API callback URL:

Callback method:

XML

e.g. <google-order-number>123</google-order-number>

HTML (name/value pairs)

e.g. google-order-number=123

 

 

 

Advanced settings

Please note that any changes to these settings will modify the API messages that Google delivers. It is strongly recommended that you first test any changes to these settings on the Sandbox test server.[?] Provide the first name, last name and full name of the buyer and order recipient in separate fields in the new order notification.

Notifications must include any amounts involving a Google promotion.

Return the buyer's ship-to phone number in the new order notification.

Return the buyer's billing phone number in the new order notification.

Require notification acknowledgments to specify the serial number of the notification.

Merchant calculations (tax and shipping) callback messages must include information about co-funded promotions.

 

 

All last 6 option or 6 lines have one checkboxes but there is no one checked. All checkboxes are unchecked .

 

If you have any suggestion about this page.Then please suggest me . I will be very thankful to you. Because this is very urgent for me.

thanks,

gagan

Edited April 29, 2009 by sippy

[h2oHOH]

What version of Google Checkout are you using?

 

Are you testing sandbox or production?

Edited April 29, 2009 by h2oHOH

[sippy]

What version of Google Checkout are you using?

 

Are you testing sandbox or production?

thanks for reply,

 

i do not exactly i think it is production..........but i m not getting orders of sales in google checkout account which should come first page in order menu after logging which customer is purcasing means order details of prodcuts

[h2oHOH]

What version of Google Checkout are you using?

[web-project]

Remote host closed connection

during handshake

ask your hosting provider to open firewall to allow connection from and to Google Checkout.

 

Doesn't matter what version of Google Checkout he is using, the error is in connection between services!

Edited April 29, 2009 by web-project

[h2oHOH]

Doesn't matter what version of Google Checkout he is using

I got several similar type java.net and handshake error messages in the integration console and web server logs trying to get my callback api working until I discovered a couple of errors in the v1.5 responsehandler.php. These were new php errors not in v1.45... thanks for solving this Alex...

[ian wat]

I got several similar type java.net and handshake error messages in the integration console and web server logs trying to get my callback api working until I discovered a couple of errors in the v1.5 responsehandler.php. These were new php errors not in v1.45... thanks for solving this Alex...

 

I saw your post regarding responsehandler.php errors with version 1.5 of google check out.

I'm pulling my hair out with this.

Do you have a working responsehandler.php to replace the one with 1.5

[h2oHOH]

I saw your post regarding responsehandler.php errors

I'm still in development and have not worked out all the bugs with the callback and responsehandler... I've got orders to show up in admin but cannot process them... Think it's a DIR_WS_CATALOG address issue, what kind of results are you getting. What error messages are you getting in the integration console and server logs?

[web-project]

I don't know everything is working in my installation without any problems!

[h2oHOH]

...everything is working in my installation without any problems!

I was getting the following error in the server logs from Google callback:

 

PHP Parse error: syntax error, unexpected T_DEFAULT in /home/userName/public_html/catalog/googlecheckout/responsehandler.php on line 1154

 

I have altered the php in responsehandler to get past this and receive orders and xml, however, now I'm getting some additional errors...

I think I will be able to solve them but they all seem to be local addressing issues.

 

Shared server: /home/userName/public_html/catalog

 

vs

 

Dedicated: domainName.com/catalog

 

Can you explain the above case/switch error? Is this because I'm testing on a shared server....

 

Thanks

[ian wat]

My problem is that some time orders did not show in the shop when placed with google check out and I was also seeing "Ids are integral numbers, but you sent: " in the response_error.log

 

I found an error reported here:

http://groups.google.com/group/google-chec...c95ae5ae596201#

(From 2007!)

which sounded like it could be the cause and checked the current code to find that its still there!!!

(ASIDE - whats going on, smart installers developed but major errors in the code? :blink: )

 

The problem may not show, depending on the way customers use the shop.

The error occurs when an account is created in the shop first, and then the customer places an order with google.

On the return the code in responsehandler.php checks if a new account needs to be created in the shop, if it does then the entry is made in oscommerce tables AND the google table which likes the customer shop ID and the customer google id. IF the user does have an account at the shop the the google table DOES NOT get updated.

With out the mapping in the Google table the customer id cant be resolved to google id and the order does not show (and the ids missing in return comms to google).

 

The code at the above like is for an old version so I have updated the code as shown below.

(original code commented out - in an attempt to remember what I have done at a later date :huh: )

I have given this a test with the user account that was causing problems and if fixed it, but still want to run a couple of test cases and check the contents of the db tables before I happy. I will post back after this testing ( should be in next couple of days)

 

code is in the process_new_order_notification function

//	if (ACCOUNT_DOB == 'true') {
//	  $sql_data_array['customers_dob'] = 'now()';
//	}
//	tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);
//	$customer_id = tep_db_insert_id();
//	tep_session_register('customer_id');
//	tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . "
//		(customers_info_id, customers_info_number_of_logons,
//		customers_info_date_account_created)
//		values ('" . (int) $customer_id . "', '0', now())");
//	tep_db_query("insert into " . $google_checkout->table_name . " " .
//		" values ( " . $customer_id . ", " .
//		$gc_data[$root]['buyer-id']['VALUE'] . ")");
//	$new_user = true;
//  }
if (ACCOUNT_DOB == 'true') {
  $sql_data_array['customers_dob'] = 'now()';
}
tep_db_perform(TABLE_CUSTOMERS, $sql_data_array);
$customer_id = tep_db_insert_id();
tep_session_register('customer_id');
tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . "
	(customers_info_id, customers_info_number_of_logons,
  		customers_info_date_account_created)
	values ('" . (int) $customer_id . "', '0', now())");
$new_user = true;
 }
 // end of new customer if

 // check if buyer id from google is in the check out table
 // as customer may exist but this is the first time they have used google 
 $customer_in_gc = tep_db_fetch_array(tep_db_query("select gct.customers_id from " .
  $google_checkout->table_name . " gct " .
  " where gct.buyer_id = " .
  gc_make_sql_string($gc_data[$root]['buyer-id']['VALUE'])));

 if($customer_in_gc['customer_id'] == '') {
// insert new record in check out table to map google buyer id to customer_id 
tep_db_query("insert into " . $google_checkout->table_name . " " .
	" values ( " . $customer_id . ", " .
	$gc_data[$root]['buyer-id']['VALUE'] . ")");
 }

[h2oHOH]

Saw that Google sticky when I first installed... just assumed it was for an earlier version...I'll give that a try... so I'm back-tracking...gotten busy here w/other projects so post in "next couple days" sounds good...will do also

[stevenri]