[SOLVED] Problems with FTP

[DiXeoN]

Ill now try Debian Lenny with RC7

[sci2tech]

Again, try last trunk. In RC7 is an error that was corrected in trunk.

[DiXeoN]

allright - i will

[DiXeoN]

Still that damn error..

What the hell is going wrong?

Or, now i got this when i tried to start proftpd:

Quote:main:/var/www/ispcp/engine/setup# /etc/init.d/proftpd start
Starting ftp server: proftpd - Fatal: SQLMinUserUID: requires a numeric argument on line 183 of '/etc/proftpd/proftpd.conf'
failed!

Changed the MinUserUID to 1 and maxuseruid to 9999, and it started up,

Quote:main:/var/www/ispcp/engine/setup# /etc/init.d/proftpd start
Starting ftp server: proftpd - processing configuration directory '/etc/proftpd/ispcp'

But i still cant login?

It just goes:

Quote:[R] Connecting to 192.168.1.38 -> IP=192.168.1.38 PORT=21 (attempt # 1)
[R] Connected to 192.168.1.38
[R] Connection failed (Connection lost)

I really dont understand this..

[DiXeoN]

Nobody?

[rbtux]

now you should know what infos to provide that we can help you... redo the steps you done before...

[DiXeoN]

Allright - here it goes!

This is what i get when typing proftpd -n -d 5:

Quote:main:~# proftpd -n -d 5
- mod_tls/2.1.2: using OpenSSL 0.9.8g 19 Oct 2007
- disabling runtime support for IPv6 connections
- DenyFilter: compiling deny regex '\*.*/'
- <Directory /*>: deferring resolution of path
- PathDenyFilter: compiling deny regex '.quota$'
- <IfModule>: using '!mod_sql.c' section at line 108
- <IfModule>: using '!mod_sql_mysql.c' section at line 111
- <IfModule>: skipping '!mod_quotatab.c' section at line 114
- <IfModule>: using '!mod_quotatab_sql.c' section at line 117
- <IfModule>: using 'mod_quotatab.c' section at line 138
- <IfModule>: skipping 'mod_ratio.c' section at line 153
- <IfModule>: using 'mod_delay.c' section at line 160
- <IfModule>: using 'mod_ctrls.c' section at line 164
- <IfModule>: using 'mod_ctrls_admin.c' section at line 172
- processing configuration directory '/etc/proftpd/ispcp'
- <Directory ~/backups>: deferring resolution of path
- <Directory /var/www/virtual/cms.eu.bogus/backups/*>: deferring resolution of path
- <Directory ~/cgi-bin>: deferring resolution of path
- <Directory ~/cgi-bin/*>: deferring resolution of path
- <Directory ~/htdocs>: deferring resolution of path
- <Directory ~/htdocs/*>: deferring resolution of path
- <Directory ~/errors>: deferring resolution of path
- <Directory ~/errors/*>: deferring resolution of path
- <Directory ~/logs>: deferring resolution of path
- <Directory ~/logs/*>: deferring resolution of path
- <Directory ~/phptmp>: deferring resolution of path
- <Directory ~/phptmp/*>: deferring resolution of path
- <Directory ~/statistics>: deferring resolution of path
- <Directory ~/statistics/*>: deferring resolution of path
main.nemcom.dk -
main.nemcom.dk - Config for {HOST_NAME}:
main.nemcom.dk - ~/statistics/*
main.nemcom.dk - Limit
main.nemcom.dk - AllowAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/statistics
main.nemcom.dk - Limit
main.nemcom.dk - DenyAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/phptmp/*
main.nemcom.dk - Limit
main.nemcom.dk - AllowAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/phptmp
main.nemcom.dk - Limit
main.nemcom.dk - DenyAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/logs/*
main.nemcom.dk - Limit
main.nemcom.dk - AllowAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/logs
main.nemcom.dk - Limit
main.nemcom.dk - DenyAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/errors/*
main.nemcom.dk - Limit
main.nemcom.dk - AllowAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/errors
main.nemcom.dk - Limit
main.nemcom.dk - DenyAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/htdocs/*
main.nemcom.dk - Limit
main.nemcom.dk - AllowAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/htdocs
main.nemcom.dk - Limit
main.nemcom.dk - DenyAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/cgi-bin/*
main.nemcom.dk - Limit
main.nemcom.dk - AllowAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/cgi-bin
main.nemcom.dk - Limit
main.nemcom.dk - DenyAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - /var/www/virtual/cms.eu.bogus/backups/*
main.nemcom.dk - Limit
main.nemcom.dk - AllowAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - ~/backups
main.nemcom.dk - Limit
main.nemcom.dk - DenyAll
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - Limit
main.nemcom.dk - IgnoreHidden
main.nemcom.dk - /*
main.nemcom.dk - Umask
main.nemcom.dk - DirUmask
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - HideNoAccess
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - DeferWelcome
main.nemcom.dk - DefaultServer
main.nemcom.dk - ShowSymlinks
main.nemcom.dk - AllowOverwrite
main.nemcom.dk - IdentLookups
main.nemcom.dk - AllowStoreRestart
main.nemcom.dk - AllowForeignAddress
main.nemcom.dk - TimeoutLogin
main.nemcom.dk - TimeoutNoTransfer
main.nemcom.dk - TimeoutStalled
main.nemcom.dk - TimeoutIdle
main.nemcom.dk - DisplayLogin
main.nemcom.dk - DisplayChdir
main.nemcom.dk - ListOptions
main.nemcom.dk - DenyFilter
main.nemcom.dk - DefaultRoot
main.nemcom.dk - UserID
main.nemcom.dk - UserName
main.nemcom.dk - GroupID
main.nemcom.dk - GroupName
main.nemcom.dk - QuotaEngine
main.nemcom.dk - QuotaShowQuotas
main.nemcom.dk - QuotaDisplayUnits
main.nemcom.dk - SQLNamedQuery_get-quota-limit
main.nemcom.dk - SQLNamedQuery_get-quota-tally
main.nemcom.dk - SQLNamedQuery_update-quota-tally
main.nemcom.dk - SQLNamedQuery_insert-quota-tally
main.nemcom.dk - QuotaLock
main.nemcom.dk - QuotaLimitTable
main.nemcom.dk - QuotaTallyTable
main.nemcom.dk - DelayEngine
main.nemcom.dk - SQLBackend
main.nemcom.dk - SQLAuthTypes
main.nemcom.dk - SQLAuthenticate
main.nemcom.dk - SQLConnectInfo
main.nemcom.dk - SQLUserTable
main.nemcom.dk - SQLUsernameField
main.nemcom.dk - SQLPasswordField
main.nemcom.dk - SQLUidField
main.nemcom.dk - SQLGidField
main.nemcom.dk - SQLHomedirField
main.nemcom.dk - SQLShellField
main.nemcom.dk - SQLGroupTable
main.nemcom.dk - SQLGroupnameField
main.nemcom.dk - SQLGroupGIDField
main.nemcom.dk - SQLGroupMembersField
main.nemcom.dk - SQLMinUserUID
main.nemcom.dk - SQLMinUserGID
main.nemcom.dk - SQLLogFile
main.nemcom.dk - RootLogin
main.nemcom.dk - TransferLog
main.nemcom.dk - ExtendedLog
main.nemcom.dk - PathDenyFilter
main.nemcom.dk - mod_lang/0.8: binding to text domain 'proftpd' using locale path '/usr/share/locale'
main.nemcom.dk - ProFTPD 1.3.1 (stable) (built Mon Dec 15 17:10:41 GMT 2008) standalone mode STARTUP
main.nemcom.dk (192.168.1.39[192.168.1.39]) - FTP session requested from unknown class
main.nemcom.dk (192.168.1.39[192.168.1.39]) - FTP session closed.

The SQL Log file:

Quote:Jan 16 15:35:12 mod_sql/4.2.2[20248]: defaulting to 'mysql' backend
Jan 16 15:35:12 mod_sql/4.2.2[20248]: backend module 'mod_sql_mysql/4.0.7'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: backend api 'mod_sql_api_v1'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: >>> sql_sess_init
Jan 16 15:35:12 mod_sql/4.2.2[20248]: entering mysql cmd_defineconnection
Jan 16 15:35:12 mod_sql/4.2.2[20248]: name: 'default'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: user: '{DATABASE_USER}'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: host: '{DATABASE_HOST}'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: db: '{DATABASE_NAME}'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: port: '3306'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: ttl: '0'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: exiting mysql cmd_defineconnection
Jan 16 15:35:12 mod_sql/4.2.2[20248]: entering mysql cmd_open
Jan 16 15:35:12 mod_sql/4.2.2[20248]: exiting mysql cmd_open
Jan 16 15:35:12 mod_sql/4.2.2[20248]: unrecoverable backend error
Jan 16 15:35:12 mod_sql/4.2.2[20248]: error: '2005'
Jan 16 15:35:12 mod_sql/4.2.2[20248]: message: 'Unknown MySQL server host '{DATABASE_HOST}' (1)'

ispCP proftpd Config file:

Quote:#
# 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 "{HOST_NAME}"
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
DisplayChdir 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>

# Loading required modules
<IfModule !mod_sql.c>
LoadModule mod_sql.c
</IfModule>
<IfModule !mod_sql_mysql.c>
LoadModule mod_sql_mysql.c
</IfModule>
<IfModule !mod_quotatab.c>
LoadModule mod_quotatab.c
</IfModule>
<IfModule !mod_quotatab_sql.c>
LoadModule mod_quotatab_sql.c
</IfModule>


#
# 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=de...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 {DATABASE_NAME}@{DATABASE_HOST} {DATABASE_USER} {DATABASE_PASS}
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinUserUID {FTPD_MIN_UID}
SQLMinUserGID {FTPD_MIN_GID}

# 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/*

This should be it..

Its the latest trunk on a 32bit Debian Lenny system

[xxo]

Jan 16 15:35:12 mod_sql/4.2.2[20248]: message: 'Unknown MySQL server host '{DATABASE_HOST}' (1)'

use 127.0.0.1 as {DATABASE_HOST} in the proftpd config.
what is the output if you ping {DATABASE_HOST}?

[DiXeoN]

xxo: I was also wondering why it used those values, and not the real ones.. maybe something went wrong in the install script?

How should i ping it?

P.s. Could someone please give me the ftp database name and user?

[rbtux]

OK lets try:

Set ServerName to your Hostname...
Set SQLConnectInfo to ispcp@localhost vftp [PASSWORD]
The password is what you provided when the install script asked for the vftp password ;-)

SQLMinUserUID 2000
SQLMinUserGID 2000