Remote connection to Teiid Server fails

[simple_love]

When I try to connect to the the VDB remotely using the Java code, it fails with the below error.  I could able to connect locally using localhost, but it fails remotely.

     SEVERE: Could not create connection

org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: 10.103.240.208:31000. Reason: Connection refused: connect

     The java used is :

private static final String JDBC_URL = "jdbc:teiid:Book@mm://10.103.240.208:31000;version=1";

  public Connection getDriverConnection() throws Exception{

  Class.forName("org.teiid.jdbc.TeiidDriver");

  return DriverManager.getConnection(VDBtest.JDBC_URL,"user","user");

  }

The standalone.xml of server is :

<interfaces>

        <interface name="management">

            <inet-address value="${jboss.bind.address.management:10.103.240.208}"/>

        </interface>

        <interface name="public">

            <inet-address value="${jboss.bind.address:10.103.240.208}"/>

        </interface>

        <interface name="unsecure">

            <inet-address value="${jboss.bind.address.unsecure:10.103.240.208}"/>

        </interface>

    </interfaces>

[shawkins]

Make sure that there isn't a general networking issue, such as something blocking that port when not accessed over localhost.

[rareddy]

Did you start the JBoss EAP with "-b" option, for example

./standalone.sh -b 10.103.240.208

[simple_love]

thans for you help.I run the server in the Windows, so I have't tried ./standalone -b 10.103.240.208 . but I have used run.bat -b 10.103.240.208, and it's still have the problem.Can I slove this problem by configured the standalone.xml?

[simple_love]

thanks you very much! I try to open the port 31000. but I can't confirm I whether open the port 31000.BTW , my OS is windows7.

[jason.marley]

To test you can run from the command line and look for <ip>:31000.

netstat -a

You can all also test externally via

nc -v -z -w2 <ip-address> 31000

Likewise you can run nmap externally as well

nmap –sS -p 31000 <ip-address>

[rareddy]

You can do following in the standalone.xml (or standalone-teiid.xml) if you do not want to do the "-b" option. You need to start with "standalone.bat" file.

    <interfaces>
        <interface name="management">
            <inet-address value="${jboss.bind.address.management:10.103.240.208}"/>
        </interface>
        <interface name="public">
            <inet-address value="${jboss.bind.address:10.103.240.208}"/>
        </interface>
        <interface name="unsecure">
            <inet-address value="${jboss.bind.address.unsecure:10.103.240.208}"/>
        </interface>
    </interfaces>

If you are trying access from remote client, then you need to open the port 31000 in your computer's firewall settings where Teiid Server is running.

[simple_love]

thanks for you patient.I have tried to configured standalone.xml in this way, can I just start server in eclipse rather than start with "standalone.bat".because when I start with "standalone.bat" there are a error and I can't start the server.

[van.halbert]

What version of Teiid and EAP are you using?   Also, when you installed EAP, do you have spaces in the path or have special characters (i.e,. [86]))? 

[simple_love]

I try to open port 31000, and according to the method in the google, I still can't open port 31000.

[rareddy]

I can't read that, and you need to be a administrator of the machine to change it.

Seem like these are relevant URLs

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0CCUQFjAB&url=http%3A%2F%2Fwww.dummie…

https://www.youtube.com/watch?v=JyifH_rfs8U

Ramesh..

[simple_love]

when I start with standalone.bat , I have a error: and the version of teiid is 9.0.0.final, and the eap is 6.1, thanks again!

[simple_love]

hello Ramesh, I have open the port 31000 according to VCR in the youtobe.

And the configuration of standalone.xml is ,and I start standalone.bat successfully , but it still have the same problem.

1. <interfaces> 
2.         <interface name="management"> 
3.             <inet-address value="${jboss.bind.address.management:10.103.240.208}"/> 
4.         </interface> 
5.         <interface name="public"> 
6.             <inet-address value="${jboss.bind.address:10.103.240.208}"/> 
7.         </interface> 
8.         <interface name="unsecure"> 
9.             <inet-address value="${jboss.bind.address.unsecure:10.103.240.208}"/> 
10.         </interface> 
11.     </interfaces>

[van.halbert]

I would recommend that you change to using EAP 6.3.    You will probably have issues with administrative functions if trying to use Teiid 9 with EAP 6.1.  There were api changes in the jboss-controller that required changes in Teiid 8.7 +  in order for it to support EAP 6.3.

[shawkins]

Just to double check, what version of the Teiid runtime do you have installed?  There is no Teiid version 9 yet.  Perhaps you are looking at the Teiid Designer version instead.