 |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
|
|
|

November 18th, 2004, 12:26 PM
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Dreamweaver 2004 & mySQL database connection
Hi, I'm encountering an error when I try to connect to my mySQL server through Dreamweaver MX.
Dreamweaver says the testing server has been set up fine, but when I come to add a mySQL connection I input all my connection details and click "Select..." it brings up an allert followed by an error message, which both say the same thing...
The error reads
"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://localhost:/_mmServerScripts/MMHTTPDB.php URL. Varify that the URL prefix maps to the root of the site."
I have no clue what's going wrong and have tried countless solutions... can anyone help?!
|

November 18th, 2004, 01:31 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Hi there,
Can you show us how you set up the info for Local, Remote and Testing server in your Site Definition dialog?
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|

November 18th, 2004, 02:22 PM
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Of course I can...
[u]Local Info</u>
Site Name = Test
Local Root Folder = E:\My Documents\Unnamed Site 1 HTTP Address = http://localhost:/
[u]Remote Info</u>
Access = Local/Network
Remote Folder = E:\v3\temp\php
(E:\v3 is my webservers document root)
[u]Testing Server</u>
Server Model = PHP MySQL
Access = Local/Network
Testing Server Folder = E:\v3\temp\php URL Prefix = http://localhost:/
if you want to know anything else just let me know
:)
|

November 18th, 2004, 04:35 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Well, there you go. Just as the error message (sort of) indicated:
http://localhost:/
Is not a valid address. Drop the colons:
http://localhost/
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|

November 18th, 2004, 04:41 PM
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Like I say I have tried loads of things, that being one of the first and it seems to work fine with the colons, so i left them there.
even without the colons it doesnt work
|

November 18th, 2004, 05:09 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Whatever the problem may be, the colons shouldn't be there. Period (no pun intended).
So, it must be something with the root of your site.
When Dreamweaver verifies the server, it tries to create a file at the server, and then tries to request it. So, somehow, E:\v3\temp\php doesn't map to http://localhost.
What happens when you create a file called test.php in the temp\php folder. Can you then request it through http://localhost/test.php?
Are you running multiple Web servers??
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|

November 18th, 2004, 06:00 PM
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
no it'd be //localhost/temp/php/test.php
I only have one web server running
|

November 19th, 2004, 03:03 AM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
Well, in that case, your remote folder and testing folder should be
E:\v3
There should be a direct mapping between the root folder you set in DW and the root of your site.
So, when DW put a file like test.php in E:\ it can be requested as http://localhost/test.php
Once inside the root, you can create folders (directly or in DW) that then map to http://localhost/temp/php for example.
Cheers,
Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
|

November 19th, 2004, 10:55 AM
|
Authorized User
|
|
Join Date: Nov 2004
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Tried it... I have tried everything I can think of.. I'm not a newcomer to Dreamweaver MX 2004, nor any of the macromedia products...
I have tried every obvious thing... I have mapped to the document root before with no luck, and tried again after your suggestion, still with no luck.
Even if I try to define the testing server is basic mode it doesnt work.
When I test the url http://localhost/ in basic mode it brings up an alert saying
"Dreamweaver cannot use the prefix you have entered to display live data. Please double-check your site configuration or click on Help for more information on how to correct this problem. (HTTP Error: 12029)"
I have been through the help files looking for information regarding this problem, and all it says is how to set it up, not anything on how to correct the problem, or even if it's related to my other problems.
|

November 19th, 2004, 03:09 PM
|
 |
Wrox Author
|
|
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
|
|
In that case I am out of ideas. Like you said, it should work the way you described it.
Cheers,
Imar
|
|
 |