Issues setting up database connections in DWCS3

[Guest]

Hi there,

I am experimenting with dynamic sites in DW, and I keep running into a problem. Whenever I try to create a MySQL connection, I get this 404 error:

1) There is no testing server running on the server machine.
2) The testing server specified to this site does not map to the http://127.0.01/_mmServerScripts/MMHTTPDB.php URL. Varify that the URL prefix maps to the root of the site.

I am running XAMPP (yes, it's on!) and DWCS3 on a Mac.

Advice, anyone? I've been all over the web with this and nothing I've tried has helped. Thanks loads!

[Newsgroup_User]

bec_wilson wrote:
> 1) There is no testing server running on the server machine.
> 2) The testing server specified to this site does not map to the
> http://127.0.01/_mmServerScripts/MMHTTPDB.php URL. Varify that the URL prefix
> maps to the root of the site.
>
> I am running XAMPP (yes, it's on!) and DWCS3 on a Mac.

XAMPP on a Mac? You like living dangerously. The front page of the XAMPP
site has this warning: "This version of XAMPP is still in the first
steps of development. Use at you [sic] own risk!"

If you want an all-in-one PHP/MySQL installation for a Mac, you're on
much safer ground with MAMP ( http://www.mamp.info/en/mamp.html).

Now, to your problem. Setting up a testing server is very simple. The
site must be inside the Apache DocumentRoot. The location of the
DocumentRoot depends on whether you're using XAMPP, MAMP, or the default
version of Apache that ships with Mac OS X. However, assuming you're
using either XAMPP or MAMP, it's a folder called htdocs. Your site must
be in a subfolder of htdocs.

The values of Testing server folder and URL prefix in the Dreamweaver
site definition should both point to the same place. The first is a
physical path; the second is a URL to the same location.

So, in the Testing server folder field, put /path/to/htdocs/mysite (use
the real path, not these actual words). In the URL prefix, put
http://localhost/mysite/.

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

[Guest]

I will try MAMP as opposed to XAMPP, but I have had XAMPP running a testing server wonderfully for months. I double-checked all the paths, etc, and everything looks to be correct.

So, assuming that my local server is running (which it is), and the folders are there, and the file paths read what I assume to be correct (pointing to the htdocs folder), why would DW throw this error?

[Guest]

I uninstalled XAMPP and am now using MAMP. Tested it, it seems to be working fine. But now when I try to connect to a database, I get a 403 Forbidden! Please help? Thanks!

[Newsgroup_User]

bec_wilson wrote:
> I uninstalled XAMPP and am now using MAMP. Tested it, it seems to be working fine. But now when I try to connect to a database, I get a 403 Forbidden! Please help? Thanks!

MAMP uses non-standard ports for Apache and MySQL. I can't remember the
details, but they're listed in the FAQ on the MAMP site.

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

[Guest]

I changed all the file permissions to 775 and now I have a new issue. Here's the current error message:

The URL prefix localhost:8889/test/ for this site's server could not be resolved. This could be due to several reasons:
1. You have specified a local root folder that does not fall under the web server root folder.
2. There is no web server running on the URL. A web server must be running in order to map pages through a URL.
3. There is a web server running but no virtual web folder has been mapped to this prefix. A web virutal folder lapping is needed for local sites that aren't under the web root folder.
Please consult your web server documentation or your system administrator if you need further information.

Once I press "OK", I get another warning that says "An unidentified error has occurred."

Yes, I realized when first testing MAMP that it uses ports 8888 and 8889. I have tried mapping the database connection to both (server 'localhost:8888' as opposed to 'localhost').

The files are located in "MacHD:Applications:MAMP:htdocs:test:", so that is where the filepaths lead. This has always been standard protocol for all the static sites I've done, it just doesn't seem to work now that I am trying something dynamic. Does the filepath have to be something different?

Thanks.

[Guest]

Fixed it.

[Newsgroup_User]

bec_wilson wrote:
> So, assuming that my local server is running (which it is), and the folders
> are there, and the file paths read what I assume to be correct (pointing to the
> htdocs folder), why would DW throw this error?

Because what you think are the right paths are incorrect. If everything
is in the right place, it works. It's as simple as 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/