Can't Connect with Remote MySQL Server

Hello all,

I new in VP and can’t connect with my remote MySQL server

My captured screen of connection (password show in **** for security):
http://www.cursosenelmundo.com/capturedCONNECTION_MySQL.jpg

My log:

Test adapter connection failed!
v.yys: Connection timeout!
at v.bgz.i(:62)
at v.iteg.i(:126)
at v.hqd.F(:858)
at v.hqd.d(:32)
at v.shx.actionPerformed(:365)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at v.irqs.show(:427)
at v.iqok.y(:735)
at v.iqok.show(:745)
at v.icba.i(:54)
at v.icza.i(:97)
at v.erd.i(:61)
at v.ptt.b(:1656)
at v.ivej.i(:2897)
at v.ifhg.r(:154)
at v.uvj.actionPerformed(:63)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Thanks,

Fernando
Brazil

Hi racetech,

Please make sure all your database settings have been entered correctly. I suggest you verify it by using MySQL client.

Secondly, please send me your log file to checking. You can find it from the bin folder of VP Suite installation directory.

Best regards,
Jick

[quote=Jick]Hi racetech,

Please make sure all your database settings have been entered correctly. I suggest you verify it by using MySQL client.

Secondly, please send me your log file to checking. You can find it from the bin folder of VP Suite installation directory.

Best regards,
Jick
[/quote]

Hi Jick, thak you…

My settings ok…

I attach the vp log file…

Best regards,

Fernando
Brazil

[quote=racetech][quote=Jick]Hi racetech,

Please make sure all your database settings have been entered correctly. I suggest you verify it by using MySQL client.

Secondly, please send me your log file to checking. You can find it from the bin folder of VP Suite installation directory.

Best regards,
Jick
[/quote]

Hi Jick, thak you…

My settings ok…

I attach the vp log file…

Best regards,

Fernando
Brazil[/quote]
vp.log

Hi racetech,

The problem may come from firewall, invalid port, accessing restriction and etc. Please use MySQL client to test the connection (PS. please test in the same machine as VPUML, and with the same user)

Best regards,
Jick

[quote=Jick]Hi racetech,

The problem may come from firewall, invalid port, accessing restriction and etc. Please use MySQL client to test the connection (PS. please test in the same machine as VPUML, and with the same user)

Best regards,
Jick[/quote]

Hi Jick, thanks…

Now is Ok, I connect with the hostname without port and the connect successful.

Best regards,

Fernando

That’s great! :smiley: :smiley:

[quote=racetech]Hello all,

I new in VP and can’t connect with my remote MySQL server

My captured screen of connection (password show in **** for security):
http://www.cursosenelmundo.com/capturedCONNECTION_MySQL.jpg

My log:

Test adapter connection failed!
v.yys: Connection timeout!
at v.bgz.i(:62)
at v.iteg.i(:126)
at v.hqd.F(:858)
at v.hqd.d(:32)
at v.shx.actionPerformed(:365)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.Dialog$1.run(Unknown Source)
at java.awt.Dialog$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.Dialog.show(Unknown Source)
at v.irqs.show(:427)
at v.iqok.y(:735)
at v.iqok.show(:745)
at v.icba.i(:54)
at v.icza.i(:97)
at v.erd.i(:61)
at v.ptt.b(:1656)
at v.ivej.i(:2897)
at v.ifhg.r(:154)
at v.uvj.actionPerformed(:63)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.AbstractButton.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI.doClick(Unknown Source)
at com.jidesoft.plaf.vsnet.VsnetMenuItemUI$MouseInputHandler.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)

Thanks,

Fernando
Brazil
[/quote]