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


      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.





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