close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Live online paypal connection error

Thread began 1/21/2011 1:11 pm by chssagmi366905 | Last modified 1/25/2011 10:54 am by Jason Byrnes | 1122 views | 9 replies |

chssagmi366905

Live online paypal connection error

When I tested my site locally I had no problems but when I went live I got a error on the confirm page.

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'danny_even5'@'localhost' (using password: YES) in C:\wamp\www\mysite.com\Connections\dbc.php on line 16

Fatal error: Access denied for user 'danny_even5'@'localhost' (using password: YES) in C:\wamp\www\mysite.com\Connections\dbc.php on line 16

This same connection works throughout the rest of the site and I can't see where this error is coming from.

This is the connection info:

$hostname_dbc = "localhost";
$database_dbc = "danny";
$username_dbc = "danny_even5";
$password_dbc = "get456";
$dbc = mysql_pconnect($hostname_dbc, $username_dbc, $password_dbc) or trigger_error(mysql_error(),E_USER_ERROR);

This is not actual info but exact examples with different names.
thanks.

Sign in to reply to this post

Jason ByrnesWebAssist

the error is a very simple one. It means that the username and password are not being excepted by the mysql server.


it is not possible that this same connection information could be used on other pages in the site successfully, they would give the same error message

Sign in to reply to this post

chssagmi366905

That is what I thought for the last 2 days that I have been trying to figure it out but it always worked locally. I can display, insert, update and select data from the database without problems so this is a head banger for me too but it is the exact connection heading info throughout the site.

This is the start of file:
<?php
//WA eCart Include
require_once("../WA_eCart/ambCart_PHP.php");
?>
<?php require_once('../Connections/dbc.php'); ?><?php
$ambCart->GetContent();
?>
<?php
require_once("../WA_eCart/PP_ECO_Scripts/PP_ECO_PHP.php");
?>
<?php
require_once("../WA_eCart/Adv_CO_Scripts/PP_DirectPayment_PHP.php");
?>
<?php
//WA eCart Include
require_once("../WA_eCart/WA_eCart_Database_PHP.php");
?>
<?php
if (!session_id()) session_start();
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["eCartCheckoutForm_country"] = "".((isset($_POST["country"]))?$_POST["country"]:"") ."";
}
?>

Sign in to reply to this post

Jason ByrnesWebAssist

I suspect that you have more than one connection folder on the server, and it looks like the pages are using the same connection info, but they really are using different connection info.


Send a copy of one of the pages that can successfully connect to the database. Send a link to the page and a link to the confirm page so i can look into it.

Sign in to reply to this post

chssagmi366905

I forgot that when I use dreamweaver to upload "confirm.php" file I get a message that says "Synchronization info can not be found on connections and uploading file could overwrite changes online. Then when I select 'yes to all' it ends up saying 1 file or folders was not uploaded' ".

I don't know how to send a link but I will follow your instructions.
thanks

Sign in to reply to this post

Jason ByrnesWebAssist

well, that means any changes being made to the connections file are not being uploaded. If you have edited the connection file to use the correct info to connect to the mysql server, the updates are not making it to the server.


try deleting the connection file on the server, then re uploading.

If you still have problems, compress a file that is successfully connecting to the db into a zip archive.

to send a link, you just need to paste the server address to the page in your reply, pate a link for the page that can successfully connect and a link for the confirm page

Sign in to reply to this post

chssagmi366905

I'm sending a zip file with the confirm.php file. I'm also sending 4 pp_ files because when I tried to check out through the express I got the failure page instead with all the checkout info displayed including my paypal api signature info. The cus_pricing page can be used as I will change any pricing info back to what I wanted.
Thanks

Attached Files
wa_payPalProblems.zip
Sign in to reply to this post

Jason ByrnesWebAssist

Ok, thank you for sending the files, but I will also need a link to your site.

Can you also send a screen shot of the failure page so i can get a better understanding of the express checkout issue.

Sign in to reply to this post

chssagmi366905

The screen shot of payPal checkout would be the above "pConnect error.
The express page I can't screen shot because it shows my actual charge card info as well as my actual payPal username, password and signature.
The only way to get to those screens is to actually use a real charge card with a minimum product charge of $50 since I am now tied into payPal. Again everything worked perfectly through the sandbox.
If you need to take over my screen I will go through the steps with my charge card so you would be able to see both screens.

Sign in to reply to this post

Jason ByrnesWebAssist

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
supporthistory.php

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...