Teiid install
esuey Sep 25, 2012 10:25 AMI'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