1 Reply Latest reply on Aug 28, 2016 11:16 AM by Ramesh Reddy

    teiid: can not connect to teiid

    Tobias Wieprich Newbie

      Hi,

      I want to use a MySQL database for a teiid application.

      So I created a vdb.xml, added the datasource etc.

       

       

      After starting the teiid server the vdb is active but a simple Java progamm or SQuirrl can’t connect to teiid.

       

       

      This is the simple Java programm:

      public class Main {

       

       

        public static void main(String[] args) throws ClassNotFoundException, SQLException {

           String url = "jdbc:teiid:Quickstart@mm://localhost:31000";

           String sql = "select id, label from product";

        

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

        

           Connection connection = null;

           try{

               connection = DriverManager.getConnection(url, "admin", "Password1!!");

               Statement statement = connection.createStatement();

               ResultSet results = statement.executeQuery(sql);

               while(results.next()) {

                 System.out.println(results.getString(1));

                 System.out.println(results.getString(2));

               }

               results.close();

               statement.close();

           } catch (SQLException e){

               e.printStackTrace();

               throw e;

           } finally {

               try{

                 connection.close();

               }catch(SQLException e1){

                 // ignore

               }

           }

        }

       

      this progamm throws following exception:

      Aug 27, 2016 11:38:45 PM org.teiid.jdbc.TeiidDriver connect

      SEVERE: Could not create connection

      org.teiid.jdbc.TeiidSQLException: TEIID50072 The username "admin" and/or password and/or payload token could not be authenticated by security domain teiid-security.

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

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

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

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

        at java.sql.DriverManager.getConnection(DriverManager.java:664)

        at java.sql.DriverManager.getConnection(DriverManager.java:247)

        at Main.main(Main.java:17)

      Caused by: org.teiid.net.ConnectionException: TEIID50072 The username "admin" and/or password and/or payload token could not be authenticated by security domain teiid-security.

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

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

        ... 5 more

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

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

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

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

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

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

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

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

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

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

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

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

        at org.teiid.transport.SSLAwareChannelHandler.channelRead(SSLAwareChannelHandler.java:218)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

        at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

        at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

        at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)

        at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)

        at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)

        at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)

        at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)

        at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)

        at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)

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

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

        at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:116)

        at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:50)

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

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

        ... 27 more

       

       

      org.teiid.jdbc.TeiidSQLException: TEIID50072 The username "admin" and/or password and/or payload token could not be authenticated by security domain teiid-security.

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135)

        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71)

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

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

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

        at java.sql.DriverManager.getConnection(DriverManager.java:664)

        at java.sql.DriverManager.getConnection(DriverManager.java:247)

        at Main.main(Main.java:17)

      Caused by: org.teiid.net.ConnectionException: TEIID50072 The username "admin" and/or password and/or payload token could not be authenticated by security domain teiid-security.

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

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

        ... 5 more

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

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

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

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

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

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

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

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

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

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

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

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

        at org.teiid.transport.SSLAwareChannelHandler.channelRead(SSLAwareChannelHandler.java:218)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

        at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

        at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)

        at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

        at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

        at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)

        at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)

        at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)

        at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)

        at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)

        at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)

        at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)

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

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

        at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:116)

        at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:50)

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

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

        ... 27 more

      Exception in thread "main" java.lang.NullPointerException

        at Main.main(Main.java:31)

       

       

       

       

      this is my mysql-vdb.xml:

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>

      <vdb name="Quickstart" version="1">

       

          <description>A Dynamic VDB</description>

       

          <property name="UseConnectorMetadata" value="true" />

       

          <model name="product">

       

              <property name="importer.useFullSchemaName" value="false"/>

       

              <source name="jdbc-connector" translator-name="mysql" connection-jndi-name="java:/BenchmarkDS"/>

          </model>

        

      </vdb>

       

       

      the standalone-teiid.xml:

      <?xml version='1.0' encoding='UTF-8'?>

       

       

      <server xmlns="urn:jboss:domain:3.0">

       

       

          <extensions>

              <extension module="org.jboss.as.clustering.infinispan"/>

              <extension module="org.jboss.as.connector"/>

              <extension module="org.jboss.as.deployment-scanner"/>

              <extension module="org.jboss.as.ee"/>

              <extension module="org.jboss.as.ejb3"/>

              <extension module="org.jboss.as.jaxrs"/>

              <extension module="org.jboss.as.jdr"/>

              <extension module="org.jboss.as.jmx"/>

              <extension module="org.jboss.as.jpa"/>

              <extension module="org.jboss.as.jsf"/>

              <extension module="org.jboss.as.logging"/>

              <extension module="org.jboss.as.mail"/>

              <extension module="org.jboss.as.naming"/>

              <extension module="org.jboss.as.pojo"/>

              <extension module="org.jboss.as.remoting"/>

              <extension module="org.jboss.as.sar"/>

              <extension module="org.jboss.as.security"/>

              <extension module="org.jboss.teiid"/>

              <extension module="org.jboss.as.transactions"/>

              <extension module="org.jboss.as.webservices"/>

              <extension module="org.jboss.as.weld"/>

              <extension module="org.wildfly.extension.batch"/>

              <extension module="org.wildfly.extension.bean-validation"/>

              <extension module="org.wildfly.extension.io"/>

              <extension module="org.wildfly.extension.request-controller"/>

              <extension module="org.wildfly.extension.security.manager"/>

              <extension module="org.wildfly.extension.undertow"/>

          </extensions>

       

       

       

       

          <management>

              <security-realms>

                  <security-realm name="ManagementRealm">

                      <authentication>

                          <local default-user="$local" skip-group-loading="true"/>

                          <properties path="mgmt-users.properties" relative-to="jboss.server.config.dir"/>

                      </authentication>

                      <authorization map-groups-to-roles="false">

                          <properties path="mgmt-groups.properties" relative-to="jboss.server.config.dir"/>

                      </authorization>

                  </security-realm>

                  <security-realm name="ApplicationRealm">

                      <authentication>

                          <local default-user="$local" allowed-users="*" skip-group-loading="true"/>

                          <properties path="application-users.properties" relative-to="jboss.server.config.dir"/>

                      </authentication>

                      <authorization>

                          <properties path="application-roles.properties" relative-to="jboss.server.config.dir"/>

                      </authorization>

                  </security-realm>

              </security-realms>

              <audit-log>

                  <formatters>

                      <json-formatter name="json-formatter"/>

                  </formatters>

                  <handlers>

                      <file-handler name="file" formatter="json-formatter" path="audit-log.log" relative-to="jboss.server.data.dir"/>

                  </handlers>

                  <logger log-boot="true" log-read-only="false" enabled="false">

                      <handlers>

                          <handler name="file"/>

                      </handlers>

                  </logger>

              </audit-log>

              <management-interfaces>

                  <http-interface security-realm="ManagementRealm" http-upgrade-enabled="true">

                      <socket-binding http="management-http"/>

                  </http-interface>

              </management-interfaces>

              <access-control provider="simple">

                  <role-mapping>

                      <role name="SuperUser">

                          <include>

                              <user name="$local"/>

                          </include>

                      </role>

                      <role name="Administrator">

                          <include>

                              <user name="user"/>

                          </include>

                      </role>

                  </role-mapping>

              </access-control>

          </management>

       

       

          <profile>

              <subsystem xmlns="urn:jboss:domain:logging:3.0">

                  <console-handler name="CONSOLE">

                      <level name="INFO"/>

                      <formatter>

                          <named-formatter name="COLOR-PATTERN"/>

                      </formatter>

                  </console-handler>

                  <periodic-rotating-file-handler name="FILE" autoflush="true">

                      <formatter>

                          <named-formatter name="PATTERN"/>

                      </formatter>

                      <file relative-to="jboss.server.log.dir" path="server.log"/>

                      <suffix value=".yyyy-MM-dd"/>

                      <append value="true"/>

                  </periodic-rotating-file-handler>

                  <logger category="com.arjuna">

                      <level name="WARN"/>

                  </logger>

                  <logger category="org.apache.tomcat.util.modeler">

                      <level name="WARN"/>

                  </logger>

                  <logger category="org.jboss.as.config">

                      <level name="DEBUG"/>

                  </logger>

                  <logger category="sun.rmi">

                      <level name="WARN"/>

                  </logger>

                  <logger category="jacorb">

                      <level name="WARN"/>

                  </logger>

                  <logger category="jacorb.config">

                      <level name="ERROR"/>

                  </logger>

                  <logger category="org.teiid">

                      <level name="INFO"/>

                  </logger>

                  <logger category="org.teiid.COMMAND_LOG">

                      <level name="WARN"/>

                  </logger>

                  <root-logger>

                      <level name="INFO"/>

                      <handlers>

                          <handler name="CONSOLE"/>

                          <handler name="FILE"/>

                      </handlers>

                  </root-logger>

                  <formatter name="PATTERN">

                      <pattern-formatter pattern="%d{yyyy-MM-dd HH:mm:ss,SSS} %-5p [%c] (%t) %X{teiid-session} %s%e%n"/>

                  </formatter>

                  <formatter name="COLOR-PATTERN">

                      <pattern-formatter pattern="%K{level}%d{HH:mm:ss,SSS} %-5p [%c] (%t) %X{teiid-session} %s%e%n"/>

                  </formatter>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:batch:1.0">

                  <job-repository>

                      <in-memory/>

                  </job-repository>

                  <thread-pool>

                      <max-threads count="10"/>

                      <keepalive-time time="30" unit="seconds"/>

                  </thread-pool>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:bean-validation:1.0"/>

              <subsystem xmlns="urn:jboss:domain:datasources:3.0">

                  <datasources>

                      <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">

                          <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1;DB_CLOSE_ON_EXIT=FALSE</connection-url>

                          <driver>h2</driver>

                          <security>

                              <user-name>sa</user-name>

                              <password>sa</password>

                          </security>

                      </datasource>

                      <datasource jndi-name="java:/BenchmarkDS" pool-name="BenchmarkDS" enabled="true" use-java-context="true">

                          <connection-url>jdbc:mysql://localhost:3306/benchmark</connection-url>

                          <driver>mysql</driver>

                          <security>

                              <user-name>root</user-name>

                              <password>password!</password>

                          </security>

                      </datasource>

                      <drivers>

                          <driver name="h2" module="com.h2database.h2">

                              <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                          </driver>

                          <driver name="mysql" module="com.mysql">

                              <driver-class>com.mysql.jdbc.Driver</driver-class>

                          </driver>

                          <driver name="teiid-local" module="org.jboss.teiid">

                              <driver-class>org.teiid.jdbc.TeiidDriver</driver-class>

                              <xa-datasource-class>org.teiid.jdbc.TeiidDataSource</xa-datasource-class>

                          </driver>

                          <driver name="teiid" module="org.jboss.teiid.client">

                              <driver-class>org.teiid.jdbc.TeiidDriver</driver-class>

                              <xa-datasource-class>org.teiid.jdbc.TeiidDataSource</xa-datasource-class>

                          </driver>

                      </drivers>

                  </datasources>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:deployment-scanner:2.0">

                  <deployment-scanner path="deployments" relative-to="jboss.server.base.dir" scan-interval="5000" runtime-failure-causes-rollback="${jboss.deployment.scanner.rollback.on.failure:false}"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:ee:3.0">

                  <spec-descriptor-property-replacement>false</spec-descriptor-property-replacement>

                  <concurrent>

                      <context-services>

                          <context-service name="default" jndi-name="java:jboss/ee/concurrency/context/default" use-transaction-setup-provider="true"/>

                      </context-services>

                      <managed-thread-factories>

                          <managed-thread-factory name="default" jndi-name="java:jboss/ee/concurrency/factory/default" context-service="default"/>

                      </managed-thread-factories>

                      <managed-executor-services>

                          <managed-executor-service name="default" jndi-name="java:jboss/ee/concurrency/executor/default" context-service="default" hung-task-threshold="60000" core-threads="5" max-threads="25" keepalive-time="5000"/>

                      </managed-executor-services>

                      <managed-scheduled-executor-services>

                          <managed-scheduled-executor-service name="default" jndi-name="java:jboss/ee/concurrency/scheduler/default" context-service="default" hung-task-threshold="60000" core-threads="2" keepalive-time="3000"/>

                      </managed-scheduled-executor-services>

                  </concurrent>

                  <default-bindings context-service="java:jboss/ee/concurrency/context/default" datasource="java:jboss/datasources/ExampleDS" managed-executor-service="java:jboss/ee/concurrency/executor/default" managed-scheduled-executor-service="java:jboss/ee/concurrency/scheduler/default" managed-thread-factory="java:jboss/ee/concurrency/factory/default"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:ejb3:3.0">

                  <session-bean>

                      <stateful default-access-timeout="5000" cache-ref="simple" passivation-disabled-cache-ref="simple"/>

                      <singleton default-access-timeout="5000"/>

                  </session-bean>

                  <pools>

                      <bean-instance-pools>

                          <strict-max-pool name="slsb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>

                          <strict-max-pool name="mdb-strict-max-pool" max-pool-size="20" instance-acquisition-timeout="5" instance-acquisition-timeout-unit="MINUTES"/>

                      </bean-instance-pools>

                  </pools>

                  <caches>

                      <cache name="simple"/>

                      <cache name="distributable" passivation-store-ref="infinispan" aliases="passivating clustered"/>

                  </caches>

                  <passivation-stores>

                      <passivation-store name="infinispan" cache-container="ejb" max-size="10000"/>

                  </passivation-stores>

                  <async thread-pool-name="default"/>

                  <timer-service thread-pool-name="default" default-data-store="default-file-store">

                      <data-stores>

                          <file-data-store name="default-file-store" path="timer-service-data" relative-to="jboss.server.data.dir"/>

                      </data-stores>

                  </timer-service>

                  <remote connector-ref="http-remoting-connector" thread-pool-name="default"/>

                  <thread-pools>

                      <thread-pool name="default">

                          <max-threads count="10"/>

                          <keepalive-time time="100" unit="milliseconds"/>

                      </thread-pool>

                  </thread-pools>

                  <default-security-domain value="other"/>

                  <default-missing-method-permissions-deny-access value="true"/>

                  <log-system-exceptions value="true"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:io:1.1">

                  <worker name="default"/>

                  <buffer-pool name="default"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:infinispan:3.0">

                  <cache-container name="server" default-cache="default" module="org.wildfly.clustering.server">

                      <local-cache name="default">

                          <transaction mode="BATCH"/>

                      </local-cache>

                  </cache-container>

                  <cache-container name="web" default-cache="passivation" module="org.wildfly.clustering.web.infinispan">

                      <local-cache name="passivation">

                          <locking isolation="REPEATABLE_READ"/>

                          <transaction mode="BATCH"/>

                          <file-store passivation="true" purge="false"/>

                      </local-cache>

                      <local-cache name="persistent">

                          <locking isolation="REPEATABLE_READ"/>

                          <transaction mode="BATCH"/>

                          <file-store passivation="false" purge="false"/>

                      </local-cache>

                  </cache-container>

                  <cache-container name="ejb" default-cache="passivation" module="org.wildfly.clustering.ejb.infinispan" aliases="sfsb">

                      <local-cache name="passivation">

                          <locking isolation="REPEATABLE_READ"/>

                          <transaction mode="BATCH"/>

                          <file-store passivation="true" purge="false"/>

                      </local-cache>

                      <local-cache name="persistent">

                          <locking isolation="REPEATABLE_READ"/>

                          <transaction mode="BATCH"/>

                          <file-store passivation="false" purge="false"/>

                      </local-cache>

                  </cache-container>

                  <cache-container name="hibernate" default-cache="local-query" module="org.hibernate.infinispan">

                      <local-cache name="local-query">

                          <eviction strategy="LRU" max-entries="10000"/>

                          <expiration max-idle="100000"/>

                      </local-cache>

                      <local-cache name="entity">

                          <transaction mode="NON_XA"/>

                          <eviction strategy="LRU" max-entries="10000"/>

                          <expiration max-idle="100000"/>

                      </local-cache>

                      <local-cache name="timestamps"/>

                  </cache-container>

                  <cache-container name="teiid" default-cache="resultset">

                      <local-cache name="resultset">

                          <transaction mode="NON_XA"/>

                          <eviction strategy="LIRS" max-entries="1024"/>

                          <expiration lifespan="7200000"/>

                      </local-cache>

                      <local-cache name="resultset-repl">

                          <transaction mode="NON_XA"/>

                          <eviction strategy="LIRS" max-entries="1024"/>

                          <expiration lifespan="7200000"/>

                      </local-cache>

                      <local-cache name="preparedplan">

                          <eviction strategy="LIRS" max-entries="512"/>

                          <expiration lifespan="28800"/>

                      </local-cache>

                  </cache-container>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:jaxrs:1.0"/>

              <subsystem xmlns="urn:jboss:domain:jca:3.0">

                  <archive-validation enabled="true" fail-on-error="true" fail-on-warn="false"/>

                  <bean-validation enabled="true"/>

                  <default-workmanager>

                      <short-running-threads>

                          <core-threads count="50"/>

                          <queue-length count="50"/>

                          <max-threads count="50"/>

                          <keepalive-time time="10" unit="seconds"/>

                      </short-running-threads>

                      <long-running-threads>

                          <core-threads count="50"/>

                          <queue-length count="50"/>

                          <max-threads count="50"/>

                          <keepalive-time time="10" unit="seconds"/>

                      </long-running-threads>

                  </default-workmanager>

                  <cached-connection-manager/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:jdr:1.0"/>

              <subsystem xmlns="urn:jboss:domain:jmx:1.3">

                  <expose-resolved-model/>

                  <expose-expression-model/>

                  <remoting-connector/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:jpa:1.1">

                  <jpa default-datasource="" default-extended-persistence-inheritance="DEEP"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:jsf:1.0"/>

              <subsystem xmlns="urn:jboss:domain:mail:2.0">

                  <mail-session name="default" jndi-name="java:jboss/mail/Default">

                      <smtp-server outbound-socket-binding-ref="mail-smtp"/>

                  </mail-session>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:naming:2.0">

                  <remote-naming/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:pojo:1.0"/>

              <subsystem xmlns="urn:jboss:domain:remoting:3.0">

                  <endpoint worker="default"/>

                  <http-connector name="http-remoting-connector" connector-ref="default" security-realm="ApplicationRealm"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:resource-adapters:3.0">

                  <resource-adapters>

                      <resource-adapter id="file">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.file"/>

                      </resource-adapter>

                      <resource-adapter id="google">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.google"/>

                      </resource-adapter>

                      <resource-adapter id="ldap">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.ldap"/>

                      </resource-adapter>

                      <resource-adapter id="salesforce">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce"/>

                      </resource-adapter>

                      <resource-adapter id="salesforce-34">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.salesforce-34"/>

                      </resource-adapter>

                      <resource-adapter id="webservice">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.webservice"/>

                      </resource-adapter>

                      <resource-adapter id="mongodb">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.mongodb"/>

                      </resource-adapter>

                      <resource-adapter id="cassandra">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.cassandra"/>

                      </resource-adapter>

                      <resource-adapter id="simpledb">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.simpledb"/>

                      </resource-adapter>

                      <resource-adapter id="accumulo">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.accumulo"/>

                      </resource-adapter>

                      <resource-adapter id="solr">

                          <module slot="main" id="org.jboss.teiid.resource-adapter.solr"/>

                      </resource-adapter>

                  </resource-adapters>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:request-controller:1.0"/>

              <subsystem xmlns="urn:jboss:domain:sar:1.0"/>

              <subsystem xmlns="urn:jboss:domain:security-manager:1.0">

                  <deployment-permissions>

                      <maximum-set>

                          <permission class="java.security.AllPermission"/>

                      </maximum-set>

                  </deployment-permissions>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:security:1.2">

                  <security-domains>

                      <security-domain name="other" cache-type="default">

                          <authentication>

                              <login-module code="Remoting" flag="optional">

                                  <module-option name="password-stacking" value="useFirstPass"/>

                              </login-module>

                              <login-module code="RealmDirect" flag="required">

                                  <module-option name="password-stacking" value="useFirstPass"/>

                              </login-module>

                          </authentication>

                      </security-domain>

                      <security-domain name="jboss-web-policy" cache-type="default">

                          <authorization>

                              <policy-module code="Delegating" flag="required"/>

                          </authorization>

                      </security-domain>

                      <security-domain name="jboss-ejb-policy" cache-type="default">

                          <authorization>

                              <policy-module code="Delegating" flag="required"/>

                          </authorization>

                      </security-domain>

                      <security-domain name="teiid-security" cache-type="default">

                          <authentication>

                              <login-module code="RealmDirect" flag="required">

                                  <module-option name="password-stacking" value="useFirstPass"/>

                              </login-module>

                          </authentication>

                      </security-domain>

                  </security-domains>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:teiid:1.1">

                  <policy-decider-module>org.jboss.teiid</policy-decider-module>

                  <resultset-cache infinispan-container="teiid"/>

                  <preparedplan-cache infinispan-container="teiid"/>

                  <transport name="embedded"/>

                  <transport name="odata">

                      <authentication security-domain="teiid-security"/>

                  </transport>

                  <transport name="jdbc" socket-binding="teiid-jdbc" protocol="teiid">

                      <authentication security-domain="teiid-security"/>

                  </transport>

                  <transport name="odbc" socket-binding="teiid-odbc" protocol="pg">

                      <authentication security-domain="teiid-security"/>

                      <ssl mode="disabled"/>

                  </transport>

                  <translator name="jdbc-simple" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="jdbc-ansi" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="access" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="db2" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="derby" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="h2" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="hsql" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="hana" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="informix" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="metamatrix" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="mysql" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="mysql5" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="oracle" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="postgresql" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="greenplum" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="sqlserver" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="sybase" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="sybaseiq" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="teiid" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="teradata" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="modeshape" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="ingres" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="ingres93" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="intersystems-cache" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="netezza" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="file" module="org.jboss.teiid.translator.file"/>

                  <translator name="google-spreadsheet" module="org.jboss.teiid.translator.google"/>

                  <translator name="ldap" module="org.jboss.teiid.translator.ldap"/>

                  <translator name="loopback" module="org.jboss.teiid.translator.loopback"/>

                  <translator name="olap" module="org.jboss.teiid.translator.olap"/>

                  <translator name="ws" module="org.jboss.teiid.translator.ws"/>

                  <translator name="salesforce" module="org.jboss.teiid.translator.salesforce"/>

                  <translator name="salesforce-34" module="org.jboss.teiid.translator.salesforce" slot="34"/>

                  <translator name="hive" module="org.jboss.teiid.translator.hive"/>

                  <translator name="jpa2" module="org.jboss.teiid.translator.jpa"/>

                  <translator name="map-cache" module="org.jboss.teiid.translator.object"/>

                  <translator name="odata" module="org.jboss.teiid.translator.odata"/>

                  <translator name="sap-gateway" module="org.jboss.teiid.translator.odata"/>

                  <translator name="sap-nw-gateway" module="org.jboss.teiid.translator.odata"/>

                  <translator name="mongodb" module="org.jboss.teiid.translator.mongodb"/>

                  <translator name="cassandra" module="org.jboss.teiid.translator.cassandra"/>

                  <translator name="simpledb" module="org.jboss.teiid.translator.simpledb"/>

                  <translator name="accumulo" module="org.jboss.teiid.translator.accumulo"/>

                  <translator name="solr" module="org.jboss.teiid.translator.solr"/>

                  <translator name="excel" module="org.jboss.teiid.translator.excel"/>

                  <translator name="impala" module="org.jboss.teiid.translator.hive"/>

                  <translator name="prestodb" module="org.jboss.teiid.translator.prestodb"/>

                  <translator name="hbase" module="org.jboss.teiid.translator.hbase"/>

                  <translator name="ucanaccess" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="vertica" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="actian-vector" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="osisoft-pi" module="org.jboss.teiid.translator.jdbc"/>

                  <translator name="odata4" module="org.jboss.teiid.translator.odata4"/>

                  <translator name="redshift" module="org.jboss.teiid.translator.jdbc"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:transactions:3.0">

                  <core-environment>

                      <process-id>

                          <uuid/>

                      </process-id>

                  </core-environment>

                  <recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:undertow:2.0">

                  <buffer-cache name="default"/>

                  <server name="default-server">

                      <http-listener name="default" socket-binding="http" redirect-socket="https"/>

                      <host name="default-host" alias="localhost">

                          <location name="/" handler="welcome-content"/>

                          <filter-ref name="server-header"/>

                          <filter-ref name="x-powered-by-header"/>

                      </host>

                  </server>

                  <servlet-container name="default">

                      <jsp-config/>

                      <websockets/>

                  </servlet-container>

                  <handlers>

                      <file name="welcome-content" path="${jboss.home.dir}/welcome-content"/>

                  </handlers>

                  <filters>

                      <response-header name="server-header" header-name="Server" header-value="WildFly/9"/>

                      <response-header name="x-powered-by-header" header-name="X-Powered-By" header-value="Undertow/1"/>

                  </filters>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:webservices:2.0">

                  <wsdl-host>${jboss.bind.address:127.0.0.1}</wsdl-host>

                  <endpoint-config name="Standard-Endpoint-Config"/>

                  <endpoint-config name="Recording-Endpoint-Config">

                      <pre-handler-chain name="recording-handlers" protocol-bindings="##SOAP11_HTTP ##SOAP11_HTTP_MTOM ##SOAP12_HTTP ##SOAP12_HTTP_MTOM">

                          <handler name="RecordingHandler" class="org.jboss.ws.common.invocation.RecordingServerHandler"/>

                      </pre-handler-chain>

                  </endpoint-config>

                  <client-config name="Standard-Client-Config"/>

              </subsystem>

              <subsystem xmlns="urn:jboss:domain:weld:2.0"/>

          </profile>

       

       

          <interfaces>

              <interface name="management">

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

              </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>

       

       

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

              <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:9993}"/>

              <socket-binding name="ajp" port="${jboss.ajp.port:8009}"/>

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

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

              <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>

       

       

      </server>

       

       

      the User and mangament properties:

      admin=db45bf94a7c8945359eba843bc654319

      test=086365bc577303b2e8bff3df65af3aa3

      user=6f658d4096fede7e54244bc77905e908

       

      and the module.xml in com/mysql/main:

      <?xml version="1.0" encoding="UTF-8"?>

      <module xmlns="urn:jboss:module:1.0" name="com.mysql">

        <resources>

          <resource-root path="mysql-connector-java-5.1.39-bin.jar"/>

        </resources>

        <dependencies>

          <module name="javax.api"/>

        </dependencies>

      </module>

        • 1. Re: teiid: can not connect to teiid
          Ramesh Reddy Master

          forum etiquette : Please try to keep the configuration stuff as attachments so that it is simple for to scan for details of issue faster.

           

          All looks good. I think the issue is you are using a management user with JDBC connection. There are two types of user accounts you can create with "add-user.sh/bat" program, one management user and then application user. You need to use application user for the JDBC connection. If yo use web-console then you need to use the Management user. The former is application user, the later is administrative user.