ports/96177: sqlite3 doesn't compile threadsafe correctly

[jonathan]

>Number:         96177
>Category:       ports
>Synopsis:       sqlite3 doesn't compile threadsafe correctly
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Sun Apr 23 06:10:08 GMT 2006
>Closed-Date:
>Last-Modified:
>Originator:     jonathan
>Release:        6.0
>Organization:
>Environment:
FreeBSD rsrr1 6.0-STABLE FreeBSD 6.0-STABLE #1: Tue Nov  8 14:54:13 EST 2005     root at rsrr1:/usr/obj/usr/src/sys/CUSTOM  i386
>Description:
using the latest sqlite3, which i thought would have fixed this problem that has been around for a while ( sqlite-3.3.5 ) i can not link to sqlite3 if threads are required

i routinely get this response:
/usr/local/lib/libsqlite3.so: undefined reference to `pthread_create'
/usr/local/lib/libsqlite3.so: undefined reference to `pthread_equal'
/usr/local/lib/libsqlite3.so: undefined reference to `pthread_join'
>How-To-Repeat:
i first noticed this in exim-sqlite, but then saw it in a few other ports

cd /usr/ports/mail/exim-sqlite && make install 

you'll notice that sqlite3 is compilied threadsafe ( you can even do it manually if wanted ), but then we get to this:
---
cc exim_dbmbuild.c
cc -o exim_dbmbuild
/usr/local/lib/libsqlite3.so: undefined reference to `pthread_create'
/usr/local/lib/libsqlite3.so: undefined reference to `pthread_equal'
/usr/local/lib/libsqlite3.so: undefined reference to `pthread_join'
---
all the ports that require libsqlite3 w/threads seem to have this issue
>Fix:

>Release-Note:
>Audit-Trail:
>Unformatted: