Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 316489 - sqlite-3.6.22-r2 has undefined symbol sqlite3_enable_load_extension
Summary: sqlite-3.6.22-r2 has undefined symbol sqlite3_enable_load_extension
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Library (show other bugs)
Hardware: AMD64 Linux
: High normal
Assignee: Arfrever Frehtes Taifersar Arahesis (RETIRED)
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-21 09:41 UTC by Postmodern
Modified: 2010-05-21 00:31 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Postmodern 2010-04-21 09:41:54 UTC
After installing sqlite-3.6.22-r2 with FEATURES="nostrip", various Ruby bindings which compiled C extensions against libsqlite3.so began to fail. This was due to the C extensions being unable to find the symbol "sqlite3_enable_load_extension" at runtime when libsqlite3.so was loaded.

After further inspection, I found that the symbol was not listed in symbols table in libsqlite3.so, but was listed in the sqlite3.h header file.

$ nm -D /usr/lib/libsqlite3.so.0.8.6 | grep sqlite3_enable_load_extension
$ nm /usr/lib/libsqlite3.a | grep sqlite3_enable_load_extension
$ file /usr/lib/libsqlite3.so.0.8.6 
/usr/lib/libsqlite3.so.0.8.6: ELF 64-bit LSB shared object, x86-64, version 1 (SYSV), dynamically linked, not stripped
grep -r sqlite3_enable_load_extension /usr/include/sqlite3.h 
** [sqlite3_enable_load_extension()] prior to calling this API,
** ^Call the sqlite3_enable_load_extension() routine with onoff==1
SQLITE_API int sqlite3_enable_load_extension(sqlite3 *db, int onoff);

I believe this is due to SQLITE_API not being defined by autoconf. Typically, it should be defined as "extern". If sqlite3_enable_load_extension is part of libsqlite3's private API, then it should not be defined in the header file at all.

Reproducible: Always

Steps to Reproduce:
1. emerge sqlite
2. nm -D /usr/lib/libsqlite3.so.0.8.6 | grep sqlite3_enable_load_extension


Expected Results:  
The symbol is exposed.

Portage 2.1.8.3 (default/linux/amd64/10.0/desktop/gnome, gcc-4.3.4-hardenednopie, glibc-2.10.1-r1, 2.6.28-hardened-r9 x86_64)
=================================================================
System uname: Linux-2.6.28-hardened-r9-x86_64-AMD_Athlon-tm-_64_Processor_3400+-with-gentoo-1.12.13
Timestamp of tree: Wed, 21 Apr 2010 09:00:01 +0000
app-shells/bash:     4.0_p37
dev-java/java-config: 2.1.10
dev-lang/python:     2.6.4-r1
dev-util/cmake:      2.6.4-r3
sys-apps/baselayout: 1.12.13
sys-apps/sandbox:    1.6-r2
sys-devel/autoconf:  2.13, 2.63-r1
sys-devel/automake:  1.9.6-r2, 1.10.3, 1.11.1
sys-devel/binutils:  2.18-r3
sys-devel/gcc:       3.4.6-r2, 4.3.4
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6b
virtual/os-headers:  2.6.30-r1
ACCEPT_KEYWORDS="amd64"
ACCEPT_LICENSE="*"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-march=athlon64 -O2 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c"
CXXFLAGS="-march=athlon64 -O2 -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="assume-digests distlocks fixpackages news nostrip parallel-fetch protect-owned sandbox sfperms strict unmerge-logs unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org"
LANG="C"
LDFLAGS="-Wl,-O1"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="X a52 aac acl acpi alsa amd64 bash-completion berkdb branding bzip2 cairo cdr cli consolekit cracklib crypt cxx dbus doc dri dts dvd dvdr eds emboss encode exif fam firefox flac fortran gdbm gdu gif gnome gnome-keyring gpm gstreamer gtk hal iconv ipv6 jpeg lcms libnotify mad mikmod mmx mng modules mp3 mp4 mpeg mudflap multilib nautilus ncurses network nls nptl nptlonly ogg opengl openmp pam pango pcre pdf perl png policykit ppds pppd python readline reflection sdl session spell spl sqlite3 sse sse2 ssl startup-notification svg sysfs tcpd theora tiff truetype unicode usb vorbis x264 xcb xml xorg xulrunner xv xvid zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="fbdev glint intel mach64 mga neomagic nv r128 radeon savage sis tdfx trident vesa via vmware voodoo" 
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, LINGUAS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS, PORTDIR_OVERLAY
Comment 1 Postmodern 2010-05-21 00:31:12 UTC
I tracked this down to the "extensions" USE-flag for dev-db/sqlite not being enabled.