community/proftpd: proftpd not compiled with -lodbc
Hello,
I am trying to get proftpd to connect to a database using mod_sql_odbc module. I appear to be running into the same issue as described on the proftpd GitHub repository here: https://github.com/proftpd/proftpd/issues/1669, namely:
2024-01-27 15:40:24,984 ubuntu proftpd[7]: mod_dso/0.5: unable to load 'mod_sql_odbc.c'; check to see if '/usr/lib/proftpd/mod_sql_odbc.la' exists
2024-01-27 15:40:24,984 ubuntu proftpd[7]: fatal: LoadModule: error loading module 'mod_sql_odbc.c': No such file or directory on line 34 of '/tmp/proftpd/conf/proftpd.conf'
I note that /usr/lib/proftpd/mod_sql_odbc.so
exists in the container.
The output from proftpd --settings
:
/ # proftpd --version
ProFTPD Version 1.3.8b
/ # proftpd --settings
Compile-time Settings:
Version: 1.3.8b (maint)
Platform: LINUX [Linux 5.15.0-91-generic x86_64]
OS/Release:
NAME="Alpine Linux"
ID=alpine
VERSION_ID=3.19.1
PRETTY_NAME="Alpine Linux v3.19"
Built: Wed Dec 20 2023 05:01:57 UTC
Built With:
configure '--build=x86_64-alpine-linux-musl' '--host=x86_64-alpine-linux-musl' '--prefix=/usr' '--sysconfdir=/etc/proftpd' '--localstatedir=/run/proftpd' '--libexecdir=/usr/lib/proftpd' '--disable-static' '--enable-sendfile' '--enable-facl' '--enable-dso' '--enable-autoshadow' '--enable-ctrls' '--enable-ipv6' '--enable-pcre2' '--disable-strip' '--disable-wtmp' '--disable-auth-pam' '--enable-openssl' '--with-shared=mod_unique_id:mod_site_misc:mod_load:mod_ban:mod_quotatab:mod_sql:mod_sql_mysql:mod_sql_postgres:mod_sql_sqlite:mod_sql_odbc:mod_dynmasq:mod_quotatab_sql:mod_ldap:mod_quotatab_ldap:mod_ratio:mod_tls:mod_rewrite:mod_radius:mod_wrap2:mod_wrap2_file:mod_wrap2_sql:mod_quotatab_file:mod_quotatab_radius:mod_facl:mod_ctrls_admin:mod_copy:mod_deflate:mod_ifversion:mod_geoip:mod_exec:mod_sftp:mod_sftp_sql:mod_shaper:mod_sql_passwd:mod_ifsession:mod_auth_otp:mod_tls_redis:mod_wrap2_redis:mod_redis:mod_memcache:mod_tls_memcache:mod_readme:mod_snmp:mod_tls_shmcache' 'build_alias=x86_64-alpine-linux-musl' 'host_alias=x86_64-alpine-linux-musl' 'CC=gcc' 'CFLAGS=-Os -fstack-clash-protection -Wformat -Werror=format-security -fno-plt' 'LDFLAGS=-Wl,--as-needed,-O1,--sort-common -Wl,-z,pack-relative-relocs' 'CXX=g++' 'CXXFLAGS=-Os -fstack-clash-protection -Wformat -Werror=format-security -D_GLIBCXX_ASSERTIONS=1 -D_LIBCPP_ENABLE_THREAD_SAFETY_ANNOTATIONS=1 -D_LIBCPP_ENABLE_HARDENED_MODE=1 -fno-plt'
CFLAGS: -g2 -Os -fstack-clash-protection -Wformat -Werror=format-security -fno-plt -Wall -fno-omit-frame-pointer -fno-strict-aliasing -Werror=implicit-function-declaration
LDFLAGS: -Wl,-L$(top_srcdir)/lib,-L$(top_builddir)/lib -Wl,--as-needed,-O1,--sort-common -Wl,-z,pack-relative-relocs -rdynamic -L/usr/lib/ -L/usr/lib
LIBS: -lpcre2-posix -lpcre2-8 -lssl -lcrypto -lsodium -lresolv -lresolv -lcrypt -pthread
Files:
Configuration File:
/etc/proftpd/proftpd.conf
Pid File:
/run/proftpd/proftpd.pid
Scoreboard File:
/run/proftpd/proftpd.scoreboard
Header Directory:
/usr/include/proftpd
Shared Module Directory:
/usr/lib/proftpd
Info:
+ Max supported UID: 4294967295
+ Max supported GID: 4294967295
Features:
+ Autoshadow support
+ Controls support
+ curses support
- Developer support
+ DSO support
+ IPv6 support
+ Largefile support
- Lastlog support
- Memcache support
+ ncurses support
- NLS support
+ OpenSSL support (OpenSSL 3.1.4 24 Oct 2023)
- PCRE support
+ PCRE2 support
+ POSIX ACL support
- Redis support
+ Sendfile support
+ Shadow file support
+ Sodium support
+ Trace support
+ xattr support
Tunable Options:
PR_TUNABLE_BUFFER_SIZE = 1024
PR_TUNABLE_DEFAULT_RCVBUFSZ = 8192
PR_TUNABLE_DEFAULT_SNDBUFSZ = 8192
PR_TUNABLE_ENV_MAX = 2048
PR_TUNABLE_GLOBBING_MAX_MATCHES = 100000
PR_TUNABLE_GLOBBING_MAX_RECURSION = 8
PR_TUNABLE_HASH_TABLE_SIZE = 40
PR_TUNABLE_LOGIN_MAX = 256
PR_TUNABLE_NEW_POOL_SIZE = 512
PR_TUNABLE_PATH_MAX = 4096
PR_TUNABLE_SCOREBOARD_BUFFER_SIZE = 80
PR_TUNABLE_SCOREBOARD_SCRUB_TIMER = 30
PR_TUNABLE_SELECT_TIMEOUT = 30
PR_TUNABLE_TIMEOUTIDENT = 10
PR_TUNABLE_TIMEOUTIDLE = 600
PR_TUNABLE_TIMEOUTLINGER = 10
PR_TUNABLE_TIMEOUTLOGIN = 300
PR_TUNABLE_TIMEOUTNOXFER = 300
PR_TUNABLE_TIMEOUTSTALLED = 3600
PR_TUNABLE_XFER_SCOREBOARD_UPDATES = 10
-lodbc
does not appear in LIBS
in the output, which was one of the problems in the aforementioned proftpd GitHub issue. It could just as likely be a configuration issue on my end, but I am interested to know if ODBC support has been confirmed to be working in this package?
Best regards,
Andrew