Connection to MySQL Database

[dwfan]

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.

[Newsgroup_User]

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/

[dwfan]

Hi David,

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.

Should i copy those folders to the public_html folder?

I have changed the permission and tried to connect but got the following error:

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

[Newsgroup_User]

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/

[dwfan]

Hi David,

I have checked the settings in my testing server many times using different paths but to no avail. Currently the hostdirectory is exactly as listed on the remote connection dialog box which is /public_html/ for the remote server and testing serever. I am using the exact url for the site. I am able to connect to the server. When i upload the local site to the remote server. It gives me the following errors:

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

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

If dreamweaver is not putting the files to the correct location, should I do it manually using the remote control panel?

[Newsgroup_User]

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]

Hi David,

No Luck. I am still getting the same errors. The dreamweaver is creating the files.

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. I changed the permissions on the folders and the files. That did not work either. Should i change my webhost? I Know I set up the testing server properly.

[Newsgroup_User]

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/