python2.7安装sqlite3模块


摘要:使用sqlmap时遇到一个问题,需要给python安装sqlite3。记录下安装过程!

安装sqlite3

尝试使用pip安装,安装失败:

[root@mysql1 src]# pip install sqlite3
Collecting sqlite3
Using cached sqlite3-99.0.tar.gz
Complete output from command python setup.py egg_info:
Traceback (most recent call last):
File "<string>", line 1, in <module>
File "/tmp/pip-build-GKbPwN/sqlite3/setup.py", line 2, in <module>
raise RuntimeError("Package 'sqlite3' must not be downloaded from pypi")
RuntimeError: Package 'sqlite3' must not be downloaded from pypi
----------------------------------------
Command "python setup.py egg_info" failed with error code 1 in /tmp/pip-build-GKbPwN/sqlite3/

下载安装sqlite3

[root@mysql1 src]# wget https://sqlite.org/2017/sqlite-autoconf-3190300.tar.gz
[root@mysql1 src]# tar -xvf sqlite-autoconf-3190300.tar.gz
[root@mysql1 sqlite-autoconf-3190300]# ./configure --prefix=/usr/local/lib/python2.7/dist-packages/sqlite3
[root@mysql1 sqlite-autoconf-3190300]# make && make install
安装完毕后发现导入sqlite3仍然失败,只能重装python了
>>> import sqlite3
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python2.7/sqlite3/__init__.py", line 24, in <module>
from dbapi2 import *
File "/usr/local/lib/python2.7/sqlite3/dbapi2.py", line 28, in <module>
from _sqlite3 import *
ImportError: No module named _sqlite3
>>> exit()

修改python安装源文件setup.py

[root@mysql1 src]# tar -xvf Python-2.7.10.tgz
[root@mysql1 src]# cd Python-2.7.10
[root@mysql1 Python-2.7.10]# vi setup.py
搜索sqlite3找到第1105行,在其下面加入一行上面我们安装的sqlite3的路径:
1097 # We hunt for #define SQLITE_VERSION "n.n.n"
1098 # We need to find >= sqlite version 3.0.8
1099 sqlite_incdir = sqlite_libdir = None
1100 sqlite_inc_paths = [ '/usr/include',
1101 '/usr/include/sqlite',
1102 '/usr/include/sqlite3',
1103 '/usr/local/include',
1104 '/usr/local/include/sqlite',
1105 '/usr/local/include/sqlite3',
1106 '/usr/local/lib/python2.7/dist-packages/sqlite3', #新增此行
1107 ]
保存退出。

重新编译python2.7

[root@mysql1 Python-2.7.10]# ./configure
[root@mysql1 Python-2.7.10]# make && make install

验证安装

检查lib文件是否生成

[root@mysql1 Python-2.7.10]# ll /usr/local/lib/python2.7/lib-dynload/_sqlite3.so
-rwxr-xr-x 1 root root 243444 Aug 30 01:15 /usr/local/lib/python2.7/lib-dynload/_sqlite3.so

验证sqlite3模块导入是否成功

[root@mysql1 Python-2.7.10]# python
Python 2.7.10 (default, Aug 30 2017, 01:14:38)
[GCC 4.4.7 20120313 (Red Hat 4.4.7-16)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> exit()
[root@mysql1 Python-2.7.10]#

<完>

文章目录
  1. 1. 安装sqlite3
    1. 1.1. 尝试使用pip安装,安装失败:
    2. 1.2. 下载安装sqlite3
    3. 1.3. 修改python安装源文件setup.py
    4. 1.4. 重新编译python2.7
  2. 2. 验证安装
    1. 2.1. 检查lib文件是否生成
    2. 2.2. 验证sqlite3模块导入是否成功
|