Proftpd mysql problem after upgrade ports

[Miroslav Lachman]

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 at 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