Sorry, requires Python module sqlite3

Support for the freeBSD package, created by dbrooks
Post Reply
kg648
Newbie
Newbie
Posts: 2
Joined: August 20th, 2017, 1:58 am

Sorry, requires Python module sqlite3

Post by 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
Newbie
Newbie
Posts: 2
Joined: August 20th, 2017, 1:58 am

Re: Sorry, requires Python module sqlite3

Post by kg648 »

Fixed, upgraded to FreeBSD 11.1.
User avatar
safihre
Administrator
Administrator
Posts: 5338
Joined: April 30th, 2015, 7:35 am
Contact:

Re: Sorry, requires Python module sqlite3

Post by safihre »

Good to know!
If you like our support, check our special newsserver deal or donate at: https://sabnzbd.org/donate
augeaz
Newbie
Newbie
Posts: 3
Joined: May 29th, 2018, 4:48 pm

Re: Sorry, requires Python module sqlite3

Post by 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
User avatar
sander
Release Testers
Release Testers
Posts: 8811
Joined: January 22nd, 2008, 2:22 pm

Re: Sorry, requires Python module sqlite3

Post by 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
Newbie
Newbie
Posts: 3
Joined: May 29th, 2018, 4:48 pm

Re: Sorry, requires Python module sqlite3

Post by 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
User avatar
sander
Release Testers
Release Testers
Posts: 8811
Joined: January 22nd, 2008, 2:22 pm

Re: Sorry, requires Python module sqlite3

Post by 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
Newbie
Newbie
Posts: 3
Joined: May 29th, 2018, 4:48 pm

Re: Sorry, requires Python module sqlite3

Post by 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
User avatar
sander
Release Testers
Release Testers
Posts: 8811
Joined: January 22nd, 2008, 2:22 pm

Re: Sorry, requires Python module sqlite3

Post by sander »

Nice.

Thanks for your feedback
Post Reply