Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 19th November 2011, 05:12
ShinnRa ShinnRa is offline
Junior Member
Join Date: Jan 2007
Posts: 7
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via ICQ to ShinnRa
Default Proftpd howto: weird ouput on SQLShowInfo LIST...

i have something like this in sql.conf file of proftpd
	SQLNamedQuery			gettally SELECT "ROUND((bytes_in_used/1048576), 2) as gettally FROM ftpquotatallies WHERE name='%u'"
	SQLNamedQuery			getlimit SELECT "ROUND((bytes_in_avail/1048576), 2) as getlimit FROM ftpquotalimits WHERE name='%u'"
	SQLNamedQuery			getfree SELECT "ROUND(((fql.bytes_in_avail - fqt.bytes_in_used)/1048576), 2) as getfree FROM ftpquotalimits fql, ftpquotatallies fqt WHERE fql.name = '%u' AND fqt.name = '%u'"
	SQLShowInfo				LIST "214" "Used %{gettally}MB from %{getlimit}MB. You have %{getfree}MB available space."
and it works... partially... 'cause when i list dirs (ls) i get something like this:
214 Ue {etlyM rm15.00M.Yuhv {efe}Baalbesae
what did i wrong...

what i have installed
root :: kiki :: 2.6.32-5-686 :: 19/11/2011 :: GNU/Linux
79 :: [/var/log/proftpd] dpkg -l | egrep "proftpd|mysql"
ii  libdbd-mysql-perl                  4.016-1                      Perl5 database interface to the MySQL database
ii  libmysqlclient-dev                 5.1.49-3                     MySQL database development files
ii  libmysqlclient16                   5.1.49-3                     MySQL database client library
ii  mysql-client                       5.1.49-3                     MySQL database client (metapackage depending on the latest version)
ii  mysql-client-5.1                   5.1.49-3                     MySQL database client binaries
ii  mysql-common                       5.1.49-3                     MySQL database common files, e.g. /etc/mysql/my.cnf
ii  mysql-server                       5.1.49-3                     MySQL database server (metapackage depending on the latest version)
ii  mysql-server-5.1                   5.1.49-3                     MySQL database server binaries and system database setup
ii  mysql-server-core-5.1              5.1.49-3                     MySQL database server binaries
ii  php5-mysql                         5.3.3-7+squeeze3             MySQL module for php5
ii  proftpd-basic                      1.3.3a-6squeeze4             Versatile, virtual-hosting FTP daemon - binaries
ii  proftpd-doc                        1.3.3a-6squeeze4             Versatile, virtual-hosting FTP daemon - documentation
ii  proftpd-mod-mysql                  1.3.3a-6squeeze4             Versatile, virtual-hosting FTP daemon - MySQL module
Linux user: 398881
Reply With Quote
Sponsored Links


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ISP / Centos 5.4 gjaouen Installation/Configuration 11 20th January 2010 12:18
Proftpd LIST permission Problem HugofromBOSS HOWTO-Related Questions 2 23rd May 2008 14:36
Proftpd howto: Does SQLShowInfo work? Guido64 Installation/Configuration 7 16th August 2006 18:05
Totally Confused?? :( kingtux Installation/Configuration 7 9th February 2006 23:14
Im thinking about throwing proftpd to the trashcan danf.1979 Installation/Configuration 2 23rd December 2005 10:27

All times are GMT +2. The time now is 09:01.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.