[opensuse] Proftpd with MySQL problem
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 ftp@localhost 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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On 10/17/07, Jake Conk
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 ftp@localhost 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: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On 2007-10-18 20:47:36 -0700, Jake Conk wrote:
Here is my proftpd.conf file: [snip]
i dont see LoadModule directives
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 wont do that. as it would compile in all modules into the binary. something i dont want.
I hope this problem gets fixed soon.
sure. as soon as you add LoadModule mod_sql LoadModule mod_sql_mysql to your config. for the later module you need the proftpd-sql-mysql package. darix -- openSUSE - SUSE Linux is my linux openSUSE is good for you www.opensuse.org -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
participants (2)
-
Jake Conk
-
Marcus Rueckert