Hallo,
habe bereits einiges über die Probleme mit ProFTPd in Verbindung mit Debian hier gelesen.
Da ich mir aber nicht sicher bin ob meine Probleme darauf beruhen hier nochmals meine Frage !
1. mal Informationen zu meinem System :- Debian 3.0 "Woody"
- Kernel 2.6.11-3
- MySQL 4.1.10a
- ProFTPd 1.2.10 (von hier geladen)
Nach einigen Recherchen habe ich es auch hinbekommen ProFTPd zu compilieren.
Nun habe ich die Standardconfig einfach um die SQL Abfragen erweitert um es zu testen. Das funktioniert auch soweit - nur der Login schlägt mit der Meldung
"530 Login incorrect" fehl.
Nun bin ich mir nicht sicher ob das an dem Debian Problem liegt oder an meinen Configs !
Daher hier mal meine Configs und Ausgaben :
proftpd.conf :# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use. It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.
ServerName "ProFTPD Default Installation"
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 under which the server will run.
User nobody
Group nogroup
# To cause every FTP user to be "jailed" (chrooted) into their home
# directory, uncomment this line.
#DefaultRoot ~
# Normally, we want files to be overwriteable.
<Directory />
AllowOverwrite on
</Directory>
# A basic anonymous configuration, no upload directories. If you do not
# want anonymous users, simply delete this entire <Anonymous> section.
#<Anonymous ~ftp>
# User ftp
# Group ftp
#
# # We want clients to be able to login with "anonymous" as well as "ftp"
# UserAlias anonymous ftp
# # 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
# <Limit WRITE>
# DenyAll
# </Limit>
#</Anonymous>
RequireValidShell off
SQLAuthTypes Plaintext
SQLAuthenticate users*
SQLConnectInfo provider@localhost root ********
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo ftp username password uid gid homedir shell
SQLLOGFILE /var/log/proftpd.sql.log
- parsing '/usr/local/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
- FS: using system read()
- 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
- dispatching directive 'Group' to module mod_core
- dispatching auth request "getgrnam" to module mod_sql
- dispatching auth request "getgrnam" to module mod_auth_file
- dispatching auth request "getgrnam" to module mod_auth_unix
- dispatching directive '<Directory>' to module mod_core
- <Directory />: adding section for resolved path '/'
- dispatching directive 'AllowOverwrite' to module mod_xfer
- dispatching directive '</Directory>' to module mod_core
- FS: using system read()
- dispatching directive 'RequireValidShell' 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
- dispatching directive 'SQLLogFile' to module mod_sql
- FS: using system read()
- FS: using system close()
earth -
earth - Config for ProFTPD Default Installation:
earth - /
earth - AllowOverwrite
earth - Umask
earth - RequireValidShell
earth - SQLAuthTypes
earth - SQLAuthenticate
earth - SQLConnectInfo
earth - SQLDefaultGID
earth - SQLDefaultUID
earth - SQLMinUserGID
earth - SQLMinUserUID
earth - DefaultServer
earth - Umask
earth - UserID
earth - UserName
earth - GroupID
earth - GroupName
earth - RequireValidShell
earth - SQLAuthTypes
earth - SQLAuthenticate
earth - SQLConnectInfo
earth - SQLDefaultGID
earth - SQLDefaultUID
earth - SQLMinUserGID
earth - SQLMinUserUID
earth - SQLUserTable
earth - SQLUsernameField
earth - SQLPasswordField
earth - SQLUidField
earth - SQLGidField
earth - SQLHomedirField
earth - SQLShellField
earth - SQLLogFile
earth - dispatching auth request "getgroups" to module mod_sql
earth - dispatching auth request "getgroups" to module mod_auth_file
earth - dispatching auth request "getgroups" to module mod_auth_unix
earth - SETUP PRIVS at main.c:2733
earth - ROOT PRIVS at main.c:1967
earth - RELINQUISH PRIVS at main.c:1974
earth - ROOT PRIVS at main.c:2322
earth - deleting existing scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
earth - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
earth - RELINQUISH PRIVS at main.c:2348
earth - ROOT PRIVS at inet.c:322
earth - RELINQUISH PRIVS at inet.c:380
earth - ProFTPD 1.2.10 (stable) (built Sat Mar 19 00:30:45 CET 2005) standalone mode STARTUP
earth - ROOT PRIVS at main.c:2185
earth - RELINQUISH PRIVS at main.c:2187
earth - FS: using system lstat()
Hier der Auszug aus der sql.log :
Mar 19 11:44:34 mod_sql/4.11[19999]: backend module 'mod_sql_mysql/4.04'
Mar 19 11:44:34 mod_sql/4.11[19999]: backend api 'mod_sql_api_v1'
Mar 19 11:44:34 mod_sql/4.11[19999]: >>> sql_getconf
Mar 19 11:44:34 mod_sql/4.11[19999]: entering mysql cmd_defineconnection
Mar 19 11:44:34 mod_sql/4.11[19999]: name: 'default'
Mar 19 11:44:34 mod_sql/4.11[19999]: user: 'root'
Mar 19 11:44:34 mod_sql/4.11[19999]: host: 'localhost'
Mar 19 11:44:34 mod_sql/4.11[19999]: db: 'provider'
Mar 19 11:44:34 mod_sql/4.11[19999]: port: '3306'
Mar 19 11:44:34 mod_sql/4.11[19999]: ttl: '0'
Mar 19 11:44:34 mod_sql/4.11[19999]: exiting mysql cmd_defineconnection
Mar 19 11:44:34 mod_sql/4.11[19999]: entering mysql cmd_open
Mar 19 11:44:34 mod_sql/4.11[19999]: connection 'default' opened
Mar 19 11:44:34 mod_sql/4.11[19999]: connection 'default' count is now 1
Mar 19 11:44:34 mod_sql/4.11[19999]: exiting mysql cmd_open
Mar 19 11:44:34 mod_sql/4.11[19999]: backend successfully connected.
Mar 19 11:44:34 mod_sql/4.11[19999]: mod_sql status : on
Mar 19 11:44:34 mod_sql/4.11[19999]: negative_cache : off
Mar 19 11:44:34 mod_sql/4.11[19999]: authenticate : users
Mar 19 11:44:34 mod_sql/4.11[19999]: usertable : ftp
Mar 19 11:44:34 mod_sql/4.11[19999]: userid field : username
Mar 19 11:44:34 mod_sql/4.11[19999]: password field : password
Mar 19 11:44:34 mod_sql/4.11[19999]: uid field : uid
Mar 19 11:44:34 mod_sql/4.11[19999]: gid field : gid
Mar 19 11:44:34 mod_sql/4.11[19999]: homedir field : homedir
Mar 19 11:44:34 mod_sql/4.11[19999]: shell field : shell
Mar 19 11:44:34 mod_sql/4.11[19999]: homedirondemand : false
Mar 19 11:44:34 mod_sql/4.11[19999]: SQLMinUserUID : 500
Mar 19 11:44:34 mod_sql/4.11[19999]: SQLMinUserGID : 100
Mar 19 11:44:34 mod_sql/4.11[19999]: <<< sql_getconf
Mar 19 11:44:47 mod_sql/4.11[19999]: >>> cmd_getpwnam
Mar 19 11:44:47 mod_sql/4.11[19999]: entering mysql cmd_escapestring
Mar 19 11:44:47 mod_sql/4.11[19999]: exiting mysql cmd_escapestring
Mar 19 11:44:47 mod_sql/4.11[19999]: cache miss for user 'urgewalt'
Mar 19 11:44:47 mod_sql/4.11[19999]: : entering mysql cmd_select
Mar 19 11:44:47 mod_sql/4.11[19999]: entering mysql cmd_open
Mar 19 11:44:47 mod_sql/4.11[19999]: connection 'default' count is now 2
Mar 19 11:44:47 mod_sql/4.11[19999]: exiting mysql cmd_open
Mar 19 11:44:47 mod_sql/4.11[19999]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username
='urgewalt') LIMIT 1"
Mar 19 11:44:47 mod_sql/4.11[19999]: entering mysql cmd_close
Mar 19 11:44:47 mod_sql/4.11[19999]: connection 'default' count is now 1
Mar 19 11:44:47 mod_sql/4.11[19999]: exiting mysql cmd_close
Mar 19 11:44:47 mod_sql/4.11[19999]: exiting mysql cmd_select
Mar 19 11:44:47 mod_sql/4.11[19999]: cache miss for user 'urgewalt'
Mar 19 11:44:47 mod_sql/4.11[19999]: user 'urgewalt' cached
Mar 19 11:44:47 mod_sql/4.11[19999]: + pwd.pw_name : urgewalt
Mar 19 11:44:47 mod_sql/4.11[19999]: + pwd.pw_uid : 65534
Mar 19 11:44:47 mod_sql/4.11[19999]: + pwd.pw_gid : 65534
Mar 19 11:44:47 mod_sql/4.11[19999]: + pwd.pw_dir : /hosting/www/urgewalt
Mar 19 11:44:47 mod_sql/4.11[19999]: + pwd.pw_shell : /bin/false
Mar 19 11:44:47 mod_sql/4.11[19999]: <<< cmd_getpwnam
Mar 19 11:44:47 mod_sql/4.11[19999]: >>> cmd_auth
Mar 19 11:44:47 mod_sql/4.11[19999]: entering mysql cmd_escapestring
Mar 19 11:44:47 mod_sql/4.11[19999]: exiting mysql cmd_escapestring
Mar 19 11:44:47 mod_sql/4.11[19999]: cache hit for user 'urgewalt'
Mar 19 11:44:47 mod_sql/4.11[19999]: >>> cmd_check
Mar 19 11:44:47 mod_sql/4.11[19999]: checking auth_type Plaintext
Mar 19 11:44:47 mod_sql/4.11[19999]: <<< cmd_check
Mar 19 11:44:47 mod_sql/4.11[19999]: <<< cmd_auth
Mar 19 11:44:50 mod_sql/4.11[19999]: entering mysql cmd_close
Mar 19 11:44:50 mod_sql/4.11[19999]: connection 'default' closed
Mar 19 11:44:50 mod_sql/4.11[19999]: connection 'default' count is now 0
Mar 19 11:44:50 mod_sql/4.11[19999]: exiting mysql cmd_close
