www.ProFTPD.de
13. März 2007, 19:29:42 *
Willkommen Gast. Bitte einloggen oder registrieren.
Haben Sie Ihre Aktivierungs E-Mail übersehen?

Einloggen mit Benutzername, Passwort und Sitzungslänge
News: SMF - Neu installiert!
 
   Übersicht   Hilfe Suche Login Registrieren  
Seiten: [1]   Nach unten
  Drucken  
Autor Thema: Debian - mod_sql - Fragen  (Gelesen 271 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
g-access
ProFTPD
*
Offline Offline

Beiträge: 6


Profil anzeigen WWW
« 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
Gespeichert

Gruß Alex
Seiten: [1]   Nach oben
  Drucken  
 
Gehe zu:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Prüfe XHTML 1.0 Prüfe CSS
Seite erstellt in 0.056 Sekunden mit 14 Zugriffen.