2 Replies Latest reply on Jan 4, 2017 9:24 AM by Ramesh Reddy

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

    Shishir Kulkarni Newbie

      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