Mysql Datasource Issue

Hi all,

i'm getting an issue from with intellij idea 9.0.2 (and 9.0.3) as well, where a previously definied project datasource will not connect to the mysql database to get table, column updates.

The error i get is

java.rmi.ConnectException: Connection refused to host: 192.168.0.3; nested exception is:
    java.net.ConnectException: Connection timed out: connect
    at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:601)
    at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:198)
    at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:184)
    at sun.rmi.server.UnicastRef.newCall(UnicastRef.java:322)
    at sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source)
Caused by: java.net.ConnectException: Connection timed out: connect
    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:366)
    at java.net.Socket.connect(Socket.java:525)
    at java.net.Socket.connect(Socket.java:475)
    at java.net.Socket.<init>(Socket.java:372)
    at java.net.Socket.<init>(Socket.java:186)
    at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(RMIDirectSocketFactory.java:22)
    at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(RMIMasterSocketFactory.java:128)
    at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:595)
    ... 28 more

The settings are correct, as the datastore previously functioned perfectly and the underlying database has not changed. I can't pinpoint exactly when it stopped (i.e was it when i updated idea, etc ??? no idea)
I've also tried removing and readding the datastore, which fails when trying to test the connection.

I'm running the following
idea 9.0.3
mysql 5.1
mysql connector 5.1.12 (have also tried version 5.0.8 and 5.0.4)
windows 7 64bit with ip v6 enabled

I've tried disabiling the windows firewall, playing with network settings, etc but to no evail.... mysql is definitely listening locally on port 3306 and i've tried connecting to localhost, the pc's actual ip and 127.0.0.1 address...

Any ideas would be appreciated as this is becoming frustrating.

Crash

1 comment
Comment actions Permalink

Hello Damian,

The problem is not in drivers or anything else except that IDEA for some unclear reason
cannot communicate with a helper process hosting an RMI registry.
This process is used for all mysql-related activities.
Please ensure with the help of your favorite process/TCP manager that a java process is started
by IDEA and listens/reachable on specific port for RMI requests on any mysql-related request from the IDE.

HTH,
Gregory Shrago



On 08.08.2010 9:11, Damian wrote:

Hi all,

>

i'm getting an issue from with intellij idea 9.0.2 (and 9.0.3) as well, where a previously definied project datasource will not connect to the mysql database to get table, column updates.

>

The error i get is

>

java.rmi.ConnectException: Connection refused to host: 192.168.0.3; nested exception is:
     java.net.ConnectException: Connection timed out: connect
     at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:601)
     at sun.rmi.transport.tcp.TCPChannel.createConnection(TCPChannel.java:198)
     at sun.rmi.transport.tcp.TCPChannel.newConnection(TCPChannel.java:184)
     at sun.rmi.server.UnicastRef.newCall(UnicastRef.java:322)
     at sun.rmi.registry.RegistryImpl_Stub.lookup(Unknown Source)
Caused by: java.net.ConnectException: Connection timed out: connect
     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:366)
     at java.net.Socket.connect(Socket.java:525)
     at java.net.Socket.connect(Socket.java:475)
     at java.net.Socket.<init>(Socket.java:372)
     at java.net.Socket.<init>(Socket.java:186)
     at sun.rmi.transport.proxy.RMIDirectSocketFactory.createSocket(RMIDirectSocketFactory.java:22)
     at sun.rmi.transport.proxy.RMIMasterSocketFactory.createSocket(RMIMasterSocketFactory.java:128)
     at sun.rmi.transport.tcp.TCPEndpoint.newSocket(TCPEndpoint.java:595)
     ... 28 more

>

The settings are correct, as the datastore previously functioned perfectly and the underlying database has not changed. I can't pinpoint exactly when it stopped (i.e was it when i updated idea, etc ??? no idea)
I've also tried removing and readding the datastore, which fails when trying to test the connection.

>

I'm running the following
idea 9.0.3
mysql 5.1
mysql connector 5.1.12 (have also tried version 5.0.8 and 5.0.4)
windows 7 64bit with ip v6 enabled

>

I've tried disabiling the windows firewall, playing with network settings, etc but to no evail.... mysql is definitely listening locally on port 3306 and i've tried connecting to localhost, the pc's actual ip and 127.0.0.1 address...

>

Any ideas would be appreciated as this is becoming frustrating.

>

Crash

>

---
Original message URL: http://devnet.jetbrains.net/message/5269633#5269633


0

Please sign in to leave a comment.