sqlite3 breakage

[Tijl Coosemans]

On Sun, 19 Oct 2014 14:28:08 +0100 John <freebsd-ports at potato.growveg.org> wrote:
> sqlite3 appears to be breaking things in multiple places.
> 
> using generic amd64 r273255 and ports 371178
> 
> I get errors like this whenever sqlite3 is called as a dependency. So, in 
> /data/ports/devel/libsoup-gnome:
> 
> ===>  Building for libsoup-gnome-2.40.3_4
> cd /data/ports/devel/libsoup-gnome/work/libsoup-2.40.3/libsoup && gmake libsoup-gnome-2.4.la
> gmake[1]: Entering directory '/data/ports/devel/libsoup-gnome/work/libsoup-2.40.3/libsoup'
>   CC       soup-cookie-jar-sqlite.lo
>   CC       soup-gnome-features.lo
>   CC       soup-proxy-resolver-gnome.lo
>   CC       soup-password-manager-gnome.lo
>   CCLD     libsoup-gnome-2.4.la
> /usr/bin/ld: /usr/local/lib/libsqlite3.a(sqlite3.o): relocation R_X86_64_32S against `a local symbol' can not be used when making a shared object; recompile with -fPIC
> /usr/local/lib/libsqlite3.a: could not read symbols: Bad value
> cc: error: linker command failed with exit code 1 (use -v to see invocation)
> Makefile:721: recipe for target 'libsoup-gnome-2.4.la' failed
> gmake[1]: *** [libsoup-gnome-2.4.la] Error 1
> gmake[1]: Leaving directory '/data/ports/devel/libsoup-gnome/work/libsoup-2.40.3/libsoup'
> *** Error code 2
> 
> Stop.
> make: stopped in /data/ports/devel/libsoup-gnome
> 
> #######################################################
> 
> in pidgin:
> 
> aking all in cap
> gmake[4]: Entering directory '/data/ports/net-im/pidgin/work/pidgin-2.10.9/pidgin/plugins/cap'
>   CC     cap.lo
> cap.c:97:9: warning: assigning to 'char *' from 'const char *' discards qualifiers [-Wincompatible-pointer-types-discards-qualifiers]
>         sta_id = purple_status_get_id(get_status_for(buddy));
>                ^ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 1 warning generated.
>   CCLD   cap.la
> /usr/bin/ld: /usr/local/lib/libsqlite3.a(sqlite3.o): relocation R_X86_64_32S against `a local symbol' can not be used when making a shared object; recompile with -fPIC
> /usr/local/lib/libsqlite3.a: could not read symbols: Bad value
> cc: error: linker command failed with exit code 1 (use -v to see invocation)
> Makefile:482: recipe for target 'cap.la' failed
> gmake[4]: *** [cap.la] Error 1
> gmake[4]: Leaving directory '/data/ports/net-im/pidgin/work/pidgin-2.10.9/pidgin/plugins/cap'
> Makefile:902: recipe for target 'all-recursive' failed
> gmake[3]: *** [all-recursive] Error 1
> gmake[3]: Leaving directory '/data/ports/net-im/pidgin/work/pidgin-2.10.9/pidgin/plugins'
> Makefile:895: recipe for target 'all-recursive' failed
> gmake[2]: *** [all-recursive] Error 1
> gmake[2]: Leaving directory '/data/ports/net-im/pidgin/work/pidgin-2.10.9/pidgin'
> ===> Compilation failed unexpectedly.
> Try to set MAKE_JOBS_UNSAFE=yes and rebuild before reporting the failure to
> the maintainer.
> *** Error code 1
> 
> Stop.
> make[1]: stopped in /data/ports/net-im/pidgin
> *** Error code 1
> 
> Stop.
> make: stopped in /data/ports/net-im/pidgin
> 
> ########################################################
> 
> Rebuilt sqlite3 from the ports, which made no difference.
> There are other ports affected. How can I fix this?

Check that you have these files in /usr/local/lib:

libsqlite3.a
libsqlite3.so
libsqlite3.so.0
libsqlite3.so.0.8.6

If any are missing then make sure you have the latest version of pkg.
It fixes a bug that allowed packages with missing files to be installed.
Then build databases/sqlite3 using 'script build.log make install' and
email us build.log.