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.

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

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"]:"") ."";
}
?>

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.

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

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

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

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.

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.

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