[Update] Query Not Showing

Issue Summary

I am running Redash via docker and host the database locally. The connection to database showed a ‘Success’. However, when I tried to execute a query, it returned Error running query: Internal Server Error.

Successful connection of db:

My yaml set up:

version: ‘2’
services:
server:
image: redash/redash:latest
command: server
depends_on:
- postgres
- redis
ports:
- “5000:5000”
environment:
PYTHONUNBUFFERED: 0
REDASH_LOG_LEVEL: “INFO”
REDASH_REDIS_URL: “redis://redis:6379/0”
REDASH_DATABASE_URL: postgresql://postgres:password@host.docker.internal/data
REDASH_COOKIE_SECRET: veryverysecret
REDASH_WEB_WORKERS: 4
REDASH_MAIL_SERVER: “smtp2http”
REDASH_MAIL_DEFAULT_SENDER: “dalong@qq.com
worker:
image: redash/redash:latest
command: scheduler
environment:
PYTHONUNBUFFERED: 0
REDASH_LOG_LEVEL: “INFO”
REDASH_REDIS_URL: “redis://redis:6379/0”
REDASH_DATABASE_URL: postgresql://postgres:password@host.docker.internal/data
QUEUES: “queries,scheduled_queries,celery”
WORKERS_COUNT: 2
REDASH_MAIL_SERVER: “smtp2http”
REDASH_MAIL_DEFAULT_SENDER: “dalong@qq.com
redis:
image: redis:3.0-alpine
mongodb:
image: mongo:3.2
ports:
- “27017:27017”
benthos:
image: jeffail/benthos
volumes:
- “./conf/webhook.yaml:/benthos.yaml”
ports:
- “4195:4195”
smtp2http:
image: uflare/smtp2http
command: --listen=:25 --webhook=http://benthos:4195/ --strict=false
api:
build: ./
ports:

  • “8080:80”
    p:
    image: prom/prometheus
    volumes:
    - “./prometheus.yml:/etc/prometheus/prometheus.yml”
    ports:
    - “9090:9090”
    grafana:
    image: grafana/grafana
    ports:
    - “3000:3000”
    postgres:
    image: postgres:9.5.6-alpine
    ports:
    - “5432:5432”
    nginx:
    image: redash/nginx:latest
    ports:
    • “80:80”
      depends_on:
    • server
      links:
    • server:redash

Technical details:

  • Browser/OS: Chrose and Edge / Windows 10
  • How did you install Redash: docker pull redash/redash:latest

Can you please advise? Thank you.

As I am unable to add an additional picture, here is a snapshot of my query.

I have another issue now that the error has gone. The query result is not showing. I know that there is another ticket here, but I am using Windows.

Do you see any errors in your browser javascript console?

Hi @k4s1m thank you for your reply. I didn’t have any errors.