i have something like this in sql.conf file of proftpd Code: 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: Code: 214 Ue {etlyM rm15.00M.Yuhv {efe}Baalbesae what did i wrong... what i have installed Code: 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
