amd64/164691: compiling database/proftpd-mod_sql_postgres do not add backend to Proftpd

[Torsten Zühlsdorff]

>Number:         164691
>Category:       amd64
>Synopsis:       compiling database/proftpd-mod_sql_postgres do not add backend to Proftpd
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    freebsd-amd64
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Wed Feb 01 14:40:09 UTC 2012
>Closed-Date:
>Last-Modified:
>Originator:     Torsten Zühlsdorff
>Release:        8.2-RELEASE
>Organization:
>Environment:
FreeBSD 8.2-RELEASE-p3 FreeBSD 8.2-RELEASE-p3 #0: Tue Sep 27 18:45:57 UTC 2011     root at amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC  amd64
>Description:
After building Proftpd 1.3.4a (maint) with an SQL-Backend, the backend is not registered in Proftpd. Both, database/proftpd-mod_sql_postgres and database/proftpd-mod_sql_mysql, are not working.

Example of Proftp output after building proftpd and the proftpd-mod_sql_postgres and database/proftpd-mod_sql_mysql port:
Built With:
    configure  '--localstatedir=/var/run' '--libexecdir=/usr/local/libexec/proftpd' '--with-pkgconfig=libdata/pkgconfig' '--sysconfdir=/usr/local/etc' '--enable-dso' '--disable-sendfile' '--enable-ipv6' '--enable-nls' '--enable-pcre' '--enable-ctrls' '--disable-memcache' '--with-shared=mod_ratio:mod_readme:mod_rewrite:mod_copy:mod_deflate:mod_ifsession:mod_ifversion:mod_radius:mod_quotatab_file:mod_quotatab_sql:mod_quotatab:mod_sftp:mod_sql:mod_tls:mod_wrap2' '--with-includes=:/usr/local/include:/usr/local/include:/include' '--with-libraries=:/usr/local/lib:/usr/local/lib:/usr/local/lib' '--prefix=/usr/local' '--mandir=/usr/local/man' '--infodir=/usr/local/info/' '--build=amd64-portbld-freebsd8.2' 'build_alias=amd64-portbld-freebsd8.2' 'CC=cc' 'CFLAGS=-O2 -pipe -DHAVE_OPENSSL -I/usr/include -fno-strict-aliasing' 'LDFLAGS= -rpath=/usr/lib:/usr/local/lib' 'LIBS=-lintl -L/usr/local/lib -lssl -lcrypto -L/usr/lib' 'CPPFLAGS=' 'CPP=cpp'

  CFLAGS: -O2 -pipe -DHAVE_OPENSSL -I/usr/include -fno-strict-aliasing -Wall
  LDFLAGS: -L$(top_srcdir)/lib  -rpath=/usr/lib:/usr/local/lib -L/usr/local/lib -L/usr/local/lib -L/usr/local/lib
  LIBS: -lintl  -lpcreposix -lpcre -lssl -lcrypto -lpam -lsupp -lcrypt -lintl -L/usr/local/lib -lssl -lcrypto -L/usr/lib -liconv -lutil

As you can see there is no hint for mysql or postgres to be compiled. In a correct build the LIBS path for example would look like:
LIBS: -lintl  -lssl -lcrypto -lm -lmysqlclient  -lpam  -lz -lsupp -lcrypt -lintl -L/usr/local/lib -lssl -lcrypto -L/usr/lib -liconv -lutil

Please notice "-lmysqlclient" as it is build with mysql-backend. Correct output taken from  1.3.3g (maint).

>How-To-Repeat:
# cd /usr/ports/databases/proftpd-mod_sql_postgres/
# make install
# proftpd -V

[examine the output]
>Fix:


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