www.ProFTPD.de
13. März 2007, 22:04:53 *
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: SysCP - ProFTPD - MySQL  (Gelesen 217 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
Dumby
ProFTPD
*
Offline Offline

Beiträge: 1


Profil anzeigen
« am: 30. April 2005, 21:15:50 »

Hallo,
ich nutze ProFTPD im Zusammenhang mit SysCP auf einem Debian Sarge System. Der FTP Deamon läuft und springt auch auf Verbindungsversuche an.
Jedoch erwiedert der server meinem Client '530 Login Incorrect'. Ich habe meine Config sowie das SQL-Logfile angehängt.

Und ja, ich habe andere Threads die sich mit dem Thema beschäftigen bereits gelesen, aber keine Lösung gefunden.

Über Hilfe wäre ich sehr Dankbar.

Grüße Dumby

Config:
Code:
ServerName                      "85.10.XXX.XXX FTP Server"
ServerType                      standalone
DeferWelcome                    off

MultilineRFC2228                on
DefaultServer                   on
ShowSymlinks                    on
AllowOverwrite                  on

TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200

DisplayLogin                    welcome.msg
DisplayFirstChdir               .message
ListOptions                     "-l"

DenyFilter                      \*.*/

Port                            21
MaxInstances                    30

# Set the user and group that the server normally runs at.
User                            nobody
Group                           nogroup

<Directory /*>
# Umask 022 is a good standard umask to prevent new files and dirs
# (second parm) from being group and world writable.
  Umask                         022  022
# Normally, we want files to be overwriteable.
  AllowOverwrite                on
</Directory>

DefaultRoot ~
RequireValidShell off

SQLLOGFILE /var/log/proftpd.sqllog

SQLAuthTypes Crypt Plaintext
SQLAuthenticate users* groups*
SQLConnectInfo syscp@localhost ******* **********
SQLUserInfo ftp_users username password uid gid homedir shell
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"

SQLLog PASS login
SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users

SQLLog RETR download
SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users

SQLLog STOR upload
SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_users


SQL-Logfile
Code:
Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_getgroups
Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******'
Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for group ******
Apr 30 21:09:48 mod_sql/4.11[20598]: : entering         mysql cmd_select
Apr 30 21:09:48 mod_sql/4.11[20598]: entering   mysql cmd_open
Apr 30 21:09:48 mod_sql/4.11[20598]: connection 'default' count is now 2
Apr 30 21:09:48 mod_sql/4.11[20598]: exiting    mysql cmd_open
Apr 30 21:09:48 mod_sql/4.11[20598]: query "SELECT groupname, gid, members FROM ftp_groups WHERE (members = '******' OR members LIKE '******,%' OR members LIK
E '%,******' OR members LIKE '%,******,%')"
Apr 30 21:09:48 mod_sql/4.11[20598]: entering   mysql cmd_close
Apr 30 21:09:48 mod_sql/4.11[20598]: connection 'default' count is now 1
Apr 30 21:09:48 mod_sql/4.11[20598]: exiting    mysql cmd_close
Apr 30 21:09:48 mod_sql/4.11[20598]: exiting    mysql cmd_select
Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for group '******'
Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_getgroups
Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_getpwnam
Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******'
Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_getpwnam
Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_gid2name
Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for group ******
Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_gid2name
Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_auth
Apr 30 21:09:48 mod_sql/4.11[20598]: entering   mysql cmd_escapestring
Apr 30 21:09:48 mod_sql/4.11[20598]: exiting    mysql cmd_escapestring
Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******'
Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_check
Apr 30 21:09:48 mod_sql/4.11[20598]: checking auth_type Crypt
Apr 30 21:09:48 mod_sql/4.11[20598]: checking auth_type Plaintext
Apr 30 21:09:48 mod_sql/4.11[20598]: 'Plaintext' auth handler reports success
Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******'
Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_check
Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_auth
Apr 30 21:09:48 mod_sql/4.11[20598]: >>> cmd_getpwnam
Apr 30 21:09:48 mod_sql/4.11[20598]: cache hit for user '******'
Apr 30 21:09:48 mod_sql/4.11[20598]: <<< cmd_getpwnam
Apr 30 21:09:48 mod_sql/4.11[20598]: entering   mysql cmd_close
Apr 30 21:09:48 mod_sql/4.11[20598]: connection 'default' closed
Apr 30 21:09:48 mod_sql/4.11[20598]: connection 'default' count is now 0
Apr 30 21:09:48 mod_sql/4.11[20598]: exiting    mysql cmd_close
Gespeichert
Anonymous
Gast
« Antwort #1 am: 01. Mai 2005, 11:15:34 »

Habe festgestellt, dass man sich mit den Shell-Users einloggen kann, liegt also wohl am MySQL Code, fehler finde ich aber nicht.
Gespeichert
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.054 Sekunden mit 18 Zugriffen.