linux Python pysqlite2安装的方法 sqlite3升级数据库

小樱

[root@207 flexget]# flexget check
2018-03-20 06:34 VERBOSE  manager                       Creating new database /etc/flexget/db-config.sqlite - DO NOT INTERUPT ...
FATAL: Unable to use SQLite. Are you running Python 2.7, 3.3 or newer ?
Python should normally have SQLite support built in.
If you're running correct version of Python then it is not equipped with SQLite.
You can try installing `pysqlite`. If you have compiled python yourself, recompile it with SQLite support.
Error: /usr/local/lib/python2.7/site-packages/pysqlite2/_sqlite.so: undefined symbol: sqlite3_stmt_readonly
[root@207 flexget]#

一些程序报错，手动安装

1. yum -y install sqlite-devel
   
2. wget https://pypi.python.org/packages/42/02/981b6703e3c83c5b25a829c6e77aad059f9481b0bbacb47e6e8ca12bd731/pysqlite-2.8.3.tar.gz#md5=033f17b8644577715aee55e8832ac9fc
   
3. pysqlite-2.8.3.tar.gz
   
4. tar xzf pysqlite-2.8.3.tar.gz
   
5. cd pysqlite-2.8.3
   
6. python setup.py install
   

复制代码

错误也没有解决，其实这个贴也是扯淡的，，不过有了点经验，可能是其它原因，根据上面的报错，打印看到sqlite相关的只有/usr/lib64/libsqlite3.so.0没有结果，说明问题出在sqlite版本上，可能当前的sqlite版本太老，没有提供sqlite3_stmt_readonly这个函数

1. nm /usr/local/lib/python2.7/site-packages/pysqlite2/_sqlite.so | grep sqlite3_stmt_readonly

复制代码

U sqlite3_stmt_readonly

1. ldd /usr/local/lib/python2.7/site-packages/pysqlite2/_sqlite.so

复制代码

        linux-vdso.so.1 =>  (0x00007ffc20074000)
        libsqlite3.so.0 => /usr/lib64/libsqlite3.so.0 (0x00007fd514e95000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fd514c78000)
        libc.so.6 => /lib64/libc.so.6 (0x00007fd5148e3000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007fd5146df000)
        /lib64/ld-linux-x86-64.so.2 (0x00007fd515340000)

打印当前版本号
sqlite3 -version
3.6.20

我们升级下。。。

1. wget https://www.sqlite.org/2018/sqlite-autoconf-3220000.tar.gz
   
2. tar xvzf sqlite-autoconf-3220000.tar.gz
   
3. cd sqlite-autoconf-3220000
   
4. ./configure
   
5. make -j 4
   
6. make install

复制代码

然后再打印版本号，，，怎么没变？
[root@207 ~]# sqlite3
SQLite version 3.22.0 2018-01-22 18:45:57
这里倒是看到变动了

后面，，，又不知道怎么办了，，之后再补充

补充。。
特么直接
yum -y install sqlite-devel
然后，重新编译Python安装就好了