|
Titel: Probleme mit Proftpd und Mysql Beitrag von: manuel am 17. November 2005, 20:06:40 Hallo,
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. Hier der Debug proftpd -nd9: Code: - 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() Hier die proftpd.conf Code: # 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 |