CS4 can't connect to any MySQL databases

[Guest]

The MySQL connections stopped working recently from Dreamweaver CS4, even though they still work for the assocated PHP pages when accessed from a web browser. I get this message: "Dreamweaver could not securely connect to your server. It's possible that your SSL certificates are not installed correctly." I should mention that I'm working from a new machine with a fresh installation of CS4, importing the sites from my old machine.

[pziecina]

Hi

"Dreamweaver could not securely connect to your server. It's possible that your SSL certificates are not installed correctly."

Check if your pages require ssl, if so you will need to install a 'new' ssl certificate on the new machines local testing server, (for testing locally, a self signed will suffice).

PZ

[Guest]

I'm using the remote server as the testing server. Do you know if Dreamweaver uses the same protocol for connecting to the Web as Internet Explorer? On this computer, IE has problems connecting to some secure sites, but only when I'm directly connected to the company network. If I'm working at a remote location, IE has no such problems.

[pziecina]

Hi

Do you know if Dreamweaver uses the same protocol for connecting to the Web as Internet Explorer?

Not certain about this, as DW is not a browser, (the multi-screen view in DW5 can work as such) did this set-up work before? The reason I ask is that the ssl on the remote site may not be able to establish a secure connection with DW and this would explain the problem, as DW may not be able to supply the 'return' headers to do so.

PZ

[Guest]

Thanks. Not only did the setup work before, it still works if I log into another DW-equipped computer on the same network.

[pziecina]

Hi

Have you checked that your firewall is allowing dreamweaver to connect to the remote server?

PZ

[Guest]

Dreamweaver connects fine to the remote server using FTP. It's only the MySQL connections that are the issue.

[pziecina]

Hi

Are you getting the connections folder showing in the databases panel, and is the connection string file opening?

PZ

[Guest]

Yes, I can see the list of Connections, and when I open one I get the MySQL Connection window with the connection name, server name and so forth. The error message comes up when I click Test in the window. And if I try to create a page that inserts data or fetches it, Dreamweaver cannot find any of the tables in any of the databases.

[pziecina]

Hi

As you can see and open the connection this would indicate that your server is not allowing a remote connection to the database from your new computer. Have you checked with them for the authorization files to be changed? You may also require a script from them to allow/authorise the remote connection.

PZ

[Guest]

Do you mean the webserver or our company's network server? From the webserver's standpoint, it sees the same IP address no matter which computer on the network we use to access the webserver. It's only this particular computer that has the problem accessing the MySQL connections. I should mention that this same computer also cannot access many secure websites in Internet Explorer.

[pziecina]

Hi

In your case I am not certain where the following folder would be created by dreamweaver, the folder name is _mmServerScripts and contains 2 files - 'MMHTTPDB.php' and 'mysql.php'. It is an hidden folder but both the files are required by dreamweaver for it to connect to the database.

Check your 'old' machine for the files in the 'testing server' as defined in the site definition and/or look on your remote server, although I would not think it would be on the remote server due to the security implications.

PZ

[Guest]

I checked those two files and they are fine. I retested the MySQL connections using an outside Web connection and they test fine, and I"m also able to get to secure websites in IE using this connection. It's only when I use the network's proxy connection that both of these fail.

[Bullwinkle_Gilmore]

Hi Carston

I am upgrading from Dreamweaver 8 (where all 24 of my sites were working) to Dreamweaver CS5.  When I try to make the database connection file I get the error:

The files from the _mmServerScripts folder are for the server PHP-MySQL.  You try to connect to a database using a different server model.

Please remove this folder outside the Dremweaver environment on both local and testing machines and try again.

OR

HTTP Error Code 404 File Not Found.

2)The testing server specified for this site does not map to the http://www.site name/sitename/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL Prefix maps to the root of the site.

I opened up my sites with another FTP program and deleted the hidden folder _mmServerScripts from my remote servers. Then deleted the same folder from my local machine.  Finally one of my sites at PHPWebhosting worked.  I ended up deleteing all the other sites from the Site Manager and duplicating the site that worked.  I edited the copy to a different site and was able to get them to work one by one.  I only have one site now at DreamHost.com that is not working.

These same site definitions I have been using for up to 3 years on some of my sites (and they are working in Dremweaver 8).  My problem has to do with the _mmServerScripts and all their parts.  There must be .js files involved as well??  It seems there should be a simple fix for this problem.

Note:  When I click the test button in the sites setup dialog boxes, Dreamweaver is able to connect.

Cheers,

Terry

[Guest]

Trying Internet Explorer again, I noticed that the error page I receive with my site is "dnserror.htm." Do you think that flushing the DNS resolver cache using IPCONFIG will fix the problem in Dreamweaver as well as in the browser?

[Guest]

Good news - upgrading to the current version of Internet Explorer seems to have fixed the problem. Thanks to everyone for all the suggestions.