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

PS3 & PG integration ~ password fails

Thread began 6/18/2010 3:45 am by nicola.goodenough317043 | Last modified 6/18/2010 7:49 pm by Eric Mittman | 562 views | 1 replies |

nicola.goodenough317043

PS3 & PG integration ~ password fails

Jimmy said "start a new thread" if still problems:

A rehash of the problem ....

Integrating PG with PS3 ...

I added the code from PowerGallery>Admin>Add to Site to PowerStore Admin> Products> Update (product information)> Long Description > Source > paste code > Update.

I then checked as a user from my site (chengyan.nickdfg.com). When I clicked on the product, I got the error:

Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'dbo330230171'@'212.227.119.22' (using password: YES) in /homepages/18/d319201787/htdocs/chengyanWhite/Connections/powergallery.php on line 9

Fatal error: in /homepages/18/d319201787/htdocs/chengyanWhite/Connections/powergallery.php on line 9

So I looked in my Connections/powergallery.php and it said:

<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_powergallery = "db2509.oneandone.co.uk";
$database_powergallery = "db330230171";
$username_powergallery = "dbo330230171";
$password_powergallery = "xxxxxxxx";
$powergallery = mysql_pconnect($hostname_powergallery, $username_powergallery, $password_powergallery) or trigger_error(mysql_error(),E_USER_ERROR);
?>

where it correctly gives my password (not the x's I have edited in). So I don't understand why it is failing. My password is there.

Can anyone tell me what changes I need to make? Any help gratefully received.

Regards, Nick


Jimmy replied:
--------------------------------------------------------------------------------

One thing that you might need to do is to implement the Database Integration Update in your download center:
mywebassist...ad.php?PID=292

--------------------------------------------------------------------------------

I have checked my Products pages, and they have the db integration correctly in place. But I am still getting the "access denied" password problem.

The website is: www.chengyan.nickdfg.com/

When I went to Products > Tigers from the menu (which was visible), and then clicked on the first tiger, "learn more" button, I got the same error msg. (This one is the only one which I have applied the code to, but I only get two lines of code ... which from other forum entries seems to be wrong.)

Also, my CSS stopped working correctly (see side panel, and top navigation on the "learn more" page). The top navigation is now back to raw text, with no css, although the css is still there! And the side navigation has strange gaps in it. If you go back to the home page, and hover where the top navigation should be, then click on "all products", everything looks fine ... until you click on the "learn more" button again. See txt attachment for extra info

More advice please.

Nick

Sign in to reply to this post

Eric Mittman

The error you are getting in regards to your connection is coming directly from the MySQL server. So it is your server that is saying the password or connection is not valid, not any of our scripts. Are you able to test this connection file with any other pages that make reference to it?

The error says that access is denied so it seems that the username if off, the password is off, or the address used for the server is not accessible from this script. I would suggest that you make a new page that makes use of this connection and put a recordset on the page and display some values from the rs to test it out.

Sign in to reply to this post

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