Current time: 12-23-2024, 04:36 PM Hello There, Guest! (LoginRegister)


Post Reply 
FTP failure after upgrade
Author Message
Rusted Offline
Newbie
*

Posts: 9
Joined: Aug 2009
Reputation: 0
Post: #1
FTP failure after upgrade
After digging thru the forums and the Solving ProFTPd issues doc and trying several fixes including replacing the proftpd.conf file I am stuck. I cannot seem to get ftp working.

I upgraded to 1.0.3 this morning and all works until I try to create a new ftp user. The Choose dir option states "Can not open directory! Please contact your administrator!" and ftp users can no longer connect.

During the upgrade, all went well until the end where I recieved the following error: Starting ftp server: proftpd - Fatal: SQLMinUserUID: requires a numeric argument on line 168 of '/etc/proftpd/proftpd.conf'. I reset the hostname, sql server, sqdb, ftpuser, ftppassword info in the proftpd.conf and it still failed. Replaced the proftpd.conf and reconfigured.

I am running Debian Etch 4.0 w/ ProFTP ver. 1.3.0
Output of proftpd -n -d5:
Code:
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - ~/errors
webhostdeb1.iaccessapps.com -  Limit
webhostdeb1.iaccessapps.com -   DenyAll
webhostdeb1.iaccessapps.com -  ShowSymlinks
webhostdeb1.iaccessapps.com -  AllowOverwrite
webhostdeb1.iaccessapps.com -  AllowStoreRestart
webhostdeb1.iaccessapps.com -  AllowForeignAddress
webhostdeb1.iaccessapps.com -  DisplayLogin
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - ~/htdocs/*
webhostdeb1.iaccessapps.com -  Limit
webhostdeb1.iaccessapps.com -   AllowAll
webhostdeb1.iaccessapps.com -  ShowSymlinks
webhostdeb1.iaccessapps.com -  AllowOverwrite
webhostdeb1.iaccessapps.com -  AllowStoreRestart
webhostdeb1.iaccessapps.com -  AllowForeignAddress
webhostdeb1.iaccessapps.com -  DisplayLogin
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - ~/htdocs
webhostdeb1.iaccessapps.com -  Limit
webhostdeb1.iaccessapps.com -   DenyAll
webhostdeb1.iaccessapps.com -  ShowSymlinks
webhostdeb1.iaccessapps.com -  AllowOverwrite
webhostdeb1.iaccessapps.com -  AllowStoreRestart
webhostdeb1.iaccessapps.com -  AllowForeignAddress
webhostdeb1.iaccessapps.com -  DisplayLogin
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - ~/cgi-bin/*
webhostdeb1.iaccessapps.com -  Limit
webhostdeb1.iaccessapps.com -   AllowAll
webhostdeb1.iaccessapps.com -  ShowSymlinks
webhostdeb1.iaccessapps.com -  AllowOverwrite
webhostdeb1.iaccessapps.com -  AllowStoreRestart
webhostdeb1.iaccessapps.com -  AllowForeignAddress
webhostdeb1.iaccessapps.com -  DisplayLogin
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - ~/cgi-bin
webhostdeb1.iaccessapps.com -  Limit
webhostdeb1.iaccessapps.com -   DenyAll
webhostdeb1.iaccessapps.com -  ShowSymlinks
webhostdeb1.iaccessapps.com -  AllowOverwrite
webhostdeb1.iaccessapps.com -  AllowStoreRestart
webhostdeb1.iaccessapps.com -  AllowForeignAddress
webhostdeb1.iaccessapps.com -  DisplayLogin
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - ~/backups/*
webhostdeb1.iaccessapps.com -  Limit
webhostdeb1.iaccessapps.com -   AllowAll
webhostdeb1.iaccessapps.com -  ShowSymlinks
webhostdeb1.iaccessapps.com -  AllowOverwrite
webhostdeb1.iaccessapps.com -  AllowStoreRestart
webhostdeb1.iaccessapps.com -  AllowForeignAddress
webhostdeb1.iaccessapps.com -  DisplayLogin
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - ~/backups
webhostdeb1.iaccessapps.com -  Limit
webhostdeb1.iaccessapps.com -   DenyAll
webhostdeb1.iaccessapps.com -  ShowSymlinks
webhostdeb1.iaccessapps.com -  AllowOverwrite
webhostdeb1.iaccessapps.com -  AllowStoreRestart
webhostdeb1.iaccessapps.com -  AllowForeignAddress
webhostdeb1.iaccessapps.com -  DisplayLogin
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - Limit
webhostdeb1.iaccessapps.com -  IgnoreHidden
webhostdeb1.iaccessapps.com - /*
webhostdeb1.iaccessapps.com -  Umask
webhostdeb1.iaccessapps.com -  DirUmask
webhostdeb1.iaccessapps.com -  AllowOverwrite
webhostdeb1.iaccessapps.com -  HideNoAccess
webhostdeb1.iaccessapps.com -  ShowSymlinks
webhostdeb1.iaccessapps.com -  AllowStoreRestart
webhostdeb1.iaccessapps.com -  AllowForeignAddress
webhostdeb1.iaccessapps.com -  DisplayLogin
webhostdeb1.iaccessapps.com -  DisplayFirstChdir
webhostdeb1.iaccessapps.com -  ListOptions
webhostdeb1.iaccessapps.com -  DenyFilter
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com -  SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com -  SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com -  SQLAuthTypes
webhostdeb1.iaccessapps.com -  SQLAuthenticate
webhostdeb1.iaccessapps.com -  SQLConnectInfo
webhostdeb1.iaccessapps.com -  SQLMinUserUID
webhostdeb1.iaccessapps.com -  SQLMinUserGID
webhostdeb1.iaccessapps.com -  RootLogin
webhostdeb1.iaccessapps.com -  TransferLog
webhostdeb1.iaccessapps.com -  PathDenyFilter
webhostdeb1.iaccessapps.com - DeferWelcome
webhostdeb1.iaccessapps.com - DefaultServer
webhostdeb1.iaccessapps.com - ShowSymlinks
webhostdeb1.iaccessapps.com - AllowOverwrite
webhostdeb1.iaccessapps.com - IdentLookups
webhostdeb1.iaccessapps.com - AllowStoreRestart
webhostdeb1.iaccessapps.com - AllowForeignAddress
webhostdeb1.iaccessapps.com - TimeoutLogin
webhostdeb1.iaccessapps.com - TimeoutNoTransfer
webhostdeb1.iaccessapps.com - TimeoutStalled
webhostdeb1.iaccessapps.com - TimeoutIdle
webhostdeb1.iaccessapps.com - DisplayLogin
webhostdeb1.iaccessapps.com - DisplayFirstChdir
webhostdeb1.iaccessapps.com - ListOptions
webhostdeb1.iaccessapps.com - DenyFilter
webhostdeb1.iaccessapps.com - DefaultRoot
webhostdeb1.iaccessapps.com - UserID
webhostdeb1.iaccessapps.com - UserName
webhostdeb1.iaccessapps.com - GroupID
webhostdeb1.iaccessapps.com - GroupName
webhostdeb1.iaccessapps.com - QuotaEngine
webhostdeb1.iaccessapps.com - QuotaShowQuotas
webhostdeb1.iaccessapps.com - QuotaDisplayUnits
webhostdeb1.iaccessapps.com - SQLNamedQuery_get-quota-limit
webhostdeb1.iaccessapps.com - SQLNamedQuery_get-quota-tally
webhostdeb1.iaccessapps.com - SQLNamedQuery_update-quota-tally
webhostdeb1.iaccessapps.com - SQLNamedQuery_insert-quota-tally
webhostdeb1.iaccessapps.com - QuotaLock
webhostdeb1.iaccessapps.com - QuotaLimitTable
webhostdeb1.iaccessapps.com - QuotaTallyTable
webhostdeb1.iaccessapps.com - DelayEngine
webhostdeb1.iaccessapps.com - SQLBackend
webhostdeb1.iaccessapps.com - SQLAuthTypes
webhostdeb1.iaccessapps.com - SQLAuthenticate
webhostdeb1.iaccessapps.com - SQLConnectInfo
webhostdeb1.iaccessapps.com - SQLUserTable
webhostdeb1.iaccessapps.com - SQLUsernameField
webhostdeb1.iaccessapps.com - SQLPasswordField
webhostdeb1.iaccessapps.com - SQLUidField
webhostdeb1.iaccessapps.com - SQLGidField
webhostdeb1.iaccessapps.com - SQLHomedirField
webhostdeb1.iaccessapps.com - SQLShellField
webhostdeb1.iaccessapps.com - SQLGroupTable
webhostdeb1.iaccessapps.com - SQLGroupnameField
webhostdeb1.iaccessapps.com - SQLGroupGIDField
webhostdeb1.iaccessapps.com - SQLGroupMembersField
webhostdeb1.iaccessapps.com - SQLMinUserUID
webhostdeb1.iaccessapps.com - SQLMinUserGID
webhostdeb1.iaccessapps.com - RootLogin
webhostdeb1.iaccessapps.com - TransferLog
webhostdeb1.iaccessapps.com - ExtendedLog
webhostdeb1.iaccessapps.com - PathDenyFilter
webhostdeb1.iaccessapps.com - mod_ctrls/0.9.4: binding ctrls socket to '/var/run/proftpd/proftpd.sock'
webhostdeb1.iaccessapps.com - ProFTPD 1.3.0 (stable) (built Mon Oct 26 14:21:00 UTC 2009) standalone mode STARTUP

/etc/proftpd/proftpd.conf:
Code:
#
# ispCP Ï (OMEGA) a Virtual Hosting Control System
#
# @copyright    2001-2006 by moleSoftware GmbH
# @copyright    2006-2008 by ispCP | http://isp-control.net
# @version              SVN: $Id$
# @link                 http://isp-control.net
# @author               ispCP Team
#
# @license
#   This program is free software; you can redistribute it and/or modify it under
#   the terms of the MPL General Public License as published by the Free Software
#   Foundation; either version 1.1 of the License, or (at your option) any later
#   version.
#   You should have received a copy of the MPL Mozilla Public License along with
#   this program; if not, write to the Open Source Initiative (OSI)
#   http://opensource.org | osi@opensource.org
#
################################################################################​
# Includes DSO modules (this is mandatory in proftpd 1.3)
Include /etc/proftpd/modules.conf

# Set off to disable IPv6 support which is annoying on IPv4 only boxes.
UseIPv6                    off

ServerName                 "webhostdeb1"
ServerType                 standalone
DeferWelcome               off

MultilineRFC2228           on
DefaultServer              on
ShowSymlinks               on

AllowOverwrite             on
UseReverseDNS              off
IdentLookups               off
AllowStoreRestart          on
AllowForeignAddress        on

LogFormat                  traff "%b %u"

TimeoutLogin               120
TimeoutNoTransfer          600
TimeoutStalled             600
TimeoutIdle                1200

DisplayLogin               welcome.msg
DisplayFirstChdir          message

ListOptions                "-l"
#LsDefaultOptions           "-l"

DenyFilter                 \*.*/

DefaultRoot                ~

# Uncomment this if you are using NIS or LDAP to retrieve passwords:
# PersistentPasswd         off

# 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               49152 65534

# 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                       nobody
Group                      nogroup

# Normally, we want files to be overwriteable.
<Directory /*>
  # 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
  HideNoAccess             on
</Directory>

<Limit ALL>
  IgnoreHidden             on
</Limit>

# 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

<Global>
  RootLogin                off
  TransferLog              /var/log/proftpd/xferlog
  ExtendedLog              /var/log/proftpd/ftp_traff.log read,write traff
  PathDenyFilter           "\.quota$"
</Global>

#
# SSL via TLS
#
#<IfModule mod_tls.c>
#  TLSEngine                off                           # on for use of TLS
#  TLSLog                   /var/log/proftpd/ftp_ssl.log  # where to log to
#  TLSProtocol              SSLv23                        # SSLv23 or TLSv1
#  TLSOptions               NoCertRequest                 # either to request the certificate or not
#  TLSRSACertificateFile    /etc/proftpd/ssl.crt          # SSL certfile
#  TLSRSACertificateKeyFile /etc/proftpd/ssl.key          # SSL keyfile
#  TLSVerifyClient          off                           # client verification
#</IfModule>

#
# ISPCP Quota management;
#
<IfModule mod_quotatab.c>
  QuotaEngine              on
  QuotaShowQuotas          on
  QuotaDisplayUnits        Mb

  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 quotalimits 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 quotatallies 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}'" quotatallies
  SQLNamedQuery            insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" quotatallies

  QuotaLock                /var/run/proftpd/tally.lock
  QuotaLimitTable          sql:/get-quota-limit
  QuotaTallyTable          sql:/get-quota-tally/update-quota-tally/insert-quota-tally
</IfModule>

<IfModule mod_ratio.c>
  Ratios                   on
</IfModule>

# Delay engine reduces impact of the so-called Timing Attack described in
# http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02
# It is on by default.
<IfModule mod_delay.c>
  DelayEngine              on
</IfModule>

<IfModule mod_ctrls.c>
  ControlsEngine           on
  ControlsMaxClients       2
  ControlsLog              /var/log/proftpd/controls.log
  ControlsInterval         5
  ControlsSocket           /var/run/proftpd/proftpd.sock
</IfModule>

<IfModule mod_ctrls_admin.c>
  AdminControlsEngine      on
</IfModule>

# ispCP SQL Managment
SQLBackend                 mysql
SQLAuthTypes               Crypt
SQLAuthenticate            on
SQLConnectInfo             ispcp@webhostdeb1 vftp MYpassword
SQLUserInfo                ftp_users userid passwd uid gid homedir shell
SQLGroupInfo               ftp_group groupname gid members
SQLMinUserUID              2000
SQLMinUserGID              2000

# 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>
Include /etc/proftpd/ispcp/*
I thought it might be an incorrect vftp password in mysql based on many threads so I reset it there. No luck!
Oh, and I verified all permissions on the virtual directories and ftproot.

What am I missing? And Thanks.
(This post was last modified: 12-02-2009 07:49 AM by Rusted.)
12-02-2009 07:31 AM
Find all posts by this user Quote this message in a reply
kilburn Offline
Development Team
*****
Dev Team

Posts: 2,182
Joined: Feb 2007
Reputation: 34
Post: #2
RE: FTP failure after upgrade
Can you show us the output of "proftpd -n -d5" when you try to connect to the server? I mean, you've posted the startup procedure (and it looks good), but we're missing the messages of any connection attempt...
12-02-2009 08:20 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Rusted Offline
Newbie
*

Posts: 9
Joined: Aug 2009
Reputation: 0
Post: #3
RE: FTP failure after upgrade
Sorry, this is the end of the output with connection attempt:

webhostdeb1.iaccessapps.com - SQLMinUserUID
webhostdeb1.iaccessapps.com - SQLMinUserGID
webhostdeb1.iaccessapps.com - RootLogin
webhostdeb1.iaccessapps.com - TransferLog
webhostdeb1.iaccessapps.com - ExtendedLog
webhostdeb1.iaccessapps.com - PathDenyFilter
webhostdeb1.iaccessapps.com - mod_ctrls/0.9.4: binding ctrls socket to '/var/run/proftpd/proftpd.sock'
webhostdeb1.iaccessapps.com - ProFTPD 1.3.0 (stable) (built Mon Oct 26 14:21:00 UTC 2009) standalone mode STARTUP
webhostdeb1.iaccessapps.com (x.x.x.x[x.x.x.x]) - FTP session requested from unknown class
webhostdeb1.iaccessapps.com (x.x.x.x[x.x.x.x]) - FTP session closed.
webhostdeb1.iaccessapps.com (x.x.x.x[x.x.x.x]) - FTP session requested from unknown class
webhostdeb1.iaccessapps.com (x.x.x.x[x.x.x.x]) - FTP session closed.

It appears to be a disconnect with the vftp user. What do I need to check to ensure that vftp is working? I can log into mysql with the vftp username and password in the proftpd.conf file. Is there somewhere else that it should be defined. Should vftp appear in the ftpuser tables?
(This post was last modified: 12-03-2009 06:46 AM by Rusted.)
12-03-2009 02:48 AM
Find all posts by this user Quote this message in a reply
Rusted Offline
Newbie
*

Posts: 9
Joined: Aug 2009
Reputation: 0
Post: #4
RE: FTP failure after upgrade
Fixed it after a lot of googling and trial and error. This seems to be the culprit and fix:
vftp user was hosed up after the upgrade (I think). After commenting out the root entry in the /etc/ftpusers file, I tested connections while in debug mode and received much more info. Still failed, but more info. I added the line:
SQLLogFile /var/log/proftpd/mod_sql.log
to the end of the # ispCP SQL Managment section of the proftpd.conf and received even more info on the authentication errors in the log file. Found a site that detailed how to configure ftp users in mysql and ran the following:

GRANT SELECT, INSERT, UPDATE, DELETE ON ispcp.* TO 'vftp'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE ON ispcp.* TO 'vftp'@'ipaddress' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, DELETE ON ispcp.* TO 'vftp'@'localhost.localdomain' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;

-where localhost is the computername and password is the actual vftp password

After restarting the proftpd service, all is good.
12-03-2009 07:38 AM
Find all posts by this user Quote this message in a reply
kilburn Offline
Development Team
*****
Dev Team

Posts: 2,182
Joined: Feb 2007
Reputation: 34
Post: #5
RE: FTP failure after upgrade
Contrats for solving your issue! Just one comment though: you've given the vftp way too much permissions to do its work. From the ispcp setup, the (minimum) required permissions are SELECT,INSERT,UPDATE,DELETE only on tables ftp_group, ftp_users, quotalimits and quotatallies.

You can fine-tune these permissions through phpMyAdmin, which will probably be easier than manually building the queries Wink
12-03-2009 06:19 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Rusted Offline
Newbie
*

Posts: 9
Joined: Aug 2009
Reputation: 0
Post: #6
RE: FTP failure after upgrade
Thanks Kilburn,
the directions I followed were not specifically for ispcp. I will modify perms based on your suggestions.
12-03-2009 11:44 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 2 Guest(s)