close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Connecting the database on Godaddy

Thread began 3/30/2010 11:28 pm by admin140217 | Last modified 6/18/2010 10:45 am by Jason Byrnes | 3899 views | 5 replies |

admin140217

Connecting the database on Godaddy

Well it seems to be one thing after another lately.

I just uploaded powerCMS to hosting on Godaddy, and set up the database using PHpmyadmin within the hosting account but I'm getting an error when I try to open a page connected to the database.

Here is the error:

Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/64/5760064/html/CMS/Connections/localhost.php on line 9

Fatal error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/64/5760064/html/CMS/Connections/localhost.php on line 9

I understand that this is probably something to do with the path but I'm not sure what. I was under the impression I wouldn't have to modify any of the files once uploaded.

With that said, the only two files haveing connection data in them are the localhost.php and WA_Globals.php. But I'm not sure of what to change, the connection string to the database, or the local and/or remote naming.

Help would be great!

Thanks

Sign in to reply to this post

admin140217

Solved

Okay, I have fixed the issue.

Sign in to reply to this post

Peter

Would you mind sharing how you resolved. I'm facing my first upload ever to GoDaddy here shortly. Thank you.

Sign in to reply to this post

Jason ByrnesWebAssist

the error:
Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket


usually occurs as a result of entering the wrong MySQL server name. Your GoDaddy control panel should have the correct MySQL Server name, Username, Password and Database name listed, make sure you use those values from the control panel when running the ePowerCMS installer.

Sign in to reply to this post

nathan400860

Same Problem:

I am having some trouble. So I have just recently uploaded my e commerce site on my godaddy hosting account. The site uploaded fine except for a few problems. Problem 1: Two product images on the home page did not pop up/ the image was blank. Problem 2. Not all of the thumbnail images SHOW in the shopping cart when I add a product to the cart when it works great in the testing server. Problem 3. I am getting this error when I try to buy a product on the remote server.

"Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/s/w/a/swaney777/html/Connections/MyConnection.php on line 9

Fatal error: Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2) in /home/content/s/w/a/swaney777/html/Connections/MyConnection.php on line 9"

I'm guessing that the problem is occurring because the check our pages are looking for mysql databass. I have created a mysql databass on my testing server.

If you would like to see these three problems go to www.dvinecigars.com . The domain name is a test domain before I put it on the live server.

Once these three problems are solved the site will work great!
Thanks,
Nate Swan

Sign in to reply to this post

Jason ByrnesWebAssist

looks like you posted this twice, see Eric's response in your other thread:
showthread.php?t=13875

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