Ich habe auf meine Computer Suse Linux 9.1 mit Mysql 5.0.15 und Proftpd 1.2.10. Immer wenn ich Proftpd mit Mysql starte kommt beim Client "Die FTP-Situng wurde beendet". Lösche ich die SQL zeilen in der proftpd.conf funktioniert der Login, aber nur mit dem localen Benutzern.
- parsing '/usr/local/proftpd/conf/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 'IdentLookups' 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
- 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
- FS: using system read()
- dispatching directive 'AllowOverwrite' to module mod_xfer
- dispatching directive '<Limit>' to module mod_core
- dispatching directive 'DenyAll' to module mod_core
- dispatching directive '</Limit>' to module mod_core
- dispatching directive '<Anonymous>' to module mod_core
- dispatching directive 'User' to module mod_core
- dispatching directive 'Group' to module mod_core
- dispatching directive 'UserAlias' to module mod_auth
- dispatching directive 'MaxClients' to module mod_auth
- dispatching directive 'DisplayLogin' to module mod_core
- dispatching directive 'DisplayFirstChdir' to module mod_core
- dispatching directive '<Limit>' to module mod_core
- dispatching directive 'DenyAll' to module mod_core
- dispatching directive '</Limit>' to module mod_core
- dispatching directive '</Anonymous>' to module mod_core
- dispatching directive 'AuthOrder' to module mod_core
- dispatching directive 'SQLAuthTypes' to module mod_sql
- dispatching directive 'SQLConnectInfo' to module mod_sql
- dispatching directive 'SQLDefaultGID' to module mod_sql
- FS: using system read()
- dispatching directive 'SQLDefaultUID' to module mod_sql
- dispatching directive 'SQLMinUserGID' to module mod_sql
- dispatching directive 'SQLMinUserUID' to module mod_sql
- FS: using system read()
- FS: using system read()
- dispatching directive 'SQLUserInfo' to module mod_sql
- FS: using system read()
- FS: using system close()
linux.site -
linux.site - Config for ProFTPD Default Installation:
linux.site - ~ftp/
linux.site - Limit
linux.site - DenyAll
linux.site - UserName
linux.site - GroupName
linux.site - UserAlias
linux.site - MaxClients
linux.site - DisplayLogin
linux.site - DisplayFirstChdir
linux.site - Umask
linux.site - AllowOverwrite
linux.site - SQLAuthTypes
linux.site - SQLConnectInfo
linux.site - SQLDefaultGID
linux.site - SQLDefaultUID
linux.site - SQLMinUserGID
linux.site - SQLMinUserUID
linux.site - Limit
linux.site - DenyAll
linux.site - DefaultServer
linux.site - Umask
linux.site - IdentLookups
linux.site - UserID
linux.site - UserName
linux.site - GroupID
linux.site - GroupName
linux.site - AllowOverwrite
linux.site - AuthOrder
linux.site - SQLAuthTypes
linux.site - SQLConnectInfo
linux.site - SQLDefaultGID
linux.site - SQLDefaultUID
linux.site - SQLMinUserGID
linux.site - SQLMinUserUID
linux.site - SQLUserTable
linux.site - SQLUsernameField
linux.site - SQLPasswordField
linux.site - SQLUidField
linux.site - SQLGidField
linux.site - SQLHomedirField
linux.site - SQLShellField
linux.site - dispatching auth request "getgroups" to module mod_sql
linux.site - dispatching auth request "getgroups" to module mod_auth_file
linux.site - dispatching auth request "getgroups" to module mod_auth_unix
linux.site - SETUP PRIVS at main.c:2733
linux.site - ROOT PRIVS at main.c:1967
linux.site - RELINQUISH PRIVS at main.c:1974
linux.site - ROOT PRIVS at main.c:2322
linux.site - opening scoreboard '/var/proftpd/proftpd/proftpd.scoreboard'
linux.site - RELINQUISH PRIVS at main.c:2348
linux.site - ROOT PRIVS at inet.c:322
linux.site - RELINQUISH PRIVS at inet.c:380
linux.site - ProFTPD 1.2.10 (stable) (built Thu Nov 17 01:34:19 CET 2005) standalone mode STARTUP
linux.site - ROOT PRIVS at main.c:2185
linux.site - RELINQUISH PRIVS at main.c:2187
linux.site - FS: using system lstat()
linux.site - ROOT PRIVS at main.c:1162
linux.site - RELINQUISH PRIVS at main.c:1166
linux.site - FS: using system lstat()
linux.site - FS: using system lstat()
linux.site (192.168.0.100[192.168.0.100]) - ROOT PRIVS at main.c:1011
linux.site (192.168.0.100[192.168.0.100]) - SETUP PRIVS at main.c:1016
linux.site (192.168.0.100[192.168.0.100]) - FTP session requested from unknown class
linux.site (192.168.0.100[192.168.0.100]) - performing module session initializations
linux.site (192.168.0.100[192.168.0.100]) - FTP session closed.
linux.site - FS: using system lstat()
# 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
IdentLookups off
# 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.
AllowOverwrite on
# Bar use of SITE CHMOD by default
<Limit SITE_CHMOD>
DenyAll
</Limit>
# 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>
AuthOrder mod_sql.c
SQLAuthTypes Plaintext
SQLConnectInfo proftpd@localhost proftpd passwort
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo ftp username password uid gid homedir shell
