2 Replies Latest reply on Jan 27, 2015 10:19 PM by kisienya

    Teiid localhost:31000 connection errror

    kisienya
    kisienya Jan 26, 2015 11:31 PM

      Hi I get the following error on Error log when I start up Teiid.

       

      Where could the problem be?

       

      eclipse.buildId=4.3.2.M20140221-1700

      java.version=1.7.0_71

      java.vendor=Oracle Corporation

      BootLoader constants: OS=win32, ARCH=x86_64, WS=win32, NL=en_AU

      Framework arguments:  -product org.eclipse.epp.package.jee.product

      Command-line arguments:  -os win32 -ws win32 -arch x86_64 -product org.eclipse.epp.package.jee.product

       

      Error

      Fri Jan 23 20:12:29 EST 2015

      The teiid driver failed to connect to jdbc:teiid:PREVIEW_d4b5e694-7a15-4f57-bdbb-7749c9a1aad3_CDMT_project@mm://localhost:31000 with the given username and password

       

      java.lang.Exception: The teiid driver failed to connect to jdbc:teiid:PREVIEW_d4b5e694-7a15-4f57-bdbb-7749c9a1aad3_CDMT_iCare_to_P5_project@mm://localhost:31000 with the given username and password

          at org.teiid.datatools.connectivity.TeiidJDBCConnection.connect(TeiidJDBCConnection.java:45)

          at org.teiid.datatools.connectivity.TeiidJDBCConnection.createConnection(TeiidJDBCConnection.java:126)

          at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:105)

          at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:54)

          at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)

          at org.teiid.datatools.connectivity.TeiidJDBCConnectionFactory.createConnection(TeiidJDBCConnectionFactory.java:23)

          at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)

          at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)

          at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.getSqlConnection(PreviewDataWorker.java:619)

          at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.internalRun(PreviewDataWorker.java:396)

          at org.teiid.designer.runtime.ui.preview.PreviewDataWorker.run(PreviewDataWorker.java:261)

          at org.teiid.designer.runtime.ui.preview.PreviewTableDataContextAction.run(PreviewTableDataContextAction.java:99)

          at org.eclipse.jface.action.Action.runWithEvent(Action.java:499)

          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$6.handleEvent(ActionContributionItem.java:452)

          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.sql.SQLException: org.teiid.net.ConnectionException: org.teiid.client.security.LogonException: TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.

          at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:49)

          at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:120)

          at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:1)

          at org.teiid.datatools.connectivity.TeiidJDBCConnection.connect(TeiidJDBCConnection.java:41)

          ... 41 more

      Caused by: org.teiid.net.ConnectionException: org.teiid.client.security.LogonException: TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.

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

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

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

          at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:47)

          ... 44 more

      Caused by: org.teiid.client.security.LogonException: TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.

          at org.teiid.transport.LogonImpl.logon(LogonImpl.java:153)

          at org.teiid.transport.LogonImpl.logon(LogonImpl.java:117)

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

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:606)

          at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87)

          at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)

          at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:207)

          at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:193)

          at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:211)

          at org.jboss.netty.channel.SimpleChannelHandler.handleUpstream(SimpleChannelHandler.java:88)

          at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560)

          at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787)

          at org.jboss.netty.handler.stream.ChunkedWriteHandler.handleUpstream(ChunkedWriteHandler.java:142)

          at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560)

          at org.jboss.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:787)

          at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:296)

          at org.jboss.netty.handler.codec.frame.FrameDecoder.unfoldAndFireMessageReceived(FrameDecoder.java:462)

          at org.jboss.netty.handler.codec.frame.FrameDecoder.callDecode(FrameDecoder.java:443)

          at org.jboss.netty.handler.codec.frame.FrameDecoder.messageReceived(FrameDecoder.java:303)

          at org.jboss.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:70)

          at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:560)

          at org.jboss.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:555)

          at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:268)

          at org.jboss.netty.channel.Channels.fireMessageReceived(Channels.java:255)

          at org.jboss.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)

          at org.jboss.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:107)

          at org.jboss.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:312)

          at org.jboss.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:88)

          at org.jboss.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)

          at org.jboss.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)

          at org.jboss.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)

          at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

          at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

          at java.lang.Thread.run(Thread.java:745)

      Caused by: javax.security.auth.login.LoginException: TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.

          at org.teiid.jboss.JBossSessionService.authenticate(JBossSessionService.java:78)

          at org.teiid.services.SessionServiceImpl.createSession(SessionServiceImpl.java:171)

          at org.teiid.transport.LogonImpl.logon(LogonImpl.java:133)

          ... 35 more

        • 1. Re: Teiid localhost:31000 connection errror
          rareddy
          rareddy Jan 27, 2015 11:59 AM (in response to kisienya)

          Morgon,

           

          That means that your Teiid server is not running or the credentials are wrong or not set up yet. Make sure the Teiid server is running, then add a user using the "add-user.sh or add-user.bat" scripts in the "bin" directory of installation. Then in the Designer, in the server view make sure you have the user added. Note there are two different users (management, and JDBC) both need to be created and set in the Designer. If the server is running on the same machine as the Designer, you may not need to management user, but you would still require the JDBC user. Correct all that, then above error goes away.

           

          Ramesh..

            • Actions
          • 2. Re: Teiid localhost:31000 connection errror
            kisienya
            kisienya Jan 27, 2015 10:19 PM (in response to rareddy)

            Thanks Ramesh

              • Actions