www.ProFTPD.de
13. März 2007, 21:19:16 *
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: schon wieder mysql  (Gelesen 424 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
Flo
Gast
« am: 28. Juni 2004, 09:55:50 »

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, Zunge
ich kann mich zum Server Connecten Smiley
bekomme aber ein 530 Login Incorrect: Traurig

 :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
Gespeichert
stonki
Administrator
ProFTPD
*****
Offline Offline

Beiträge: 1853


15318939
Profil anzeigen WWW E-Mail
« Antwort #1 am: 28. Juni 2004, 11:05:25 »

und jetzt noch das normale Debug Log !

cu
stonki
Gespeichert

www.stonki.de:    the more I see, the more I know.......
www.proftpd.de:   Deutsche ProFTPD Dokumentation
www.krename.net:  Der Batch Renamer für KDE
www.kbarcode.net: Die Barcode Solution für KDE
Flo
Gast
« Antwort #2 am: 29. Juni 2004, 08:41:47 »

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
Gespeichert
Flo
Gast
« Antwort #3 am: 29. Juni 2004, 09:18:21 »

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!?
Gespeichert
Wörsty
Moderator
ProFTPD
*****
Offline Offline

Beiträge: 1602


50772603
Profil anzeigen WWW E-Mail
« Antwort #4 am: 29. Juni 2004, 10:46:04 »

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.
Gespeichert

RedHat 8.0 (2.4er Kernel)
proftpd 1.2.10
-mod_sql_mysql
-mow_wrap
-mod_exec
-mod_ifsession[/size]
stonki
Administrator
ProFTPD
*****
Offline Offline

Beiträge: 1853


15318939
Profil anzeigen WWW E-Mail
« Antwort #5 am: 30. Juni 2004, 14:54:03 »

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.
Gespeichert

www.stonki.de:    the more I see, the more I know.......
www.proftpd.de:   Deutsche ProFTPD Dokumentation
www.krename.net:  Der Batch Renamer für KDE
www.kbarcode.net: Die Barcode Solution für KDE
Hoaxter
ProFTPD
*
Offline Offline

Beiträge: 26


Profil anzeigen
« Antwort #6 am: 30. Juni 2004, 18:08:45 »

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?
Gespeichert
Anonymous
Gast
« Antwort #7 am: 02. Juli 2004, 09:34:53 »

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
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.161 Sekunden mit 17 Zugriffen.