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


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[Reload] Debian vs ISPCP FTP User Problem
Author Message
Muluske Offline
Junior Member
*

Posts: 35
Joined: Apr 2009
Reputation: 0
Post: #1
[Reload] Debian vs ISPCP FTP User Problem
Hallo!

Ich greife hier nochmal das FTP-User Problem auf.
Wie schon bekannt sein dürfte, kann man keinen FTP Zugang einrichten/herstellen, wenn man ISPCP über VAdmin installiert.

Der Fehler liegt darin, das sämtliche Daten zu mysql nicht angelegt werden.

Die Lösung sollte mit diesem Script erreicht werden indem man die proftpd.conf damit überschreibt.
Code:
#
# ispCP ω (OMEGA) a Virtual Hosting Control System
#
# @copyright    2001-2006 by moleSoftware GmbH
# @copyright    2006-2009 by ispCP | http://isp-control.net
# @version        SVN: $Id: proftpd1.3.conf.lenny 1793 2009-05-19 17:07:18Z benedikt $
# @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
  AuthOrder                mod_sql.c
</IfModule>
<IfModule !mod_sql_mysql.c>
  LoadModule               mod_sql_mysql.c
  AuthOrder                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=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             {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/*



Nur leider funktioniert das auch nicht, weil dann der FTP nicht mehr läuft und diese Meldung als Fehler angezeigt wird:

Quote:Starting ftp server: proftpd - Fatal: AuthOrder: AuthOrder has already been configured on line 114 of '/etc/proftpd/proftpd.conf' failed!

Wo nun der Wurm in der Zeile 114 liegen soll, ist mir jedenfalls unbegreiflich....Sad Vielleicht hat ja jemand noch einen Tipp was nun hier los ist?Wink

PS: Die Platzhalter sollen und waren natürlich ausgefüllt, als Beispiel habe ich diese aber jetzt nicht ersetzt.

Vielleicht könnte ja jemand auch einfach eine funktionierende proftpd.conf posten um die Fehlerquelle zu finden.

MFG
(This post was last modified: 11-09-2009 08:35 AM by ZooL.)
11-09-2009 02:44 AM
Find all posts by this user Quote this message in a reply
WuChEn Offline
Junior Member
*

Posts: 192
Joined: Feb 2009
Reputation: 2
Post: #2
RE: [Reload] Debian vs ISPCP FTP User Problem
Änder mal deinen

# Loading required modules

Bereich in. Smile

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

Gruß WU
11-09-2009 06:44 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Muluske Offline
Junior Member
*

Posts: 35
Joined: Apr 2009
Reputation: 0
Post: #3
RE: [Reload] Debian vs ISPCP FTP User Problem
Hmm, FTP läuft.
Aber, die FTP-Anmeldung schlägt wieder fehl. Sad

Oder hängt der Fehler in dieser Zeile?:

Quote:SQLConnectInfo ispcp@localhost vftp rootpasswort
(This post was last modified: 11-09-2009 07:40 AM by Muluske.)
11-09-2009 07:21 AM
Find all posts by this user Quote this message in a reply
ZooL Offline
Moderator
*****
Moderators

Posts: 3,429
Joined: Jan 2007
Reputation: 79
Post: #4
RE: [Reload] Debian vs ISPCP FTP User Problem
wenn die anmeldung fehl schlägt ja liegt es daran...tip ich drauf..
ist aber ohne logs ein nadel im heuhaufen suchen...


mfg
11-09-2009 08:14 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Muluske Offline
Junior Member
*

Posts: 35
Joined: Apr 2009
Reputation: 0
Post: #5
RE: [Reload] Debian vs ISPCP FTP User Problem
Welchen Log würdest du gebrauchen?
(This post was last modified: 11-09-2009 08:19 AM by Muluske.)
11-09-2009 08:19 AM
Find all posts by this user Quote this message in a reply
ZooL Offline
Moderator
*****
Moderators

Posts: 3,429
Joined: Jan 2007
Reputation: 79
Post: #6
RE: [Reload] Debian vs ISPCP FTP User Problem
naja vieleicht ist das deamon.log auth.log und diverse ispcp ftp logs...

nicht nur ich alle hier brauchen die Big Grin
11-09-2009 08:25 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Muluske Offline
Junior Member
*

Posts: 35
Joined: Apr 2009
Reputation: 0
Post: #7
RE: [Reload] Debian vs ISPCP FTP User Problem
Habe hier mal den daemon.log herausgezogen:

Quote:Nov 8 16:52:17 vadmin33 proftpd[9166]: vadmin33 (127.0.0.1[127.0.0.1]) - FTP session opened.
Nov 8 16:52:17 vadmin33 proftpd[9166]: vadmin33 (127.0.0.1[127.0.0.1]) - no such user 'sbecker'
Nov 8 16:54:46 vadmin33 proftpd[9179]: vadmin33 (127.0.0.1[127.0.0.1]) - FTP session opened.
Nov 8 16:54:46 vadmin33 proftpd[9179]: vadmin33 (127.0.0.1[127.0.0.1]) - no such user 'sbecker'
Nov 8 16:57:19 vadmin33 proftpd[9193]: vadmin33 (127.0.0.1[127.0.0.1]) - FTP session opened.
Nov 8 16:57:19 vadmin33 proftpd[9193]: vadmin33 (127.0.0.1[127.0.0.1]) - no such user 'sbecker'
Nov 8 16:58:07 vadmin33 proftpd[9204]: vadmin33 (127.0.0.1[127.0.0.1]) - FTP session opened.
Nov 8 16:58:07 vadmin33 proftpd[9204]: vadmin33 (127.0.0.1[127.0.0.1]) - no such user 'sbecker'
Nov 8 16:58:30 vadmin33 proftpd[9145]: vadmin33 - ProFTPD killed (signal 15)
Nov 8 16:58:30 vadmin33 proftpd[9145]: vadmin33 - ProFTPD 1.3.1 standalone mode SHUTDOWN
Nov 8 17:00:21 vadmin33 ispcp_daemon[9307]: child 9307 started !
Nov 8 17:00:21 vadmin33 ispcp_daemon[9307]: read_line(): socket read error: Connection reset by peer
Nov 8 17:15:36 vadmin33 ispcp_daemon[9340]: child 9340 started !
Nov 8 17:15:36 vadmin33 ispcp_daemon[9340]: read_line(): socket read error: Connection reset by peer
Nov 8 22:12:57 vadmin33 proftpd[10346]: vadmin33 - ProFTPD 1.3.1 (stable) (built Thu Oct 29 09:01:50 UTC 2009) standalone mode STARTUP
Nov 8 22:13:45 vadmin33 ispcp_daemon[10359]: child 10359 started !
Nov 8 22:13:45 vadmin33 ispcp_daemon[10359]: read_line(): socket read error: Connection reset by peer
Nov 8 22:13:45 vadmin33 proftpd[10360]: vadmin33 (xxx.40.192.xx[xxx.40.192.xx]) - FTP session opened.
Nov 8 22:13:45 vadmin33 proftpd[10360]: vadmin33 (xxx.40.192.xx[xxx.40.192.xx]) - FTP session closed.
Nov 8 22:16:07 vadmin33 proftpd[10376]: vadmin33 (127.0.0.1[127.0.0.1]) - FTP session opened.
Nov 8 22:16:07 vadmin33 proftpd[10376]: vadmin33 (127.0.0.1[127.0.0.1]) - no such user 'sbecker'
Nov 8 22:29:21 vadmin33 proftpd[10346]: vadmin33 - ProFTPD killed (signal 15)
Nov 8 22:29:21 vadmin33 proftpd[10346]: vadmin33 - ProFTPD 1.3.1 standalone mode SHUTDOWN
Nov 8 22:32:53 vadmin33 proftpd[10505]: vadmin33 - ProFTPD 1.3.1 (stable) (built Thu Oct 29 09:01:50 UTC 2009) standalone mode STARTUP
Nov 8 22:34:43 vadmin33 proftpd[10525]: vadmin33 (127.0.0.1[127.0.0.1]) - FTP session opened.
Nov 8 22:34:43 vadmin33 proftpd[10525]: vadmin33 (127.0.0.1[127.0.0.1]) - no such user 'sbecker'
Nov 8 22:46:10 vadmin33 proftpd[10505]: vadmin33 - ProFTPD killed (signal 15)
Nov 8 22:46:10 vadmin33 proftpd[10505]: vadmin33 - ProFTPD 1.3.1 standalone mode SHUTDOWN
Nov 8 23:06:43 vadmin33 proftpd[10738]: vadmin33 - ProFTPD 1.3.1 (stable) (built Thu Oct 29 09:01:50 UTC 2009) standalone mode STARTUP
Nov 8 23:07:51 vadmin33 proftpd[10754]: vadmin33 (127.0.0.1[127.0.0.1]) - FTP session closed.
Nov 8 23:08:12 vadmin33 proftpd[10755]: vadmin33 (127.0.0.1[127.0.0.1]) - FTP session closed.
Nov 8 23:08:43 vadmin33 ispcp_daemon[10761]: child 10761 started !
Nov 8 23:08:43 vadmin33 ispcp_daemon[10761]: read_line(): socket read error: Connection reset by peer
Nov 8 23:08:43 vadmin33 proftpd[10762]: vadmin33 (xxx.40.192.xx[xxx.40.192.xx]) - FTP session closed.
Nov 8 23:10:08 vadmin33 ispcp_daemon[10777]: child 10777 started !
Nov 8 23:10:08 vadmin33 ispcp_daemon[10777]: read_line(): socket read error: Connection reset by peer
Nov 8 23:10:08 vadmin33 proftpd[10778]: vadmin33 (xxx.40.192.xx[xxx.40.192.xx]) - FTP session closed.
Nov 8 23:15:35 vadmin33 proftpd[10738]: vadmin33 - ProFTPD killed (signal 15)
Nov 8 23:15:35 vadmin33 proftpd[10738]: vadmin33 - ProFTPD 1.3.1 standalone mode SHUTDOWN
(This post was last modified: 11-09-2009 08:42 AM by Muluske.)
11-09-2009 08:41 AM
Find all posts by this user Quote this message in a reply
WuChEn Offline
Junior Member
*

Posts: 192
Joined: Feb 2009
Reputation: 2
Post: #8
RE: [Reload] Debian vs ISPCP FTP User Problem
Steht doch klar da, der user "sbecker" gibt es nicht. Smile

Gruß WU
11-09-2009 07:20 PM
Visit this user's website Find all posts by this user Quote this message in a reply
TheCry Away
Member
***

Posts: 851
Joined: Oct 2008
Reputation: 21
Post: #9
RE: [Reload] Debian vs ISPCP FTP User Problem
(11-09-2009 07:20 PM)WuChEn Wrote:  Steht doch klar da, der user "sbecker" gibt es nicht. Smile

Gruß WU

Vielleicht sollte er es mal mit "sbecker@domain.tld" probieren... Wink
11-09-2009 07:35 PM
Find all posts by this user Quote this message in a reply
joximu Offline
helper
*****
Moderators

Posts: 7,024
Joined: Jan 2007
Reputation: 92
Post: #10
RE: [Reload] Debian vs ISPCP FTP User Problem
Benutzernamen im ftp sind nach ispcp-Standard: user@domain.tld
also sbecker@diedomain.de

Probleme mit proftpd werden am besten analysiert, wenn proftpd im debug modus gestartet wird:

proftpd beenden und dann "proftpd -nd5" dann sieht man gleich was passiert.

/J
11-09-2009 07:43 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


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