Connecting to MySQL thru Dreamweaver

Posts: 4 · Posted: Wed Sep 19, 2007 9:04 pm

I just got the newest version of Adobe DW CS3 and I'm trying to set it up for dynamic page development, which requires a remote connection to MySQL from my dev machine.

I have confirmed the params are all correct; ie Username, Password, Database, and IP are all correct but I keep getting "An unidentified error has occured"...thats it.

I came in here to confirm that I could in fact connect from an external source, and from what I have seen so far it looks like I can. Any ideas?

I connect via FTP and my FTP client has no problems connecting...even with my firewall disabled Dreamweaver produces the same error...

.

Posts: 550 · Posted: Wed Sep 19, 2007 11:03 pm

Make sure your firewall is open to allow dreamweaver out.

Secondly, delete your _Connections folder (it will be a hidden folder) in the website you are setting up), and try again.

Furthermore, be sure your remote directory that you are trying to connect to on HMS is correct. It needs the full path to connect correctly

Example: C:\Websites\h12345\www\

and not just \www

If that STILL doesn't work, let me know.

Posts: 4 · Posted: Thu Sep 20, 2007 2:07 am

Thanks for the reply!

I went to a clean machine and installed DW to test. No firewall.
I've never been able to make this work in past versions either I should note Smile

When I setup the very first (and only) site in the site manager, I choose to connect to my remote server via FTP, port 21, and complete the form to connect. When i click the "test" button it informs me the connection was successful (no possibility of firewall issue correct?).

Once the site setup wizzard finishes, DW loads the cache of files locally. Next, in the right column, I click APPLICATION > DATABASES > '+' to start the MySQL new connection wizzard. I give the connection a name (shouldn't matter what) then enter the IP address of my server, my MySQL username and password, and the name of my database, then click 'test' again:
"An unspecified error has occured"

This has happened on 2 machines now, work & home.

I tried putting the full path in the initial setup wizzard where I usually enter /www/ as the remote root directory, but DW didn't like that setting and threw repeated warning boxes.

Unless it's a security settings issue on HMS's end, its got me baffled. My regular FTP client works fine as well as my FireFox FTP browser, but those connect to the html root...not the SQL server.
.
.

Posts: 96 · Posted: Sat Sep 22, 2007 2:25 pm

Are you connecting to a shared MySQL server? Or is this a database on say a VPS or dedicated server? I've read that if your database resides on the same server as your website you need to use localhost for the database connection ... although I have had other users who have claimed using the IP works equally as well.

http://kb.adobe.com/selfservice/viewContent.do?externalId=tn_16575&sliceId=2

Posts: 4 · Posted: Mon Sep 24, 2007 3:35 pm

Thanks for the reply nathacof Smile

I've tried both ways (IP and localhost) without success. I have a dedicated server, but I host about 6 domains on it using cPanel. I've added my home and work dedicated IP's to the 'allowed' list in cPanel's MySQl Connections.

The error log says:

[20-Sep-2007 09:07:02] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Host 'hog1.hogthis.com' is not allowed to connect to this MySQL server in /home/hogthis/public_html/_mmServerScripts/mysql.php on line 101

line 101 says:

$this->connectionId = mysql_connect($this->hostname, $this->username, $this->password);

However, I get this same error with both IP and localhost

Posts: 96 · Posted: Wed Oct 03, 2007 2:23 pm

What username and password combination are you using to access the server and what privileges does this user have?

With MySQL you can specify which hosts a user is allowed to connect from and it's possible that your IP is not currently allowed to connect with the username and password you are using.

If you open up a support request I can take a look at your user's privileges.

Posts: 4 · Posted: Sat Oct 06, 2007 1:57 am

Hi -

Thanks for the response. The username and password I'm using are the ones I created in cPanel under the MySQl manager where you also create the database and attach users to it.

I've also allowed my PC as a host by IP address and by assigning a wildcard to my ISP's domain, ie; *.my.isp.com in the allowed hosts file.

To be honest, I figured that as many times as I've tried, and with different versions of Dreamweaver, it's probably never worked due to a security setting on the server. I can see where allowing this could be a potential securty risk that I'm not sure I need to take.

I have setup Apache, PHP and MySQL on my local XP machine and it seems to work fine now (locally)...

Thanks again!

Jim