I have checked in a change to address this on trunk. Meanwhile, your work-around is to include the ".so" suffix on the library name. xample:
SELECT load_extension('mod_spatiallite.so'); On 5/6/18, a.furi...@lqt.it <a.furi...@lqt.it> wrote: > it seems that some unexpected regression is affecting load_extension() > on Linux when using the most recent versions of SQLite (3.22 and 3.23). > > my test configuration: > - sqlite3 installed on the current directory > - extension module installed on /usr/local/lib > (/usr/local/lib/mod_spatialite.so) > > $ export "LD_LIBRARY_PATH=/usr/local/lib" > $ ./sqlite3 > sqlite> SELECT load_extension('mod_spatialite'); > > - the extension module is successfully loaded when using 3.20.1 > - but it fails when using 3.22.0 or 3.23.1 > > digging into the code I was finally able to reestablish the expected > behavior of load_extension() after applying the following patch: > > sqlite3.c (v.3.23.1) - line 115917 - sqlite3LoadExtension() > ----------------------------------------------------------- > handle = sqlite3OsDlOpen(pVfs, zFile); > #if SQLITE_OS_UNIX || SQLITE_OS_WIN > for(ii=0; ii<ArraySize(azEndings) && handle==0; ii++){ > char *zAltFile = sqlite3_mprintf("%s.%s", zFile, azEndings[ii]); > int bExists = 0; > if( zAltFile==0 ) return SQLITE_NOMEM_BKPT; > /* > sqlite3OsAccess(pVfs, zAltFile, SQLITE_ACCESS_EXISTS, &bExists); > if( bExists ) > */ > handle = sqlite3OsDlOpen(pVfs, zAltFile); > sqlite3_free(zAltFile); > } > #endif > ----------------------------------------------------------- > > it seems that sqlite3OsAccess() fails to correctly locate the > module to be loaded because it checks just the current working > directory whilst sqlite3OsDlOpen() correctly searches more > directories, as the additional ones defined by LD_LIBRARY_PATH. > > bye > Sandro Furieri (developer and maintainer of SpatiaLite) > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users