You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2021/12/20 12:28:44 UTC

[GitHub] [superset] BFergerson edited a comment on issue #17049: Import of datasources (`superset import-datasources`) fails

BFergerson edited a comment on issue #17049:
URL: https://github.com/apache/superset/issues/17049#issuecomment-997880612


   I believe I'm experience the same issue. My setup looks like:
   
   ### docker-compose.yml
   ```yml
   version: '3.3'
   services:
     superset:
       container_name: superset
       hostname: superset
       ports:
         - "8888:8088"
       depends_on:
         - postgres
       links:
         - postgres
       build:
         context: .
         dockerfile: Dockerfile-superset
     postgres:
       image: postgres:9.6.21
       container_name: postgres
       hostname: postgres
       environment:
         - POSTGRES_PASSWORD=123456
         - POSTGRES_USER=postgres
         - POSTGRES_DB=postgres
         - POSTGRES_HOST_AUTH_METHOD=md5
   ```
   
   ### Dockerfile-superset
   ```
   FROM apache/superset:latest
   USER root
   
   RUN pip install psycopg2-binary
   
   USER superset
   
   ADD datasources.yml ./
   ```
   
   ### datasources.yml
   ```yml
   databases:
   - database_name: postgres
     extra: '{"metadata_params":{},"engine_params":{},"metadata_cache_timeout":{},"schemas_allowed_for_file_upload":[]}'
     sqlalchemy_uri: postgresql+psycopg2://postgres:123456@postgres:5432/postgres
   ```
   
   #### setup-superset.sh
   ```sh
   docker exec -it superset superset fab create-admin \
                  --username admin \
                  --firstname Superset \
                  --lastname Admin \
                  --email admin@superset.com \
                  --password admin
   
   docker exec -it superset superset db upgrade
   
   docker exec -it superset superset init
   
   docker exec -it superset superset import-datasources -p datasources.yml
   ```
   
   ---
   
   If I input `postgresql+psycopg2://postgres:123456@postgres:5432/postgres` through the UI, everything works fine. It is only when I use `import-datasources` that I get `ERROR: Please re-enter the password`.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org