proFTPD Problem

[vampire]

and as I resolve?, I don't succeed in even not entering street FTP if I create a consumer from the system (Debian 4.0 eths)

[joximu]

Well, you have to setup proftpd to use mysql to get user information.

take the original proftpd.conf - I think this should work... - or they did change some big parts..

at least you need to be able to connect to the ftp server - on lo/localhost and of course on the ethX LAN...

for the process to choose the dir, a tmp ftp user is created in the database... and with this user ispcp connects locally to the ftp server.

/J

[vampire]

This is my proftpd.confi


#
# ispCP OMEGA ProFTPd config file
#
#
#
# Includes required DSO modules. This is mandatory in proftpd 1.3
#
Include /etc/proftpd/modules.conf

ServerName "vh32137.vhosting-it.com"
ServerType standalone
DeferWelcome off

ShowSymlinks on
MultilineRFC2228 on
DefaultServer on
ShowSymlinks on
AllowOverwrite on
UseReverseDNS off
IdentLookups off
AllowStoreRestart on
AllowForeignAddress on

LogFormat traff "%b %u"

TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200

DisplayLogin welcome.msg
DisplayFirstChdir message

#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

# 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

AllowOverwrite on
HideNoAccess on

</Directory>

<Limit ALL>
IgnoreHidden on
</Limit>

<Global>
RootLogin off
# proFTPd >= 1.3: change log dirs to /var/log/proftpd
TransferLog /var/log/proftpd/
ExtendedLog /var/log/proftpd/ftp_traff.log read,write traff
PathDenyFilter "\.quota$"
</Global>

<IfModule mod_delay.c>
DelayEngine off
</IfModule>

#
# ISPCP Managment;
#
SQLBackend mysql # enable for proFTPd >= 1.3
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
SQLMinID 2000

#
# ISPCP Quota management;
#

QuotaEngine on
QuotaShowQuotas on
QuotaDisplayUnits Mb

SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_se ssion, limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_a vail, 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_x fer_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}' AN D 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-q uota-tally

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

[joximu]

You don't have this in the file do you?

SQLConnectInfo {DATABASE_NAME}@{DATABASE_HOST} {DATABASE_USER} {DATABASE_PASS}

instead of the {...} you have real values,

I have:

SQLConnectInfo ispcp@localhost vftp MyISPCftpPaSsWoRd

the password for vftp you gave when yopu were installing ispcp...

Joximu

[vampire]

Ok done, but now the error is

- warning: the DisplayFirstChdir directive is deprecated and will be removed in a future release. Please use the DisplayChdir directive.
- Fatal: unknown configuration directive 'SQLBackend' on line 91 of '/etc/proftpd.conf'

[joximu]

ok, first: should be fixed in later versions.
but SQLBackend...

hay what version do you use?

http://www.proftpd.org/docs/directives/l...ckend.html
Compatibility 1.3.0rc1 and later

or is something missing in the modules.conf?

/J

[vampire]

Now I format my server. I restart from the beginning, see you later

[BeNe]

And please install the RC3 (current trunk or nightly build)
There it should work.

Greez BeNe

[vampire]

The rc3 i have problem with installation. i tryed to install 17/nov/07 but it not install.

[BeNe]

Ok - but we need more Infos!!!
At which Point ? What happend ?

Greez BeNe