>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  
   [email protected]:/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:
_______________________________________________
[email protected] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-amd64
To unsubscribe, send any mail to "[email protected]"

Reply via email to