ispCP - Board - Support
Problem proftpd - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: System Setup & Installation (/forum-32.html)
+--- Thread: Problem proftpd (/thread-1519.html)



Problem proftpd - muchakk - 10-13-2007 08:08 PM

Hi! I have one problem witch proftpd. Client shows error during connection 530 me ftp where given user exists. Mysql settings is ok, maybe no?

proftpd.conf

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

ServerName "s1.3be.biz"
ServerType standalone
DeferWelcome off

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

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.

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@server user passwd
SQLUserInfo ftp_users userid passwd uid gid homedir shell
SQLGroupInfo ftp_group groupname gid members
SQLMinID 2000
SQLLOGFILE /var/log/proftpd.sql.log

#
# ISPCP Quota management;
#

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_i
n_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, file
s_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 = by
tes_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

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


Please Help me[/quote]


RE: Problem proftpd - joximu - 10-13-2007 09:55 PM

Could you also post some info from the several log files?


RE: Problem proftpd - muchakk - 10-13-2007 10:43 PM

6.26]): USER komandos@domain: no such user found from renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl [::ffff:ip] to ::ffff:85.114.128.
65:21
Oct 11 22:10:52 g065.green.fastwebserver.de proftpd[4532] g065.green.fastwebserver.de (renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl[::ffff:ip
6.26]): FTP session closed.
Oct 11 22:10:53 g065.green.fastwebserver.de proftpd[4534] g065.green.fastwebserver.de (renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl[::ffff:ip
6.26]): error setting IPV6_V6ONLY: Protocol not available
Oct 11 22:11:03 g065.green.fastwebserver.de proftpd[4534] g065.green.fastwebserver.de (renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl[::ffff:ip
6.26]): FTP session opened.
Oct 11 22:11:03 g065.green.fastwebserver.de proftpd[4534] g065.green.fastwebserver.de (renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl[::ffff:ip
6.26]): FTP session closed.
Oct 11 22:12:13 g065.green.fastwebserver.de proftpd[4361] g065.green.fastwebserver.de: ProFTPD killed (signal 15)
Oct 11 22:12:13 g065.green.fastwebserver.de proftpd[4361] g065.green.fastwebserver.de: ProFTPD 1.3.0 standalone mode SHUTDOWN
Oct 11 22:12:14 g065.green.fastwebserver.de proftpd[4749] g065.green.fastwebserver.de: error setting IPV6_V6ONLY: Protocol not available
Oct 11 22:12:14 g065.green.fastwebserver.de proftpd[4749] g065.green.fastwebserver.de: ProFTPD 1.3.0 (stable) (built mar gen 2 10:57:47 CET 2007) standalone
mode STARTUP
Oct 11 22:16:00 g065.green.fastwebserver.de proftpd[4749] g065.green.fastwebserver.de: ProFTPD killed (signal 15)
Oct 11 22:16:00 g065.green.fastwebserver.de proftpd[4749] g065.green.fastwebserver.de: ProFTPD 1.3.0 standalone mode SHUTDOWN


RE: Problem proftpd - muchakk - 10-13-2007 10:45 PM

6.26]): USER komandos@domains: no such user found from renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl [::ffff:212.182.126.26] to ::ffff:85.114.128.
65:21
Oct 11 22:10:52 g065.green.fastwebserver.de proftpd[4532] g065.green.fastwebserver.de (renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl[::ffff:ip
6.26]): FTP session closed.
Oct 11 22:10:53 g065.green.fastwebserver.de proftpd[4534] g065.green.fastwebserver.de (renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl[::ffff:ip
6.26]): error setting IPV6_V6ONLY: Protocol not available
Oct 11 22:11:03 g065.green.fastwebserver.de proftpd[4534] g065.green.fastwebserver.de (renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl[::ffff:ip
6.26]): FTP session opened.
Oct 11 22:11:03 g065.green.fastwebserver.de proftpd[4534] g065.green.fastwebserver.de (renicom.eth0.raptor-cl-renicom-wyzynna.lubman.net.pl[::ffff:ip
6.26]): FTP session closed.
Oct 11 22:12:13 g065.green.fastwebserver.de proftpd[4361] g065.green.fastwebserver.de: ProFTPD killed (signal 15)
Oct 11 22:12:13 g065.green.fastwebserver.de proftpd[4361] g065.green.fastwebserver.de: ProFTPD 1.3.0 standalone mode SHUTDOWN
Oct 11 22:12:14 g065.green.fastwebserver.de proftpd[4749] g065.green.fastwebserver.de: error setting IPV6_V6ONLY: Protocol not available
Oct 11 22:12:14 g065.green.fastwebserver.de proftpd[4749] g065.green.fastwebserver.de: ProFTPD 1.3.0 (stable) (built mar gen 2 10:57:47 CET 2007) standalone
mode STARTUP
Oct 11 22:16:00 g065.green.fastwebserver.de proftpd[4749] g065.green.fastwebserver.de: ProFTPD killed (signal 15)
Oct 11 22:16:00 g065.green.fastwebserver.de proftpd[4749] g065.green.fastwebserver.de: ProFTPD 1.3.0 standalone mode SHUTDOWN


RE: Problem proftpd - joximu - 10-14-2007 02:50 AM

hm

is there anything in the SQL Logfile?
> SQLLOGFILE /var/log/proftpd.sql.log

maybe it should be in /var/log/proftpd/sql.log ... (folder should not be world writable)
http://www.proftpd.org/docs/directives/linked/config_ref_SQLLogFile.html

/J


RE: Problem proftpd - muchakk - 10-14-2007 04:06 AM

I have repaired already, I had transmit entitlement on main folders of domains evil Smile