模块未发现错误:运行 docker 映像时没有名为'turbodbc'的模块



我在代码中使用Cloudera Hive ODBC驱动程序,并尝试将应用程序容器化。下面是我的Dockerfile,

FROM ubuntu:18.04
FROM continuumio/anaconda3
FROM node:10

RUN conda update -n base -c defaults conda
RUN conda create -n env python=3.7
RUN echo "conda activate env" > ~/.bashrc
ENV PATH /opt/conda/envs/env/bin:$PATH
RUN apt-get update && apt-get install -y 
curl apt-utils apt-transport-https debconf-utils gcc build-essential 
&& rm -rf /var/lib/apt/lists/*
RUN apt-get update && apt-get install -y 
python-pip python-dev python-setuptools 
--no-install-recommends 
&& rm -rf /var/lib/apt/lists/*
RUN pip install --upgrade pip
RUN pip install pyyaml pandas numpy pymysql sqlalchemy schedule tornado
RUN apt-get update && apt-get install -y --no-install-recommends git unzip unixodbc unixodbc-dev
RUN conda install -c conda-forge turbodbc=3.1.1
RUN apt-get update && apt-get install -y gettext nano vim -y
RUN yarn install --modules-folder ./static
WORKDIR /app
COPY entry.sh /usr/local/bin/
COPY . /app/
ENV SSH_PASSWD "root:Docker!"
RUN apt-get update 
&& apt-get install -y --no-install-recommends dialog 
&& apt-get update 
&& apt-get install -y --no-install-recommends openssh-server 
&& echo "$SSH_PASSWD" | chpasswd 
COPY sshd_config /etc/ssh/
COPY entry.sh /usr/local/bin/
RUN chmod u+x /usr/local/bin/entry.sh
EXPOSE 5000 2222 22 80 8000
CMD ["entry.sh"]

构建图像越来越成功,但我看到当我运行docker图像时,我看到下面的错误

Traceback (most recent call last):

File "app.py", line 14, in <module>
from abc_scheduler import scheduler_main
File "/app/abc_scheduler.py", line 5, in <module>
from methods import Methods
File "/app/methods.py", line 10, in <module>
from utils import *
File "/app/utils.py", line 2, in <module>
from turbodbc import connect, make_options
ModuleNotFoundError: No module named 'turbodbc'

我在Dockerfile中尝试过许多其他ODBC,但没有成功。任何帮助都会很棒。

根据@DavidMaze的建议,我成功地创建了一个Dockerfile&显示在下方

FROM ubuntu:latest
FROM continuumio/anaconda3
FROM node:10
RUN conda update -n base -c defaults conda
RUN conda create -n env python=3.7
RUN echo 'conda init bash' >/.bashrc
RUN echo "conda activate env" > ~/.bashrc
ENV PATH /opt/conda/envs/env/bin:$PATH
RUN apt-get update && apt-get install -y 
curl apt-utils apt-transport-https debconf-utils gcc build-essential 
&& rm -rf /var/lib/apt/lists/*
RUN apt-get update && apt-get install -y 
python-pip python-dev python-setuptools 
--no-install-recommends 
&& rm -rf /var/lib/apt/lists/*
RUN pip install --upgrade pip
# ==================TURBODBC========================
RUN apt-get update
RUN apt-get upgrade -y
RUN apt-get dist-upgrade -y
RUN apt-get install -y alien # optional
COPY ClouderaHiveODBC-2.6.1.1001-1.x86_64.rpm /opt/cloudera/
RUN alien /opt/cloudera/ClouderaHiveODBC-2.6.1.1001-1.x86_64.rpm
RUN dpkg -i clouderahiveodbc_2.6.1.1001-2_amd64.deb
# ==================END=============================
RUN conda install --name env -c conda-forge turbodbc=4.1.1 tornado=6.0.4 pyyaml pymysql schedule sqlalchemy pyarrow numpy=1.19.3
pandas=1.1.4  pybind11 pyarrow
COPY odbc.ini /etc/
RUN apt-get update && apt-get install -y gettext nano vim -y
RUN yarn install --modules-folder ./static
WORKDIR /app
COPY . /app/
ENV SSH_PASSWD "root:Docker!"
RUN apt-get update 
&& apt-get install -y --no-install-recommends dialog 
&& apt-get update 
&& apt-get install -y --no-install-recommends openssh-server 
&& echo "$SSH_PASSWD" | chpasswd 
COPY sshd_config /etc/ssh/
COPY entry.sh /usr/local/bin/
RUN chmod u+x /usr/local/bin/entry.sh
EXPOSE 9988 2222 22 80 8000
CMD ["entry.sh"]

在当前目录中保留ClouderaHiveODBC-2.6.1.1001-1.x86_64.rpm的副本同时保留以下文件:

odbc.ini-具有数据库信息

entry.sh-它是shell脚本,有一个命令-python app.py

ssh_config-没有任何扩展名的文件具有如下所示的信息

Port                    2222
ListenAddress           0.0.0.0
LoginGraceTime          180
X11Forwarding           yes
Ciphers                 aes128-cbc,3des-cbc,aes256-cbc
MACs                    hmac-sha1,hmac-sha1-96
StrictModes             yes
SyslogFacility          DAEMON
PrintMotd               no
IgnoreRhosts            no
#deprecated option
#RhostsAuthentication   no
RhostsRSAAuthentication yes
RSAAuthentication       no
PasswordAuthentication  yes
PermitEmptyPasswords    no
PermitRootLogin         yes

我想通过展示一种无需conda即可工作的方法来扩展答案。换句话说,一个完整的pip最低可行的docker设置,用于安装涡轮数据库。我已经在官方的turbodbc repo中的Github评论中完整地记录了该解决方案。

最新更新