Proftpd howto: Does SQLShowInfo work?

Discussion in 'Installation/Configuration' started by Guido64, Aug 13, 2006.

  1. Guido64

    Guido64 Member

    I installed "Virtual Hosting With Proftpd And MySQL (Incl. Quota)"
    Everything works fine.

    Except wen I add the extra configuration options ..
    ---------------------
    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."
    ---------------------
    There should be a banner in Ws_ftp pro monitor?
    I don't see the banner.
    I don't see any errors in de log messages of proftpd either.
    It seems to do nothing, what am i doing wrong?
     
  2. falko

    falko Super Moderator ISPConfig Developer

    I haven't tested it, so I don't know if it works...
    Did you restart Proftpd?
     
  3. Guido64

    Guido64 Member

    Yes many times I restarted proftpd
    Everything else works, oh wel pity :)
     
  4. ManWithNoName

    ManWithNoName New Member

    I've copied & paste this code into my proftpd.conf and it works fine with Flashfxp

    [03:05:17] [R] 226 Used 14.13MB from 15.00MB. You have 0.87MB available space.
     
  5. Guido64

    Guido64 Member

    Looks very nice.
    I don't understand why its not working for me.

    If the extra code is not working it would complain in a log message I gues but there is no error message.

    Do I have to set the user account to something other then de default quota settings?
     
  6. Guido64

    Guido64 Member

    I installed flashftp the one you used
    It works here now too :)
    Obviously "ws_ftp pro" does not show this extra information.

    Thank you for your tip!
     
  7. falko

    falko Super Moderator ISPConfig Developer

    I've just tested with WS_FTP light, and it's working there, too. Maybe a problem with the pro version? :confused:
     
  8. Guido64

    Guido64 Member

    Yeah i gues with ws_ftp pro it is not showing that extra line.

    I downloaded ws_ftp LE thats working fine here too
    so I gues for ssl its the pro version and for normal ftp surfing I use this LE version.

    Main thing is my server is running oke :)

    Thanks!
     

Share This Page