Skip to main content
S
swood30
Participant
December 28, 2010
Answered

Issue with MySql Connection and secure server

  • December 28, 2010
  • 1 reply
  • 1173 views

I have setup my Site in Dreamweaver specifying FTP.  The Remote and Testing checkboxes are selected for my Server. I do not want a separate Testing server, and therefore, have NOT installed Apache.  I connect successfully to my Yahoo web hosting server to put files.  From my PHP page, I am attempting to setup MySQL connection.  Since I am placing all of my files in an SSL folder on my Web Hosting server, I’m not sure if I’m setting everything up properly.  When I attempt to connect to mysql I get an HTTP Error Code 404 File Not Found with possible reasons:

1)      There is no testing server running on the server machine

2)      The testing server specified for this site does not map to the [site details removed by moderator] .com/ssl/_mmServerScripts/MMHTTPDB.php URL.  Verify that the URL Prefix maps to the root of the site.

When I open my Yahoo server, my files sit in the location:  www.example.com/ssl/

If I enter this as a root directory in the Server setup section, I get an FTP error message stating that the server folder can not be opened because it doesn’t exist or there’s a permission problem when I attempt to test the MySql connection.  If I leave the root directory field blank, I’m able to connect to the server with success, but receive the testing server error as stated previously.

I have setup a different website previously with success and thus used it as a guide for the entries I’ve made for this website.  I was on a different computer at the time and had installed Apache back then.  The only difference between my previous website and this one, is my working with an SSL folder on the Yahoo server and thus having to work with the https://.....etc. 

Please provide solutions in an easy to understand fashion, I’m not a developer and don’t know how to debug or anything.  Thanks!!!

This topic has been closed for replies.
Correct answer David_Powers

swood30 wrote:

Please provide solutions in an easy to understand fashion, I’m not a developer and don’t know how to debug or anything.  Thanks!!!

You were doing quite well until you wrote that.

If you want to work with PHP, you need to have a basic understanding of the technology you're working with, and be willing to roll up your sleeves, dive into the code, and debug. Otherwise, you will struggle; and if you rely on Dreamweaver's server behaviors, you'll be extremely limited in what you can achieve. Showing a willingness to learn is likely to result in others being more willing to help you.

Using your remote server as the testing server is not recommended. You should always test locally, or at least on a server that's not publicly accessible.

The way that Dreamweaver communicates with MySQL, regardless of whether you're using a local or remote testing server, is as follows: Dreamweaver creates a hidden folder called _mmServerScripts in the site root of the testing server, and uses the two scripts in that folder to establish connection with MySQL. I suspect that your server is preventing Dreamweaver from creating the _mmServerScripts folder in your ssl folder. As the error message says, it's a permissions problem. If you log into your remote server's control panel, you could try creating an empty folder called _mmServerScripts in the ssl folder. That might solve the permissions problem.

A better solution would be to create a local testing environment, and test locally. Once everything is working to your satisfaction, upload the files to the remote server. The _mmServerScripts folder is required only by Dreamweaver for testing. Once you go live, the PHP scripts connect directly to MySQL.

1 reply

David_Powers
David_PowersCorrect answer
Inspiring
December 28, 2010

swood30 wrote:

Please provide solutions in an easy to understand fashion, I’m not a developer and don’t know how to debug or anything.  Thanks!!!

You were doing quite well until you wrote that.

If you want to work with PHP, you need to have a basic understanding of the technology you're working with, and be willing to roll up your sleeves, dive into the code, and debug. Otherwise, you will struggle; and if you rely on Dreamweaver's server behaviors, you'll be extremely limited in what you can achieve. Showing a willingness to learn is likely to result in others being more willing to help you.

Using your remote server as the testing server is not recommended. You should always test locally, or at least on a server that's not publicly accessible.

The way that Dreamweaver communicates with MySQL, regardless of whether you're using a local or remote testing server, is as follows: Dreamweaver creates a hidden folder called _mmServerScripts in the site root of the testing server, and uses the two scripts in that folder to establish connection with MySQL. I suspect that your server is preventing Dreamweaver from creating the _mmServerScripts folder in your ssl folder. As the error message says, it's a permissions problem. If you log into your remote server's control panel, you could try creating an empty folder called _mmServerScripts in the ssl folder. That might solve the permissions problem.

A better solution would be to create a local testing environment, and test locally. Once everything is working to your satisfaction, upload the files to the remote server. The _mmServerScripts folder is required only by Dreamweaver for testing. Once you go live, the PHP scripts connect directly to MySQL.

S
swood30Author
Participant
December 28, 2010

Hi David-

Thank you for your QUICK and CORRECT reply!  Yes, creating the _mmServerScripts folder in my SSL folder on my remote server did the trick!!

I did try to setup a testing server using one of your tutorials, but I received FTP errors.  Since I have a working website with remote and testing flagged on the same server and for my ease of understanding, I copied the setup as closely as I could (less the SSL add-on).  Mind you, I originally setup that website 3 years ago, so I'm a bit rusty.  I'm not a web developer and don't do this for a living, thus I get by with instructions from the books I own, web tutorials, Adobe forums, etc., but I have not taken any classes.  It's not my choice to work with PHP, but I have to in order to pull data from database tables into my web pages.  Since I don't do this for paying customers, I don't have to setup anything too fancy (thank goodness).  I would like to know how to debug and write java script code, but I lack the time and patience (mostly patience).

Besides...Adobe does such a good job with their products, that I can get by pretty well without having to know everything.

Again, THANK YOU!!!

PS- Would you mind replacing my root site info above with the following:  www.sitename.com/ssl/

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices