Hello,
I'm using openSuSE 10.3 and I installed the following packages:
proftpd-1.3.0a-7.3, proftpd-sql-mysql-1.3.0a-7.3. I then configured my
/etc/proftpd/proftpd.conf file with all the sql necessary stuff.
Starting with the first sql configuration, proftpd is telling me it
doesn't know what it is and not letting me start it up. I get this
error when trying to start proftpd:
Starting proftpd - Fatal: unknown configuration directive
'SQLAuthTypes' on line 65 of '/etc/proftpd/proftpd.conf'
startproc: exit status of parent of /usr/sbin/proftpd: 1
Here is my proftpd.conf file:
ServerName "Proftpd Server"
ServerType standalone
DefaultServer on
Port 21
Umask 022
MaxInstances 30
User nobody
Group nogroup
DefaultRoot ~
AllowOverwrite on
<Limit SITE_CHMOD>
DenyAll
</Limit>
SQLAuthTypes Plaintext Crypt
SQLAuthenticate users* groups*
SQLConnectInfo [EMAIL PROTECTED] root
SQLUserInfo ftpuser userid passwd uid gid homedir shell
SQLGroupInfo ftpgroup groupname gid members
SQLMinID 500
SQLHomedirOnDemand on
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1,
accessed=now() WHERE userid='%u'" ftpuser
SQLLog STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE
userid='%u'" ftpuser
QuotaEngine on
QuotaDirectoryTally on
QuotaDisplayUnits Mb
QuotaShowQuotas on
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 ftpquotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type,
bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used,
files_out_used, files_xfer_used FROM ftpquotatallies WHERE name =
'%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used =
bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1},
bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used =
files_in_used + %{3}, files_out_used = files_out_used + %{4},
files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND
quota_type = '%{7}'" ftpquotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2},
%{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies
SQLNamedQuery gettally SELECT
"ROUND((bytes_in_used/1048576),2) FROM ftpquotatallies WHERE
name='%u'"
SQLNamedQuery getlimit SELECT
"ROUND((bytes_in_avail/1048576),2) FROM ftpquotalimits WHERE
name='%u'"
SQLNamedQuery getfree SELECT
"ROUND(((ftpquotalimits.bytes_in_avail-ftpquotatallies.bytes_in_used)/1048576),2)
FROM ftpquotalimits,ftpquotatallies WHERE ftpquotalimits.name = '%u'
AND ftpquotatallies.name = '%u'"
SQLShowInfo LIST "226" "Used %{gettally}MB from
%{getlimit}MB. You have %{getfree}MB available space."
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable
sql:/get-quota-tally/update-quota-tally/insert-quota-tally
RootLogin off
RequireValidShell off
I don't know what the problem is and according to proftpd -V it shows
it compiled with mysql features:
Compile-time Settings:
Version: 1.3.0a
Platform: LINUX
Built With:
configure --host=i686-suse-linux-gnu --build=i686-suse-linux-gnu
--target=i586-suse-linux --program-prefix= --prefix=/usr
--exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin
--sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include
--libdir=/usr/lib --libexecdir=/usr/lib --localstatedir=/var
--sharedstatedir=/usr/com --mandir=/usr/share/man
--infodir=/usr/share/info --bindir=/usr/sbin
--libexecdir=/usr/lib/proftpd --sysconfdir=/etc/proftpd
--localstatedir=/var/run/ --enable-sendfile --enable-ipv6
--enable-ctrls --enable-facl --enable-dso
--with-includes=/usr/include/mysql:/usr/include/pgsql
--with-shared=mod_ctrls_admin:mod_ifsession:mod_ldap:mod_load:mod_quotatab:mod_quotatab_file:mod_quotatab_ldap:mod_quotatab_sql:mod_radius:mod_ratio:mod_readme:mod_rewrite:mod_site_misc:mod_sql:mod_sql_mysql:mod_sql_postgres:mod_tls:mod_wrap
Files:
Configuration File:
/etc/proftpd/proftpd.conf
Pid File:
/var/run//proftpd.pid
Scoreboard File:
/var/run//proftpd/proftpd.scoreboard
Shared Module Directory:
/usr/lib/proftpd
Features:
- Autoshadow support
+ Controls support
+ curses support
- Developer support
+ DSO support
+ IPv6 support
+ Largefile support
+ ncurses support
+ POSIX ACL support
+ Shadow file support
+ Sendfile support
Tunable Options:
PR_TUNABLE_BUFFER_SIZE = 1024
PR_TUNABLE_GLOBBING_MAX = 8
PR_TUNABLE_HASH_TABLE_SIZE = 40
PR_TUNABLE_NEW_POOL_SIZE = 512
PR_TUNABLE_RCVBUFSZ = 87380
PR_TUNABLE_SCOREBOARD_BUFFER_SIZE = 80
PR_TUNABLE_SCOREBOARD_SCRUB_TIMER = 30
PR_TUNABLE_SELECT_TIMEOUT = 30
PR_TUNABLE_SNDBUFSZ = 16384
PR_TUNABLE_TIMEOUTIDENT = 10
PR_TUNABLE_TIMEOUTIDLE = 600
PR_TUNABLE_TIMEOUTLINGER = 180
PR_TUNABLE_TIMEOUTLOGIN = 300
PR_TUNABLE_TIMEOUTNOXFER = 300
PR_TUNABLE_TIMEOUTSTALLED = 3600
PR_TUNABLE_XFER_BUFFER_SIZE = 16384
PR_TUNABLE_XFER_SCOREBOARD_UPDATES = 10
And lastly here is the output of proftpd -l if it is of any use:
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_dso.c
mod_auth_pam.c
mod_cap.c
mod_ctrls.c
Is this package known to be broken or am I doing something wrong?
Thanks,
- Jake
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
