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 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
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
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
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.
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