d4software / QueryTree

Data reporting and visualization for your app
http://querytreeapp.com
GNU Lesser General Public License v3.0
335 stars 121 forks source link

QueryTree Not able to fetch New tables created in MYSQL container #109

Closed dshah2012 closed 3 years ago

dshah2012 commented 4 years ago

Hello ,

Steps to reproduce the issue 1 I am using the latest docker image of query tree and also mysql.

  1. Created a docker-compose.yml to spin up the containers and communicate.
  2. Logged in query tree webpage
  3. Created a db connection with mysql container.
  4. Got a Connection Successful Message.
  5. Clicked on create report for that conection.
  6. Displays tables that are existed.
  7. Created new tables in mysql container.
  8. Refresh the querytree webpage, New tables created are not displayed.

PS: When I delete the connection in querytree and again add it then it shows. Also second way when I restart my containers it shows.

Is it normal that it will behave this way. It should have taken the tables on the go as it has already created connection with the mysql container in the beginning.

Here is my docker-compose file.

version: '3.2'
services: 
    reports:
        image: d4software/querytree:latest
        networks: 
            - frontend
            - backend
        container_name: nextreport
        ports: 
            - 8090:80
    mysql:
        image: mysql:latest
        restart: always
        volumes: 
            - ${DATABASE_STORAGE}:/var/lib/mysql
        networks: 
            - backend
        ports: 
            - 3309:3006
        environment: 
            MYSQL_ROOT_PASSWORD: ${ROOT_PASSWORD}
            MYSQL_DATABASE: ${DATABASE_NAME}
            MYSQL_USER: ${CUSTOM_USER}
            MYSQL_PASSWORD: ${CUSTOM_PASSWORD}
        container_name: mysql    
networks: 
    frontend:
    backend:
dshah2012 commented 3 years ago

Anyone faced this issue .

stale[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.