forked from demisto/dockerfiles
/
Dockerfile
77 lines (69 loc) · 2.34 KB
/
Dockerfile
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
FROM demisto/python3-deb:3.10.12.62632
COPY requirements.txt .
COPY odbcinst.ini /etc/odbcinst.ini
RUN apt-get update && apt-get install -y --no-install-recommends \
unixodbc \
freetds-bin \
libpq5 \
libaio1 \
wget \
unzip \
libssl1.1 \
&& rm -rf /var/lib/apt/lists/*
# install oracle instant client
RUN mkdir -p /opt/oracle && \
cd /opt/oracle && \
wget -q https://download.oracle.com/otn_software/linux/instantclient/19600/instantclient-basiclite-linux.x64-19.6.0.0.0dbru.zip && \
unzip instantclient-basiclite-linux.x64-19.6.0.0.0dbru.zip && \
rm instantclient-basiclite-linux.x64-19.6.0.0.0dbru.zip && \
echo /opt/oracle/instantclient_19_6 > /etc/ld.so.conf.d/oracle-instantclient.conf && \
ldconfig
# install freetds
RUN apt-get update && apt-get install -y --no-install-recommends \
build-essential \
libc-dev \
libssl-dev \
unixodbc-dev \
&& wget ftp://ftp.freetds.org/pub/freetds/stable/freetds-1.1.39.tar.gz \
&& tar -xzf freetds-1.1.39.tar.gz \
&& cd freetds-1.1.39 \
&& ./configure --with-openssl --with-unixodbc=/usr --enable-msdblib \
&& make \
&& make install \
&& apt-get purge -y --auto-remove \
build-essential \
libc-dev \
libssl-dev \
unixodbc-dev \
&& rm -rf /var/lib/apt/lists/* \
&& cd .. \
&& rm freetds-1.1.39.tar.gz \
&& rm -rf freetds-1.1.39
# Install the Microsoft ODBC driver for SQL Server (Linux)
RUN apt-get update \
&& apt-get install -y --allow-downgrades gpgv gnupg2 curl apt-utils \
&& curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - \
&& curl https://packages.microsoft.com/config/debian/11/prod.list > /etc/apt/sources.list.d/mssql-release.list \
&& apt-get update \
&& ACCEPT_EULA=Y apt-get install msodbcsql18 \
&& apt-get install -y unixodbc-dev libgssapi-krb5-2
# install python packages
RUN apt-get update && apt-get install -y --no-install-recommends \
gcc \
g++ \
libc-dev \
libffi-dev \
python3-dev \
unixodbc-dev \
&& pip install --no-cache-dir -r requirements.txt \
&& apt-get purge -y --auto-remove \
gcc \
g++ \
libc-dev \
libffi-dev \
python3-dev \
unixodbc-dev \
&& rm -rf /var/lib/apt/lists/*
# Handling the issue described here https://github.com/mkleehammer/pyodbc/issues/610#issuecomment-534920201 by using TLS v1
RUN sed -i s/DEFAULT@SECLEVEL=2/DEFAULT@SECLEVEL=1/g /etc/ssl/openssl.cnf \
&& sed -i s/TLSv1.2/TLSv1/g /etc/ssl/openssl.cnf