close ad
Help us test the new Databridge BETA with MySQLi support
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

PayPal checkout error

Thread began 3/20/2012 10:36 am by chssagmi366905 | Last modified 3/22/2012 2:45 pm by Jason Byrnes | 1243 views | 11 replies |

chssagmi366905

PayPal checkout error

In testing there is no problem with PP_confirm checkout but now I uploaded the site and after logging in to PayPal and hit continue button and then the following error:


Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'ronald50_rBiz'@'localhost' (using password: YES) in C:\wamp\www\reunion\connections\dbc.php on line 17

Fatal error: Access denied for user 'ronald50_rBiz'@'localhost' (using password: YES) in C:\wamp\www\reunion\connections\dbc.php on line 17

I inserted the API info from PayPal for live site. The connection info works when, for example,
I access my questions and answers from my database so I don't know any other password location that could be causing this problem
Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

it looks like you are testing on your local wamp server and the conndection file at connections\dbc.php is set to use the username for the remote server.

the default user created by wamp is named "root", when testing locally, your connection file will need to use the root user and password.

Sign in to reply to this post

chssagmi366905

PayPal checkout error

Sorry, I wasn't clear. I'm finished testing and uploaded my site to the web. To go from PayPal sandbox to "live", I changed the password and signature in the PP_confirm page to live API credentials. So it's on the web where PP_confirm doesn't work anymore. The web connection file has the remote username and password.
Thanks

Sign in to reply to this post

Jason ByrnesWebAssist

send a link where i can see the problem

Sign in to reply to this post

chssagmi366905

PayPal checkout error

I included a zip file to show PP_Confirm page and my connection file
Thanks

Attached Files
PP_Confirm Problems2.zip
Sign in to reply to this post

Jason ByrnesWebAssist

send a link where i can see the problem

Sign in to reply to this post

chssagmi366905

Sorry. The link is pp_confirm.php What I discovered is that if I use my pp_confirm.php , everything shows up correct. However when I click submit the transaction, I get pp_checkout_failure.php

Sign in to reply to this post

Jason ByrnesWebAssist

well, yes, the localhost address:
pp_confirm.php

is using your local wamp server for testing, like i said in my previous reply, you are running the pages from your local server and the database connection is set to connect top the remote server.

you need to use the live server address for doing the transaction.

to troubleshoot why the transaction is failing, add the following code to the pp_checkout_failure.php page just before the closing </body> tag:

php:
<?php

     
@session_start();
     echo 
"<p>Express Authorize: <br />"
     echo 
"Full Request: ".(isset($_SESSION["ECO_Auth_Request"])?htmlentities($_SESSION["ECO_Auth_Request"]):"n/a")."<br />"
     echo 
"Full Response: ".(isset($_SESSION["ECO_Auth_Result"])?htmlentities($_SESSION["ECO_Auth_Result"]):"n/a")."<br /></p>"
     echo 
"<p>Express Process: <br />"
     echo 
"Full Request: ".(isset($_SESSION["ECO_Process_Request"])?htmlentities($_SESSION["ECO_Process_Request"]):"n/a")."<br />"
     echo 
"Full Response: ".(isset($_SESSION["ECO_Process_Result"])?htmlentities($_SESSION["ECO_Process_Result"]):"n/a")."<br /></p>"

?>



this will write the full request being sent to paypal and the response coming back to help determine the cause of the failure.

NOTE: the full request and full response will contain sensitive information that should be removed before posting here,

Sign in to reply to this post

chssagmi366905

OK I don't understand. I uploaded my site to the internet and the connection file has only the web username and password. The host name is localhost. Where am I suppose to change something to start using internet settings so PayPal works?

Sign in to reply to this post

Jason ByrnesWebAssist

in your previous message you say:

  Sorry. The link is pp_confirm.php What I discovered is that if I use my pp_confirm.php , everything shows up correct. However when I click submit the transaction, I get pp_checkout_failure.php  





the address:
pp_confirm.php

is using your local testing server, this isn't working because the settings are for the remote server.

the address:
pp_confirm.php


is using the remote server which is working except that you are getting the payment failure page.

you need to be using the live server address for testing not the localhost address

on the payment failure page add the code that i provided in my previous response so that we can troubleshoot why the transaction is not working, until I know the full request and response info, i wont be able to troubleshoot the transaction failure.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...