MySql Connection Problem

[iwantheman]

Hi there,
*I have used xampp to sucessfully install apache,php and mysql.
*I have set up my testing server with Dreamweaver 8.
*I have hand coded a database connection using Dreamweaver 8 as my text editor.
*When I F12 preview, I get a sucessful output...

BUT (AAAAAAAAAAAAAAARGH!)

*When I try to connect via Dreamweaver 8 > Application Panel > Databases > MySql Connection using localhost, it says:

"1)There is no testing server running on the server machine.
2)The testing server specified for this site does not map to the http://localhost/myRoot/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL Prefix maps to the root of the site."

Can anyone shed any light on this please, as I am losing my finger-nail grip on reality by now - cheers
Iwan

[Newsgroup_User]

iwantheman wrote:
> "1)There is no testing server running on the server machine.
> 2)The testing server specified for this site does not map to the
> http://localhost/myRoot/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL
> Prefix maps to the root of the site."

One way to restore your grip on reality is to search Googlegroups for
one of the zillions of times exactly the same question has been asked
and answered in this forum.

In your site definition, the testing server folder and URL prefix must
point to the same location. In other words, the XAMPP server root and
http://localhost/ should point to the same folder. I don't use XAMPP,
but my Apache DocumentRoot is C:\htdocs. If I create a site in
C:\htdocs\mysite\, the values in the site definition are as follows:

Testing server folder: C:\htdocs\mysite\
URL prefix: http://localhost/mysite/

That's all there is to it.

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

[iwantheman · Accepted solution]

Thanks mate, but I did search the groups and found lots of answers like yours that miss the point.

Thanks for your efforts, but I discovered the real reason for the problem myself - it's the firewall - simple as that and nothing to do with site definitions, testing servers or indeed Dreamweaver itself.
cheers

[Newsgroup_User]

iwantheman wrote:
> Thanks mate, but I did search the groups and found lots of answers like yours
> that miss the point.

No, they don't miss the point. The vast majority of problems are caused
by incorrect site definition. Your original post gave no indication of
how you had set up your testing server. That's why you got the standard
answer.

> Thanks for your efforts, but I discovered the real reason for the problem
> myself - it's the firewall - simple as that and nothing to do with site
> definitions, testing servers or indeed Dreamweaver itself.

Yes, the firewall would be the next place to look. But the site
definition and testing server are involved. It won't work unless all
parts of the equation are complete. Anyway, glad that you are now up and
running.

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

[iwantheman]

Hi there

I disagree,old chap - the fact that a hand coded connection can be made and tested via Dreamweaver implies that the testing server is indeed correctly defined. If the site definiton were incorrect, the hand coded connection would have generated Error 404 or some such rather than getting a sucessful output... - all of which is in my original posting.

Many thanks for taking the trouble to help me
Best regards

[iwantheman]

Hi there

I disagree,old chap - the fact that a hand coded connection can be made and tested via Dreamweaver implies that the testing server is indeed correctly defined. If the site definiton were incorrect, the hand coded connection would have generated Error 404 or some such rather than getting a sucessful output... - all of which is in my original posting.

Many thanks for taking the trouble to help me
Best regards

[Newsgroup_User]

iwantheman wrote:
> I disagree,old chap - the fact that a hand coded connection can be made and
> tested via Dreamweaver implies that the testing server is indeed correctly
> defined. If the site definiton were incorrect, the hand coded connection would
> have generated Error 404 or some such rather than getting a sucessful output...
> - all of which is in my original posting.

Feel free to disagree, but you're wrong. Dreamweaver uses a hidden
folder called _mmServerScripts to communicate with MySQL. If the site
definition is wrong, you get exactly the same error message as you
described. It's such a common mistake that it should always be the first
thing to check.

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

[iwantheman]

I do believe we have arrived at that juncture upon which all gentlemen of good faith and character must truly agree to differ.

Thank you for making a newcomer to the forum feel welcome.

Best regards

[Newsgroup_User]

iwantheman wrote:
> I do believe we have arrived at that juncture upon which all gentlemen of good
> faith and character must truly agree to differ.
>
> Thank you for making a newcomer to the forum feel welcome.

I hope you do feel welcome. There's quite a lot of expertise in
different areas here. However, there's a high volume of traffic.
Sometimes it's difficult to tell whether someone asking a question has
done any research beforehand. Sadly, many people don't. So it's always a
good idea to say you've searched the archives, found a particular
solution (say briefly what it is), but that it didn't fit your
circumstances.

If you stick around long enough, you'll get to know who provides
reliable answers. But even those of us who glory in the title of Adobe
Community Expert are only human. We don't claim to know everything. Many
different factors can lay behind a problem. It's not always easy to
identify the relevant ones.

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

[iwantheman]

Fair enough

I guess I should have made it clearer that I knew the testing server was working. It is easy to miss things - I asked various php colleagues at work prior to posting and they didn't spot it either.

I will be sure to make things clearer in future.
Thanks.
Best regards