Skip to main content
I
iwantheman
Inspiring
February 1, 2007
Answered

MySql Connection Problem

  • February 1, 2007
  • 1 reply
  • 628 views
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
This topic has been closed for replies.
Correct answer iwantheman
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

1 reply

N
Newsgroup_User
Inspiring
February 1, 2007
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/
N
Newsgroup_User
Inspiring
February 2, 2007
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/
I
iwanthemanAuthor
Inspiring
February 2, 2007
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


Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices