http://www.sqlpower.ca/forum/posts/list/2.page JForum - http://www.jforum.net
[code]
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
[/code]]]> http://www.sqlpower.ca/forum/posts/preList/1841/2491.page http://www.sqlpower.ca/forum/posts/preList/1841/2491.page GMT
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]]> http://www.sqlpower.ca/forum/posts/preList/1841/2494.page http://www.sqlpower.ca/forum/posts/preList/1841/2494.page GMT
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!]]> http://www.sqlpower.ca/forum/posts/preList/1841/2496.page http://www.sqlpower.ca/forum/posts/preList/1841/2496.page GMT 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.]]> http://www.sqlpower.ca/forum/posts/preList/1841/2723.page http://www.sqlpower.ca/forum/posts/preList/1841/2723.page GMT
-Jonathan]]> http://www.sqlpower.ca/forum/posts/preList/1841/2725.page http://www.sqlpower.ca/forum/posts/preList/1841/2725.page GMT