非root解决ModuleNotFoundError: No module named ‘_sqlite3‘_pysqlite3 非root 用户 pip 安装失败

今天在pip安装pymatgen的时候发现一个很神奇的问题，ModuleNotFoundError: No module named ‘_sqlite3’。查看网上的说法是需要安装sqlite3，结果因为机器还在调试，根本没有sqlite3，而且因为非root，所以无法直接yum install或者apt-get install。解决方案如下。

python安装

wget https://www.python.org/ftp/python/3.8.2/Python-3.8.2.tgz
tar zxvf Python-3.8.2.tgz
cd Python-3.8.2
./configure --prefix=--prefix=${python3_install_PATH} --enable-loadable-sqlite-extensions
make
make install
alias python=${python3_install_PATH}/bin/python3.8
alias pip=${python3_install_PATH}/bin/pip3
1
2
3
4
5
6
7
8

sqlite3安装

wget https://www.sqlite.org/2024/sqlite-src-3450000.zip
unzip sqlite-src-3450000.zip
cd sqlite-src-3450000
./configure --prefix=${sqlite_install_PATH}
make
make install
1
2
3
4
5
6

pysqlite3安装

wget https://files.pythonhosted.org/packages/0e/37/33f0c3a77b0b8e34f09ddc3b997f18d5c7c7f5d8b86d2d555ad04ca2abb7/pysqlite3-0.5.2.tar.gz
tar zxvf pysqlite3-0.5.2.tar.gz
cd pysqlite3-0.5.2
cp ${sqlite_install_PATH}/include/sqlite.h ./
cp ${sqlite_src_PATH}/sqlite.c ./
python setup.py build_static build
cp pysqlite3-0.5.2/build/lib.linux-aarch64-3.8/pysqlite3/_sqlite3.cpython-38-aarch64-linux-gnu.so ${python3_install_path}/lib/python3.8/lib-dynload
1
2
3
4
5
6
7

验证

import sqlite3
1