Question about Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch

Discussion in 'HOWTO-Related Questions' started by ikkem, Feb 21, 2008.

  1. ikkem

    ikkem New Member

    @topdog the error message is different indeed after some made changes I get this error message
    Status:	Connecting to myexternalip...
    Status:	Connection established, waiting for welcome message...
    Response:	220 ProFTPD 1.3.0 Server (server1) [myexternalip]
    Command:	USER ikkem
    Response:	331 Password required for ikkem.
    Command:	PASS ********
    Response:	530 Login incorrect.
    Error:	Could not connect to server  
    the output of /var/log/proftpd/proftpd.log=

    Thanks in advance.....

    Last edited: Feb 21, 2008
  2. falko

    falko Super Moderator ISPConfig Developer

    What's in your proftpd.conf?
  3. ikkem

    ikkem New Member

    hi falko thanks for reacting the config file looks like this....
    # /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file.
    # To really apply changes reload proftpd after modifications.
    # Includes DSO modules
    Include /etc/proftpd/modules.conf
    RootLogin off
    RequireValidShell off
    # Set off to disable IPv6 support which is annoying on IPv4 only boxes.
    UseIPv6				off
    ServerName			"server1"
    ServerType			standalone
    DeferWelcome			off
    MultilineRFC2228		on
    DefaultServer			on
    ShowSymlinks			on
    TimeoutNoTransfer		600
    TimeoutStalled			600
    TimeoutIdle			1200
    DisplayLogin                    welcome.msg
    DisplayFirstChdir               .message
    ListOptions                	"-l"
    DenyFilter			\*.*/
    # Port 21 is the standard FTP port.
    Port				21
    # In some cases you have to specify passive ports range to by-pass
    # firewall limitations. Ephemeral ports can be used for that, but
    # feel free to use a more narrow range.
    PassivePorts                    2899 2901
    # To prevent DoS attacks, set the maximum number of child processes
    # to 30.  If you need to allow more than 30 concurrent connections
    # at once, simply increase this value.  Note that this ONLY works
    # in standalone mode, in inetd mode you should use an inetd server
    # that allows you to limit maximum number of processes per service
    # (such as xinetd)
    MaxInstances			30
    # Set the user and group that the server normally runs at.
    User				proftpd
    Group				nogroup
    # Umask 022 is a good standard umask to prevent new files and dirs
    # (second parm) from being group and world writable.
    Umask				022  022
    # Normally, we want files to be overwriteable.
    AllowOverwrite			on
    # Uncomment this if you are using NIS or LDAP to retrieve passwords:
    # PersistentPasswd		off
    # Be warned: use of this directive impacts CPU average load!
    # Uncomment this if you like to see progress and transfer rate with ftpwho
    # in downloads. That is not needed for uploads rates.
    # UseSendFile			off
    TransferLog /var/log/proftpd/xferlog
    SystemLog   /var/log/proftpd/proftpd.log
    <IfModule mod_tls.c>
    TLSEngine off
    <IfModule mod_quota.c>
    QuotaEngine on
    <IfModule mod_ratio.c>
    Ratios on
    # Delay engine reduces impact of the so-called Timing Attack described in
    # It is on by default. 
    <IfModule mod_delay.c>
    DelayEngine on
    <IfModule mod_ctrls.c>
    ControlsEngine        on
    ControlsMaxClients    2
    ControlsLog           /var/log/proftpd/controls.log
    ControlsInterval      5
    ControlsSocket        /var/run/proftpd/proftpd.sock
    <IfModule mod_ctrls_admin.c>
    AdminControlsEngine on
    DefaultRoot ~
    # The passwords in MySQL are encrypted using CRYPT
    SQLAuthTypes            Plaintext Crypt
    SQLAuthenticate         users groups
    # used to connect to the database
    # [email protected] database_user user_password
    SQLConnectInfo  [email protected] proftpd password
    # Here we tell ProFTPd the names of the database columns in the "usertable"
    # we want it to interact with. Match the names with those in the db
    SQLUserInfo     ftpuser userid passwd uid gid homedir shell
    # Here we tell ProFTPd the names of the database columns in the "grouptable"
    # we want it to interact with. Again the names match with those in the db
    SQLGroupInfo    ftpgroup groupname gid members
    # set min UID and GID - otherwise these are 999 each
    SQLMinID        500
    # create a user's home directory on demand if it doesn't exist
    SQLHomedirOnDemand on
    # Update count every time user logs in
    SQLLog PASS updatecount
    SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser
    # Update modified everytime user uploads or deletes a file
    SQLLog  STOR,DELE modified
    SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
    # User quotas
    # ===========
    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
    QuotaLimitTable sql:/get-quota-limit
    QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
    RootLogin off
    RequireValidShell off
    # A basic anonymous configuration, no upload directories.
    # <Anonymous ~ftp>
    #   User				ftp
    #   Group				nogroup
    #   # We want clients to be able to login with "anonymous" as well as "ftp"
    #   UserAlias			anonymous ftp
    #   # Cosmetic changes, all files belongs to ftp user
    #   DirFakeUser	on ftp
    #   DirFakeGroup on ftp
    #   RequireValidShell		off
    #   # Limit the maximum number of anonymous logins
    #   MaxClients			10
    #   # We want 'welcome.msg' displayed at login, and '.message' displayed
    #   # in each newly chdired directory.
    #   DisplayLogin			welcome.msg
    #   DisplayFirstChdir		.message
    #   # Limit WRITE everywhere in the anonymous chroot
    #   <Directory *>
    #     <Limit WRITE>
    #       DenyAll
    #     </Limit>
    #   </Directory>
    #   # Uncomment this if you're brave.
    #   # <Directory incoming>
    #   #   # Umask 022 is a good standard umask to prevent new files and dirs
    #   #   # (second parm) from being group and world writable.
    #   #   Umask				022  022
    #   #            <Limit READ WRITE>
    #   #            DenyAll
    #   #            </Limit>
    #   #            <Limit STOR>
    #   #            AllowAll
    #   #            </Limit>
    #   # </Directory>
    # </Anonymous>
    Thanks in advance....
  4. ikkem

    ikkem New Member

    now i get this error message when i try to connect to mysql could someone please help me to sort it out....
    thanks in advance....
  5. topdog

    topdog Active Member

    Your mysql server is not running you need to start it.
    /etc/init.d/mysql start
  6. ikkem

    ikkem New Member

    Finally I got it working now after googling for a solution and reading all your helpful posts I have a working ftp server now I am gonna test it also i will post how I got it working later on....
  7. ikkem

    ikkem New Member

    These are the commands I use to start mysql
    The weird thing is that I need to give these commands every time my system restarts....

    The errors I got from proftpd were because of the fact that I did not configure the system to act as a server properly so in order to fix it I configured the system according to the how to by falko the perfect setup debian etch

    I also used the info from this page to set mysql
  8. ikkem

    ikkem New Member

    After some testing I found that the client cannot down or upload files to the directory they can login and see the files but they cannot down or upload files.

    if i login locally it works ok
    remote logins are ok also but the client cannot down/upload files

    can someone point me into the right direction
    thanks in advance

  9. falko

    falko Super Moderator ISPConfig Developer

    Have you tried both active and passive transfers in your FTP client?
  10. ikkem

    ikkem New Member

    hi thanks for reacting,
    I specified active and passive mode in proftpd conf and also set the firewall rules

    thanks in advance

  11. falko

    falko Super Moderator ISPConfig Developer

    Any errors in your logs?
    What exactly did you modify in the firewall? What ports are open now?

Share This Page