User können sich nicht einloggen (proFTPD mit mySQL)

[superbike]

Hallo Leute,
Habe ProFTPD mit mySQL fehlerfrei compiliert (http://www.proftpd.de/HowTo__SQL.29.0.html) und
nach killall proftp starte ich im Debugmode lexus:/opt/lampp/proftpd-1.2.10/proftpd -nd9 und versuche mich als user ftptest anzumelden mit folgender Debugausgabe

Code: Select all

 - parsing '/opt/lampp/etc/proftpd.conf' configuration
 - FS: using system open()
 - FS: using system read()
 - dispatching directive 'ServerName' to module mod_core
 - dispatching directive 'ServerType' to module mod_core
 - dispatching directive 'DefaultServer' to module mod_core
 - dispatching directive 'Port' to module mod_core
 - dispatching directive 'Umask' to module mod_core
 - dispatching directive 'MaxInstances' to module mod_core
 - dispatching directive 'User' to module mod_core
 - dispatching auth request "getpwnam" to module mod_sql
 - dispatching auth request "getpwnam" to module mod_auth_file
 - dispatching auth request "getpwnam" to module mod_auth_unix
 - FS: using system read()
 - dispatching directive '<Directory>' to module mod_core
 - <Directory /opt/lampp/htdocs/*>: adding section for resolved path '/opt/lampp/htdocs/*'
 - dispatching directive 'AllowOverwrite' to module mod_xfer
 - dispatching directive '</Directory>' to module mod_core
 - dispatching directive 'DefaultRoot' to module mod_auth
 - dispatching directive 'UserPassword' to module mod_auth
 - dispatching directive 'RequireValidShell' to module mod_auth
 - dispatching directive 'UseFtpUsers' to module mod_auth
 - dispatching directive 'SQLAuthTypes' to module mod_sql
 - dispatching directive 'SQLAuthenticate' to module mod_sql
 - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated.  Use AuthOrder for setting authoritativeness
 - dispatching directive 'SQLConnectInfo' to module mod_sql
 - dispatching directive 'SQLDefaultGID' to module mod_sql
 - dispatching directive 'SQLDefaultUID' to module mod_sql
 - dispatching directive 'SQLMinUserGID' to module mod_sql
 - dispatching directive 'SQLMinUserUID' to module mod_sql
 - dispatching directive 'SQLUserInfo' to module mod_sql
 - FS: using system read()
 - FS: using system read()
 - dispatching directive 'SQLLogFile' to module mod_sql
 - FS: using system read()
 - FS: using system close()
192.168.1.55 -
192.168.1.55 - Config for ProFTPD:
192.168.1.55 - /opt/lampp/htdocs/*
192.168.1.55 -  AllowOverwrite
192.168.1.55 -  Umask
192.168.1.55 -  UserPassword
192.168.1.55 -  RequireValidShell
192.168.1.55 -  UseFtpUsers
192.168.1.55 -  SQLAuthTypes
192.168.1.55 -  SQLAuthenticate
192.168.1.55 -  SQLConnectInfo
192.168.1.55 -  SQLDefaultGID
192.168.1.55 -  SQLDefaultUID
192.168.1.55 -  SQLMinUserGID
192.168.1.55 -  SQLMinUserUID
192.168.1.55 - DefaultServer
192.168.1.55 - Umask
192.168.1.55 - UserID
192.168.1.55 - UserName
192.168.1.55 - DefaultRoot
192.168.1.55 - UserPassword
192.168.1.55 - RequireValidShell
192.168.1.55 - UseFtpUsers
192.168.1.55 - SQLAuthTypes
192.168.1.55 - SQLAuthenticate
192.168.1.55 - SQLConnectInfo
192.168.1.55 - SQLDefaultGID
192.168.1.55 - SQLDefaultUID
192.168.1.55 - SQLMinUserGID
192.168.1.55 - SQLMinUserUID
192.168.1.55 - SQLUserTable
192.168.1.55 - SQLUsernameField
192.168.1.55 - SQLPasswordField
192.168.1.55 - SQLUidField
192.168.1.55 - SQLGidField
192.168.1.55 - SQLHomedirField
192.168.1.55 - SQLShellField
192.168.1.55 - SQLLogFile
192.168.1.55 - dispatching auth request "getgroups" to module mod_sql
192.168.1.55 - dispatching auth request "getgroups" to module mod_auth_file
192.168.1.55 - dispatching auth request "getgroups" to module mod_auth_unix
192.168.1.55 - SETUP PRIVS at main.c:2733
192.168.1.55 - ROOT PRIVS at main.c:1967
192.168.1.55 - RELINQUISH PRIVS at main.c:1974
192.168.1.55 - ROOT PRIVS at main.c:2322
192.168.1.55 - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
192.168.1.55 - RELINQUISH PRIVS at main.c:2348
192.168.1.55 - ROOT PRIVS at inet.c:322
192.168.1.55 - RELINQUISH PRIVS at inet.c:380
192.168.1.55 - ProFTPD 1.2.10 (stable) (built Fri Mar 18 14:16:57 CET 2005) standalone mode STARTUP
192.168.1.55 - ROOT PRIVS at main.c:2185
192.168.1.55 - RELINQUISH PRIVS at main.c:2187
192.168.1.55 - FS: using system lstat()
192.168.1.55 - ROOT PRIVS at main.c:1162
192.168.1.55 - RELINQUISH PRIVS at main.c:1166
192.168.1.55 - FS: using system lstat()
192.168.1.55 - FS: using system lstat()
192.168.1.55 (192.168.1.55[192.168.1.55]) - ROOT PRIVS at main.c:1011
192.168.1.55 (192.168.1.55[192.168.1.55]) - SETUP PRIVS at main.c:1016
192.168.1.55 (192.168.1.55[192.168.1.55]) - FTP session requested from unknown class
192.168.1.55 (192.168.1.55[192.168.1.55]) - performing module session initializations
192.168.1.55 (192.168.1.55[192.168.1.55]) - ROOT PRIVS at mod_sql.c:3657
192.168.1.55 (192.168.1.55[192.168.1.55]) - RELINQUISH PRIVS at mod_sql.c:3659
192.168.1.55 (192.168.1.55[192.168.1.55]) - FTP session closed.
192.168.1.55 - FS: using system lstat()
192.168.1.55 - scrubbing scoreboard
192.168.1.55 - ROOT PRIVS at mod_core.c:130
192.168.1.55 - RELINQUISH PRIVS at mod_core.c:132
192.168.1.55 - ROOT PRIVS at mod_core.c:160
192.168.1.55 - RELINQUISH PRIVS at mod_core.c:189
192.168.1.55 - FS: using system lstat()


Habe mit phpMyAdmin die Datenbank ProFTPD erstellt (http://www.proftpd.de/files/proftpd_sql.sql) und den user ftptest manuell angelegt. Ich kann mich aber weder mit diesem user noch als Linuxuser anmelden.

Code: Select all

#'/opt/lampp/etc/proftpd.conf'
ServerName         "ProFTPD"
ServerType         standalone
DefaultServer         on
# Port 21 is the standard FTP port.
Port            21
# Umask 022 is a good standard umask to prevent new dirs and files
# from being group and world writable.
Umask            022
# 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 /opt/lampp/htdocs/*>
  AllowOverwrite      on
</Directory>
# only for the web servers content
# DefaultRoot /opt/lampp/htdocs
DefaultRoot /webhosts/ftp
# nobody gets the password "lampp"
# commented out by lampp security
#UserPassword nobody wRPBu8u4YP0CY
UserPassword nobody 0IKB8EtLp8Dhw
# nobody is no normal user so we have to allow users with no real shell
RequireValidShell off
# nobody may be in /etc/ftpusers so we also have to ignore this file
UseFtpUsers off
 SQLAuthTypes Plaintext

SQLAuthenticate users*
SQLConnectInfo ProFTPD@localhost ftptest ftptest
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo ftp username password uid gid homedir shell
SQLLogFile /var/log/proftpd/proftpd.sql.log


Versuche mich lokal mit ftp://ftptest@localhost/ anzumelden, aber im Browser kommt nicht mal das Loginfenster zur PW Eingabe ....
Wer kann mir helfen; ich habe sicher hier in der config Datei was nicht sauber angepasst Danke schon im voraus

[superbike]

Versuche mich lokal mit ftp://ftptest@localhost/ anzumelden, aber im Browser kommt nicht mal das Loginfenster zur PW Eingabe ....

Hallo Leute,
hab den ftp gestern nochmals in die Hände genommen und siehe da:
Mit Konsolenoutput (proftpd -nd9) und proftpd.sql Logfile kam ich zur Lösung:

1. error 1045 access denied for user --> Benutzer ftptest hatte keine Rechte für die mySQL-Datenbank. Benutzerrechte mit Webmin auf "Alle" gesetzt. http://www.proftpd.de/forum/viewtopic.p ... light=1045
Folge: Loginprompt erscheint nun schon einmal

2. Loginfehler 530 behoben, nachdem ich in proftpd.conf ein gültiges SQLDefaultHomedir (und noch SQLHomedirOnDemand On) gesetzt habe.

Damit ist auch diese Problem aus der Welt geschaft. Dank ans Forum und allen Schreiberlinge.