Client Server Jboss Datavirt with Teiid : no connexion to Teiid instance from Eclipse

[vince_fr]

Hi,

Having experience on data processing and warehousing as well as *nix environments, I'm quite new on Jboss Datavirt.

I deployed a Jboss ecosystem on a Centos Server.

Running in standalone. Almost fine except teiid jdbc and odbc services that can't start because of bad /etc/hosts file (can't fix it now coz not sudo).

Will fix that later.

This server is setup to allow connexions from any ipv4. Usual ports. No iptables.

Then on my client, I set up a Jboss Dev Studio.

Connected to my server : works fine. I can start or stop the server from the Jboss Dev Studio.

Installed Teiid plugins (8.4.1 in order to be inline with the server) : ok.

BUT, when trying to setup Teiid instance from the tab, I'm unable to establish a connexion to the server.

AND, shortly after starting the server from Jboss Dev Studio, I'm prompted with "Teiid instancde for the server failed to initialiwze".

Please find a pic showing the issue.

Also please find the interface section for my standalone.xml file.

Ps . user=user in teiid-security-users.properties has been uncommented.

Ps . Ports 9999 and 31000 are cleared and responded as "listening" while scanning from my workstation.

Many thanks for your recommendations.

Vincent

    <interfaces>

        <interface name="management">

            <any-ipv4-address/>

        </interface>

        <interface name="public">

            <any-ipv4-address/>

        </interface>

        <interface name="unsecure">

            <any-ipv4-address/>

        </interface>

    </interfaces>

    <socket-binding-group name="standard-sockets" default-interface="public" port-offset="${jboss.socket.binding.port-offset:0}">

        <socket-binding name="management-native" interface="management" port="${jboss.management.native.port:9999}"/>

        <socket-binding name="management-http" interface="management" port="${jboss.management.http.port:9990}"/>

        <socket-binding name="management-https" interface="management" port="${jboss.management.https.port:9443}"/>

        <socket-binding name="ajp" port="8009"/>

        <socket-binding name="http" port="8080"/>

        <socket-binding name="https" port="8443"/>

        <socket-binding name="remoting" port="4447"/>

        <socket-binding name="txn-recovery-environment" port="4712"/>

        <socket-binding name="txn-status-manager" port="4713"/>

        <socket-binding name="teiid-jdbc" port="31000"/>

        <socket-binding name="teiid-odbc" port="35432"/>

        <outbound-socket-binding name="mail-smtp">

            <remote-destination host="localhost" port="25"/>

        </outbound-socket-binding>

    </socket-binding-group>

[rareddy]

Vincent,

I was following along until you said

"Installed Teiid plugins (8.4.1 in order to be inline with the server) : ok."

How did you install that? Typically after installing JBDS, in the very first screen that shows JBoss Developer Central, it has another tab called "updates", you need to switch to that and install "Data Virtualization" packages, and that will install the necessary libraries. Once it is done, there should be a "Teiid Designer Perspective" available to work with Data Virtualization.

My suggestion is remove your current JBDS and reinstall and follow directions from above.

Ramesh..

[vince_fr]

Hi Ramesh,

Many thanks for your answer.

I installed the Teiid Eclipse Plugins by adding "Teiid Designer - http://download.jboss.org/jbosstools/updates/release/kepler/integration-stack/teiiddesigner/8.4.1.Final/" in the install software features and then click all and install.

[vince_fr]

By the way, I did what you recommended to me : reinstall the Teiid plugins by using the "update" feature from JBDS.

Installed fine.

Creating a server is fine. Can start/stop it.

But still issue with Teiid (plugin=org.teiid.designer.dqp).

Seems related with port 9999.

Also having a prompt to re enter the Jboss server credential (are we really speaking about jboss admin server credentials btw ?).

Here is the dump that pops into my JBDS :

org.jboss.ide.eclipse.as.management.core.JBoss7ManangerException: java.io.IOException: java.net.ConnectException: JBAS012144: Could not connect to remote://10.10.192.13:9999. The connection timed out

  at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:336)

  at org.jboss.ide.eclipse.as.internal.management.as71.JBoss71ManagerService.execute(JBoss71ManagerService.java:171)

  at org.jboss.ide.eclipse.as.management.core.JBoss7ManagerServiceProxy.execute(JBoss7ManagerServiceProxy.java:87)

  at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.executeRequest(JBoss7ServerUtil.java:66)

  at org.teiid.designer.runtime.adapter.JBoss7ServerUtil.getTeiidRuntimeVersion(JBoss7ServerUtil.java:250)

  at org.teiid.designer.runtime.adapter.TeiidServerAdapterFactory.getTeiidRuntimeVersion(TeiidServerAdapterFactory.java:298)

  at org.teiid.designer.runtime.TeiidServer.connect(TeiidServer.java:200)

  at org.teiid.designer.runtime.TeiidServer.testPing(TeiidServer.java:437)

  at org.teiid.designer.runtime.ui.server.editor.TeiidServerEditor$7.linkActivated(TeiidServerEditor.java:470)

  at org.eclipse.ui.forms.widgets.AbstractHyperlink.handleActivate(AbstractHyperlink.java:233)

  at org.eclipse.ui.forms.widgets.AbstractHyperlink.handleMouseUp(AbstractHyperlink.java:327)

  at org.eclipse.ui.forms.widgets.AbstractHyperlink.access$2(AbstractHyperlink.java:311)

  at org.eclipse.ui.forms.widgets.AbstractHyperlink$4.handleEvent(AbstractHyperlink.java:125)

  at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)

  at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1057)

  at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4170)

  at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3759)

  at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(PartRenderingEngine.java:1113)

  at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

  at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:997)

  at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:140)

  at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:611)

  at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

  at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:567)

  at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)

  at org.eclipse.ui.internal.ide.application.IDEApplication.start(IDEApplication.java:124)

  at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

  at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

  at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

  at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:354)

  at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:181)

  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

  at java.lang.reflect.Method.invoke(Unknown Source)

  at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:636)

  at org.eclipse.equinox.launcher.Main.basicRun(Main.java:591)

  at org.eclipse.equinox.launcher.Main.run(Main.java:1450)

  at org.eclipse.equinox.launcher.Main.main(Main.java:1426)

Caused by: java.io.IOException: java.net.ConnectException: JBAS012144: Could not connect to remote://10.10.192.13:9999. The connection timed out

  at org.jboss.as.controller.client.impl.AbstractModelControllerClient.executeForResult(AbstractModelControllerClient.java:129)

  at org.jboss.as.controller.client.impl.AbstractModelControllerClient.execute(AbstractModelControllerClient.java:71)

  at org.jboss.ide.eclipse.as.internal.management.as71.AS71Manager.execute(AS71Manager.java:325)

  ... 38 more

Caused by: java.net.ConnectException: JBAS012144: Could not connect to remote://10.10.192.13:9999. The connection timed out

  at org.jboss.as.protocol.ProtocolConnectionUtils.connectSync(ProtocolConnectionUtils.java:131)

  at org.jboss.as.protocol.ProtocolConnectionManager$EstablishingConnection.connect(ProtocolConnectionManager.java:256)

  at org.jboss.as.protocol.ProtocolConnectionManager.connect(ProtocolConnectionManager.java:70)

  at org.jboss.as.protocol.mgmt.FutureManagementChannel$Establishing.getChannel(FutureManagementChannel.java:176)

  at org.jboss.as.controller.client.impl.RemotingModelControllerClient.getOrCreateChannel(RemotingModelControllerClient.java:144)

  at org.jboss.as.controller.client.impl.RemotingModelControllerClient$1.getChannel(RemotingModelControllerClient.java:65)

  at org.jboss.as.protocol.mgmt.ManagementChannelHandler.executeRequest(ManagementChannelHandler.java:115)

  at org.jboss.as.protocol.mgmt.ManagementChannelHandler.executeRequest(ManagementChannelHandler.java:98)

  at org.jboss.as.controller.client.impl.AbstractModelControllerClient.executeRequest(AbstractModelControllerClient.java:236)

  at org.jboss.as.controller.client.impl.AbstractModelControllerClient.execute(AbstractModelControllerClient.java:141)

  at org.jboss.as.controller.client.impl.AbstractModelControllerClient.executeForResult(AbstractModelControllerClient.java:127)

  ... 40 more

[vince_fr]

Started from a clean JBDS setup.

Can interface with my server with SSH profile.

Created server and can interact (start/stop).

But when trying more interactions, I receive this issue in JBDS :

Regarding security credentials, I'm using the ones I setup during the EAP server setup.

Another thing I cannot explain is this, below.

My ports are opened, not blocked (no iptable, no fw).

Extract of my standalone.xml :

    <interfaces>

        <interface name="management">

            <any-ipv4-address/>

        </interface>

        <interface name="public">

            <any-ipv4-address/>

        </interface>

        <interface name="unsecure">

            <any-ipv4-address/>

        </interface>

    </interfaces>

    <socket-binding-group name="standard-sockets" default-interface="public" port-offset="${jboss.socket.binding.port-offset:0}">

        <socket-binding name="management-native" interface="management" port="${jboss.management.native.port:9999}"/>

        <socket-binding name="management-http" interface="management" port="${jboss.management.http.port:9990}"/>

        <socket-binding name="management-https" interface="management" port="${jboss.management.https.port:9443}"/>

        <socket-binding name="ajp" port="8009"/>

        <socket-binding name="http" port="8080"/>

        <socket-binding name="https" port="8443"/>

        <socket-binding name="remoting" port="4447"/>

        <socket-binding name="txn-recovery-environment" port="4712"/>

        <socket-binding name="txn-status-manager" port="4713"/>

        <socket-binding name="teiid-jdbc" port="31000"/>

        <socket-binding name="teiid-odbc" port="35432"/>

        <outbound-socket-binding name="mail-smtp">

            <remote-destination host="localhost" port="25"/>

        </outbound-socket-binding>

    </socket-binding-group>

Any help is welcome since I'm kind of stuck here ...

Thanks

Vincent

[rareddy]

Vincent,

1) By default server will not bind ports on IP 10.10.192.13, it does on loopback which is 127.0.0.1. In order to server to start on the IP you want you can start the server by supplying "-b" option. Also, there is no requirement to start the server from the JBDS. So, open a terminal on server execute

cd <jboss-eap-6.1/bin>
./standalone.xml -b 10.10.192.13 

That will start the server. Now create a "datavirt" user using below command, choose "ManagementRelam"

./add-user.sh

Now on JDBS machine, click on the "Server View" (if do not already see it, Window->Show View->Server), and configure a server instance and set to to manage externally and click start. You should see connect, you have to supply above credentials.

Then you can go about Data Virtulization related activities.

Ramesh..

[vince_fr]

Ramesh,

Thanks again for your time and help.

I'm puzzled.

I did what you recommended to me but still stuck with the same issue from plugin = org.teiid.designer.dqp

I can provide all other information you d need to help me investigate this issue of course.

Enclosed : my standalone.xml, located on my remote server.

[rareddy]

Vincent,

Do you have any firewall on the remote server? if yes please open up ports 31000 and 9999, 9990. The first one is used by Teiid for JDBC/ODBC access and other two are for admin ports. Make be use telnet to make sure you have the access.

Ramesh..

[vince_fr]

Hi Ramesh,

Local iptables on server are stopped.

And firewall is allowing all the necessary ports.

Checked by scanning the ports from my PC and showed "listening".

That's why I'm puzzled.

Should I investigate more about the network / security ?

Vincent

[rareddy]

Vincent,

Have tried with telnet to ping as I suggested to see if you can invoke on the port?

Basically there are couple issues in running in a remote server, binding on the right ip (you can also use -b 0.0.0.0 to bind on all interfaces), then having access to the machine externally (checking reach ability and firewall on specific ports) that it.

In the <jboss-eap-6.1>/bin directory there is console app called "jboss-cli.sh" which is management app, you can use to connect to the server to make sure it is running. It makes similar kind of connection request that JBDS is making. You can try that locally to the server first to make sure server is up and running.

Ramesh..

[vince_fr]

Hi Ramesh

First, thanks for your help. Really appreciated.

All the firewall stuff has been checked :  port 9999 is reachable."

But I still can't connect to Teiid : testing the administration connection and the jdbc connection, with JBDS, fails (Unable to establish connection to server "mm://10.10.192.13:9999::admin").

I'm puzzled.

Here are some more infos for you, in case of a new suggestion.

- My Teiid-security-users.properties is having user=user not commented. I'm using these credentials in the Teiiid configuration page from JBDS.

- The Teiid configuration page from JBDS (screenshot)

- The JBoss startup log (showing the interfaces are listening on 0.0.0.0:9999)

- The Server overview page from JBDS (in the managenent login credentials, I'm using the credentials previously created with ./add-user.sh   as you suggested in a previous post)

[vince_fr]

BTW, telnet on ports 9999 and others is OK.

And using jboss-cli.sh locally is OK.

And starting jboss with -b 0.0.0.0 is OK.

[vince_fr]

Well after hours and days on that issue, I have to start thinking about giving up.

Having my client asking me to give better consideration to Denodo (it has a price, yes ...), I'm still not fan of the idea to abandon redhat/jboss.

Still the same issue : java.io.IOException: java.net.ConnectException: JBAS012144: Could not connect to remote://my_hostname:9999. The connection timed out

My server is :  JBoss EAP 6.1.1.GA  on CENTOS with Teiid = Teiid Engine 8.4.1-redhat-7

I tried all Teiid plugin version on my JBDS (with fresh install between each try)

My OS has a good resolv.conf and gives answer with localhost, 127.0.0.1 and its own ip (10.10.192.13)

Firewall(s), both OS based and devices are ok and allow all traffic on the specific Datavirt ports (the ones from the standalone.xml).

My standalone.xml allows "any-address" in the interfaces.

Credentials are ok. I'm using the ones I created with add user

The  JBoss EAP 6.1.1.GA is running and I can connect to it with the local jboss-cli.sh

Ex :

./jboss-cli.sh

You are disconnected at the moment. Type 'connect' to connect to the server or 'help' for the list of supported commands.

[disconnected /] connect

[standalone@localhost:9999 /]

I didn't find any real client-server deployement how to / tuto / method etc ... on the web.

So I'm wondering : Is there anyone using JBOSS/Datavirt/Teiid in a real client server mode for a real project ??

Thx

Vincent

[rareddy]

Vincent,

By default JBoss management port is only open on 127.0.0.1 for security purposes, that may be causing the issue in your case. In the standalone.xml try

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

Also, in your jboss-cli example, when you do "--connect" it is connecting to a local jboss-eap, that means you have one running locally and one remote. For testing, please shutdown the local and try connecting with

./jboss-cli.sh

connect 10.10.192.13:9999

If that succeeds then your communications between client and server are OK. Then proceed to JBDS.

Yes, DV has many customers and community users use in client/server fashion. If you have Redhat support agreement, then they can also help you narrow the issue, with community support we are trying our best to get you going based on information you are providing.

Ramesh..

[rareddy]

BTW, you can also set above to

<inet-address value="0.0.0.0"/>

to bind on any address

Ramesh..