GitHub user Kranthi32 added a comment to the discussion: Production deployment
issue in
@dosu i am getting this mssql server connection issue
connection string is
mssql+pyodbc:///?odbc_connect=DRIVER%3D%7BODBC+Driver+18+for+SQL+Server%7D%3BSERVER%3Dapsqlminnd002.e88744a491af.database.windows.net%3BDATABASE%3DMultitenant_Staging_Mechanical2%3BUID%3Ddynamicapp_user%3BPWD%3Dgoddyun%2540m1ct%2524tu%2524r%3BEncrypt%3Dyes%3BTrustServerCertificate%3Dyes%3BConnectionTimeout%3D30%3B
Error: ERROR: (builtins.NoneType) None [SQL: (pyodbc.OperationalError)
('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout
expired (0) (SQLDriverConnect)') (Background on this error at:
https://sqlalche.me/e/14/e3q8)] (Background on this error at:
https://sqlalche.me/e/14/dbapi)
my image is
FROM apache/superset:4.1.2
USER root
# Install base tools and dependencies
RUN apt-get update && apt-get install -y \
build-essential \
libpq-dev \
unixodbc-dev \
curl \
gnupg2 \
apt-transport-https \
software-properties-common
# Add Microsoft GPG key and repository (Debian 12 - bookworm)
RUN curl -sSL https://packages.microsoft.com/keys/microsoft.asc | \
gpg --dearmor > /usr/share/keyrings/microsoft.gpg && \
echo "deb [signed-by=/usr/share/keyrings/microsoft.gpg]
https://packages.microsoft.com/debian/12/prod bookworm main" \
> /etc/apt/sources.list.d/mssql-release.list
# Install msodbcsql18
RUN apt-get update && \
ACCEPT_EULA=Y apt-get install -y msodbcsql18
# Install Python drivers including MSSQL plugin support
RUN pip install --upgrade pip setuptools wheel && \
pip install --no-cache-dir \
redis \
psycopg2-binary \
pyodbc \
'apache-superset[sql_server]' && \
apt-get clean && \
rm -rf /var/lib/apt/lists/*
USER superset
GitHub link:
https://github.com/apache/superset/discussions/33957#discussioncomment-13640349
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
