Avatar of sidney78
sidney78 asked on

How can I get dreamweaver MX to connect to my Mysql database

Hi everyone,

I'm trying to make a connection to my Mysql database using Dreamweaver MX 7.0.1
When I fill in the details on the MYSQL connection box within Dreamweaver to make a connection to my Mysql database I keep getting the following error message -
an error occured cannot put MMHTTPDB.php The process cannot access the file because it is being used by another process.
Followed by HTTP error code 500 internal server error.
I can sucessfully connect to my databbase using Myphpadmin but after several days of banging my head against a wall and going over all my settings within dreamweaver's site definitions I'm still unable to get it to workt.

I am running Appache web server 2.2 / Mysql 5.5.51 / PHP 5.2.6 /  on http://localhost/

Any hellp or a solution would be fantastic as there is only so much more head banging I can take

PHPAdobe DreamweaverMySQL Server

Avatar of undefined
Last Comment
sidney78

8/22/2022 - Mon
dodge20

ASKER
sidney78

Thanks dodge20 for the link to the article,

I've just gone through the possible fixes on it but I'm still unable to connect, and I'm just getting the HTTP error code 500 internal server error now.

There is one section on there where I'm not getting the results as expected though -

"Verify that the connection scripts are up on the server
browse to the URL prefix you have defined in the Testing Server category of the site definition and add /_mmServerScripts/MMHTTPDB.php"

When I do this I just get a blank page appearing, in the article it says that I should receive
Notice: Undefined index: Type inc:\inetpub\wwwroot\mysite\_mmServerScripts\MMHTTPDB.php on line 13 in the browser, is this significant? and if so what should I do to rectify it?

I've also just noticed ion Myphpadmin home page that there is a box at the bottom of the page that says
Cannot load mysql extension. Please check your PHP configuration. - Documentation
I had this error preventing me from accessing Myphpadmin at all a couple of weeks ago but I managed (so I thought) to find a solution and myphpadmin seems to be working correctly other than this box being there.

I'm able to view a <?php phpinfo(); ?>,  via localhost without any problem

Hope any of this extra info will help in finding me a solution, fingers crossed
ASKER
sidney78

Sorry in addition I've just viewed my error log in the logs folder of my server and I have a lot of entries that state -

[Wed May 21 17:41:06 2008] [error] [client 127.0.0.1] PHP Fatal error:  Call to undefined function mysql_connect() in C:\\webserver\\htdocs\\_mmServerScripts\\mysql.php on line 49

I'm guessing this has something to do with why I'm experiencing problems connecting

Thanks in advance
anymore Ideas?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Jason C. Levine

Hi sidney78,

Did you compile the PHP installation yourself?  Is the mysql module part of the installation?
ASKER
sidney78

Hi jason1178

Yes I installed PHP and mysql separately, could  this be the  reason for the problem? although they all seem to be working correctly other than the problem that I'm having connecting to mysql via Dreamweaver.
Jason C. Levine

PHP has to be installed with the mysql module explicitly compiled.  I've attached my PHP compile statement below:

Check your phpinfo() function again and see if the with-mysql and with-mysqli options are in there.  
'./configure' '--prefix=/usr/local/php5' '--enable-fastcgi' '--with-mysql=/usr' '--enable-calendar' '--enable-force-cgi-redirect' '--with-config-file-path=/etc/php5/cgi' '--enable-trans-sid' '--with-gd' '--with-xml' '--with-xsl' '--with-ttf=/usr' '--with-freetype-dir=/usr' '--enable-exif' '--with-xslt' '--with-xslt-sablot=/usr' '--with-dom-xslt=/usr' '--with-jpeg-dir=/usr' '--with-png-dir=/usr' '--with-zlib-dir=/usr' '--with-pdo-mysql' '--enable-ftp' '--with-curl=/usr' '--with-pspell=/usr' '--enable-mbstring' '--with-mcrypt' '--with-mysqli' '--with-openssl=/usr' '--with-imap=/usr/local/imap-2000b' '--with-imap-ssl' '--with-gettext'

Open in new window

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
sidney78

Jason1178 thank you for trying to help me
I'm looking through my phpinfo() I don't see anything that says with-mysql or with-mysqli I

I've pasted the mysql info from phpinfo() file below, I hope this helps you

msql
MSQL Support  enabled  
Allow Persistent Links  yes  
Persistent Links  0/unlimited  
Total Links  0/unlimited  


mysqli
MysqlI Support enabled
Client API library version  5.0.51a  
Client API header version  5.0.51a  
MYSQLI_SOCKET  /tmp/mysql.sock  

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off

I am new to all things database, mysql as such like so this is a very steep learning curve for me, you've kindly attached your php compile statement but I'm unsure of what to do with it; sorry but could you talk me through how I can use this and what I'll need to do.

thank you again
Jason C. Levine

You should probably post this as a new question in the PHP and MySQL Zones because I'm not the best guy to assist with installations and compiling.

Basically, tell them what you installed on your local machine and mention that you are having trouble connecting from PHP to the MySQL server on the local machine.  Those Experts can guide you through testing and recompiling.   I don't want to say anything that might lead to you borking your desktop.

I tend to think the installation is the problem because of this:

"PHP Fatal error:  Call to undefined function mysql_connect()"

and I know reinstalling/recompiling is the way to go.  But at this point, I pick up the phone and yell at my Network guy until he does it for me :)
ASKER
sidney78

Just wish I had that same network guy on the end of my phone, never been so flustrated, i'll do several laps of honour when this problems been sorted out, I'll try your suggestion of posting in the other zones.

thank you very much for your help thus far
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
ASKER CERTIFIED SOLUTION
sidney78

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question