|
Titel: Debian - mod_sql - Fragen Beitrag von: g-access am 19. März 2005, 11:48:29 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 : 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 # 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 proftpd -nd9 : Code: - 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 : Code: 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 |