Teiid JDBC Connection Preview VDB: teiid driver failed to connect to jdbc:teiid

[shishirvk]

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

[van.halbert]

Hi Shishir;

Regarding OData, when you setup the user, did you assign them the role of OData?

In Teiid Designer, on the Teiid Instance tab when configuring a server, make sure the Teiid JDBC user name and password have been set and are being saved.

Hope this helps.

Van

[rareddy]

In the Teiid/Wildfly server's bin directory there is script called adduser.sh or adduser.bat, use that to create a user "application management" domain with role "odata" to connect to active VDB either through JDBC or OData.