SQL Power Software Forum

I'm running MAMP on Mac OS X Tiger and trying to connect PowerArchitect to it's MySQL database. I suspect it may be the socket path that needs to be changed. Any ideas of what I need to do and how?

ca.sqlpower.architect.ArchitectException: Couldn't connect to database: Communications link failure

Last packet sent to the server was 0 ms ago. (cause: com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.)
	at ca.sqlpower.architect.SQLDatabase.getConnection(SQLDatabase.java:559)
	at ca.sqlpower.architect.SQLDatabase.populate(SQLDatabase.java:112)
	at ca.sqlpower.architect.SQLObject.getChildCount(SQLObject.java:212)
	at ca.sqlpower.architect.swingui.DBTreeModel.getChildCount(DBTreeModel.java:146)
	at javax.swing.plaf.basic.BasicTreeUI.paintExpandControl(BasicTreeUI.java:1365)
	at javax.swing.plaf.basic.BasicTreeUI.paint(BasicTreeUI.java:1192)
	at javax.swing.plaf.ComponentUI.update(ComponentUI.java:154)
	at javax.swing.JComponent.paintComponent(JComponent.java:743)
	at javax.swing.JComponent.paint(JComponent.java:1006)
	at javax.swing.JComponent._paintImmediately(JComponent.java:4890)
	at javax.swing.JComponent.paintImmediately(JComponent.java:4676)
	at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:477)
	at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:114)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
	at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
	at ca.sqlpower.sql.SPDataSource.createConnection(SPDataSource.java:420)
	at ca.sqlpower.sql.SPDSConnectionFactory.createConnection(SPDSConnectionFactory.java:55)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
	at ca.sqlpower.architect.SQLDatabase.getConnection(SQLDatabase.java:557)
	... 19 more
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:430)
	at java.net.Socket.connect(Socket.java:520)
	at java.net.Socket.connect(Socket.java:470)
	at java.net.Socket.<init>(Socket.java:367)
	at java.net.Socket.<init>(Socket.java:209)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
	... 27 more
Root Cause:
com.mysql.jdbc.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
	at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
	at ca.sqlpower.sql.SPDataSource.createConnection(SPDataSource.java:420)
	at ca.sqlpower.sql.SPDSConnectionFactory.createConnection(SPDSConnectionFactory.java:55)
	at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
	at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840)
	at ca.sqlpower.architect.SQLDatabase.getConnection(SQLDatabase.java:557)
	at ca.sqlpower.architect.SQLDatabase.populate(SQLDatabase.java:112)
	at ca.sqlpower.architect.SQLObject.getChildCount(SQLObject.java:212)
	at ca.sqlpower.architect.swingui.DBTreeModel.getChildCount(DBTreeModel.java:146)
	at javax.swing.plaf.basic.BasicTreeUI.paintExpandControl(BasicTreeUI.java:1365)
	at javax.swing.plaf.basic.BasicTreeUI.paint(BasicTreeUI.java:1192)
	at javax.swing.plaf.ComponentUI.update(ComponentUI.java:154)
	at javax.swing.JComponent.paintComponent(JComponent.java:743)
	at javax.swing.JComponent.paint(JComponent.java:1006)
	at javax.swing.JComponent._paintImmediately(JComponent.java:4890)
	at javax.swing.JComponent.paintImmediately(JComponent.java:4676)
	at javax.swing.RepaintManager.paintDirtyRegions(RepaintManager.java:477)
	at javax.swing.SystemEventQueueUtilities$ComponentWorkRequest.run(SystemEventQueueUtilities.java:114)
	at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
	at java.awt.EventQueue.dispatchEvent(EventQueue.java:461)
	at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:269)
	at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:190)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:184)
	at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:176)
	at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Caused by: java.net.ConnectException: Connection refused
	at java.net.PlainSocketImpl.socketConnect(Native Method)
	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:430)
	at java.net.Socket.connect(Socket.java:520)
	at java.net.Socket.connect(Socket.java:470)
	at java.net.Socket.<init>(Socket.java:367)
	at java.net.Socket.<init>(Socket.java:209)
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
	... 27 more

Hi!

It looks like your MySQL is not accepting connections on the TCP port you're trying to connect on. The default port for MySQL is 3306.

You could try this from a terminal window to test that MySQL is accepting connections. Assuming the database is on the local machine, the command to try would be telnet localhost 3306.

Here's what a failure would look like:

$ telnet localhost 3306
Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
telnet: connect to address 127.0.0.1: Connection refused
telnet: Unable to connect to remote host

Here's what success looks like:

$ telnet localhost 3306
Trying ::1...
Connected to localhost.
Escape character is '^]'.
4
5.0.459Ay`Uf%~,q:j,7nGW_Vs`Connection closed by foreign host.

If you get the latter result, then there's probably something wrong with the connection config within the Architect. If you get the former, then you need to tell MySQL to accept connections from localhost on port 3306.

-Jonathan

Awesome, thanks Jonathan!

You were right about TCP port. I went into /etc/my.cnf and removed the "skip-networking" option. Works great now.

BTW, thanks for adding the PDF Export I requested a while back! Product looks really promising!

I had a similar problem while trying to import sql using ant's sql task. First I figured out to add -verbose to ant's command line. Then I got these exceptions. Then I found this forum post and I can't express how much I'm grateful for the solution. Indeed I use xampp and its security script asks to disable networking. At the time when I answered 'yes - disable' I had no idea I will not be able to connect from Java from localhost via tcp.
Interestingly I have suspected the culprit - connection refused/access denied. So I tried to connect from the ssh and it worked. Thank you for the telnet hint.

Glad we were able to help, geniot! Thanks for taking the time to let us know.

-Jonathan