schon wieder mysql

[Flo]

Hallo,
*gleichmalduck* :oops:
ich hab schon wahnsinnig viel infos finden können wie man ProFTPD
mit mysql Installiert. Ich bin auch darauf gestoßen das in Debian
fehlerhaft MySQL pakete enthalten sind. :evil:

Ich habe versucht ProFTPD mit diesen .deb Paketen zu installieren
http://sven.stormbind.net/proftpd/debian
hat aber nicht funktioniert da immer Abhängigkeitsprobleme
mit dem common Paket auftraten die ich (noch NewBie) aber nicht
beseitigen konnte! :cry:

Dann hab ichs mit
ftp://ftp.proftpd.de/Development/proftpd-1.2.10rc1_debian.tar.gz
versucht, nach der Anleitung (und Pfad anpassung)
http://www.proftpd.de/forum2/viewtopic.php?t=1015

Die installation verlief (in meinen augen) ohne Probleme! :?
auch das Patchen (denk ich, hab ich noch nie gemacht) hat geklappt,
ich kann mich zum Server Connecten
bekomme aber ein 530 Login Incorrect:

 :arrow: meine .conf

Code:

ServerName                      "Debian"
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                      \*.*/

#PersistentPasswd               off


#TLSEngine                      on

#Quotas                         on

#Ratios                         on

# Port 21 is the standard FTP port.
Port                            21

MaxInstances                    30

User                            nobody
Group                           nogroup

<Directory /*>
  Umask                         022  022
  AllowOverwrite                on
</Directory>

SQLAuthTypes Plaintext

SQLAuthenticate users*

SQLConnectInfo ftp@localhost proftpd root

SQLDefaultGID 65534

SQLDefaultUID 65534

SQLMinUserGID 100

SQLMinUserUID 500

SQLUserInfo ftp username password uid gid homedir shell

SQLLOGFILE /var/log/proftpd.sql.log

 :arrow: sql.log

Code:

Jun 28 09:35:25 mod_sql/4.10[686]: backend module 'mod_sql_mysql/4.04'
Jun 28 09:35:25 mod_sql/4.10[686]: backend api    'mod_sql_api_v1'
Jun 28 09:35:25 mod_sql/4.10[686]: >>> sql_getconf
Jun 28 09:35:25 mod_sql/4.10[686]: entering     mysql cmd_defineconnection
Jun 28 09:35:25 mod_sql/4.10[686]:  name: 'default'
Jun 28 09:35:25 mod_sql/4.10[686]:  user: 'proftpd'
Jun 28 09:35:25 mod_sql/4.10[686]:  host: 'localhost'
Jun 28 09:35:25 mod_sql/4.10[686]:    db: 'ftp'
Jun 28 09:35:25 mod_sql/4.10[686]:  port: '3306'
Jun 28 09:35:25 mod_sql/4.10[686]:   ttl: '0'
Jun 28 09:35:25 mod_sql/4.10[686]: exiting      mysql cmd_defineconnection
Jun 28 09:35:25 mod_sql/4.10[686]: entering     mysql cmd_open
Jun 28 09:35:25 mod_sql/4.10[686]: connection 'default' opened
Jun 28 09:35:25 mod_sql/4.10[686]: connection 'default' count is now 1
Jun 28 09:35:25 mod_sql/4.10[686]: exiting      mysql cmd_open
Jun 28 09:35:25 mod_sql/4.10[686]: backend successfully connected.
Jun 28 09:35:25 mod_sql/4.10[686]: mod_sql status     : on
Jun 28 09:35:25 mod_sql/4.10[686]: negative_cache     : off
Jun 28 09:35:25 mod_sql/4.10[686]: authenticate       : users
Jun 28 09:35:25 mod_sql/4.10[686]: usertable          : ftp
Jun 28 09:35:25 mod_sql/4.10[686]: userid field       : username
Jun 28 09:35:25 mod_sql/4.10[686]: password field     : password
Jun 28 09:35:25 mod_sql/4.10[686]: uid field          : uid
Jun 28 09:35:25 mod_sql/4.10[686]: gid field          : gid
Jun 28 09:35:25 mod_sql/4.10[686]: homedir field      : homedir
Jun 28 09:35:25 mod_sql/4.10[686]: shell field        : shell
Jun 28 09:35:25 mod_sql/4.10[686]: homedirondemand    : false
Jun 28 09:35:25 mod_sql/4.10[686]: SQLMinUserUID      : 500
Jun 28 09:35:25 mod_sql/4.10[686]: SQLMinUserGID      : 100
Jun 28 09:35:25 mod_sql/4.10[686]: <<< sql_getconf
Jun 28 09:35:25 mod_sql/4.10[686]: >>> cmd_getpwnam
Jun 28 09:35:25 mod_sql/4.10[686]: entering     mysql cmd_escapestring
Jun 28 09:35:25 mod_sql/4.10[686]: exiting      mysql cmd_escapestring
Jun 28 09:35:25 mod_sql/4.10[686]: cache miss for user 'admin'
Jun 28 09:35:25 mod_sql/4.10[686]: : entering   mysql cmd_select
Jun 28 09:35:25 mod_sql/4.10[686]: entering     mysql cmd_open
Jun 28 09:35:25 mod_sql/4.10[686]: connection 'default' count is now 2
Jun 28 09:35:25 mod_sql/4.10[686]: exiting      mysql cmd_open
Jun 28 09:35:25 mod_sql/4.10[686]: query "SELECT username, password, uid, gid, homedir, shell FROM ftp WHERE (username='admin') LIMIT 1"
Jun 28 09:35:25 mod_sql/4.10[686]: entering     mysql cmd_close
Jun 28 09:35:25 mod_sql/4.10[686]: connection 'default' count is now 1
Jun 28 09:35:25 mod_sql/4.10[686]: exiting      mysql cmd_close
Jun 28 09:35:25 mod_sql/4.10[686]: exiting      mysql cmd_select
Jun 28 09:35:25 mod_sql/4.10[686]: NULL shell column value, setting to ""
Jun 28 09:35:25 mod_sql/4.10[686]: cache miss for user 'admin'
Jun 28 09:35:25 mod_sql/4.10[686]: user 'admin' cached
Jun 28 09:35:25 mod_sql/4.10[686]: + pwd.pw_name  : admin
Jun 28 09:35:25 mod_sql/4.10[686]: + pwd.pw_uid   : 65534
Jun 28 09:35:25 mod_sql/4.10[686]: + pwd.pw_gid   : 501
Jun 28 09:35:25 mod_sql/4.10[686]: + pwd.pw_dir   : /home/admin
Jun 28 09:35:25 mod_sql/4.10[686]: + pwd.pw_shell :
Jun 28 09:35:25 mod_sql/4.10[686]: <<< cmd_getpwnam
Jun 28 09:35:25 mod_sql/4.10[686]: >>> cmd_auth
Jun 28 09:35:25 mod_sql/4.10[686]: entering     mysql cmd_escapestring
Jun 28 09:35:25 mod_sql/4.10[686]: exiting      mysql cmd_escapestring
Jun 28 09:35:25 mod_sql/4.10[686]: cache hit for user 'admin'
Jun 28 09:35:25 mod_sql/4.10[686]: >>> cmd_check
Jun 28 09:35:25 mod_sql/4.10[686]: checking auth_type Plaintext
Jun 28 09:35:25 mod_sql/4.10[686]: 'Plaintext' auth handler reports success
Jun 28 09:35:25 mod_sql/4.10[686]: cache hit for user 'admin'
Jun 28 09:35:25 mod_sql/4.10[686]: <<< cmd_check
Jun 28 09:35:25 mod_sql/4.10[686]: <<< cmd_auth

 :arrow: das sagt mein FTPClient

Code:

WinSock 2.0
Connecting to 192.168.0.3
Connected to 192.168.0.3 -> IP=192.168.0.3 PORT=21
220 ProFTPD 1.2.10rc1 Server (Debian) [localhost]
USER admin
331 Password required for admin.
PASS (hidden)
530 Login incorrect.
Connection failed

Ich wäre euch sehr dankbar wenn mir wer helfen könnte,
ich verzweifle schon seit über einer Woche!
Danke schon mal im Vorraus!!!
 :!: Ich nutze Debian aktuelle testing
 :!: Mysql 4.0.18
 :!: ProFTPD 1.2.10.rc1

[stonki]

und jetzt noch das normale Debug Log !

cu
stonki

[Flo]

Hi,
danke für die Antwort hier die Log vom Debugmodus

 - parsing '/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 'DeferWelcome' to module mod_core
 - dispatching directive 'MultilineRFC2228' to module mod_core
 - dispatching directive 'DefaultServer' to module mod_core
 - dispatching directive 'ShowSymlinks' to module mod_ls
 - dispatching directive 'AllowOverwrite' to module mod_xfer
 - dispatching directive 'TimeoutNoTransfer' to module mod_xfer
 - dispatching directive 'TimeoutStalled' to module mod_xfer
 - dispatching directive 'TimeoutIdle' to module mod_core
 - dispatching directive 'DisplayLogin' to module mod_core
 - dispatching directive 'DisplayFirstChdir' to module mod_core
 - dispatching directive 'ListOptions' to module mod_ls
 - dispatching directive 'DenyFilter' to module mod_core
 - Compiling deny regex '\*.*/'.
 - Allocated deny regex at location 0x80c4778.
 - dispatching directive 'Port' to module mod_core
 - FS: using system read()
 - 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
 - dispatching directive '<Directory>' to module mod_core
 - <Directory /*>: adding section for resolved path '/*'
 - dispatching directive 'Umask' to module mod_core
 - dispatching directive 'AllowOverwrite' to module mod_xfer
 - dispatching directive '</Directory>' to module mod_core
 - FS: using system read()
 - dispatching directive 'SQLAuthTypes' to module mod_sql
 - dispatching directive 'SQLAuthenticate' to module mod_sql
 - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated.  Use AuthOr
der 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
 - FS: using system read()
 - dispatching directive 'SQLUserInfo' to module mod_sql
 - dispatching directive 'SQLLogFile' to module mod_sql
 - FS: using system read()
 - FS: using system read()
 - FS: using system close()
localhost -
localhost - Config for Debian:
localhost - /*
localhost -  Umask
localhost -  DirUmask
localhost -  AllowOverwrite
localhost -  ShowSymlinks
localhost -  DisplayLogin
localhost -  DisplayFirstChdir
localhost -  ListOptions
localhost -  DenyFilter
localhost -  SQLAuthTypes
localhost -  SQLAuthenticate
localhost -  SQLConnectInfo
localhost -  SQLDefaultGID
localhost -  SQLDefaultUID
localhost -  SQLMinUserGID
localhost -  SQLMinUserUID
localhost - DeferWelcome
localhost - DefaultServer
localhost - ShowSymlinks
localhost - AllowOverwrite
localhost - TimeoutNoTransfer
localhost - TimeoutStalled
localhost - TimeoutIdle
localhost - DisplayLogin
localhost - DisplayFirstChdir
localhost - ListOptions
localhost - DenyFilter
localhost - UserID
localhost - UserName
localhost - GroupID
localhost - GroupName
localhost - SQLAuthTypes
localhost - SQLAuthenticate
localhost - SQLConnectInfo
localhost - SQLDefaultGID
localhost - SQLDefaultUID
localhost - SQLMinUserGID
localhost - SQLMinUserUID
localhost - SQLUserTable
localhost - SQLUsernameField
localhost - SQLPasswordField
localhost - SQLUidField
localhost - SQLGidField
localhost - SQLHomedirField
localhost - SQLShellField
localhost - SQLLogFile
localhost - dispatching auth request "getgroups" to module mod_sql
localhost - dispatching auth request "getgroups" to module mod_auth_file
localhost - dispatching auth request "getgroups" to module mod_auth_unix
localhost - SETUP PRIVS at main.c:2790
localhost - ROOT PRIVS at main.c:2015
localhost - RELINQUISH PRIVS at main.c:2022
localhost - ROOT PRIVS at main.c:2392
localhost - deleting existing scoreboard '/usr/local/var/proftpd/proftpd.scorebo
ard'
localhost - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
localhost - RELINQUISH PRIVS at main.c:2418
localhost - ROOT PRIVS at inet.c:322
localhost - RELINQUISH PRIVS at inet.c:362
localhost - Failed binding to 0.0.0.0, port 21: Address already in use
localhost - Check the ServerType directive to ensure you are configured correctl
y.

hilft dir das was?*hoff* :roll:
gruss Flo

[Flo]

uupps,
hab gemerkt hanad der logfile
das der ja noch läuft hab in mal beendet (ging nur mit kill!)
und dann im Debug Modus nochma gestartet,
(sorry für den obigen beitrag!)

Code:

 proftpd -c /etc/proftpd.conf -n -d 9
 - parsing '/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 'DeferWelcome' to module mod_core
 - dispatching directive 'MultilineRFC2228' to module mod_core
 - dispatching directive 'DefaultServer' to module mod_core
 - dispatching directive 'ShowSymlinks' to module mod_ls
 - dispatching directive 'AllowOverwrite' to module mod_xfer
 - dispatching directive 'TimeoutNoTransfer' to module mod_xfer
 - dispatching directive 'TimeoutStalled' to module mod_xfer
 - dispatching directive 'TimeoutIdle' to module mod_core
 - dispatching directive 'DisplayLogin' to module mod_core
 - dispatching directive 'DisplayFirstChdir' to module mod_core
 - dispatching directive 'ListOptions' to module mod_ls
 - dispatching directive 'DenyFilter' to module mod_core
 - Compiling deny regex '\*.*/'.
 - Allocated deny regex at location 0x80c4778.
 - dispatching directive 'Port' to module mod_core
 - FS: using system read()
 - 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
 - dispatching directive '<Directory>' to module mod_core
 - <Directory /*>: adding section for resolved path '/*'
 - dispatching directive 'Umask' to module mod_core
 - dispatching directive 'AllowOverwrite' to module mod_xfer
 - dispatching directive '</Directory>' to module mod_core
 - FS: using system read()
 - 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
 - FS: using system read()
 - dispatching directive 'SQLUserInfo' to module mod_sql
 - dispatching directive 'SQLLogFile' to module mod_sql
 - FS: using system read()
 - FS: using system read()
 - FS: using system close()
localhost -
localhost - Config for Debian:
localhost - /*
localhost -  Umask
localhost -  DirUmask
localhost -  AllowOverwrite
localhost -  ShowSymlinks
localhost -  DisplayLogin
localhost -  DisplayFirstChdir
localhost -  ListOptions
localhost -  DenyFilter
localhost -  SQLAuthTypes
localhost -  SQLConnectInfo
localhost -  SQLDefaultGID
localhost -  SQLDefaultUID
localhost -  SQLMinUserGID
localhost -  SQLMinUserUID
localhost - DeferWelcome
localhost - DefaultServer
localhost - ShowSymlinks
localhost - AllowOverwrite
localhost - TimeoutNoTransfer
localhost - TimeoutStalled
localhost - TimeoutIdle
localhost - DisplayLogin
localhost - DisplayFirstChdir
localhost - ListOptions
localhost - DenyFilter
localhost - UserID
localhost - UserName
localhost - GroupID
localhost - GroupName
localhost - SQLAuthTypes
localhost - SQLAuthenticate
localhost - SQLConnectInfo
localhost - SQLDefaultGID
localhost - SQLDefaultUID
localhost - SQLMinUserGID
localhost - SQLMinUserUID
localhost - SQLUserTable
localhost - SQLUsernameField
localhost - SQLPasswordField
localhost - SQLUidField
localhost - SQLGidField
localhost - SQLHomedirField
localhost - SQLShellField
localhost - SQLLogFile
localhost - dispatching auth request "getgroups" to module mod_sql
localhost - dispatching auth request "getgroups" to module mod_auth_file
localhost - dispatching auth request "getgroups" to module mod_auth_unix
localhost - SETUP PRIVS at main.c:2790
localhost - ROOT PRIVS at main.c:2015
localhost - RELINQUISH PRIVS at main.c:2022
localhost - ROOT PRIVS at main.c:2392
localhost - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
localhost - RELINQUISH PRIVS at main.c:2418
localhost - ROOT PRIVS at inet.c:322
localhost - RELINQUISH PRIVS at inet.c:380
localhost - ProFTPD 1.2.10rc1 (devel) (built Mo Jun 28 08:19:05 CEST 2004) standalone mode STARTUP
localhost - ROOT PRIVS at main.c:2233
localhost - RELINQUISH PRIVS at main.c:2235
localhost - FS: using system lstat()
localhost - ProFTPD terminating (signal 2)
localhost - ROOT PRIVS at main.c:1894
localhost - RELINQUISH PRIVS at main.c:1917
localhost - ProFTPD 1.2.10rc1 standalone mode SHUTDOWN
localhost - ROOT PRIVS at main.c:1924
localhost - deleting existing scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
localhost - RELINQUISH PRIVS at main.c:1926

wenn ich

Code:

proftpd stop

mache startet er den ftp, und man kann ihn nur
mit KILL beenden!?

[Wörsty]

Entweder die Startscripte von www.proftpd.de nehmen (bei Download) oder killall proftpd - ist Wurst. Aber bei den init.d-Scripten startet er auch automatisch und wird beendet beim Runterfahren.

[stonki]

ProFTPD Crasht hat noch immer bei Dir.... Das sieht nicht gut aus. Compiliere mal erst ohne mod_sql um zu sehen, ob alles andere klappt.

[Hoaxter]

Wie waere es wenn Du einfach meine Pakete nimmst und die Abhaengtigkeiten loest? Das koennen nicht viele sein und sollten mit den paketen aus Debian woody zu erfuellen sein. Achso falls ich noch nicht gewarnt hatte die sind fuer Debian/woody das aktuelle stable. Je nachdem wenn Du nen anderen zweig verwendest ist das natuerlich unsinn diesen Backport zu verwenden.

Sven

Addon, Du hast http://sven.stormbind.net/proftpd/debian/READ_THIS_FIRST.txt gelesen und dich daran gehalten?

[Anonymous]

soory für die lange antwort Zeit aber ich hatte
probs mitm internet zugang!
Ich werd jetzt erstmal proftpd ohne mysql installieren!
Das hat ja wenigstens schon mal geklappt!

gruss und Danke Flo