PDA

View Full Version : mySQL and Dreamweaver MX



paul
05-25-2003, 06:07 PM
:?: I am having difficulty setting up the connection between Dreamweaver MX and my MySQL database. - Paul

Purple
05-26-2003, 09:37 AM
I too was having real trouble getting this working at one stage - it was working one day, then the next it wasn't.

If you have ImpAKT or PhaKT installed, you need to double check and see if they haven't overridden. See Macromedia's technote http://www.macromedia.com/support/dreamweaver/ts/documents/unidentified_error_mysql.htm for more information.

If pain persists, see your doctor - or, keep on posting in here until we get it working :)

Cheers,

Purple

WestHost - CSimiskey
05-28-2003, 12:17 PM
An item of note here:

We do not allow external (network) connections to your databases, so if dreamweaver is trying to read your database from your home computer, you should not be able to. If you are trying to access the databse through "localhost" and it is still failing, then let us know and we'll see what can be done.

lambrite
06-14-2003, 08:28 PM
Does this mean that I can, indeed, set up connections in Dreamweaver to take advantage of all their wysiwyg tools? And I have just been trying in the wrong manner?


(crosses fingers and prays that the answer is yes)

~Sarah

WestHost - CSimiskey
06-16-2003, 02:33 PM
From what I understand, it is possible to do, but not being a DreamWeaver user myself I do not know the details of getting it set up and working. If Dreamweaver can be made to use a secure connection, then yes you should be able to access the database through that, but you'll need to look more into support from MacroMedia or DreamWeaver user groups for specifics on how to do that.

lambrite
06-20-2003, 07:51 PM
After a lot of searching, I found instructions on how to set up DreamweaverMX with SSH.

http://www.macromedia.com/software/dreamweaver/product_resources/roi/putty/puttydownload.html

However, after following those, I get the error message "An FTP error occurred - cannot get remote folder information. " :(

I'm not really sure what to do at this point.

==========
From Macromedia's Site (http://www.macromedia.com/support/dreamweaver/ts/documents/ssh.htm)

Troubleshooting a potential FTP error message
When you attempt to transfer files through an SSH tunnel, the following error message may appear:

An FTP error occurred - cannot get remote folder information. 425 possible PASV port theft, cannot open data connection.
This error is common and occurs due to restrictions on the FTP server. To prevent this error, consult the FTP server configuration instructions or speak to the server administrator or ISP. Configuration will differ depending on the FTP server used:

If you are using the ProFTPD FTP server, add the "AllowForeignAddress on" directive to the Virtual Address section of the configuration file.
If using the WU-FTPD FTP server, add the following lines to the configuration file:
pasv-allow all + valid IP address
port-allow all + valid IP address

If using another FTP server, please consult configuration documentation or speak to your server administrator or ISP.

teenawr
07-24-2003, 12:54 AM
I've just completed successful testing of WestHost's compatibility with Dreamweaver's database connectivity with the assistance of Brian Shellabarger, Chief Technology Officer, WestHost.

A record of the procedure is up temporarily up at http://teenawr.westhost.net/.

If this is still an issue for anyone, I'd appreciate feedback / corrections on the tutorial.

Thanks in advance,

Teena
www.teenawr.com
913.248.1990
---------------
"Things may come to those who wait,
but only things left by those who hustle."
~Abraham Lincoln

foeggy
12-17-2003, 02:58 AM
Teenawr -

Is there any chance that a backup of that project was kept?

Thanks. :wink:

teenawr
12-17-2003, 07:17 AM
That tutorial is now up at:
http://www.teenawr.com/dwmx_westhost/
However, I have not checked the tutorial since WestHosts recent upgrades. Please let me know if it works for you.

wildjokerdesign
12-17-2003, 08:47 AM
Great tutorial teenawr! The only thing I noticed is that it states that you have to contact WestHost to set up a database. Shouldn't you now be able to do that your self if you have phpMyAdmin installed on your site?

Wish I could check out the rest but I am still using Dreamweaver 4. Looks like it is time for me to upgrade :)

If you ever have the need to remove the tutorial from your site I would be happy to host it on one of mine... giving you credit. It would be ashame to lose it.

foeggy
12-17-2003, 08:46 PM
Wildjokerdesign - phpMyAdmin works to make tables so you no longer need to call WestHost to create a table for you.

Teenawr - thank you so much for posting the link to the turtorial. I got it connect and it now works fantastically. My original problem had been: under Remote configuration for the site I used "Require SSH" as well as for the testing server.

Thanks again!!! :lol:

elektrolab
04-06-2006, 05:50 PM
That tutorial is now up at:
http://www.teenawr.com/dwmx_westhost/
However, I have not checked the tutorial since WestHosts recent upgrades. Please let me know if it works for you.

I got an error at this page. Is this available anywhere now? thanks.

wildjokerdesign
04-06-2006, 09:08 PM
That post was from some time back. I doubt the tutorial is available any more. Been so long that I can't rember for sure reading it. :) I do have MX now so I might be able to help out. I don't connect to MYSQL with since I have found better ways but willing to try and answer any questions.