SitePoint.com

natimage · Apr 16, 2003, 06:22

Hi, All! I'm having a problem getting Dreamweaver to successfully connect to MySQL on a remote server. I feel like I've tried everything, but I know I haven't or it would be working by now!!

I'm going to go at it a little differently and post the info. I get from my FTP log when I try to test my database connection. If anyone can look at this and give me any more detailed information about the errors that show, please do. I'm having dreams about this at night because I've fought with it for so many days!!!! Here's the FTP log for a test connection:

150 Opening ASCII mode data connection for file list.
cgi-bin
_vti_pvt
index.htm
_vti_log
_private
_vti_txt
news.htm
_vti_cnf
_vti_bin
text.css
_borders
_derived
_fpclass
_overlay
textblue.css
Links.htm
_notes
TextBlueSm.css
gallery.htm
border.css
product.htm
Gallery.swf
animals.htm
stilllife.htm
winter.htm
main.css
animals2.htm
oursky.htm
fallcolors.htm
water.htm
animals3.htm
animals4.htm
animals5.htm
fallcolors2.htm
fallcolors3.htm
oursky2.htm
water2.htm
water3.htm
water4.htm
_mmServerScripts
PHP_MySQL
deletme.php
cart
Images
226 Transfer complete.
CWD /public_html/_mmServerScripts
250 CWD command successful.
PORT 65,160,38,219,5,100
200 PORT command successful.
RETR MMHTTPDB.php.LCK
550 MMHTTPDB.php.LCK: No such file or directory
PORT 65,160,38,219,5,101
200 PORT command successful.
RETR mysql.php.LCK
550 mysql.php.LCK: No such file or directory

Thanks for any help!!
Tracy

cragthehack · Apr 17, 2003, 00:06

DWMX has serious problems making a remote connection to a MySQl Server. I'm not excatly sure if they fixed it, but knowing Macromedia I doubt it. I'd search the TechNotes at Macromedia.com and see. But good luck. let me know if you do it. i ended up writing everything by hand.

siteguru · Apr 17, 2003, 01:34

One thing to watch out for - does that mySQL server accept remote connections, or does it only allow connections from the local web server? (In other words - is DW MX really the problem)?

cragthehack · Apr 17, 2003, 02:14

Quote:

Originally Posted by siteguru

One thing to watch out for - does that mySQL server accept remote connections, or does it only allow connections from the local web server? (In other words - is DW MX really the problem)?

YES DWMX is the problem. It's well known. Search their newsgroup and you'll find hundreds of messages about it.

natimage · Apr 17, 2003, 07:40

Well...I have a claim in for help with Macromedia. If they respond with any good information, I will post it here. Thanks for a direct answer...I haven't seen many of those where this issue is concerned!

Tracy

natimage · Apr 17, 2003, 14:45

OK...I've figured out that where Dreamweaver is looking for the files MMHTTPDB.php.LCK and mysql.php.LCK...

the files that are written in the folder on my remote site are MMHTTPDB.php and mysql.php.

Does anyone know what the .LCK is and why Dreamweaver is looking for it??? And is it on my local computer so that I could just copy it to the remote site manually???

...once again feeling on the verge of a solution, hoping not to crash and burn...
Tracy

Apr 16, 2003, 06:22	#1
natimage SitePoint Zealot Join Date: Apr 2003 Location: Colorado Posts: 189	using PHP/MySQL with Dreamweaver MX Hi, All! I'm having a problem getting Dreamweaver to successfully connect to MySQL on a remote server. I feel like I've tried everything, but I know I haven't or it would be working by now!! I'm going to go at it a little differently and post the info. I get from my FTP log when I try to test my database connection. If anyone can look at this and give me any more detailed information about the errors that show, please do. I'm having dreams about this at night because I've fought with it for so many days!!!! Here's the FTP log for a test connection: 150 Opening ASCII mode data connection for file list. cgi-bin _vti_pvt index.htm _vti_log _private _vti_txt news.htm _vti_cnf _vti_bin text.css _borders _derived _fpclass _overlay textblue.css Links.htm _notes TextBlueSm.css gallery.htm border.css product.htm Gallery.swf animals.htm stilllife.htm winter.htm main.css animals2.htm oursky.htm fallcolors.htm water.htm animals3.htm animals4.htm animals5.htm fallcolors2.htm fallcolors3.htm oursky2.htm water2.htm water3.htm water4.htm _mmServerScripts PHP_MySQL deletme.php cart Images 226 Transfer complete. CWD /public_html/_mmServerScripts 250 CWD command successful. PORT 65,160,38,219,5,100 200 PORT command successful. RETR MMHTTPDB.php.LCK 550 MMHTTPDB.php.LCK: No such file or directory PORT 65,160,38,219,5,101 200 PORT command successful. RETR mysql.php.LCK 550 mysql.php.LCK: No such file or directory Thanks for any help!! Tracy

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Apr 17, 2003, 00:06	#2
cragthehack SitePoint Enthusiast Join Date: Jul 2001 Location: Ft. Lauderdale, FL. USA Posts: 94	DWMX has serious problems making a remote connection to a MySQl Server. I'm not excatly sure if they fixed it, but knowing Macromedia I doubt it. I'd search the TechNotes at Macromedia.com and see. But good luck. let me know if you do it. i ended up writing everything by hand.

Apr 17, 2003, 01:34	#3
siteguru SitePoint Wizard Join Date: Oct 2002 Location: Scotland Posts: 2,936	One thing to watch out for - does that mySQL server accept remote connections, or does it only allow connections from the local web server? (In other words - is DW MX really the problem)?

Apr 17, 2003, 07:40	#5
natimage SitePoint Zealot Join Date: Apr 2003 Location: Colorado Posts: 189	Well...I have a claim in for help with Macromedia. If they respond with any good information, I will post it here. Thanks for a direct answer...I haven't seen many of those where this issue is concerned! Tracy

Apr 17, 2003, 14:45	#6
natimage SitePoint Zealot Join Date: Apr 2003 Location: Colorado Posts: 189	OK...I've figured out that where Dreamweaver is looking for the files MMHTTPDB.php.LCK and mysql.php.LCK... the files that are written in the folder on my remote site are MMHTTPDB.php and mysql.php. Does anyone know what the .LCK is and why Dreamweaver is looking for it??? And is it on my local computer so that I could just copy it to the remote site manually??? ...once again feeling on the verge of a solution, hoping not to crash and burn... Tracy