Sorry, requires Python module sqlite3

[kg648]

Hi,

After updating sabnzbd via pkg using FreeBSD 11, I see the following error:

Code: Select all

service sabnzbd start
Starting sabnzbd.
Sorry, requires Python module sqlite3
Try: apt-get install python-pysqlite2
/usr/local/etc/rc.d/sabnzbd: WARNING: failed to start sabnzbd

(I assume the linux references as this is a port.)

I have checked and it seems sqlite3 is installed along with the python module:

Code: Select all

pkg info | grep sqlite
py27-sqlite3-2.7.13_7          Standard Python binding to the SQLite3 library (Python 2.7)
sqlite3-3.20.0_2               SQL database engine in a C library

I have checked the logs, nothing other than it failed to start, I have also tried to reinstall sabnzbd and the modules above.

Any suggestions as to what else I could try?

thanks

[kg648]

Fixed, upgraded to FreeBSD 11.1.

[safihre]

Good to know!

[augeaz]

Hi,

Sorry for reviving this old post.

I have the same problem.

It's a clean install of Build FreeNAS-11.1-U4

Followed by creating a fresh SABnzbd jail.
Next some standard pkg update, pkg upgrade, pkg install sabnzbdplus, etc.

Password for root@SABnzbd:
FreeBSD 11.1-STABLE (FreeNAS.amd64) #2 r321665+366f54a78b2(freenas/11.1-stable): Wed Mar 21 23:04:13 UTC 2018

root@SABnzbd:~ # service sabnzbd start
Starting sabnzbd.
Sorry, requires Python module sqlite3
Try: apt-get install python-pysqlite2
/usr/local/etc/rc.d/sabnzbd: WARNING: failed to start sabnzbd

root@SABnzbd:~ # pkg info | grep sqlite
py27-sqlite3-2.7.15_7 Standard Python binding to the SQLite3 library (Python 2.7)
sqlite3-3.23.1 SQL database engine in a C library

Can anyone help here as I am running out of ideas after rebuilding the jail a few times?

Thanks

[sander]

What is the output of:

Code: Select all

python -c "from sqlite3 import version as sqlite3_version"

Code: Select all

python -c "import sqlite3; print dir(sqlite3)"

[augeaz]

Hi sander,

Changed dots to commas cause of "New users are not allowed to post links."

Code: Select all

root@SABnzbd:~ # python -c "from sqlite3 import version as sqlite3_version"
python: Command not found.
root@SABnzbd:~ # ln -s /usr/local/bin/python2.7 /usr/bin/python
root@SABnzbd:~ # python -c "from sqlite3 import version as sqlite3_version"
Traceback (most recent call last):
File "<string>", 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: /usr/local/lib/libsqlite3,so,0: Undefined symbol "fdatasync"
root@SABnzbd:~ # python -c "import sqlite3; print dir(sqlite3)"
Traceback (most recent call last):
  File "<string>", 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: /usr/local/lib/libsqlite3,so,0: Undefined symbol "fdatasync"

Thanks

[sander]

Code: Select all

ImportError: /usr/local/lib/libsqlite3,so,0: Undefined symbol "fdatasync"

So: problem at system level (FreeBSD / libraries), not something inside SABnzbd. Proof: that one command you executed does not contain anything SABnzbd.

Solve at system level ... start by Googling the error message ... other FreeBSD users have it too

[augeaz]

Hi sander,

I found a solution googling around.

After creating a new jail type in the following.

Code: Select all

pkg lock sqlite3

I am not sure why but apparently the newer version of sqlite3 has some kind of a problem.

It worked for me.

Thanks

[sander]

Nice.

Thanks for your feedback