damodhar-admin commented on issue #36183:
URL: https://github.com/apache/superset/issues/36183#issuecomment-3552066970
FROM ubuntu:22.04
# small example: install msodbcsql18 and pyodbc (adjust to Superset base
later)
USER root
RUN apt-get update && apt-get install -y \
curl gnupg2 apt-transport-https build-essential unixodbc-dev \
freetds-dev freetds-bin python3 python3-pip
# Add Microsoft repo for Ubuntu 22.04
RUN curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
&& \
curl https://packages.microsoft.com/config/ubuntu/22.04/prod.list \
-o /etc/apt/sources.list.d/mssql-release.list
RUN apt-get update && ACCEPT_EULA=Y apt-get install -y msodbcsql18
# Install Python drivers
RUN python3 -m pip install --upgrade pip setuptools wheel
RUN python3 -m pip install pyodbc
# (Then install Superset or copy your superset files / run superset)
Note: the above is an example base for reproducing msodbcsql18 + pyodbc
success. If the Superset official image uses Debian 12, the same apt step fails
there; that’s why I used Ubuntu 22.04 which has Microsoft packages available.
docker-compose build or docker build output showing:
pip install pymssql failure (full error excerpt)
OR apt-get install msodbcsql18 failure (exit code 100) and apt error lines
docker run --rm -it apache/superset:latest bash -c "cat /etc/os-release;
python3 --version"
shows base OS and python version that the image uses (helps devs confirm
Debian 12 / Python version)
Your minimal Dockerfile used to reproduce the failure (either FROM
apache/superset:latest + pip/apt lines, or the Ubuntu snippet above)
Short note: “I attempted both pymssql and pyodbc + msodbcsql18; pymssql
fails to compile on Python 3.10+, msodbcsql18 apt install fails on Debian 12.”
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
