[SOLVED]Ubuntu server 10.04 Proftpd error

[SOLVED]Ubuntu server 10.04 Proftpd error - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: [SOLVED]Ubuntu server 10.04 Proftpd error (/thread-11361.html)

[SOLVED]Ubuntu server 10.04 Proftpd error - NIIcK - 08-11-2010 04:45 AM

System: Ubuntu 10.04
ispCP: 1.0.6

Hello,

I have yet another issue Sad

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

RE: Ubuntu server 10.04 Proftpd error - joximu - 08-11-2010 06:31 AM

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

RE: Ubuntu server 10.04 Proftpd error - NIIcK - 08-11-2010 04:25 PM

(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

RE: [SOLVED]Ubuntu server 10.04 Proftpd error - joximu - 08-11-2010 06:46 PM

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

/J <closing here>