-
15. Re: How to connect to Salesforce using Teiid?
A frustrating thing is happening at this moment. Whenever, I am trying to create a connection with Salesforce on a fresh teiid installation using the techniques above, it works fine. But when I try to work on my master teiid instance, it fails and gives the following error:
Nov 11, 2014 3:24:24 PM org.teiid.jdbc.TeiidDriver connect
SEVERE: Could not create connection
org.teiid.jdbc.TeiidSQLException: TEIID50072 The username "tarif" and/or password and/or payload token could not be authenticated by any membership domain.
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:56)
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:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at Driver.main(Driver.java:11)
Caused by: org.teiid.net.ConnectionException: TEIID50072 The username "tarif" 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:316)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)
... 5 more
Caused by: org.teiid.client.security.LogonException: TEIID50072 The username "tarif" 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 "tarif" 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
org.teiid.jdbc.TeiidSQLException: TEIID50072 The username "tarif" and/or password and/or payload token could not be authenticated by any membership domain.
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:56)
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:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at Driver.main(Driver.java:11)
Caused by: org.teiid.net.ConnectionException: TEIID50072 The username "tarif" 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:316)
at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)
... 5 more
Caused by: org.teiid.client.security.LogonException: TEIID50072 The username "tarif" 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 "tarif" 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
I have taken the exact same procedure that worked before. Can anybody give some ideas about what other things could go wrong other than creating users? I am pretty sure that I have created those users accordingly.
-
16. Re: How to connect to Salesforce using Teiid?
In the "standalone/configuration" directory there is file called "application-users.properties" make sure the user is defined in there. When use add-user.sh, it will add entry to this file.
-
17. Re: How to connect to Salesforce using Teiid?
I have created an account by using the add-user.sh. And a new user has been created in application-user.properties. Here's a current status of the application-user.properties file:
#
# Properties declaration of users for the realm 'ApplicationRealm' which is the default realm
# for application services on a new AS 7.1 installation.
#
# This includes the following protocols: remote ejb, remote jndi, web, remote jms
#
# Users can be added to this properties file at any time, updates after the server has started
# will be automatically detected.
#
# The format of this realm is as follows: -
# username=HEX( MD5( username ':' realm ':' password))
#
# A utility script is provided which can be executed from the bin folder to add the users: -
# - Linux
# bin/add-user.sh
#
# - Windows
# bin\add-user.bat
#
# The following illustrates how an admin user could be defined, this
# is for illustration only and does not correspond to a usable password.
#
#admin=2a0923285184943425d1f53ddd58ec7a
tarif=5edecf29443c811aaf2dd1aceca475ed
I have followed the same procedure that worked before. But I am not sure where I've been making the mistake.
-
18. Re: How to connect to Salesforce using Teiid?
Have you made other changes to this instance? For example modifying the teiid-security security domain. Are management users working? And can you verify it the tarif user works from a different context from Teiid, such as from a web app using the default other security domain which utilizes the application realm.
-
19. Re: How to connect to Salesforce using Teiid?
BTW, if the VDB name in your JDBC url does not match to VDB you deployed you will see the same error. Take look at the log and make sure the VDB is active and matches to that of your URL. Same error happened to me today.
-
20. Re: How to connect to Salesforce using Teiid?
Wouldn't you see TEIID40046 if the vdb didn't exist?
-
21. Re: How to connect to Salesforce using Teiid?
Steven, I'll try to use the Teiid web app to connect to the web app and will let you know. Currently, here's my standalone-teiid.xml.
<?xml version="1.0" encoding="UTF-8"?>
<server xmlns="urn:jboss:domain:1.4">
<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.threads"/>
<extension module="org.jboss.as.transactions"/>
<extension module="org.jboss.as.web"/>
<extension module="org.jboss.as.webservices"/>
<extension module="org.jboss.as.weld"/>
</extensions>
<management>
<security-realms>
<security-realm name="ManagementRealm">
<authentication>
<local default-user="$local"/>
<properties path="mgmt-users.properties" relative-to="jboss.server.config.dir"/>
</authentication>
</security-realm>
<security-realm name="ApplicationRealm">
<authentication>
<local default-user="$local" allowed-users="*"/>
<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>
<management-interfaces>
<native-interface security-realm="ManagementRealm">
<socket-binding native="management-native"/>
</native-interface>
<http-interface security-realm="ManagementRealm">
<socket-binding http="management-http"/>
</http-interface>
</management-interfaces>
</management>
<profile>
<subsystem xmlns="urn:jboss:domain:logging:1.2">
<console-handler name="CONSOLE">
<level name="INFO"/>
<formatter>
<pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %X{teiid-session} %s%E%n"/>
</formatter>
</console-handler>
<periodic-rotating-file-handler name="FILE" autoflush="true">
<formatter>
<pattern-formatter pattern="%d{HH:mm:ss,SSS} %-5p [%c] (%t) %X{teiid-session} %s%E%n"/>
</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>
<root-logger>
<level name="INFO"/>
<handlers>
<handler name="CONSOLE"/>
<handler name="FILE"/>
</handlers>
</root-logger>
</subsystem>
<subsystem xmlns="urn:jboss:domain:datasources:1.1">
<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</connection-url>
<driver>h2</driver>
<security>
<user-name>sa</user-name>
<password>sa</password>
</security>
</datasource>
<drivers>
<driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-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>
<driver name="com.mysql" module="com.mysql"><driver-class>com.mysql.jdbc.Driver</driver-class><xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class></driver><driver name="JTDS" module="net.sourceforge.jtds"><driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class></driver></drivers>
</datasources>
</subsystem>
<subsystem xmlns="urn:jboss:domain:deployment-scanner:1.1">
<deployment-scanner path="deployments" relative-to="jboss.server.base.dir" scan-interval="5000"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:ee:1.1">
<spec-descriptor-property-replacement>false</spec-descriptor-property-replacement>
<jboss-descriptor-property-replacement>true</jboss-descriptor-property-replacement>
</subsystem>
<subsystem xmlns="urn:jboss:domain:ejb3:1.4">
<session-bean>
<stateless>
<bean-instance-pool-ref pool-name="slsb-strict-max-pool"/>
</stateless>
<stateful default-access-timeout="5000" 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" aliases="NoPassivationCache"/>
<cache name="passivating" passivation-store-ref="file" aliases="SimpleStatefulCache"/>
</caches>
<passivation-stores>
<file-passivation-store name="file"/>
</passivation-stores>
<async thread-pool-name="default"/>
<timer-service thread-pool-name="default">
<data-store path="timer-service-data" relative-to="jboss.server.data.dir"/>
</timer-service>
<remote connector-ref="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"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:infinispan:1.4">
<cache-container name="web" aliases="standard-session-cache" default-cache="local-web" module="org.jboss.as.clustering.web.infinispan">
<local-cache name="local-web" batching="true">
<file-store passivation="false" purge="false"/>
</local-cache>
</cache-container>
<cache-container name="hibernate" default-cache="local-query" module="org.jboss.as.jpa.hibernate:4">
<local-cache name="entity">
<transaction mode="NON_XA"/>
<eviction strategy="LRU" max-entries="10000"/>
<expiration max-idle="100000"/>
</local-cache>
<local-cache name="local-query">
<transaction mode="NONE"/>
<eviction strategy="LRU" max-entries="10000"/>
<expiration max-idle="100000"/>
</local-cache>
<local-cache name="timestamps">
<transaction mode="NONE"/>
<eviction strategy="NONE"/>
</local-cache>
</cache-container>
<cache-container name="teiid" default-cache="resultset">
<local-cache name="resultset">
<transaction mode="NON_XA"/>
<expiration lifespan="7200000"/>
<eviction max-entries="1024" strategy="LIRS"/>
</local-cache>
<local-cache name="resultset-repl">
<transaction mode="NON_XA"/>
<expiration lifespan="7200000"/>
<eviction max-entries="1024" strategy="LIRS"/>
</local-cache>
<local-cache name="preparedplan">
<expiration lifespan="28800"/>
<eviction max-entries="512" strategy="LIRS"/>
</local-cache>
</cache-container>
</subsystem>
<subsystem xmlns="urn:jboss:domain:jaxrs:1.0"/>
<subsystem xmlns="urn:jboss:domain:jca:1.1">
<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.2">
<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:1.1">
<mail-session jndi-name="java:jboss/mail/Default">
<smtp-server outbound-socket-binding-ref="mail-smtp"/>
</mail-session>
</subsystem>
<subsystem xmlns="urn:jboss:domain:naming:1.3">
<remote-naming/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:pojo:1.0"/>
<subsystem xmlns="urn:jboss:domain:remoting:1.1">
<connector name="remoting-connector" socket-binding="remoting" security-realm="ApplicationRealm"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:resource-adapters:1.1">
<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="infinispan">
<module slot="main" id="org.jboss.teiid.resource-adapter.infinispan"/>
</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"/>
<transaction-support>NoTransaction</transaction-support><connection-definitions><connection-definition class-name="org.teiid.resource.adapter.salesforce.SalesForceManagedConnectionFactory" jndi-name="java:/sf" enabled="true" use-java-context="true" pool-name="teiid-sf-ds"><config-property name="URL">https://www.salesforce.com/services/Soap/u/22.0</config-property><config-property name="username">tarif.ezaz@gmail.com</config-property><config-property name="password">hazards</config-property></connection-definition></connection-definitions></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:sar:1.0"/>
<subsystem xmlns="urn:jboss:domain:teiid:1.0">
<async-thread-pool>teiid-async</async-thread-pool>
<resultset-cache infinispan-container="teiid" name="resultset"/>
<preparedplan-cache infinispan-container="teiid" name="preparedplan"/>
<transport name="embedded"/>
<transport name="odata">
<authentication security-domain="teiid-security"/>
</transport>
<transport name="jdbc" protocol="teiid" socket-binding="teiid-jdbc">
<authentication security-domain="teiid-security"/>
</transport>
<transport name="odbc" protocol="pg" socket-binding="teiid-odbc">
<authentication security-domain="teiid-security"/>
</transport>
<policy-decider-module>org.jboss.teiid</policy-decider-module>
<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="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="sqlserver" module="org.jboss.teiid.translator.jdbc"/>
<translator name="sybase" 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="hive" module="org.jboss.teiid.translator.hive"/>
<translator name="jpa2" module="org.jboss.teiid.translator.jpa"/>
<translator name="infinispan-cache" module="org.jboss.teiid.translator.object"/>
<translator name="map-cache" module="org.jboss.teiid.translator.object"/>
<translator name="odata" 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"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:threads:1.1">
<unbounded-queue-thread-pool name="teiid-async">
<max-threads count="4"/>
</unbounded-queue-thread-pool>
</subsystem>
<subsystem xmlns="urn:jboss:domain:transactions:1.2">
<core-environment>
<process-id>
<uuid/>
</process-id>
</core-environment>
<recovery-environment socket-binding="txn-recovery-environment" status-socket-binding="txn-status-manager"/>
<coordinator-environment default-timeout="300"/>
</subsystem>
<subsystem xmlns="urn:jboss:domain:web:1.4" default-virtual-server="default-host" native="false">
<connector name="http" protocol="HTTP/1.1" scheme="http" socket-binding="http"/>
<virtual-server name="default-host" enable-welcome-root="true">
<alias name="localhost"/>
<alias name="example.com"/>
</virtual-server>
</subsystem>
<subsystem xmlns="urn:jboss:domain:webservices:1.2">
<modify-wsdl-address>true</modify-wsdl-address>
<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:1.0"/>
<subsystem xmlns="urn:jboss:domain:security:1.1"><security-domains><security-domain name="teiid-security" cache-type="default"><authentication><login-module code="UsersRoles" flag="required"><module-option name="usersProperties" value="${jboss.server.config.dir}/teiid-security-users.properties"/><module-option name="rolesProperties" value="${jboss.server.config.dir}/teiid-security-roles.properties"/></login-module></authentication></security-domain></security-domains></subsystem></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-native" interface="management" port="${jboss.management.native.port:32801}"/>
<socket-binding name="management-http" interface="management" port="${jboss.management.http.port:43253}"/>
<socket-binding name="management-https" interface="management" port="${jboss.management.https.port:55211}"/>
<socket-binding name="ajp" port="44154"/>
<socket-binding name="http" port="27347"/>
<socket-binding name="https" port="57448"/>
<socket-binding name="remoting" port="25631"/>
<socket-binding name="txn-recovery-environment" port="39035"/>
<socket-binding name="txn-status-manager" port="46175"/>
<socket-binding name="teiid-jdbc" port="12784"/>
<socket-binding name="teiid-odbc" port="19221"/>
<outbound-socket-binding name="mail-smtp">
<remote-destination host="localhost" port="25"/>
</outbound-socket-binding>
</socket-binding-group>
</server>
I have added the resource adapter for Salesforce and changed some of the default ports in socket-binding-group.
Here's the output of the teiid-security-roles.properties:
mario=user
Here's the output of the teiid-security-users.properties:
mario=mario
-
22. Re: How to connect to Salesforce using Teiid?
Ramesh, I double checked the name of the VDB, it matches exactly.
-
23. Re: How to connect to Salesforce using Teiid?
Steven, I tried a management user, which works fine from the Admin web console. But that user uses a management realm. Are there any available web apps that connects using an user from Application realm?
-
24. Re: Re: How to connect to Salesforce using Teiid?
I saw this
19:12:26,660 WARN [org.teiid.SECURITY] (New I/O worker #2) TEIID40011 Processing exception 'TEIID40046 VDB "tpch" version "latest" does not exist.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid.services.SessionServiceImpl.getActiveVDB(SessionServiceImpl.java:269). Enable more detailed logging to see the entire stacktrace. 19:13:08,803 WARN [org.teiid.SECURITY] (New I/O worker #4) TEIID40011 Processing exception 'TEIID50072 The username "user" and/or password and/or payload token could not be authenticated by any membership domain.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid.jboss.JBossSessionService.authenticate(JBossSessionService.java:74). Enable more detailed logging to see the entire stacktrace.
Ramesh..
-
25. Re: Re: How to connect to Salesforce using Teiid?
Ramesh,
Can you elaborate? Those are from two separate attempts. Did you deploy a vdb in between?
Tarif,
From the config you aren't using the application realm. You are using the teiid specific properties files. You would need the stock security configuration where the teiid-security security domain is using the RealmDirect login module for the application realm and the add user script to be used by Teiid. Otherwise based upon your config you would login based upon the teiid specific properties files - user/password = mario/mario.
-
26. Re: Re: How to connect to Salesforce using Teiid?
Looks like I may have the user and as well as the VDB wrong at the same time.
-
27. Re: How to connect to Salesforce using Teiid?
Thank you very much Ramesh and Steven. It finally worked!
Thanks again!
-
28. Re: How to connect to Salesforce using Teiid?
You gonna keep us in suspense or let us know what you did to make it work?
-
29. Re: How to connect to Salesforce using Teiid?
Hey Ramesh, sorry I was out of town for a few days and then when I came back, I got sick. I have used the username and password that I set earlier. It was stored in the teiid specific properties file. The file was named teiid-security-users.properties.
Thanks for you kind help.