+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: proFTPD Problem (/thread-1819.html)
RE: proFTPD Problem - vampire - 11-20-2007 09:06 AM
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)
RE: proFTPD Problem - joximu - 11-20-2007 09:17 AM
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
RE: proFTPD Problem - vampire - 11-20-2007 09:20 AM
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>
RE: proFTPD Problem - joximu - 11-20-2007 09:31 AM
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
RE: proFTPD Problem - vampire - 11-20-2007 09:44 AM
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'
RE: proFTPD Problem - joximu - 11-20-2007 09:50 AM
ok, first: should be fixed in later versions.
but SQLBackend...
hay what version do you use?
http://www.proftpd.org/docs/directives/linked/config_ref_SQLBackend.html
Compatibility 1.3.0rc1 and later
or is something missing in the modules.conf?
/J
RE: proFTPD Problem - vampire - 11-20-2007 09:52 AM
Now I format my server. I restart from the beginning, see you later
RE: proFTPD Problem - BeNe - 11-20-2007 05:08 PM
And please install the RC3 (current trunk or nightly build)
There it should work.
Greez BeNe
RE: proFTPD Problem - vampire - 11-20-2007 07:53 PM
The rc3 i have problem with installation. i tryed to install 17/nov/07 but it not install.
RE: proFTPD Problem - BeNe - 11-20-2007 08:17 PM
Ok - but we need more Infos!!!
At which Point ? What happend ?
Greez BeNe