Docker: SQLPad - Forbidden error message

See original GitHub issue

I’m running SQLPad on Docker, when trying to log in the error message: “Username or password incorrect” occurs. And during signup a “forbidden” message is displayed.

I’m passing these environment options to the Docker container.

# Email address to give admin permissions to
SQLPAD_ADMIN=""

# Password to set for admin email address on application start. Requires `admin` setting to also be provided.
SQLPAD_ADMIN_PASSWORD=""

Issue Analytics

State:
Created 3 years ago
Reactions:1
Comments:8

Top GitHub Comments

2reactions

sc911commented, May 4, 2021

You need to set the the mail-address without quotes:

SQLPAD_ADMIN=mail@domain.tld

Otherwise quotes will be included so I guess you could login using "mail@domain.tld" but not having tried that… So a stripped down docker-compose.yml would look like this:

version: "3.5"
services:
  sqlpad:
    image: "sqlpad/sqlpad:6.6.0"
    environment:
      - SQLPAD_ADMIN=mail@domain.tld
    volumes:
      - "[...]:/var/lib/sqlpad"

0reactions

sarathsaleemcommented, Aug 7, 2021

Same issue on the latest docker.

Tested an old version 5.8.0 , that is working as expected

Top Results From Across the Web

A brand new website interface for an even better experience!

Docker : SQLPad - Forbidden error message.

API Overview - SQLPad

400 : Bad request (user input error); 401 : Unauthorized (you need to be authenticated); 403 : Forbidden (you lack the permissions to...

SQLPad - Docker Hub

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto,...

SQLPad - Quick Start With Docker - DEV Community ‍ ‍

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, ...

https://raw.githubusercontent.com/rickbergfalk/sql...

Please follow good practices if your SQLPad use warrants it. ... Capture database error message on ODBC driver connection error - Show service...