Trouble connecting to MySQL db php

[tinmanjim]

Attempting to connect a contact page (contact.php) to a mySQL database on my
1and1 server space- I'm entering the information into the "MySQL Connection"
dialog to the best of my ability, but consistantly get an error -

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
http://<domainName>.com.../_mmServerScripts/MMHTTPDB.php URL.
Verify that the URL Prefix maps to the root of the site.

I'm pulling my hair out (what's left of it) going over and over it trying any
and every combination I can think of, but obviously it's something I haven't
thought of...

[Deaf Web Designer]

Tinmanjim,

In order to connect with your PHP/MySQL server within your Dreamweaver, you
need to make sure about two things. Those two things are very important.

Be sure that your PHP.ini (configuration file) is set up correctly with MySQL
database server. 2nd important thing is to make sure that MySQL server is up
and running. Including first two important factors, you need to make sure that
Apache web server is up and running too.

I am not quite sure what system architecture (operating system) and exact
version of Dreamweaver. FInally, if you are working with Mac, please state the
EXACT version and system, since there are two kinds of motherboard of Mac chips
(G4 or G5 or Intel-Duo Chip).

Tidbit of technical information *do* help us to determine the nature of
problem you are having with.

[tinmanjim]

WXPpro, DW8-

Somehow, I had never heard of a php.ini file, but now that I have, I went back
in to the server's FAQ's, where I found that: "If your webspace does not
include a php.ini file in your root directory, you need to create one
yourself." OK, cool- now that I know about it I'll be able to look it up and
do something about it..

In the meantime, any hints and/or tips would be greatly appreciated.

Thanks for the help!
Jim

[Murray *ACE*]

Here's a great tip - get a copy of David Powers' terriffic book - Foundation
PHP for Dreamweaver 8. He walks you through this entire installation.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================


"tinmanjim" <webforumsuser@macromedia.com> wrote in message
news:efgdha$503$1@forums.macromedia.com...

> WXPpro, DW8-
>
> Somehow, I had never heard of a php.ini file, but now that I have, I went
> back
> in to the server's FAQ's, where I found that: "If your webspace does not
> include a php.ini file in your root directory, you need to create one
> yourself." OK, cool- now that I know about it I'll be able to look it up
> and
> do something about it..
>
> In the meantime, any hints and/or tips would be greatly appreciated.
>
> Thanks for the help!
> Jim
>

[Deaf Web Designer]

tinmanjim, other valuable tip, if you don't know how to edit php.ini, don't do
it. You could really mess it up PHP. Same concept goes with apache conf file as
well as mysql config file for that matter.

Murray, I took a good tip and the great heads up. I haven't look at that book
myself but by the sound of your suggestion, I'll get one myself and use it as
reference in my mini book library at my residence.

[Murray *ACE*]

It's really been a great reference for me.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
[url]http://www.dreamweavermx-templates.com[/url] - Template Triage!
[url]http://www.projectseven.com/go[/url] - DW FAQs, Tutorials & Resources
[url]http://www.dwfaq.com[/url] - DW FAQs, Tutorials & Resources
[url]http://www.macromedia.com/support/search/[/url] - Macromedia (MM) Technotes
==================


"Deaf Web Designer" <webforumsuser@macromedia.com> wrote in message
news:efh9ir$bsh$1@forums.macromedia.com...

> tinmanjim, other valuable tip, if you don't know how to edit php.ini,
> don't do
> it. You could really mess it up PHP. Same concept goes with apache conf
> file as
> well as mysql config file for that matter.
>
> Murray, I took a good tip and the great heads up. I haven't look at that
> book
> myself but by the sound of your suggestion, I'll get one myself and use it
> as
> reference in my mini book library at my residence.
>

[tinmanjim]

Thanks, I'll get it immediately!

[JasonMaier]

i had the same problem and tried to deal with it for 3 days straight. I
finally figured it out with the help of my webhost. The answer probably deals
with the second part of the error.

2) The testing server specified for this site does not map to the
http://<domainName>.com.../_mmServerScripts/MMHTTPDB.php URL.

Here's the solution: go to site definition, go to the testing server
category. Under URL prefix, change it to only your domain name. Get rid of
/public_html...and everything else.

Let me know if that works!

[tinmanjim]

That was exactly the solution, which I found the next day after trying anything
and everything else. My webhost told me (on telephone support) that they deal
with connectivity issues, but aren't in the business of specific software
problems. I was on my own, and finally managed to find the solution.

After solving the issue and getting everything working, I went back and looked
at the errort message and was a bit surprised that the 'power users' and such
didn't pick right up on it. In my neophytic 20/20 hindsight it seems so
obvious- but at the time I was unaware of the strictness of the naming
conventions. I would have thought that some of the more experienced among us
would have been.

Jim

[JasonMaier]

Great. I'm glad you found the solution. Bluehost is a wonderful webhost and they helped me through this problem. I recommend them highly for anyone looking to change!! -Jason-

[Deaf Web Designer]

JasonMaier and et al,

I am glad that things work out nicely for you.

[Germayne]

Hi peepz,

I am new to building websites. I've got the exact same problem as Tinmanjim! I
am currently running apache and mysql on my machine, and I've already created a
database with a few tables using phpMyAdmin. But when I tried to create a mysql
connection with dreamweaver it returns the Http Error 404!

Here's where my files are located:

Apache/ MySQL/ PHP 4.3.10/ - C:\Server
Files I am working on in Dreamweaver - C:\website

And here's how my site is set up:

Local root folder: C:\website\
HTTP address: [url]http://localhost/[/url]
Remote Info > Access: None
Server Model: PHP MySQL
Access: Local/Network
Testing server folder: C\website\
URL prefix: [url]http://localhost/[/url]

Can anyone check if there's anything wrong? I've tried different solutions but
nothing seems to work. Apache and MySQL server are all running fine on my
mahcine. I thought of editing the php.ini file but I am not sure how to go
about doing it. I am getting desperate! Btw, I am using Dreamweaver MX 2004 7.0
Any help will be greatly appreciated!!


:grin;

[tinmanjim]

Just a guess, but you might want to try setting Remote Info > Access to
Local/Network.

And allow me to quote Murray Ace: "Here's a great tip - get a copy of David
Powers' terriffic book - Foundation PHP for Dreamweaver 8. He walks you through
this entire installation.

I worked around my problem hit-or-miss, taking a couple of days. Then I got
the book, and haven't had more than a ten-minute problem since. It's worth the
price.

[Germayne]

Thanks Tinmanjim. I tried setting to local/network but it still didn't work. Perhaps, I should check out the book. Thanks again though.