Solved

Dreamweaver MySQL Connection Error

Posted on 2010-11-07
11
881 Views
Last Modified: 2012-06-21
I am trying to setup a site within Dreamweaver CS4 and I have never had so much trouble. I have successfully setup and connected to the remote and testing servers. I am now trying to add my MySQL database but continue to receive the following error:

MySQL Error#: 2013
Lost connection to MySQL server at 'reading initial communication packet', system error: 110

Using the same settings I am able to connect to the database using Navicat for MySQL. Ideas?

This is usually a straight forward process but this is my first attempt to do this using Rackspace Cloud as my host.
0
Comment
Question by:rmb8024
  • 6
  • 5
11 Comments
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 34081043
Hi rmb8024,

Error 2013 usually means there is a problem on the MySQL server end of things, not Dreamweaver.

Verify the MySQL server is up and running and listening on the correct ports for web traffic.
0
 

Author Comment

by:rmb8024
ID: 34081060
Yes, I have verified the server is fine. I am able to connect using Navicat for MySQL, and phpMyAdmin. The issue seems to be isolated to Dreamweaver.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 34081071
Dreamweaver uses mysql_pconnect() (persistent connection) to do its thing.  Open your connection file and change that to mysql_connect() and see if works any better.
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:rmb8024
ID: 34081100
That was a good idea but unfortunately I get the same error when I test the MySQL connection.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 34081174
Okay.

1) Where is the testing server for this site?

2) Does the mysql user have permission to access from any IP address?
0
 

Author Comment

by:rmb8024
ID: 34081204
1) The testing server is the same physical server as the remote (live) server. I am using Rackspace Cloud as the host Do you need any more info then that?

2) Yes, I can only assume it does as I am able to use the same connection information in Navicat to access the database remotely.
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 34081298
1) No, no more info than that.

2) Weird.  It's almost as if DW itself is being blocked.  Can you check firewalls and other security software/appliances to be sure DW can connect out?
0
 

Author Comment

by:rmb8024
ID: 34081330
That is what is strange, I can select any of my other sites with databases and it connects fine. That said, none of my other sites are hosted at Rackspace Cloud.

I contacted Rackspace but all their tests say it is operating fine. They conclude I must have a setting incorrect in Dreamweaver somewhere.
0
 
LVL 70

Accepted Solution

by:
Jason C. Levine earned 500 total points
ID: 34081351
>> They conclude I must have a setting incorrect in Dreamweaver somewhere.

Maybe.

Try this:

Site | Advanced | Remove Connection Scripts

Then log in to the Rackspace site with a normal FTP or shell client (not DW) and delete the _mmServerScripts folder if it's still there.

Then try to rebuild the connection file and rebuild a recordset or other server behavior.
0
 

Author Comment

by:rmb8024
ID: 34081396
Jason,

Rackspace gives an IP to connect to when remotely accessing MySQL but to connect from within the script loaded on the server it is a hostname. I had tried using the hostname previously but it gave the same result.

I tried again after your last suggestion and the hostname works! The IP still does not. Very interesting because even Rackspace told me the hostname will not work.

Thanks for your patience and all your help!
0
 
LVL 70

Expert Comment

by:Jason C. Levine
ID: 34081439
>> Very interesting because even Rackspace told me the hostname will not work.

That is weird.  If it causes you problems in the future, you can always edit the connection file and replace the hostname with the IP address.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now