[SOLVED] FTP Login nicht möglich (Ubuntu 8.04, ispCp RC6)

[CeNoRiDeR]

Hallo zusammen,

ich habe jetzt ispCp bei mir erfolgreich installiert und einen Benutzer angelegt.
Wenn der Benutzer jetzt einen FTP Account anlegt, wird der Benutzer auch in die Datenbank erzeigt (unter der Tabelle FTP User), jedoch kann ich mich nicht einloggen.

Im FTP Client kommt nur:

Status: Auflösen der IP-Adresse **.**.**
Status: Verbinde mit **.**.**.**...
Status: Verbindung hergestellt, warte auf Willkommensnachricht...
Antwort: 220 ProFTPD 1.3.1 Server (Debian) [::ffff:**.**.**.**]
Befehl: USER **USERNAME**
Antwort: 331 Password required for **USERNAME**
Befehl: PASS **********
Antwort: 530 Login incorrect.
Fehler: Herstellen der Verbindung zum Server fehlgeschlagen

Weis einer warum? Passwort ist definitiv richtig!

[joximu]

Mehr Angaben wären hilfreich...

ausserdem mal im Forum suchen, wie solche Probleme angegangen werden (proftpd manuell starten mit debug ausgabe)...

/J

PS: ist auch der username richtig, also "user@domain.tld"?

[CeNoRiDeR]

Hier der Output von proftpd -n -d5: Angelegter Benutzer = admin@test.de (test.de = ***); In der Datenbank ist der User admin@test.de vorhanden und die gruppe test.de, in der der User admin@test.de Mitglied ist...

- mod_tls/2.1.2: using OpenSSL 0.9.8g 19 Oct 2007
- DenyFilter: compiling deny regex '\*.*/'
- <IfModule>: using 'mod_quotatab.c' section at line 92
- <IfModule>: skipping 'mod_ratio.c' section at line 96
- <IfModule>: using 'mod_delay.c' section at line 104
- <IfModule>: using 'mod_ctrls.c' section at line 108
- <IfModule>: using 'mod_ctrls_admin.c' section at line 116
test.de -
test.de - Config for Debian:
test.de - DeferWelcome
test.de - DefaultServer
test.de - ShowSymlinks
test.de - TimeoutNoTransfer
test.de - TimeoutStalled
test.de - TimeoutIdle
test.de - DisplayLogin
test.de - DisplayChdir
test.de - ListOptions
test.de - DenyFilter
test.de - UserID
test.de - UserName
test.de - GroupID
test.de - GroupName
test.de - Umask
test.de - DirUmask
test.de - AllowOverwrite
test.de - TransferLog
test.de - QuotaEngine
test.de - DelayEngine
test.de - ProFTPD 1.3.1 (stable) (built Thu Feb 21 04:21:14 UTC 2008) standalone mode STARTUP
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - FTP session requested from unknown class
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - connected - local : ::ffff:192.168.178.30:21
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - connected - remote : ::ffff:84.173.42.61:62322
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - FTP session opened.
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'USER admin@test.de' to mod_rewrite
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'USER admin@test.de' to mod_tls
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'USER admin@test.de' to mod_core
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'USER admin@test.de' to mod_core
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'USER admin@test.de' to mod_delay
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'USER admin@test.de' to mod_auth
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching CMD command 'USER admin@test.de' to mod_auth
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - no supplemental groups found for user 'admin@test.de'
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching POST_CMD command 'USER admin@test.de' to mod_sql
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching POST_CMD command 'USER admin@test.de' to mod_delay
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching LOG_CMD command 'USER admin@test.de' to mod_sql
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching LOG_CMD command 'USER admin@test.de' to mod_log
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap2
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_ban
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_sql
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching CMD command 'PASS (hidden)' to mod_auth
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - no supplemental groups found for user 'admin@test.de'
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - no such user 'admin@test.de'
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - USER admin@test.de: no such user found from p54AD2A3D.dip0.t-ipconnect.de [::ffff:84.173.42.61] to ::ffff:192.168.178.30:21
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_delay
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
test.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]) - FTP session closed.

[CeNoRiDeR]

Kann es sein, dass ich noch die proftpd bearbeiten muss, um die FTP User aus der DB zu lesen?

die proftpd log zeigt mir:

Oct 20 21:18:06 **.de proftpd[6192] **.de (p54AD2A3D.dip0.t-ipconnect.de[::ffff:84.173.42.61]): USER admin@**.de: no such user found from p54AD2A3D.dip0.t-ipconnect.de [::ffff:84.173.42.61] to ::ffff:192.168.178.30:21


Normal sollte das doch ispCP selber machen!?

Hat jemand eine Idee?

[Kotty]

poste mal deine modules.conf vom proftpd.

[CeNoRiDeR]

#
# This file is used to manage DSO modules and features.
#

# This is the directory where DSO modules reside

ModulePath /usr/lib/proftpd

# Allow only user root to load and unload modules, but allow everyone
# to see which modules have been loaded

ModuleControlsACLs insmod,rmmod allow user root
ModuleControlsACLs lsmod allow user *

LoadModule mod_ctrls_admin.c
LoadModule mod_tls.c
LoadModule mod_sql.c
LoadModule mod_ldap.c

#
# 'SQLBackend mysql' or 'SQLBackend postgres' directives are required
# to have SQL authorization working. You can also comment out the
# unused module here, in alternative.
#
LoadModule mod_sql_mysql.c
LoadModule mod_sql_postgres.c

LoadModule mod_radius.c
LoadModule mod_quotatab.c
LoadModule mod_quotatab_file.c
LoadModule mod_quotatab_ldap.c
LoadModule mod_quotatab_sql.c
LoadModule mod_quotatab_radius.c
LoadModule mod_wrap.c
LoadModule mod_rewrite.c
LoadModule mod_load.c
LoadModule mod_ban.c
LoadModule mod_wrap2.c
LoadModule mod_wrap2_file.c
LoadModule mod_wrap2_sql.c

# keep this module the last one
LoadModule mod_ifsession.c

[joximu]

Quote:#
# 'SQLBackend mysql' or 'SQLBackend postgres' directives are required
# to have SQL authorization working. You can also comment out the
# unused module here, in alternative.
#

mach das mal... scheint was neues zu sein...

[Gos77]

Moins,

ich hatte mit der RC5 mal so nen Problem, da hatte er in der proftpd.conf die Daten für den MySQL vftp-User nicht ordentlich eingetragen und die Variablen aus dem Template in geschweiften Klammern beibehalten.

Nachdem ich dann die Variablen für den MySQL-Zugang richtig in der proftpd.conf gesetzt hatte, funktioniertes es einwandfrei.

Mit der RC6 hatte ich jedoch dieses Problem bisher nicht.

Gruß Gos77

[Kotty]

(10-21-2008 09:25 AM)joximu Wrote:  

Quote:#
# 'SQLBackend mysql' or 'SQLBackend postgres' directives are required
# to have SQL authorization working. You can also comment out the
# unused module here, in alternative.
#

mach das mal... scheint was neues zu sein...

Bei Ubuntu 8.04 is des gleiche wie bei debian lenny proftpd version 1.3.1

folgendes sollte man in der /etc/proftpd/proftpd.conf finden

Code:

SQLBackend                 mysql
SQLAuthTypes               Crypt
SQLAuthenticate            on
SQLConnectInfo             ispcp@localhost vftp LustigesPasswort
SQLUserInfo                ftp_users userid passwd uid gid homedir shell
SQLGroupInfo               ftp_group groupname gid members
SQLMinUserUID              2000
SQLMinUserGID              2000

hast du das Paket proftpd-mysql installiert?

[CeNoRiDeR]

Ich habe die Installation wie in der Ubuntu Anleitung beschrieben gemacht -> apt-get install $(cat ./docs/Ubuntu/ubuntu-packages-hardy)

ansonsten habe ich nichts zusätlich installiert!