www.ProFTPD.de
13. März 2007, 19:25:20 *
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  
  Zeige Beiträge
Seiten: [1]
1  ProFTPD / ProFTPD - Deutsch / gelöst am: 24. August 2005, 14:41:44
lag an den unzureichenden berechtigung auf diese table für den user proftp, sollte man event. doch noch in die proftpd.conf


Code:
SQLLOGFILE /var/log/proftpd.sql.log


reingeben. da stehen auch womöglich interessante sachen ;-)
2  ProFTPD / ProFTPD - Deutsch / kein login bei debian-sarge proftpd-mysql möglich - gelöst am: 24. August 2005, 14:30:15
offenbar zu lang mein beitrag :-)

hier der rest:

mein ftp zugang:
Code:

>ftp 192.168.1.163
Verbindung mit 192.168.1.163 wurde hergestellt.
220 ProFTPD 1.2.10 Server (FTP-Server) [192.168.1.163]
Benutzer (192.168.1.163:(none)): test
331 Password required for test.
Kennwort:
Verbindung beendet durch Remotehost.



und restlichen logfiles:

Code:

==> /var/log/mysql.log <==
050822 22:17:41      62 Query       "SELECT userid, passwd, uid, gid, homedir, shell FROM proftpd_users WHERE (userid='test') LIMIT 1"
                     62 Quit      
050822 22:18:18      63 Connect     proftpd@localhost on SysConfig_db1

==> proftpd.auth_log <==
FTP-Server [16668] 192.168.1.232 [22/Aug/2005:22:18:20 +0200] "USER test" 331

==> proftpd.paranoid_log <==
FTP-Server [16668] 192.168.1.232 [22/Aug/2005:22:18:20 +0200] "USER test" 331
   


und meine proftpd.conf

Code:

debian:/home# cat /etc/proftpd.conf
#
# /etc/proftpd.conf -- This is a basic ProFTPD configuration file.
# To really apply changes reload proftpd after modifications.
#

ServerName                      "FTP-Server"
ServerType                      standalone
DeferWelcome                    off

MultilineRFC2228                on
DefaultServer                   on
ShowSymlinks                    on

TimeoutNoTransfer               600
TimeoutStalled                  600
TimeoutIdle                     1200

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

DenyFilter                      \*.*/

# Uncomment this if you would use quota module:
#Quotas                         on

# Port 21 is the standard FTP port.
Port                            21

# 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 that the server normally runs at.
User                            nobody
Group                           nogroup

# 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

# Delay engine reduces impact of the so-called Timing Attack described in
# http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02
# It is on by default.
#DelayEngine                    off

#
# Logging options
#
TransferLog /var/log/ftp/proftpd.xferlog
# Some logging formats
#
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"
# Log file/dir access
ExtendedLog /var/log/proftpd.access_log WRITE,READ write
# Record all logins
ExtendedLog /var/log/proftpd.auth_log AUTH auth
# Paranoia logging level....
ExtendedLog /var/log/proftpd.paranoid_log ALL


# Use the CreateHome default settings
CreateHome on 755 skel /etc/ftp/skel
RequireValidShell off
IdentLookups off
# Hiermit wird nun der User direkt in sein Heimatverzeichnis "gesperrt"
# Anschliessend kann der User keine höheren Verzeichnisse sehen
# Aufgrund der Gruppenangabe, nur Benutzer der Gruppe "user", jedoch
# nicht User der Gruppe "staff" werden in das Heimatverzeichnis gesperrt
DefaultRoot ~
#------------------------mysql Modul: 4.x
#
# Zugangskontrolle
#
SQLAuthTypes Plaintext
SQLAuthenticate users
SQLConnectInfo SysConfig_db1@localhost proftpd geheim
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo proftpd_users userid passwd uid gid homedir shell
SQLHomedirOnDemand on


aja und der mysql-db eintrag für diesen user:
Code:

userid  passwd  uid  gid  homedir        shell  
 test       test    656 656 /home/test    /bin/false

was mir auffällt ist z.b.:
im debug logging: no supplemental groups found for user 'test'


fällt irgend jemand ein fehler auf? stehe gerade etwas auf der leitung

zur info zum sarge-proftpd-mysql:
Code:

debian:/home# proftpd -vv
 - ProFTPD Version: 1.2.10 (stable)
 -   Scoreboard Version: 01040002
 -   Built: do mrt 22 18:28:32 CET 2001
 -     Module: mod_core.c
 -     Module: mod_xfer.c
 -     Module: mod_auth_unix.c
 -     Module: mod_auth_file.c
 -     Module: mod_auth.c
 -     Module: mod_ls.c
 -     Module: mod_log.c
 -     Module: mod_site.c
 -     Module: mod_auth_pam.c
 -     Module: mod_quotatab.c
 -     Module: mod_sql.c
 -     Module: mod_sql_mysql.c
 -     Module: mod_quotatab_sql.c
 -     Module: mod_ratio.c
 -     Module: mod_tls.c
 -     Module: mod_rewrite.c
 -     Module: mod_radius.c
 -     Module: mod_wrap.c
 -     Module: mod_quotatab_file.c
 -     Module: mod_delay/0.4
 -     Module: mod_readme.c
 -     Module: mod_ifsession.c
 -     Module: mod_cap/1.0
3  ProFTPD / ProFTPD - Deutsch / kein login bei debian-sarge proftpd-mysql möglich - gelöst am: 24. August 2005, 14:27:22
hi all,

habe eure ganzen beiträge zu diesem thema schon durchforstet. nur das problem.. ich sehe keinen fehler!?

also mein debug log zeigt folgendes:

Code:

debian:/home# proftpd -nd 9
 - mod_tls/2.0.7: using OpenSSL 0.9.7g 11 Apr 2005
 - 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 '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 0x812de08.
 - dispatching directive 'Port' 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_radius
 - 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_radius
 - 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 'Umask' to module mod_core
 - dispatching directive 'AllowOverwrite' to module mod_xfer
 - dispatching directive 'TransferLog' to module mod_core
 - dispatching directive 'LogFormat' to module mod_log
 - dispatching directive 'LogFormat' to module mod_log
 - dispatching directive 'LogFormat' to module mod_log
 - dispatching directive 'ExtendedLog' to module mod_log
 - dispatching directive 'ExtendedLog' to module mod_log
 - dispatching directive 'ExtendedLog' to module mod_log
 - dispatching directive 'CreateHome' to module mod_auth
 - FS: using system stat()
 - dispatching directive 'RequireValidShell' to module mod_auth
 - dispatching directive 'IdentLookups' to module mod_core
 - FS: using system read()
 - dispatching directive 'DefaultRoot' to module mod_auth
 - dispatching directive 'SQLAuthTypes' to module mod_sql
 - dispatching directive 'SQLAuthenticate' to module mod_sql
 - 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 'SQLHomedirOnDemand' to module mod_sql
 - FS: using system read()
 - FS: using system read()
 - FS: using system read()
 - FS: using system read()
 - FS: using system read()
 - FS: using system close()
localhost.localdomain -
localhost.localdomain - Config for FTP-Server:
localhost.localdomain - DeferWelcome
localhost.localdomain - DefaultServer
localhost.localdomain - ShowSymlinks
localhost.localdomain - TimeoutNoTransfer
localhost.localdomain - TimeoutStalled
localhost.localdomain - TimeoutIdle
localhost.localdomain - DisplayLogin
localhost.localdomain - DisplayFirstChdir
localhost.localdomain - ListOptions
localhost.localdomain - DenyFilter
localhost.localdomain - UserID
localhost.localdomain - UserName
localhost.localdomain - GroupID
localhost.localdomain - GroupName
localhost.localdomain - Umask
localhost.localdomain - DirUmask
localhost.localdomain - AllowOverwrite
localhost.localdomain - TransferLog
localhost.localdomain - ExtendedLog
localhost.localdomain - ExtendedLog
localhost.localdomain - ExtendedLog
localhost.localdomain - CreateHome
localhost.localdomain - RequireValidShell
localhost.localdomain - IdentLookups
localhost.localdomain - DefaultRoot
localhost.localdomain - SQLAuthTypes
localhost.localdomain - SQLAuthenticate
localhost.localdomain - SQLConnectInfo
localhost.localdomain - SQLDefaultGID
localhost.localdomain - SQLDefaultUID
localhost.localdomain - SQLMinUserGID
localhost.localdomain - SQLMinUserUID
localhost.localdomain - SQLUserTable
localhost.localdomain - SQLUsernameField
localhost.localdomain - SQLPasswordField
localhost.localdomain - SQLUidField
localhost.localdomain - SQLGidField
localhost.localdomain - SQLHomedirField
localhost.localdomain - SQLShellField
localhost.localdomain - SQLHomedirOnDemand
localhost.localdomain - ROOT PRIVS at ../../../modules/mod_delay.c:295
localhost.localdomain - FS: using system open()
localhost.localdomain - RELINQUISH PRIVS at ../../../modules/mod_delay.c:297
localhost.localdomain - FS: using system fstat()
localhost.localdomain - FS: using system close()
localhost.localdomain - dispatching auth request "getgroups" to module mod_radius
localhost.localdomain - dispatching auth request "getgroups" to module mod_sql
localhost.localdomain - dispatching auth request "getgroups" to module mod_auth_file
localhost.localdomain - dispatching auth request "getgroups" to module mod_auth_unix
localhost.localdomain - SETUP PRIVS at ../../../src/main.c:2736
localhost.localdomain - ROOT PRIVS at ../../../src/main.c:1970
localhost.localdomain - RELINQUISH PRIVS at ../../../src/main.c:1977
localhost.localdomain - ROOT PRIVS at ../../../src/main.c:2325
localhost.localdomain - opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
localhost.localdomain - RELINQUISH PRIVS at ../../../src/main.c:2351
localhost.localdomain - ROOT PRIVS at ../../../src/inet.c:322
localhost.localdomain - RELINQUISH PRIVS at ../../../src/inet.c:380
localhost.localdomain - ProFTPD 1.2.10 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP
localhost.localdomain - ROOT PRIVS at ../../../src/main.c:2188
localhost.localdomain - RELINQUISH PRIVS at ../../../src/main.c:2190
localhost.localdomain - FS: using system lstat()



localhost.localdomain - FS: using system lstat()
localhost.localdomain - ROOT PRIVS at ../../../src/main.c:1162
localhost.localdomain - RELINQUISH PRIVS at ../../../src/main.c:1166
localhost.localdomain (192.168.1.232[192.168.1.232]) - ROOT PRIVS at ../../../src/main.c:1011
localhost.localdomain (192.168.1.232[192.168.1.232]) - SETUP PRIVS at ../../../src/main.c:1016
localhost.localdomain (192.168.1.232[192.168.1.232]) - FTP session requested from unknown class
localhost.localdomain (192.168.1.232[192.168.1.232]) - performing module session initializations
localhost.localdomain (192.168.1.232[192.168.1.232]) - mod_delay/0.4: opening DelayTable '/var/run/proftpd/proftpd.delay'
localhost.localdomain (192.168.1.232[192.168.1.232]) - ROOT PRIVS at ../../../modules/mod_delay.c:774
localhost.localdomain (192.168.1.232[192.168.1.232]) - FS: using system open()
localhost.localdomain (192.168.1.232[192.168.1.232]) - RELINQUISH PRIVS at ../../../modules/mod_delay.c:776
localhost.localdomain (192.168.1.232[192.168.1.232]) - mod_log: opening ExtendedLog '/var/log/proftpd.paranoid_log'
localhost.localdomain (192.168.1.232[192.168.1.232]) - ROOT PRIVS at ../../../modules/mod_log.c:1144
localhost.localdomain (192.168.1.232[192.168.1.232]) - RELINQUISH PRIVS at ../../../modules/mod_log.c:1146
localhost.localdomain (192.168.1.232[192.168.1.232]) - mod_log: opening ExtendedLog '/var/log/proftpd.auth_log'
localhost.localdomain (192.168.1.232[192.168.1.232]) - ROOT PRIVS at ../../../modules/mod_log.c:1144
localhost.localdomain (192.168.1.232[192.168.1.232]) - RELINQUISH PRIVS at ../../../modules/mod_log.c:1146
localhost.localdomain (192.168.1.232[192.168.1.232]) - mod_log: opening ExtendedLog '/var/log/proftpd.access_log'
localhost.localdomain (192.168.1.232[192.168.1.232]) - ROOT PRIVS at ../../../modules/mod_log.c:1144
localhost.localdomain (192.168.1.232[192.168.1.232]) - RELINQUISH PRIVS at ../../../modules/mod_log.c:1146
localhost.localdomain (192.168.1.232[192.168.1.232]) - ROOT PRIVS at ../../../modules/mod_auth.c:132
localhost.localdomain (192.168.1.232[192.168.1.232]) - opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
localhost.localdomain (192.168.1.232[192.168.1.232]) - RELINQUISH PRIVS at ../../../modules/mod_auth.c:134
localhost.localdomain (192.168.1.232[192.168.1.232]) - ident lookup disabled
localhost.localdomain (192.168.1.232[192.168.1.232]) - connected - local  : 192.168.1.163:21
localhost.localdomain (192.168.1.232[192.168.1.232]) - connected - remote : 192.168.1.232:1336
localhost.localdomain (192.168.1.232[192.168.1.232]) - FTP session opened.
localhost.localdomain - FS: using system lstat()
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'USER test' to mod_rewrite
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'USER test' to mod_tls
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'USER test' to mod_core
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'USER test' to mod_core
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'USER test' to mod_delay
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'USER test' to mod_auth
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_auth_file
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_auth_unix
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_auth_file
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_auth_unix
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching CMD command 'USER test' to mod_ratio
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching CMD command 'USER test' to mod_auth
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getgroups" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getgroups" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getgroups" to module mod_auth_file
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getgroups" to module mod_auth_unix
localhost.localdomain (192.168.1.232[192.168.1.232]) - no supplemental groups found for user 'test'
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching POST_CMD command 'USER test' to mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching POST_CMD command 'USER test' to mod_delay
localhost.localdomain (192.168.1.232[192.168.1.232]) - mod_delay/0.4: selecting median interval from 30 values
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching LOG_CMD command 'USER test' to mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching LOG_CMD command 'USER test' to mod_log
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_rewrite
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_tls
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_delay
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_wrap
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_auth_file
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_auth_unix
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_auth_file
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_auth_unix
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching CMD command 'PASS (hidden)' to mod_auth
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getgroups" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getgroups" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getgroups" to module mod_auth_file
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getgroups" to module mod_auth_unix
localhost.localdomain (192.168.1.232[192.168.1.232]) - no supplemental groups found for user 'test'
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getpwnam" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "getpwnam" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_auth_file
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endpwent" to module mod_auth_unix
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_radius
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_sql
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_auth_file
localhost.localdomain (192.168.1.232[192.168.1.232]) - dispatching auth request "endgrent" to module mod_auth_unix
localhost.localdomain (192.168.1.232[192.168.1.232]) - FTP session closed.
localhost.localdomain - FS: using system lstat()
localhost.localdomain - scrubbing scoreboard
localhost.localdomain - ROOT PRIVS at ../../../modules/mod_core.c:130
localhost.localdomain - RELINQUISH PRIVS at ../../../modules/mod_core.c:132
localhost.localdomain - ROOT PRIVS at ../../../modules/mod_core.c:160
localhost.localdomain - RELINQUISH PRIVS at ../../../modules/mod_core.c:189
localhost.localdomain - FS: using system lstat()
localhost.localdomain - ProFTPD terminating (signal 2)
localhost.localdomain - ROOT PRIVS at ../../../src/main.c:1849
localhost.localdomain - ROOT PRIVS at ../../../modules/mod_delay.c:683
localhost.localdomain - FS: using system open()
localhost.localdomain - RELINQUISH PRIVS at ../../../modules/mod_delay.c:685
localhost.localdomain - FS: using system write()
localhost.localdomain - FS: using system close()
localhost.localdomain - RELINQUISH PRIVS at ../../../src/main.c:1872
localhost.localdomain - ProFTPD 1.2.10 standalone mode SHUTDOWN
localhost.localdomain - ROOT PRIVS at ../../../src/main.c:1879
localhost.localdomain - deleting existing scoreboard '/var/run/proftpd/proftpd.scoreboard'
localhost.localdomain - RELINQUISH PRIVS at ../../../src/main.c:1881
localhost.localdomain - ROOT PRIVS at ../../../modules/mod_delay.c:683
localhost.localdomain - FS: using system open()
localhost.localdomain - RELINQUISH PRIVS at ../../../modules/mod_delay.c:685
localhost.localdomain - FS: using system write()
localhost.localdomain - FS: using system close()
4  ProFTPD / ProFTPD - Deutsch / [Mysql] Proftpd lasst keien connection zu am: 11. Oktober 2004, 16:15:34
naja, habe es allerdigns ohne probleme zu kompilieren geschafft.
diesen thread kenne ich eh.
aber okay ,.. danke.
5  ProFTPD / ProFTPD - Deutsch / [Mysql] Proftpd lasst keien connection zu am: 11. Oktober 2004, 15:37:43
so, dürfte offenbar ein debian problem sein...
habe es auf einer RH9 kiste ohne probleme zum laufen bkeommen.
komishc, aber was solls...
danke
6  ProFTPD / ProFTPD - Deutsch / [Mysql] Proftpd lasst keien connection zu am: 11. Oktober 2004, 15:01:23
danke für info ;-)

war leider auch nicht der fehler.
kommt noch immer die selbe meldung - oder auch "nicht meldung".
werde das mal auf einer andere linuxkiste gleich ausprobieren-- erfolg oder nicht erfolg kommt sogleich ;-)
7  ProFTPD / ProFTPD - Deutsch / [Mysql] Proftpd lasst keien connection zu am: 11. Oktober 2004, 07:48:36
hello,

jup danke, jetzt wartet keine Sekunde mehr fürs Lookup sondern schreibt gleich connection refused by Remotehost.

Zitat

ramml:~# tail -f /var/log/debug /var/log/proftpd.sql.log
[.....]
Oct 11 04:36:14 ramml proftpd[18981]: ramml - FS: using system lstat()
Oct 11 04:36:14 ramml proftpd[18982]: ramml - ROOT PRIVS at ../../../src/main.c:1150
Oct 11 04:36:14 ramml proftpd[18982]: ramml - RELINQUISH PRIVS at ../../../src/main.c:1154
Oct 11 04:36:14 ramml proftpd[18981]: ramml - FS: using system lstat()
Oct 11 04:36:14 ramml proftpd[18982]: ramml (192.168.10.148[192.168.10.148]) - ident lookup disabled
Oct 11 04:36:14 ramml proftpd[18982]: ramml (192.168.10.148[192.168.10.148]) - performing module session initializations
Oct 11 04:36:14 ramml proftpd[18982]: ramml (192.168.10.148[192.168.10.148]) - ROOT PRIVS at ../../../modules/mod_sql.c:3630
Oct 11 04:36:14 ramml proftpd[18982]: ramml (192.168.10.148[192.168.10.148]) - RELINQUISH PRIVS at ../../../modules/mod_sql.c:3632
Oct 11 04:36:15 ramml proftpd[18981]: ramml - FS: using system lstat()

==> /var/log/proftpd.sql.log <==
Oct 11 04:36:14 mod_sql/4.10[18982]: backend module 'mod_sql_mysql/4.04'
Oct 11 04:36:14 mod_sql/4.10[18982]: backend api    'mod_sql_api_v1'
Oct 11 04:36:14 mod_sql/4.10[18982]: >>> sql_getconf
Oct 11 04:36:14 mod_sql/4.10[18982]: entering   mysql cmd_defineconnection
Oct 11 04:36:14 mod_sql/4.10[18982]:  name: 'default'
Oct 11 04:36:14 mod_sql/4.10[18982]:  user: 'proftpd'
Oct 11 04:36:14 mod_sql/4.10[18982]:  host: '192.168.10.1'
Oct 11 04:36:14 mod_sql/4.10[18982]:    db: 'protfptd'
Oct 11 04:36:14 mod_sql/4.10[18982]:  port: '3306'
Oct 11 04:36:14 mod_sql/4.10[18982]:   ttl: '0'
Oct 11 04:36:14 mod_sql/4.10[18982]: exiting    mysql cmd_defineconnection
Oct 11 04:36:14 mod_sql/4.10[18982]: entering   mysql cmd_open


die config sieht wie folgt aus:
Zitat

ramml:/usr/src# grep -v "^#" /etc/proftpd.conf
ServerName "SERVERNAME"
ServerType standalone
ServerAdmin support@proftpd.de
DeferWelcome on
DefaultServer on
Port 21
Umask 022
MaxInstances 30
IdentLookups off
<Directory />
AllowOverwrite on
</Directory>

AllowForeignAddress on

MaxClientsPerHost 2 "Nicht mehr als %m Verbindungen"
MaxClients 8 "Leider sind schon %m Clients verbunden"
MaxLoginAttempts 3

AllowStoreRestart on
AllowRetrieveRestart on

DefaultRoot ~
RequireValidShell off

TransferLog /var/log/proftpd.xferlog

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"
ExtendedLog /var/log/proftpd.access_log WRITE,READ write

ExtendedLog /var/log/proftpd.auth_log AUTH auth

ExtendedLog /var/log/proftpd.paranoid_log ALL default

SQLLOGFILE /var/log/proftpd.sql.log
SQLAuthTypes Plaintext
SQLAuthenticate users*
SQLConnectInfo protfptd@192.168.10.1 proftpd proftpd
SQLDefaultGID 65534
SQLDefaultUID 65534
SQLMinUserGID 100
SQLMinUserUID 500
SQLUserInfo users username password uid gid homedir shell
SQLLog PASS counter
SQLNamedQuery counter UPDATE "letzter_zugriff=now(), count=count+1 WHERE username='%u'" users
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
QuotaEngine on
QuotaShowQuotas on
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally

SQLNamedQuery get-quota-limit SELECT "name, quota_type, per_session,limit_type, bytes_in_avail, bytes_out_avail, bytes_xfer_avail, files_in_avail, files_out_avail, files_xfer_avail FROM quotalimits WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used, bytes_out_used, bytes_xfer_used, files_in_used, files_out_used, files_xfer_used FROM quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used = files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name = '%{6}' AND quota_type = '%{7}'" quotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5},%{6}, %{7}" quotatallies


.
8  ProFTPD / ProFTPD - Deutsch / [Mysql] Proftpd lasst keien connection zu am: 10. Oktober 2004, 19:22:39
hello,

habe zuerst mal mit protfpd-mysql von den backports probiert -> war der selbe fehler wie wenn ich es selber compl.
also,
egal ob ich vom localhost oder von einem anderen pc versuche einen connect zu machen -> 421 Service not available, remote server has closed connection

ps -aux bzw. netstat -alnp besagt was gegenteiliges.

hier ein auszug aus der debug:
Code:

Oct 10 16:03:45 ramml proftpd[18029]: ramml - FS: using system chdir()
Oct 10 16:03:45 ramml proftpd[18029]: ramml - ROOT PRIVS at main.c:2323
Oct 10 16:03:45 ramml proftpd[18029]: ramml - opening scoreboard '/usr/local/var/proftpd/proftpd.scoreboard'
Oct 10 16:03:45 ramml proftpd[18029]: ramml - RELINQUISH PRIVS at main.c:2347
Oct 10 16:03:45 ramml proftpd[18029]: ramml - ROOT PRIVS at inet.c:452
Oct 10 16:03:45 ramml proftpd[18029]: ramml - RELINQUISH PRIVS at inet.c:510
Oct 10 16:03:45 ramml proftpd[18029]: ramml - ROOT PRIVS at main.c:2171
Oct 10 16:03:45 ramml proftpd[18029]: ramml - RELINQUISH PRIVS at main.c:2177
Oct 10 16:03:45 ramml proftpd[18029]: ramml - FS: using system lstat()
Oct 10 16:03:48 ramml proftpd[18029]: ramml - FS: using system lstat()
Oct 10 16:03:48 ramml proftpd[18031]: ramml - ROOT PRIVS at main.c:1150
Oct 10 16:03:48 ramml proftpd[18031]: ramml - RELINQUISH PRIVS at main.c:1154
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - performing ident lookup
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - ident connection failed: Connection refused
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - ident lookup returned 'UNKNOWN'
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - performing module session initializations
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - ROOT PRIVS at mod_sql.c:3630
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - RELINQUISH PRIVS at mod_sql.c:3632
Oct 10 16:03:48 ramml proftpd[18029]: ramml - FS: using system lstat()
cOct 10 16:03:48 ramml proftpd[18029]: ramml - FS: using system lstat()
Oct 10 16:03:57 ramml proftpd[18029]: ramml - ROOT PRIVS at main.c:1823
Oct 10 16:03:57 ramml proftpd[18029]: ramml - RELINQUISH PRIVS at main.c:1826
Oct 10 16:03:57 ramml proftpd[18029]: ramml - ROOT PRIVS at main.c:1838
Oct 10 16:03:57 ramml proftpd[18029]: ramml - RELINQUISH PRIVS at main.c:1859
Oct 10 16:03:57 ramml proftpd[18029]: ramml - ROOT PRIVS at main.c:1866
Oct 10 16:03:57 ramml proftpd[18029]: ramml - RELINQUISH PRIVS at main.c:1868


vor allem dneke ich dass dieser teil interessant ist:
Zitat
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - performing ident lookup
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - ident connection failed: Connection refused
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - ident lookup returned 'UNKNOWN'
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - performing module session initializations
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - ROOT PRIVS at mod_sql.c:3630
Oct 10 16:03:48 ramml proftpd[18031]: ramml (ramml[127.0.0.1]) - RELINQUISH PRIVS at mod_sql.c:3632


dieser kommt soblad ich in meiner config die zeile
Zitat
SQLConnectInfo proftpd@192.168.10.1 user psw

wieder aktivere. die logs vom sql sieht so aus:
Zitat

Oct 10 16:08:26 mod_sql/4.10[18046]: backend module 'mod_sql_mysql/4.04'
Oct 10 16:08:26 mod_sql/4.10[18046]: backend api    'mod_sql_api_v1'
Oct 10 16:08:26 mod_sql/4.10[18046]: >>> sql_getconf
Oct 10 16:08:26 mod_sql/4.10[18046]: entering   mysql cmd_defineconnection
Oct 10 16:08:26 mod_sql/4.10[18046]:  name: 'default'
Oct 10 16:08:26 mod_sql/4.10[18046]:  user: 'proftpd'
Oct 10 16:08:26 mod_sql/4.10[18046]:  host: '192.168.10.1'
Oct 10 16:08:26 mod_sql/4.10[18046]:    db: 'proftpd'
Oct 10 16:08:26 mod_sql/4.10[18046]:  port: '3306'
Oct 10 16:08:26 mod_sql/4.10[18046]:   ttl: '0'
Oct 10 16:08:26 mod_sql/4.10[18046]: exiting    mysql cmd_defineconnection
Oct 10 16:08:26 mod_sql/4.10[18046]: entering   mysql cmd_open


beim anderen mysql server kommt kein connect an - als normal schon.
bei der version 1.2.5 (debian stable) funktioniert alles ohne probleme.
jemand eine idee?
die config und tables etc. habe ich übrings von proftpd.de 1:1 kopiert um div. fehler zu vermeiden.

danke.
Seiten: [1]
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.089 Sekunden mit 16 Zugriffen.