On 10/17/07, Jake Conk <[EMAIL PROTECTED]> wrote:
> 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
>
Well I fixed my own problem by downloading the latest proftpd and
recompiling but I changed one line on the ./configure command which
fixed the problem which was --with-shared should be --with-modules.
Here is my full ./configure command that now works with mysql (minus
the stuff I felt I didn't need from --with-modules so I removed them
for performance)...
# ./configure --program-prefix= --prefix=/usr --exec-prefix=/usr
--bindir=/usr/bin --sbindir=/usr/sbin --datadir=/usr/share
--includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/lib
--localstatedir=/var --mandir=/usr/share/man --infodir=/usr/share/info
--bindir=/usr/sbin --libexecdir=/usr/lib/proftpd --libdir=/usr/lib
--sysconfdir=/etc/proftpd --localstatedir=/var/run/ --enable-sendfile
--enable-ctrls --enable-facl --enable-dso
--with-libraries=/usr/lib/mysql --with-includes=/usr/include/mysql
--with-modules=mod_sql:mod_sql_mysql:mod_quotatab:mod_quotatab_sql
I hope this problem gets fixed soon.
Thanks,
- Jake
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
