[SOLVED]Ubuntu server 10.04 Proftpd error

[NIIcK]

System: Ubuntu 10.04
ispCP: 1.0.6

Hello,

I have yet another issue

When trying to start ProFTPD, clean install, I get the following error:

Code:

/etc/init.d/proftpd start
* Starting ftp server proftpd
- Fatal: unknown configuration directive 'SQLNamedQuery' on line 139 of '/etc/proftpd/proftpd.conf'

Line 139 has the following:

Code:

SQLNamedQuery            get-quota-limit SELECT "name, quota_type, per_session, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits WHERE name = '%{0}' AND

I've checked the installation and proftpd-mod-mysql is installed.

Please help.

Thank you,

Nick

[joximu]

maybe proftpd-mysql is not loaded...

is there a "Include /etc/proftpd/modules.conf" and the modules.conf contains something like
LoadModule mod_sql.c and maybe LoadModule mod_sql_mysql.c

???

/J

[NIIcK]

(08-11-2010 06:31 AM)joximu Wrote:  maybe proftpd-mysql is not loaded...

is there a "Include /etc/proftpd/modules.conf" and the modules.conf contains something like
LoadModule mod_sql.c and maybe LoadModule mod_sql_mysql.c

???

/J

The issue was that the /etc/proftpd/modules.conf did not have the LoadModule mod_sql.c and LoadModule mod_sql_mysql.c directives enabled.
This seems a bit strange ... maybe 1.0.6 has some install issues on Ubuntu server 10.04?

Thank you for your help!

Nick

[joximu]

Hm, I don't know who's the Ubuntu maintainer...

/J <closing here>