www.ProFTPD.de
13. März 2007, 20:31:18 *
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: SQL Auth. Problem  (Gelesen 319 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
maik
Gast
« am: 05. Oktober 2005, 15:05:45 »

Ich kann mich nicht per MySQL anmelden.
Kann jemand mal beine Logs checken, ich finde keinen Fehler:

FTP log:
Code:
- parsing '/etc/proftpd.conf' configuration
 - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated.  Use AuthOrder for setting authoritativeness
debian -
debian - Config for FTP-Server:
debian - SyslogLevel
debian - ServerIdent
debian - DeferWelcome
debian - DefaultServer
debian - DisplayLogin
debian - DisplayConnect
debian - DisplayFirstChdir
debian - SQLAuthTypes
debian - SQLAuthenticate
debian - SQLConnectInfo
debian - SQLDefaultGID
debian - SQLDefaultUID
debian - SQLMinUserGID
debian - SQLMinUserUID
debian - SQLUserTable
debian - SQLUsernameField
debian - SQLPasswordField
debian - SQLUidField
debian - SQLGidField
debian - SQLHomedirField
debian - SQLShellField
debian - SQLLog_PASS
debian - SQLNamedQuery_counter
debian - SQLLog_RETR
debian - SQLLog_STOR
debian - SQLNamedQuery_transfer1
debian - SQLLog_ERR_RETR
debian - SQLLog_ERR_STOR
debian - SQLNamedQuery_transfer2
debian - AllowForeignAddress
debian - Umask
debian - UserID
debian - UserName
debian - GroupID
debian - GroupName
debian - MaxClientsPerHost
debian - MaxClients
debian - AllowStoreRestart
debian - AllowRetrieveRestart
debian - TimeoutStalled
debian - MaxLoginAttempts
debian - RequireValidShell
debian - ProFTPD 1.2.10 (stable) (built Di Okt 4 19:29:43 CEST 2005) standalone mode STARTUP
debian (proftptestserver.local[192.168.1.211]) - FTP session requested from unknown class
debian (proftptestserver.local[192.168.1.211]) - connected - local  : 192.168.1.16:21
debian (proftptestserver.local[192.168.1.211]) - connected - remote : 192.168.1.211:4139
debian (proftptestserver.local[192.168.1.211]) - FTP session opened.
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'USER maik' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik'
debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD command 'USER maik' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_log
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik'
debian (proftptestserver.local[192.168.1.211]) - USER maik (Login failed): No such user found.
debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - FTP session closed.
debian (proftptestserver.local[192.168.1.211]) - FTP session requested from unknown class
debian (proftptestserver.local[192.168.1.211]) - connected - local  : 192.168.1.16:21
debian (proftptestserver.local[192.168.1.211]) - connected - remote : 192.168.1.211:4153
debian (proftptestserver.local[192.168.1.211]) - FTP session opened.
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'USER maik' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'USER maik' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik'
debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD command 'USER maik' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD command 'USER maik' to mod_log
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
debian (proftptestserver.local[192.168.1.211]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - dispatching CMD command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - no supplemental groups found for user 'maik'
debian (proftptestserver.local[192.168.1.211]) - USER maik (Login failed): No such user found.
debian (proftptestserver.local[192.168.1.211]) - dispatching POST_CMD_ERR command 'PASS (hidden)' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_sql
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_log
debian (proftptestserver.local[192.168.1.211]) - dispatching LOG_CMD_ERR command 'PASS (hidden)' to mod_auth
debian (proftptestserver.local[192.168.1.211]) - FTP session closed.

FTP SQL log:
Code:
Oct 05 15:06:46 mod_sql/4.11[22370]: entering   mysql cmd_escapestring
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting    mysql cmd_escapestring
Oct 05 15:06:46 mod_sql/4.11[22370]: cache miss for user 'maik'
Oct 05 15:06:46 mod_sql/4.11[22370]: : entering         mysql cmd_select
Oct 05 15:06:46 mod_sql/4.11[22370]: entering   mysql cmd_open
Oct 05 15:06:46 mod_sql/4.11[22370]: connection 'default' count is now 2
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting    mysql cmd_open
Oct 05 15:06:46 mod_sql/4.11[22370]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username
='maik') LIMIT 1"
Oct 05 15:06:46 mod_sql/4.11[22370]: entering   mysql cmd_close
Oct 05 15:06:46 mod_sql/4.11[22370]: connection 'default' count is now 1
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting    mysql cmd_close
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting    mysql cmd_select
Oct 05 15:06:46 mod_sql/4.11[22370]: cache miss for user 'maik'
Oct 05 15:06:46 mod_sql/4.11[22370]: user 'maik' cached
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_name  : maik
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_uid   : 65534
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_gid   : 65534
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_dir   : /var/ftp/
Oct 05 15:06:46 mod_sql/4.11[22370]: + pwd.pw_shell :
Oct 05 15:06:46 mod_sql/4.11[22370]: <<< cmd_getpwnam
Oct 05 15:06:46 mod_sql/4.11[22370]: >>> cmd_auth
Oct 05 15:06:46 mod_sql/4.11[22370]: entering   mysql cmd_escapestring
Oct 05 15:06:46 mod_sql/4.11[22370]: exiting    mysql cmd_escapestring
Oct 05 15:06:46 mod_sql/4.11[22370]: cache hit for user 'maik'
Oct 05 15:06:46 mod_sql/4.11[22370]: negative cache entry for user 'maik'
Oct 05 15:06:46 mod_sql/4.11[22370]: <<< cmd_auth
Oct 05 15:06:47 mod_sql/4.11[22370]: entering   mysql cmd_exit
Oct 05 15:06:47 mod_sql/4.11[22370]: entering   mysql cmd_close
Oct 05 15:06:47 mod_sql/4.11[22370]: connection 'default' closed
Oct 05 15:06:47 mod_sql/4.11[22370]: connection 'default' count is now 0
Oct 05 15:06:47 mod_sql/4.11[22370]: exiting    mysql cmd_close
Oct 05 15:06:47 mod_sql/4.11[22370]: exiting    mysql cmd_exit


mein proftpd.conf sieht wie folgt aus:
Code:
serverType                      standalone


SyslogLevel              debug
SystemLog                       /var/log/proftpd.system.log

ServerIdent                     on      "Stonki's Server"
DeferWelcome                    on
DefaultServer                   on

DisplayLogin                    /messages/ftp.motd
DisplayConnect                  /net/messages/ftp.pre
DisplayFirstChdir               index.txt

Port                            21


SQLAuthTypes                    Plaintext
SQLAuthenticate                 users*
SQLConnectInfo                  proftpd@localhost root
SQLDefaultGID                   65534
SQLDefaultUID                   65534
SQLMinUserGID                   100
SQLMinUserUID                   500
SQLUserInfo                     ftp username uid gid password homedir shell

SQLLog PASS counter
SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" ftp

SQLLog RETR,STOR transfer1
SQLNamedQuery  transfer1 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'c', NULL" xfer_stat

SQLLOG ERR_RETR,ERR_STOR transfer2
SQLNamedQuery  transfer2 INSERT "'%u', '%f', '%b', '%h', '%a', '%m', '%T', now(), 'i', NULL" xfer_stat


AllowForeignAddress             on

Umask                           022

User                            nobody
Group                           nogroup

MaxClientsPerHost       3       "Nicht mehr als %m  Verbindungen"
MaxClients              5       "Leider sind schon %m Clients verbunden"

AllowStoreRestart                               on
AllowRetrieveRestart                            on


MaxInstances                    30

UseReverseDNS                   on

TimeoutStalled                  300
LogFormat            default "%h %l %u %t \"%r\" %s %b"
LogFormat            auth    "%v [%P] %h %t \"%r\" %s"
LogFormat            write   "%h %l %u %t \"%r\" %s %b"

MaxLoginAttempts                3

RequireValidShell               off

Das ganze läuft auf nem Debian Sarge.
Alle notwendigen Module dürften korrekt einkompeliert sein.

Code:
Compiled-in modules:
  mod_core.c
  mod_xfer.c
  mod_auth_unix.c
  mod_auth_file.c
  mod_auth.c
  mod_ls.c
  mod_log.c
  mod_site.c
  mod_sql.c
  mod_sql_mysql.c
  mod_cap.c


Ich bin für jeden Hinweis dankbar.
Gespeichert
freq.9
ProFTPD
*
Offline Offline

Beiträge: 29

154694464 freq9@hotmail.com
Profil anzeigen WWW
« Antwort #1 am: 05. Oktober 2005, 19:29:15 »

Zitat
USER maik (Login failed): No such user found


Bist du sicher, dass es einen solchen User in der Datenbank gibts?

Schau doch mal in die Logs. (/var/log/proftpd/*)
Gespeichert
Anonymous
Gast
« Antwort #2 am: 06. Oktober 2005, 15:16:45 »

Zitat von: "freq.9"
Zitat
USER maik (Login failed): No such user found


Bist du sicher, dass es einen solchen User in der Datenbank gibts?

Schau doch mal in die Logs. (/var/log/proftpd/*)

Du hast nicht ganz unrecht.
Proftpd autentifiziert nicht gegen die MySQL Datenbank sondern gegen System-User.

Ich habe aber in meiner Konfiguration folgende Angaben drin:
Code:
SQLAuthTypes                    Plaintext
SQLAuthenticate                 users*
SQLConnectInfo                  proftpd@localhost root
SQLDefaultGID                   65534
SQLDefaultUID                   65534
SQLMinUserGID                   100
SQLMinUserUID                   500
SQLUserInfo                     ftp username uid gid password homedir shell

Damit sollte doch gegen MySQL autentifiziert werden, oder?

Woran könnte es liegen, dass immernoch gegen Systemuser autentifiziert wird?
Gespeichert
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« Antwort #3 am: 07. Oktober 2005, 20:43:48 »

Erstetze mal SQLAuthenticate durch AuthOrder

Code:
AuthOrder mod_sql.c


Ansonsten gabs mal Probleme mit Debian: http://www.proftpd.de/forum/viewtopic.php?t=1015
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
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.221 Sekunden mit 19 Zugriffen.