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 » August 20th, 2017, 2:02 am

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 » August 20th, 2017, 2:48 am

Fixed, upgraded to FreeBSD 11.1.

User avatar
safihre
Administrator
Administrator
Posts: 2816
Joined: April 30th, 2015, 7:35 am
Location: Switzerland
Contact:

Re: Sorry, requires Python module sqlite3

Post by safihre » August 20th, 2017, 2:52 am

Good to know!

augeaz
Newbie
Newbie
Posts: 3
Joined: May 29th, 2018, 4:48 pm

Re: Sorry, requires Python module sqlite3

Post by augeaz » May 29th, 2018, 5:02 pm

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 [email protected]:
FreeBSD 11.1-STABLE (FreeNAS.amd64) #2 r321665+366f54a78b2(freenas/11.1-stable): Wed Mar 21 23:04:13 UTC 2018

[email protected]:~ # 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

[email protected]:~ # 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: 6462
Joined: January 22nd, 2008, 2:22 pm

Re: Sorry, requires Python module sqlite3

Post by sander » May 29th, 2018, 11:41 pm

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 » May 30th, 2018, 2:19 am

Hi sander,

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

Code: Select all

[email protected]:~ # python -c "from sqlite3 import version as sqlite3_version"
python: Command not found.
[email protected]:~ # ln -s /usr/local/bin/python2.7 /usr/bin/python
[email protected]:~ # 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"
[email protected]:~ # 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: 6462
Joined: January 22nd, 2008, 2:22 pm

Re: Sorry, requires Python module sqlite3

Post by sander » May 30th, 2018, 2:34 am

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 » May 30th, 2018, 4:05 pm

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: 6462
Joined: January 22nd, 2008, 2:22 pm

Re: Sorry, requires Python module sqlite3

Post by sander » May 31st, 2018, 1:24 pm

Nice.

Thanks for your feedback

Post Reply