Package: proftpd-mod-mysql
Version: 1.3.1-17lenny4
Severity: important
proftpd doesn't work with "SQLAuthTypes OpenSSL", even if the compile flags say
so.
Even with highest DebugLevel I only get the following lines regarding this
problem during a connection try in the logfile:
Nov 13 19:02:55 mod_sql/4.2.2[10937]: >>> cmd_check
Nov 13 19:02:55 mod_sql/4.2.2[10937]: checking SQLAuthType 'OpenSSL'
Nov 13 19:02:55 mod_sql/4.2.2[10937]: 'OpenSSL' auth handler reports failure
Nov 13 19:02:55 mod_sql/4.2.2[10937]: <<< cmd_check
My /etc/proftpd/sql.conf:
#
# Proftpd sample configuration for SQL-based authentication.
#
# (This is not to be used if you prefer a PAM-based SQL authentication)
#
<IfModule mod_sql.c>
#
# Choose a SQL backend among MySQL or PostgreSQL.
# Both modules are loaded in default configuration, so you have to specify the
backend
# or comment out the unused module in /etc/proftpd/modules.conf.
# Use 'mysql' or 'postgres' as possible values.
#
SQLBackend mysql
#
SQLEngine on
SQLAuthenticate on
#
# Use both a crypted or plaintext password
#SQLAuthTypes Crypt Plaintext
#
# Use a backend-crypted or a crypted password
#SQLAuthTypes Backend Crypt
#
SQLAuthTypes OpenSSL
#
# Connection
SQLConnectInfo prof...@localhost proftpd password
#
# Describes both users/groups tables
#
SQLUserInfo users username password uid gid homedir shell
SQLGroupInfo groups groupname gid members
#
SQLLogFile /var/log/proftpd/sql.log
SQLMinUserUID 2000
SQLMinUserGID 2000
</IfModule>
The output of proftpd -V:
Compile-time Settings:
Version: 1.3.1
Platform: LINUX
Built With:
configure --prefix=/usr
--with-includes=/usr/include/postgresql:/usr/include/mysql
--mandir=/usr/share/man --sysconfdir=/etc/proftpd --localstatedir=/var/run
--libexecdir=/usr/lib/proftpd
--enable-send
file --enable-facl --enable-dso --enable-autoshadow --enable-ctrls
--with-modules=mod_readme --enable-ipv6 --enable-nls --build x86_64-linux-gnu
--with-shared=mod_site_misc:mod_load:mod_ban:mod_quotatab:mo
d_sql:mod_sql_mysql:mod_sql_postgres:mod_dynmasq:mod_quotatab_sql:mod_ldap:mod_quotatab_ldap:mod_ratio:mod_tls:mod_rewrite:mod_radius:mod_wrap:mod_wrap2:mod_wrap2_file:mod_wrap2_sql:mod_quotatab_file:mod_q
uotatab_radius:mod_facl:mod_ctrls_admin:mod_ifsession
CFLAGS: -O2 -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -DHAVE_OPENSSL
-DUSE_LDAP_TLS -Wall -Wno-long-double
LDFLAGS: -L$(top_srcdir)/lib
LIBS: -lsupp -lcrypt
Files:
Configuration File:
/etc/proftpd/proftpd.conf
Pid File:
/var/run/proftpd.pid
Scoreboard File:
/var/run/proftpd/proftpd.scoreboard
Shared Module Directory:
/usr/lib/proftpd
Features:
+ Autoshadow support
+ Controls support
+ curses support
- Developer support
+ DSO support
+ IPv6 support
+ Largefile support
- Lastlog support
+ ncurses support
+ NLS support
+ OpenSSL support
+ POSIX ACL support
+ Shadow file support
+ Sendfile support
+ Trace support
Tunable Options:
PR_TUNABLE_BUFFER_SIZE = 1024
PR_TUNABLE_GLOBBING_MAX = 8
PR_TUNABLE_HASH_TABLE_SIZE = 40
PR_TUNABLE_NEW_POOL_SIZE = 512
PR_TUNABLE_RCVBUFSZ = 8192
PR_TUNABLE_SCOREBOARD_BUFFER_SIZE = 80
PR_TUNABLE_SCOREBOARD_SCRUB_TIMER = 30
PR_TUNABLE_SELECT_TIMEOUT = 30
PR_TUNABLE_SNDBUFSZ = 8192
PR_TUNABLE_TIMEOUTIDENT = 10
PR_TUNABLE_TIMEOUTIDLE = 600
PR_TUNABLE_TIMEOUTLINGER = 180
PR_TUNABLE_TIMEOUTLOGIN = 300
PR_TUNABLE_TIMEOUTNOXFER = 300
PR_TUNABLE_TIMEOUTSTALLED = 3600
PR_TUNABLE_XFER_BUFFER_SIZE = 1024
PR_TUNABLE_XFER_SCOREBOARD_UPDATES = 10
Output of openssl version:
OpenSSL 0.9.8g 19 Oct 2007
Regards,
Daniel
-- System Information:
Debian Release: 5.0.3
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.26-2-amd64 (SMP w/8 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages proftpd-mod-mysql depends on:
ii libc6 2.7-18 GNU C Library: Shared libraries
ii libmysqlclient15off 5.0.51a-24+lenny2 MySQL database client library
ii proftpd-basic 1.3.1-17lenny4 versatile, virtual-hosting FTP dae
ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime
proftpd-mod-mysql recommends no packages.
proftpd-mod-mysql suggests no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
