3 Replies Latest reply on Jun 20, 2019 9:33 AM by rareddy

    How to connect Teiid Designer with dockerized Teiid instance

    dieman.one

      Hello,

       

      Can Teiid Designer work with dockerized standalone Teiid instance?

       

      If yes, is there any manual describing config steps in detail?

       

      Just following the same sequence of steps as with locally installed Teiid doesn't seem to work.

      One obvious contradiction: as soon as the docker container starts, Teiid server is up, but the Teiid designer would show it as a server that is down and ask to start it, and this doesn't work. 

       

      Thanks!

        • 1. Re: How to connect Teiid Designer with dockerized Teiid instance
          rareddy

          If you are starting Teiid in Docker, then you need to expose the management and JDBC ports on docker then configure Designer to connect to an external server using those exposed ports.

          • 2. Re: How to connect Teiid Designer with dockerized Teiid instance
            dieman.one

            Is there any documentation describing these steps?

            It is easier said than done, I am afraid...so far I was not able to control a docker-based Teiid from the Designer app

            • 3. Re: How to connect Teiid Designer with dockerized Teiid instance
              rareddy

              Follow below.

               

              # Pull the docker image from the Docker Hub
              $docker pull jboss/teiid
              
              # Start the Docker Image
              $docker run -p 8080:8080 -p 9990:9990 -p 31000:31000  -p 35432:35432 --name myteiid -it jboss/teiid
              
              # Connect to the docker image, we need to create an admin and application user
              $docker exec -it myteiid sh
              sh-4.2$
              sh-4.2$ wildfly/bin/add-user.sh 
              
              What type of user do you wish to add?
              a) Management User (mgmt-users.properties)
              b) Application User (application-users.properties)
              (a): a
              
              Enter the details of the new user to add.
              Using realm 'ManagementRealm' as discovered from the existing property files.
              Username : admin
              User 'admin' already exists and is disabled, would you like to...
              a) Update the existing user password and roles
              b) Enable the existing user
              c) Type a new username
              (a): a
              Password :
              Are you sure you want to use the password entered yes/no? yes
              Re-enter Password :
              What groups do you want this user to belong to? (Please enter a comma separated list, or leave blank for none)[  ]:
              Is this new user going to be used for one AS process to connect to another AS process?
              e.g. for a slave host controller connecting to the master or for a Remoting connection for server to server EJB calls.
              yes/no? no
              sh-4.2$
              sh-4.2$ wildfly/bin/add-user.sh
              
              What type of user do you wish to add?
              a) Management User (mgmt-users.properties)
              b) Application User (application-users.properties)
              (a): b
              
              Enter the details of the new user to add.
              Using realm 'ApplicationRealm' as discovered from the existing property files.
              Username : user
              Password :
              Are you sure you want to use the password entered yes/no? yes
              Re-enter Password :
              What groups do you want this user to belong to? (Please enter a comma separated list, or leave blank for none)[  ]: odata
              About to add user 'user' for realm 'ApplicationRealm'
              Is this correct yes/no? yes
              Is this new user going to be used for one AS process to connect to another AS process?
              e.g. for a slave host controller connecting to the master or for a Remoting connection for server to server EJB calls.
              yes/no? no
              sh-4.2$
              sh-4.2$ exi
              
              ttt
              
              

               

              Now remember the user names and passwords from above. Look at last comment in this form thread and configure an external Teiid Server.

              Remote connection to teiid server from designer

               

              There may be other ways to create the users so that you do not recreate after starting the container, but this may be easiest for now.