Does MX 2004 have MySQL/PHP database bug

Hi,

I'm having one heck of a time getting DW MX 2004 to recognize
Apache/MySQL/PHP setup. Having done a search in this forum for keywords
'mysql' and 'database' I've found quite a few others who are having the same
problem.

Several of the posting mention that they are newbies with database (me too)
so I'm not convinced that it is a DW problem as much as a lack of experience
problem. Either way there isn't a whole lot of help from MM on the subject.
The only two tech notes that I could locate are: "Connecting to a MySQL
database in Dreamweaver" and "Unidentified error occurs when testing a
PHP/MYSQL connection." Unfortunately, they haven't solved the problem.

Has anyone successfully created an Apache/MySQL/PHP configuration to work
with DW MX 2004? If so what resource did you work from that you found most
helpful. I know there are several of us who would greatly appreciate you
help.

Richard

On Fri, 21 Nov 2003 21:03:09 GMT, "Storyman"
<mystoryman (AT) earthlink (DOT) net> wrote:

Hi,

I'm having one heck of a time getting DW MX 2004 to recognize
Apache/MySQL/PHP setup. Having done a search in this forum for keywords
'mysql' and 'database' I've found quite a few others who are having the same
problem.

Several of the posting mention that they are newbies with database (me too)
so I'm not convinced that it is a DW problem as much as a lack of experience
problem. Either way there isn't a whole lot of help from MM on the subject.
The only two tech notes that I could locate are: "Connecting to a MySQL
database in Dreamweaver" and "Unidentified error occurs when testing a
PHP/MYSQL connection." Unfortunately, they haven't solved the problem.

Has anyone successfully created an Apache/MySQL/PHP configuration to work
with DW MX 2004? If so what resource did you work from that you found most
helpful. I know there are several of us who would greatly appreciate you
help.

Richard

Richard

I use this set up all the time, and it works well.

Have you tested to see that php is working correctly, using a
phpinfo.php file, as below:

<?php
phpinfo();
?>

At what point are you getting an error? Is you site contained in a
subfolder? Where is this subfolder? Have you defined it as an alias in
your httpd.conf file? Have you then restarted Apache?

If you want, I will send you a manual I have written on the subject.
It's a 2M file, so I don't want to email it to you without your
permission, but I'm happy for you to have it.


Paul Taylor

Paul,

I'd love to see the manual and thank you for both offering and warning me
about the size.

My ISP is Earthlink and I've had problems with large files in the past. Is
it possible for you to provide a ftp link so it can be downloaded from a
site?

BTW Both PHP and MySQL test out as installed correctly--that's what makes
this so frustrating!

Richard

"Paul Taylor" <pftaylor (AT) technocurve (DOT) co.uk> wrote

On Fri, 21 Nov 2003 21:03:09 GMT, "Storyman"
mystoryman (AT) earthlink (DOT) net> wrote:

Hi,

I'm having one heck of a time getting DW MX 2004 to recognize
Apache/MySQL/PHP setup. Having done a search in this forum for keywords
'mysql' and 'database' I've found quite a few others who are having the
same
problem.

Several of the posting mention that they are newbies with database (me
too)
so I'm not convinced that it is a DW problem as much as a lack of
experience
problem. Either way there isn't a whole lot of help from MM on the
subject.
The only two tech notes that I could locate are: "Connecting to a MySQL
database in Dreamweaver" and "Unidentified error occurs when testing a
PHP/MYSQL connection." Unfortunately, they haven't solved the problem.

Has anyone successfully created an Apache/MySQL/PHP configuration to work
with DW MX 2004? If so what resource did you work from that you found
most
helpful. I know there are several of us who would greatly appreciate you
help.

Richard


Richard

I use this set up all the time, and it works well.

Have you tested to see that php is working correctly, using a
phpinfo.php file, as below:

?php
phpinfo();
?

At what point are you getting an error? Is you site contained in a
subfolder? Where is this subfolder? Have you defined it as an alias in
your httpd.conf file? Have you then restarted Apache?

If you want, I will send you a manual I have written on the subject.
It's a 2M file, so I don't want to email it to you without your
permission, but I'm happy for you to have it.


Paul Taylor

Paul,

Thanks for your help in getting MySQL and Dreamweaver MX to play nice
together.

For those seeking an answer to a similar problem I'd like to offer words of
encouragement and a couple of suggestions.

The two areas to examine is the use of alias and creating users and
databases.

Before using alias I'd suggest to get things up and running with DW first,
then create the alias to redirect to your DW folder. This means using the
htpdocs folder instead of changing any files to redirect to the web site
folder(s).

DW requires that you have a database and user set up before anything can
happen. For whatever reason when I used command mode to type the
instructions the result was a series of errors. What worked best for me was
using a database management program. I tried several and the best freebie
one was:
http://www.dbtools.com.br/EN/

Once you're comfortable creating users and databases, then launch DW MX to
sync up with your database.

Richard



"Paul Taylor" <pftaylor (AT) technocurve (DOT) co.uk> wrote

On Fri, 21 Nov 2003 21:03:09 GMT, "Storyman"
mystoryman (AT) earthlink (DOT) net> wrote:

Hi,

I'm having one heck of a time getting DW MX 2004 to recognize
Apache/MySQL/PHP setup. Having done a search in this forum for keywords
'mysql' and 'database' I've found quite a few others who are having the
same
problem.

Several of the posting mention that they are newbies with database (me
too)
so I'm not convinced that it is a DW problem as much as a lack of
experience
problem. Either way there isn't a whole lot of help from MM on the
subject.
The only two tech notes that I could locate are: "Connecting to a MySQL
database in Dreamweaver" and "Unidentified error occurs when testing a
PHP/MYSQL connection." Unfortunately, they haven't solved the problem.

Has anyone successfully created an Apache/MySQL/PHP configuration to work
with DW MX 2004? If so what resource did you work from that you found
most
helpful. I know there are several of us who would greatly appreciate you
help.

Richard


Richard

I use this set up all the time, and it works well.

Have you tested to see that php is working correctly, using a
phpinfo.php file, as below:

?php
phpinfo();
?

At what point are you getting an error? Is you site contained in a
subfolder? Where is this subfolder? Have you defined it as an alias in
your httpd.conf file? Have you then restarted Apache?

If you want, I will send you a manual I have written on the subject.
It's a 2M file, so I don't want to email it to you without your
permission, but I'm happy for you to have it.


Paul Taylor