Page 1 of 1

Sorry, requires Python module sqlite3

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

Re: Sorry, requires Python module sqlite3

Posted: August 20th, 2017, 2:48 am
by kg648
Fixed, upgraded to FreeBSD 11.1.

Re: Sorry, requires Python module sqlite3

Posted: August 20th, 2017, 2:52 am
by safihre
Good to know!

Re: Sorry, requires Python module sqlite3

Posted: May 29th, 2018, 5:02 pm
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 [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

Re: Sorry, requires Python module sqlite3

Posted: May 29th, 2018, 11:41 pm
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)"

Re: Sorry, requires Python module sqlite3

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

Re: Sorry, requires Python module sqlite3

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

Re: Sorry, requires Python module sqlite3

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

Re: Sorry, requires Python module sqlite3

Posted: May 31st, 2018, 1:24 pm
by sander
Nice.

Thanks for your feedback