记一次pip install pymysql失败问题解决(离线安装pip)

落日映苍穹つ 2022-09-04 06:42 871阅读 0赞

### 文章目录 ###

> 背景：需要在docker环境中执行python代码，docker镜像为使用公司基础镜像打包生成，即python版本等固定。

代码如下：

# -*- coding:utf-8 -*-
    # 连接mysql打印指定表的所有字段
    import subprocess
    import sys
    import time
    import datetime
    import json
    import requests
    import pymysql
    from optparse import OptionParser
    
    
    def runTransmitTasks(host, port, user, password, db, table):
    
        try:
    
            # 连接mysql获取字段列表
            conn = pymysql.connect(host=host, user=user, password=password, database=db, port=port)
            cur = conn.cursor()
            sql = "select COLUMN_NAME from information_schema.COLUMNS where table_name = '%s'" % table
            cur.execute(sql)
            for field in cur.fetchall():
                print(field[0])
            cur.close()
            conn.close()
    
        except Exception as e:
            print('Error Info:',e)
        return 0
    
    
    if __name__ == "__main__":
    
        runTransmitTasks("127.0.0.1", 3306, "root", "root", "dbname", "tablename")

在进入容器环境下执行上面代码，报错`No module named pymysql`：

[root@hostxxxxx /]# python test.py
    Traceback (most recent call last):
      File "test.py", line 7, in <module>
        import pymysql
    ImportError: No module named pymysql

通过`pip install pymysql`进行安装时：

[root@hostxxxxx /]# pip install pymysql
    Collecting pymysql
      Downloading https://files.pythonhosted.org/packages/60/ea/33b8430115d9b617b713959b21dfd5db1df77425e38efea08d121e83b712/PyMySQL-1.0.2.tar.gz (45kB)
        100% |████████████████████████████████| 51kB 153kB/s
        Complete output from command python setup.py egg_info:
        Traceback (most recent call last):
          File "<string>", line 1, in <module>
          File "/tmp/pip-build-cdgr1c/pymysql/setup.py", line 6, in <module>
            with open("./README.rst", encoding="utf-8") as f:
        TypeError: 'encoding' is an invalid keyword argument for this function
    
        ----------------------------------------
    Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-cdgr1c/pymysql/
    You are using pip version 8.1.2, however version 21.2.3 is available.
    You should consider upgrading via the 'pip install --upgrade pip' command.

根据提示信息对pip进行升级时又报错如下：

[root@hostxxxxx /]# pip install --upgrade pip
    Collecting pip
      Downloading https://files.pythonhosted.org/packages/e1/63/7c0e553ae0513ebf1858f08030158ff5998324013e0ba4c2e1c00b85df79/pip-21.2.3.tar.gz (1.6MB)
        100% |████████████████████████████████| 1.6MB 278kB/s
        Complete output from command python setup.py egg_info:
        Traceback (most recent call last):
          File "<string>", line 1, in <module>
          File "/tmp/pip-build-4YKpdG/pip/setup.py", line 7
            def read(rel_path: str) -> str:
                             ^
        SyntaxError: invalid syntax
    
        ----------------------------------------
    Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-4YKpdG/pip/
    You are using pip version 8.1.2, however version 21.2.3 is available.
    You should consider upgrading via the 'pip install --upgrade pip' command.

而在本地pycharm中进行`pip install pymysql`是没问题的，考虑是不是python版本差异导致。

查看本地python版本：

(venv) xxxx xxxx % python --version
    Python 2.7.16

查看容器环境中python版本：

[root@hostxxxxx /]# python --version
    Python 2.7.5

搜索中发现了如下博文解决了问题：  
[centos python2.7.5 离线环境安装 pip 和 PyMySQL-0.9.3][centos python2.7.5 _ pip _ PyMySQL-0.9.3]

根本解决方案就是离线安装pip。

可以在国内清华的镜像仓库中进行镜像安装文件的查找：

[https://pypi.tuna.tsinghua.edu.cn/simple/][https_pypi.tuna.tsinghua.edu.cn_simple]

如下进行要安装pip包的检索：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI0MDk1MDU1_size_16_color_FFFFFF_t_70]  
进去下级目录后选择合适版本下载：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI0MDk1MDU1_size_16_color_FFFFFF_t_70 1]  
直接wget下载安装：

[root@hostxxxxx /]# wget https://pypi.tuna.tsinghua.edu.cn/packages/ed/39/15045ae46f2a123019aa968dfcba0396c161c20f855f11dea6796bcaae95/PyMySQL-0.9.3-py2.py3-none-any.whl#sha256=3943fbbbc1e902f41daf7f9165519f140c4451c179380677e6a848587042561a
    --2021-08-11 19:58:23--  https://pypi.tuna.tsinghua.edu.cn/packages/ed/39/15045ae46f2a123019aa968dfcba0396c161c20f855f11dea6796bcaae95/PyMySQL-0.9.3-py2.py3-none-any.whl
    Resolving pypi.tuna.tsinghua.edu.cn (pypi.tuna.tsinghua.edu.cn)... 101.6.15.130, 2402:f000:1:400::2
    Connecting to pypi.tuna.tsinghua.edu.cn (pypi.tuna.tsinghua.edu.cn)|101.6.15.130|:443... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: 47738 (47K) [application/octet-stream]
    Saving to: ‘PyMySQL-0.9.3-py2.py3-none-any.whl’
    
    100%[============================================================================================>] 47,738      --.-K/s   in 0.001s
    
    2021-08-11 19:58:23 (30.5 MB/s) - ‘PyMySQL-0.9.3-py2.py3-none-any.whl’ saved [47738/47738]
    
    [root@hostxxxxx /]# pip install PyMySQL-0.9.3-py2.py3-none-any.whl
    Processing ./PyMySQL-0.9.3-py2.py3-none-any.whl
    Installing collected packages: PyMySQL
    Successfully installed PyMySQL-0.9.3
    You are using pip version 8.1.2, however version 21.2.3 is available.
    You should consider upgrading via the 'pip install --upgrade pip' command.

如上所示，安装成功，再次执行：

[root@hostxxxxx /]# python test.py
    id
    name
    requester
    status
    module
    type
    business
    comments
    sys_created_on
    sys_updated_on
    sys_created_by
    sys_updated_by

问题成功解决。

[centos python2.7.5 _ pip _ PyMySQL-0.9.3]: https://blog.csdn.net/weixin_45189629/article/details/107356924
[https_pypi.tuna.tsinghua.edu.cn_simple]: https://pypi.tuna.tsinghua.edu.cn/simple/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI0MDk1MDU1_size_16_color_FFFFFF_t_70]: /images/20220829/6ec3e57ab8d64fffb9fdaf3e96bd7a80.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI0MDk1MDU1_size_16_color_FFFFFF_t_70 1]: /images/20220829/615aecd410ad4a1082d5c69221294753.png