4 Replies Latest reply on Sep 25, 2012 1:12 PM by Ramesh Reddy

    Teiid install

    esuey Newbie

      I'm a newbie.   I need help getting Teiid up and going.  Thanks.

       

      0) Downloaded:

      eclipse-java-indigo-SR2-win32.zip

      jboss-as-7.1.1.Final.zip

      teiid_designer-7.8.0.v20120709-1701-H10-Final.zip

      teiid-8.1.0.Final-jboss-dist.zip

      *Note:  running Windows 7 pro

      1) Set JAVA_HOME to “C:\Program Files (x86)\Java\jre6”

      2) I unpacked jboss-as-7.1.1.Final.zip to working directory

      3)  Unpacked teiid-8.1.0.Final-jboss-dist.zip and copied this over existing jboss-as-7.1.1.Final working directory

           3.5)  started Teiid with the following cmd line:  standalone.bat --server-config=standalone-teiid.xml

      4)  I ran add-user.bat and created two users:  an admin user and client user.

      5)  I unpacked eclipse-java-indigo-SR2-win32 and installed the teiid designer.

      6)  Created a connection profile utilizing the sqljdbc4.jar sql driver

      7)  Created a VDB

      8)  *** Trying to create a Teiid Instance***

                      Teiid JDBC Connection Info:

      Host:  localhost

                      Port number:  31000

                      Username:  user created in step 4

                      Teiid Admin Connection Info

                      Port number:  31443

                      Username:  user created in step 4

      The Test Fails stating this:

      “Unable to connect to Admin API using the specified Teiid server properties.  The Teiid server Admin properties could be invalid or the Teiid server may be offline.”

      Also  see this exception:

      “Error establishing socket to host and port: localhost:31443. Reason: Connection refused: connect”

      Stack Trace:

      • org.teiid.adminapi.AdminComponentException: Error establishing socket to host and port: localhost:31443. Reason: Connection refused: connect

                      at org.teiid.adminapi.AdminFactory.createAdmin(AdminFactory.java:164)

                      at org.teiid.adminapi.AdminFactory.createAdmin(AdminFactory.java:149)

                      at org.teiid.adminapi.AdminFactory.createAdmin(AdminFactory.java:120)

                      at org.teiid.designer.runtime.Server.getAdmin(Server.java:186)

                      at org.teiid.designer.runtime.ui.server.ReconnectToServerAction$1.run(ReconnectToServerAction.java:67)

                      at org.eclipse.swt.custom.BusyIndicator.showWhile(BusyIndicator.java:70)

                      at org.teiid.designer.runtime.ui.server.ReconnectToServerAction.run(ReconnectToServerAction.java:60)

                      at org.eclipse.ui.actions.BaseSelectionListenerAction.runWithEvent(BaseSelectionListenerAction.java:168)

                      at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:584)

                      at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:501)

                      at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:411)

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

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

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

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

                      at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)

                      at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)

                      at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)

                      at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)

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

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

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

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

                      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:344)

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

                      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:622)

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

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

      Caused by: org.teiid.net.socket.SingleInstanceCommunicationException: Error establishing socket to host and port: localhost:31443. Reason: Connection refused: connect

                      at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:162)

                      at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:96)

                      at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:311)

                      at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:65)

                      at org.teiid.adminapi.AdminFactory$AdminProxy.<init>(AdminFactory.java:53)

                      at org.teiid.adminapi.AdminFactory.createAdmin(AdminFactory.java:159)

                      ... 34 more

      Caused by: java.net.ConnectException: Connection refused: connect

                      at java.net.PlainSocketImpl.socketConnect(Native Method)

                      at java.net.PlainSocketImpl.doConnect(Unknown Source)

                      at java.net.PlainSocketImpl.connectToAddress(Unknown Source)

                      at java.net.PlainSocketImpl.connect(Unknown Source)

                      at java.net.SocksSocketImpl.connect(Unknown Source)

                      at java.net.Socket.connect(Unknown Source)

                      at java.net.Socket.connect(Unknown Source)

                      at org.teiid.net.socket.OioOjbectChannelFactory.createObjectChannel(OioOjbectChannelFactory.java:176)

                      at org.teiid.net.socket.SocketServerInstanceImpl.connect(SocketServerInstanceImpl.java:94)

                      at org.teiid.net.socket.SocketServerConnectionFactory.getServerInstance(SocketServerConnectionFactory.java:270)

                      at org.teiid.net.socket.SocketServerConnection.connect(SocketServerConnection.java:200)

                      at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:126)

                      ... 39 more

        • 1. Re: Teiid install
          Ramesh Reddy Master

          esuey,

           

          Welcome to Teiid. We really appreciate your interest in Teiid project.

           

          You have done all the steps correctly. However the Teiid Designer 7.8 is not compatible with the Teiid 8.1, thus you are seeing the above issues. Teiid Designer tean is soon to release a version that works with Teiid 8.x.  Until then you can design the VDBs in the Teiid Designer, but you will not ab able to preview or execute from it. However once you have the VDB, you can deploy into any Teiid server and using tools like SquirreL and issue commands against it.

           

          Also, you can take look at Dynamic VDBs, these are simple XML file way of defining the your virtual database by using DDL. No tooling is involved. Take look at Quick start guide and examples in the downloaded deployment zip.

           

          Thanks

           

          Ramesh..

          • 2. Re: Teiid install
            esuey Newbie

            Thanks Ramesh! 

            • 3. Re: Teiid install
              esuey Newbie

              Where can I download prior versions of Teiid < 8.1 ?

              • 4. Re: Teiid install
                Ramesh Reddy Master

                See here http://sourceforge.net/projects/teiid/files/

                 

                 

                Also, except for Teiid Designer 7.8 (which works with Teiid 7.7), each version of Teiid has same version denoting the Designer. So, if you are going download prior version use Teiid 7.7 and Designer 7.8.

                 

                Note Teiid 7.7 works with JBoss AS 5.10-Final *not* AS7.

                 

                Ramesh..