I am trying to setup PHP/MySQL database connection in Dreamweaver MX.

First let me say that my hand-coded PHP pages are working, so I know my DB name and password and stuff is correct.

In the MySQL connection window, I have the following:

connection name: mydatabasename
mysql server: localhost
username: myusername
password: mypassword (like i'm going to post it here )
database: mydatabasename

When I click "TEST", I get the following:

HTTP code 404, file not found:
1) there is no testing server running on the server machine.
2) the testing server specified for this site does not map to the www.mydomainname.com/public_html/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL prefix maps to the root of the site.



I went to the CPanel and found the _mmServerScripts folder and the MMHTTPDB.php file in that folder.

Any suggestions please!

-Thanks

heya,

the public_html folder on hosting companies is usually mapped to your domain, so you should not include it in the URL that you are browsing to. Make sure in the site settings that you haven't pointed it to www.yourdomain.com/public_html/

When you FTP into the account you will see the public_html and maybe public_ftp accounts in your root directory, but that is the root directory for your account login. So while the FTP settings that you use to upload files into your site should include the public_html folder, the testing URL should not.

allan

Hey, thanks! That was exactly my problem. In the "Site Definition" box, in on the "Testing Server" section of the "Advanced tab", I did have the /http_docs/ as the root, and when I took it out, it worked like a charm!

Thanks again!

/*Hello, I'm new. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle> I've been searching out this problem all night.*/

I'm also having the exact same problem except that I didn't include the public_html when defining the root of the testing server. Any and all help will be greatly appreciated. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>



//error text
HTTP code 404, file not found:
1) there is no testing server running on the server machine.
2) the testing server specified for this site does not map to the www.mydomainname.com/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL prefix maps to the root of the site.

Hi, did you go to the _mmServerScripts folder and verify that MMHTTPDB.php file is there?


Also, i'm assuming you know your db name, username, password, etc?

See that's the weird thing. I'm remoting to this server and I can SSH to it and run commands from it fine. I've created and maniupated a database from command line already so I know mySQL is on there. I've even installed phpMyAdmin and maniupate tables from there, but its only when I try to connect to it from Dreamweaver is when I get any problems.



Edited by - Demona on 02 Jun 2003 05:13:12

Try deleting MMHTTPDB.php from your website and then re-copy that file from your C: drive back up there. Maybe it's corrupted.

It's located (by default) at c:\program_files\macromedia\dreamweaver mx\configuration\connections\scripts\php_mysql\_mmdbscripts

And basically, make sure that in Dreamweaver, on your Site Definition box in the "testing" section of the Advanced tab that everything is correct there, especially the URL prefix box.
-Kevin

lol I'm still battling with this. I've done everything you've said with no avail.

The new error message is "28488 st '{server's IP address}' is not allowed to connect to this MySQL server". I have no clue where the "28488 st" comes from since it doesn't even resemble the user name and I can still SSH to the server fine. <img src=../images/dmxzone/forum/icon_smile_dissapprove.gif border=0 align=middle>

I'm beginning to think its more about my server's settings.

Hi Guys and gals, have to admit that I am a newbie here. I downloaded Nuspere (MySql, Apache and PHP with myphpadmin) on to my home system running win xp pro and installed it fine everything worked staraight away.

I created a simple database with mysql and all worked well. When I start using dreamweaver to create the site it runs a test on the URL (localhost) and says all is well, but When I try to connect to my sql database I get the 404 error seen in the previous messages. Basicaly saying that I am not connected to a testing server, although I can see apache running. I had a look in my Apache folder and found the folder _mmServerScripts containing a couple of files.
But I still dont know what is going on.
I think I need a bit of help explaining the localhost and the remote host, the root folder and the project folder. I must point out that my development machine has no internet or network connection. I plan to upload the completed project on to a linux machine in the future. Cheers john

demona,

the error you're getting means that your MySQL server does not accept incoming connections from external hosts. You'll need to write your connection scripts to point to 'localhost' and run a mirrored version of your production database in your local development machine, also using 'localhost' as your connection path.
In regards to the mysterious 404 errors, you guys should all check that (i may be repeating other people's suggestions here):

1. Your 'http address' and 'URL prefix' settings in the site definitions window are correct. If they are not, DWMX will not bve able to establish a connection to your testing server, and it will decide that you don't have one.

2. Ensure your FTP settings are correct, and have been tested (using the TEST button). Otherwise this will also cause connection problems.

That's all i can think of at the moment.

-- J



------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

I am having the same problem.. But mine says...

HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem:

1) There is no testing server running on the server machine.
2) The testing server specified for this site does not map to the serverIP/var/www/html/_mmServerScripts/MMHTTPDB.php URL. Verify that the URL Prefix maps to the root of the site.

Any help would be great...

I think, am not sure but i think that if your hosting company doesn't allow remote connection to its mysql servers it will be difficult to connect. Most hosting company does that for security reason, even i have this problem.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I think, am not sure but i think that if your hosting company doesn't allow remote connection to its mysql servers it will be difficult to connect. Most hosting company does that for security reason, even i have this problem.
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>


I have a similar problem. I use Godaddy. What hosting plans do you reccommend that would allow remote connections. I was told that it most allow SSH connections is that true.

It all depends on the hosting really. Not most but some hosting does allow remote connection. Best thing to do is to contact your hosting company and ask.

I am having as huge problem with this, i am at the server logged in as root and all and its all local so theres no ftp or anything required.

i have been getting the error:

HTTP Error Code 404 File not Found.

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

i have tried every forum i could find, tried everything and nothing seems to work ive checked everything like 30 times now and its startin to piss me off for something so simple.

PLEASE I NEED SOME HELP WITH THIS!!!!!!!!!!!!

thanks for any help it is greatly appriciated by by a noob like me

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I am having as huge problem with this, i am at the server logged in as root and all and its all local so theres no ftp or anything required.

i have been getting the error:

HTTP Error Code 404 File not Found.

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

i have tried every forum i could find, tried everything and nothing seems to work ive checked everything like 30 times now and its startin to piss me off for something so simple.

PLEASE I NEED SOME HELP WITH THIS!!!!!!!!!!!!

thanks for any help it is greatly appriciated by by a noob like me
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I'm using DW8. The problem that I had was duplicationg the numerical I.P. address in both the "FTP host" field, and the "URL Prefix field" in the Testing Site Definition form.

In the URL definition field, enter your <u>domainname.net</u> and maybe that will help.





Kind Regards.

I had the same problem, and I found the solution (at least it worked for me) copy the whole _mmServerScripts folder (which contains the files MMHTTPDB.php and mysql.php) into your server, either local (localhost) or remote. following the path that dreamweaver is asking you (in this case localhost/documents/_mmserverscripts/MMHTTPDB.php) the _mmServerScripts folder can be found in :\program_files\macromedia\dreamweaver 8\configuration\connections\scripts\php_mysql\_mmdbscripts. After i did this i got another error message from dreamveaver telling me that i didn't configure MySQL to work with php. For that i had to modify the php.ini file with Notepad ( which should be in either c:\windows\system32 or c:\windows , i copied them in both ). locate the lines:
; Directory in which the loadable extensions (modules) reside.
extension_dir = "./"
Change the last line to
extension_dir = "c:\php\ext"
(or wherever the directory actually is)
the next change involves locating an "uncommenting" the following line:
;extensions=php_mysql.dll
Simply remove the semicolon at the beginning of the line to uncomment it.
You will also need to copy the file libmysql.dll from your c:\php directory into your c:\windows\system32 or c:\windows ( i copied it in both )
and finally if dreamweaver tells you that it couldn't make a connection try to use "root" in the user name in the dialog box of mysql connection

Where are the _mmServerScripts folder?
Hi, did you go to the _mmServerScripts folder and verify that MMHTTPDB.php file is there?


Also, i'm assuming you know your db name, username, password, etc?

Here we go,
Another with the same problem.
This is the only thread that I havn't been able to try properley.
I've copied the files _mmserverscripts with both files under it and be damned if I can paste it anywhere.
I've been working on the 404 error for 3 weeks now and am pretty fed up. Please someone help me.

DW8/ php/ mysql

All site definition connects.
OBDC works
Just the database connection.
Yes all my username/ password and database name is correct.

I don't understand how some things work for some and not eveyone.
Melissa