Date: Thu, 14 Jun 2012 10:00:34 +0200 From: Miroslav Lachman <000.fbsd@quip.cz> To: =?ISO-8859-2?Q?Radek_Krej=E8a?= <radek.krejca@starnet.cz> Cc: "'ports@freebsd.org'" <ports@freebsd.org> Subject: Re: Proftpd mysql problem after upgrade ports Message-ID: <4FD99A22.7020308@quip.cz> In-Reply-To: <B2E0472020754D45B72E9B0CE35278CA90DB32DD92@EXCHANGE.mail.starnet.cz> References: <B2E0472020754D45B72E9B0CE35278CA90DB32DD92@EXCHANGE.mail.starnet.cz>
next in thread | previous in thread | raw e-mail | index | archive | help
Radek Krejča wrote:
> Hi, I have problem with this module. I upgraded ports and I have this proftpd.conf
You don't have a proper configuration. You need to put LoadModule
directives in to proftpd.conf:
# list of modules to load on startup
LoadModule mod_sql.c
LoadModule mod_sql_mysql.c
It was mentioned in /usr/ports/UPDATING
20120126:
AFFECTS: users of ftp/proftpd and ftp/proftpd-mysql
AUTHOR: Martin Matuska <mm@FreeBSD.org>
The proftpd port has been updated to 1.3.4 and changed to use
dynamically loadable modules. Please add corresponding LoadModule
directives to your configuration file, like in the following example:
LoadModule mod_tls.c
The modules mod_sql_mysql and mod_sql_postgres are now outside of the
main proftpd port:
databases/proftpd-mod_sql_mysql
databases/proftpd-mod_sql_postgres
The proftpd-mysql port has been removed, use the alternative port:
databases/proftpd-mod_sql_mysql
> Before upgrade ports I had
> proftpd-1.3.4a Highly configurable FTP daemon
> proftpd-mod_sql_mysql-1.3.4a MySQL module for ProFTPD
>
> and this config file worked. After upgrade I have
> proftpd-1.3.4a_2 Highly configurable FTP daemon
> proftpd-mod_sql_mysql-1.3.4a_2 MySQL module for ProFTPD
>
> and after starting I got this message: Fatal: unknown configuration directive 'SQLEngine' on line 43 of '/usr/local/etc/proftpd.conf'
>
> It looks like, that mod_sql isnt loaded,
> Compiled-in modules:
> mod_core.c
> mod_xfer.c
> mod_auth_unix.c
> mod_auth_file.c
> mod_auth.c
> mod_ls.c
> mod_log.c
> mod_site.c
> mod_delay.c
> mod_facts.c
> mod_dso.c
> mod_ident.c
> mod_auth_pam.c
> mod_ctrls.c
> mod_lang.c
>
> but I have compiled port proftpd with mod_sql (/var/db/ports/proftpd/options OPTIONS_FILE_SET+=SQL
> OPTIONS_FILE_SET+=SQL_PASSWD)
>
> Where could be a problem?
>
> I have fbsd 9.0 latest amd64 generic kernel.
>
> Thank you for any suggestion. Radek
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4FD99A22.7020308>