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

Check out this article

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_16515

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

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?

Hi sidney78,

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

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.

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'

Select allOpen in new window

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

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 :)

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