Hello All,

I have been getting Teiid JDBC Driver Connection error, configuration of the setup is as below :

• JBoss AS : 10.0.0
• Teiid  Server : 9.1.1
• Teiid Designer : 10.1.0
• Operating Sys : Mac OS
• Data Source Type : MySql

I was able to follow all the steps mentioned link here until the VDB Execute step :

Producing and Consuming OData in Teiid and Teiid Designer

I am able to deploy the VDB successfully , but not been able to access it over the ODATA URL .

At the VDB execute step i am getting the following error message :

"TEIID40011 Processing exception 'TEIID50072 The username "user" and/or

password and/or payload token could not be authenticated by security

domain teiid-security.' for session null.  Exception type

org.teiid.client.security.LogonException thrown from

org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.

java:154). Enable more detailed logging to see the entire stacktrace."

Also, when i try to Preview the data in table via VDB i get the following error :

The teiid driver failed to connect to jdbc:teiid:PREVIEW<VDB_ID>@mm://localhost:31000 with the given username and password

I was able to create a new user with admin rights  using add-user.sh script .

I am not able to find the right configuration file / place where i need to update the connection user

Any guidance in this regard will be very helpful.

Thanks

Shishir

Teiid Development "Test JDBC Connection" Unable to establish jdbc connection in Teiid Designer