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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Works Locally Not On Server

Thread began 8/17/2009 4:45 pm by reneas.email303886 | Last modified 8/17/2009 7:04 pm by Jason Byrnes | 705 views | 1 replies |

reneas.email303886

Works Locally Not On Server

I created my pages using DataAssist and tested them locally, then I exported my db as a .sql dump then imported it into my db called "mud09" on the server.

Okay so I imported the .sql via PHPAdmin and it created the table, etc. I then saved a copy of my Connection file locally called it server.php then changed within the resume_Insert.php the line that said <?php require_once("Connections/mud.php"); ?>
which was my original connection file to <?php require_once("Connections/server.php"); ?>

I then uploaded all files to the server and now I receive the following error when visiting resume_Insert.php:

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

Fatal error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/content/m/u/d/mudcheck/html/Connections/server.php on line 9

Okay what did I overlook? Really need to get this application built:(

Renea


Can anyone in the forum assist me, pleese....

Sign in to reply to this post

Jason ByrnesWebAssist

First, do not change the name of the connections file.

You should make a duplicate of the mud.php file, then change it to use the correct information for MySQL Server, username and Password and database name fr the remote server.

There are variable names used through out the application that will reference variables created in the mud.php connection file that will not exist in the server.php connection file.



as for the error you are getting, it indicates that you cannot refer to the mySQL server by the name localhost, check with your host to determine the correct name to refer to the mysql server by.

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