Need Help Getting Dreamweaver to find MySQL (Macintosh)

Report · Aug 23, 2006

I've been trying for a week to get Dreamweaver 8 at my job to talk to MySQL (NB: I'm experienced with Dreamweaver, but a newbie to MySQL -- I'm trying to get started…but can't!).

LOCAL INFO:

Local Root Folder: Macintosh HD:Users:robert:Sites:testy:
HTTP Address: Not required

REMOTE INFO:

Access: None

TESTING SERVER

Server Model: PHP MySQL
Access: Local/Network
Testing server folder: Macintosh HD:Users:robert:Sites:testy:
URL Prefix: http://localhost/~robert/testy/

MySQL is running, as per preferences pane.

I've got personal web sharing running as per pref pane.

When I tried the setup you suggested I got a different error:

"The URL prefix http://localhost/~robert/testy/ for this site's testing server could not be resolved. This could be due to several reasons:
1. You have specified a local root folder that doest not fall under the web server root folder
2. There is not web server running on the URL.
3. There is a web server running but no virtual web folder has been mapped to this prefix."

I tried then setting it up to run at http://localhost/~robert/, just to see if it couldn't find the folder "testy" -- but same story.

I then tried to set things up using DW's basic setup -- when I got to "What URL would you like to use to browse to the root of your site?", and I entered " http://localhost/~robert/testy/", and I tried to test, I got the error "Dreamweaver cannot use the prefix you entered to test live data...(HTTP Error: 0)"

I've also heard (somewhere in my meanderings) that there may be some problem in 10.3.9 or some such using "localhost", so I tried substituing "127.0.0.1" -- same results…

So, I'm still sitting in idle. Any help much appreciated.

Report · Aug 23, 2006

roberttraum wrote:
> I've been trying for a week to get Dreamweaver 8 at my job to talk to MySQL
> (NB: I'm experienced with Dreamweaver, but a newbie to MySQL -- I'm trying to
> get started?but can't!).

All your settings seem correct, but you have never answered the
question: is there a folder called _mmServerScripts in Macintosh
HD:Users:robert:Sites:testy:? If there is, it should work.

However, there is a possibility that there's a problem with the files in
that folder. Select the Site menu, then choose Advanced, followed by
Remove Connection Scripts. Once the connection scripts have been
removed, try creating a MySQL connection again.

Another possibility: you haven't created a user account on MySQL, or
you're using the wrong username and password.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Aug 23, 2006

quote:

All your settings seem correct, but you have never answered the
question: is there a folder called _mmServerScripts in Macintosh
HD:Users:robert:Sites:testy:? If there is, it should work.

Yes, there is. I removed connection scripts and tried again.

There is some weird thing going on here now --

In the database panel, it still says I need to set up a testing server, even when I have one setup fine (as per below).

If I go back to the "basic" wizard for setup, and get to the page with the URL for the testing server, and enter

http://localhost/~robert/testy/

A dialog pops up which says "Dreamweaver cannot use the prefix you entered to display live data...HTTP Error(0)"

I don't think it's a MySQL user name problem -- why can't it even see the testing server. All settings as per earlier message.

Report · Aug 24, 2006

roberttraum wrote:
> A dialog pops up which says "Dreamweaver cannot use the prefix you entered to
> display live data...HTTP Error(0)"

The only thing I can think of is that it might be a permissions problem.
Select the _mmServerScripts folder and its contents in Finder and run
GetInfo on each of them in turn, expand the Details section of Ownership
& Permissions. Owner should have Read & Write access. Group and Others
should both have Read only.

--
David Powers
Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
http://foundationphp.com/

Report · Nov 30, 2006

I am having exactly the same problem and am totally frustrated trying to get it to work. Everything else seems to get defined properly, as the MM scripts get copied into the local root folder. But when I set the URL Prefix to http://localhost/mysite I get the dreaded "Dreamweaver cannot use the prefix you entered to display live data...HTTP Error(0)" error message. The web browser can resolve and display the site on localhost no problem. I've tried 127.0.0.1, the real hostname and the ip address and all give the same error. I even tried putting the site on a remote system and using a fully qualifed name to set it up - still nothing. And I've searched for hours looking for resolution to this problem - it seems lots of people have encountered the problem but nothing has been posted to show how to fix it or work around it.

So if anyone has any idea how to fix this I'd be very grateful. TIA...

Report · Dec 09, 2006

bogentu wrote:
> I am having exactly the same problem and am totally frustrated trying to get it
> to work. Everything else seems to get defined properly, as the MM scripts get
> copied into the local root folder. But when I set the URL Prefix to
> http://localhost/mysite I get the dreaded "Dreamweaver cannot use the prefix
> you entered to display live data...HTTP Error(0)" error message. The web
> browser can resolve and display the site on localhost no problem. I've tried
> 127.0.0.1, the real hostname and the ip address and all give the same error. I
> even tried putting the site on a remote system and using a fully qualifed name
> to set it up - still nothing. And I've searched for hours looking for
> resolution to this problem - it seems lots of people have encountered the
> problem but nothing has been posted to show how to fix it or work around it.
>
> So if anyone has any idea how to fix this I'd be very grateful. TIA...
>
Your "Hard Drive" name have any strange characters in it?
Mick