Skip to main content
D
dwfan
Participant
July 11, 2008
Question

Connection to MySQL Database

  • July 11, 2008
  • 1 reply
  • 897 views
Hi All,

I am having problems connecting to the remote database - MySQL. I am using PHP/MySQL.

First Error:
Dreamweaver cannot determine the remote serever time. The select Newer and Synchronize commands will not be avaliable:



Second Error:
An Ftp error occured - cannot put MMHTTPDB.php. Dreamweaver encountered an internal data error. Please try the operation again.


Final Error:
The testing server specified for this site does not map to the http://www.1chu.info/public_html/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL prefix maps to the root of the site.

The root folder on the remote server is: /public_html/

I can connect to the server but my MySQL connection does not work.
Thank You.
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
July 11, 2008
dwfan wrote:
> I am having problems connecting to the remote database - MySQL. I am using
> PHP/MySQL.

Looks like a problem with permissions. Dreamweaver creates a hidden
folder called _mmServerScripts in the root of your site. If the login
name is different from the owner of the root folder, Dreamweaver cannot
write the necessary files. That's why you get the synchronize error
(which isn't very important).

Use your remote server control panel to check whether _mmServerScripts
has been created, and if it contains two files: MMHTTPDB.php and
mysql.php. If it does, change the permissions on those files and the
directory to 777. If _mmServerScripts doesn't exist, create it with
permissions of 777, and try connecting from Dreamweaver again.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
N
Newsgroup_User
Inspiring
July 11, 2008
dwfan wrote:
> Thank you for the tip. I have checked the root folder and there are both the
> files that you specified. The _mmServerScripts are located outside the remote
> root folder that my site is connected to, that is, /public_html/ . within the
> public_html, there is no _mmServerScripts folder.

If that folder is outside public_html, it means you have set up your
testing server incorrectly in the site definition. Make sure you're
using the Advanced tab of the site definition dialog box.

The value of Host directory should be the same value as you use in the
Remote info section of the site definition.

URL prefix should be http://www.mysite.com/ (use the real URL of your site).

With those settings, Dreamweaver should install _mmServerScripts in the
correct location.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
N
Newsgroup_User
Inspiring
July 11, 2008
dwfan wrote:
> If dreamweaver is not putting the files to the correct location, should I do
> it manually using the remote control panel?

Yes, you can try that.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

dwfan wrote:
> I recreated a site inside the /public_html/demo/ and when i checked the
> file it had both the _my sql page and _MM..page under the _mmScript ..folder.
> However when i tried to loginto the database, it gave me the same error.

You're getting me confused now. What are you actually trying to do? Your
earlier description made it sound as though you are using your remote
server as a testing server. That means that you develop your files
locally, and when you click Live Data, Dreamweaver connects to the
remote server to process your PHP code and connect with MySQL.

However, in your previous message, you said you get an error when
uploading things. If everything is being uploaded to your remote server,
_mmServerScripts is not needed.

> I Know I set up the testing server properly.

If you had set it up properly, it should work. The fact that it's not
working suggests you have made a mistake, although you probably don't
realize it.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices