Fails to load sqlite_extension, bails out

[Guido Falsi]

I'm the maintainer of the FreeBSD calibre port.

I'm testing update of the port to 5.23.0. When I try to run calibre I get this error:

calibre, version 5.23.0
ERROR: Bad database location: Bad database location '###'. calibre will now quit.

Traceback (most recent call last):
  File "/usr/local/lib/calibre/calibre/gui2/main.py", line 304, in initialize_db_stage2
    db = LibraryDatabase(candidate)
  File "/usr/local/lib/calibre/calibre/db/legacy.py", line 188, in __init__
    backend = self.backend = create_backend(library_path, default_prefs=default_prefs,
  File "/usr/local/lib/calibre/calibre/db/legacy.py", line 45, in create_backend
    return DB(library_path, default_prefs=default_prefs,
  File "/usr/local/lib/calibre/calibre/db/backend.py", line 463, in __init__
    if self.user_version == 0:
  File "/usr/local/lib/calibre/calibre/db/backend.py", line 1214, in user_version
    return self.conn.get('pragma user_version;', all=False)
  File "/usr/local/lib/calibre/calibre/db/backend.py", line 927, in conn
    self._conn = Connection(self.dbpath)
  File "/usr/local/lib/calibre/calibre/db/backend.py", line 342, in __init__
    plugins.load_apsw_extension(self, 'sqlite_extension')
  File "/usr/local/lib/calibre/calibre/constants.py", line 325, in load_apsw_extension
    conn.enableloadextension(True)
AttributeError: 'Connection' object has no attribute 'enableloadextension'

Looks like the Connection object is not bein gproperly initialized, I took a lok at the code but I can't really understand why.

The recent changes in src/calibre/db/backend.py:342 seem to be the cause, but I am unable to find a fix.

Thanks in advance.

[Kovid Goyal (kovid)]

See the line
AttributeError: 'Connection' object has no attribute 'enableloadextension'

you need to build apsw with sqlite extension loading enabled.

 status invalid

[Guido Falsi (madpilot78)]

Thanks a lot for pointing me in the right direction. It would have taken me some time to find out this.

I'll see if the default can be switched for python apsw in the FreeBSD ports tree.