www.ProFTPD.de
13. März 2007, 18:34:04 *
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: Problem mit mod_sql_mysql und Login  (Gelesen 267 mal)
0 Mitglieder und 1 Gast betrachten dieses Thema.
Küspert
ProFTPD
*
Offline Offline

Beiträge: 19


Profil anzeigen
« am: 09. August 2006, 22:26:56 »

Hi,

also hier erstmal alles wichtige.

Die proftpd.conf:

Code:
# This is a basic ProFTPD configuration file (rename it to
# 'proftpd.conf' for actual use. It establishes a single server
# and a single anonymous login. It assumes that you have a user/group
# "nobody" and "ftp" for normal operation and anon.

ServerName "=|PWF|= FTPserver"
ServerType standalone
DeferWelcome off
ServerAdmin admin@odelturmspringen.de

ShowSymlinks on
MultilineRFC2228 on
DefaultServer on
AllowOverwrite on

TimeoutNoTransfer 600
TimeoutStalled 600
TimeoutIdle 1200

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

DenyFilter \*.*/

# Uncomment this if you are using NIS or LDAP to retrieve passwords:

# PersistentPasswd off

# 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 ftp
Group nogroup

# It is on by default.

DelayEngine off

# Normally, we want files to be overwriteable.

<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

AllowOverwrite on

</Directory>

# Hier meine Ergänzungen

# chroot für alle User der Gruppe ftpgroup
DefaultRoot ~ ftpgroup, ~ www-data

# Login nur von Mitgliedern der Gruppe ftpgroup erlauben
<Limit LOGIN>
DenyGroup !ftpgroup, !www-data
</Limit>

# Root-Login verbieten und keine gültige Shell verlangen (in /etc/shells)

<Global>
RootLogin off
RequireValidShell off
</Global>

# Speed erhoehen

UseReverseDNS off
IdentLookups off

# FXP Unterstuetzung

AllowForeignAddress on

# Logging Formate

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"

# Logging aktivieren

# alle logins

ExtendedLog /var/log/ftp_auth.log AUTH auth

# file/dir Zugriff

ExtendedLog /var/log/ftp_access.log WRITE,READ write

# für paranoide (vorsicht, erzeugt grosse Logfiles)

# ExtendedLog /var/log/ftp_paranoid.log ALL default

# Uncomment this if you would use TLS module:

TLSEngine on
TLSLog /var/log/tls.log
TLSProtocol SSLv23
TLSOptions NoCertRequest
TLSRSACertificateFile /etc/ssl/certs/proftpd.cert.pem
TLSRSACertificateKeyFile /etc/ssl/certs/proftpd.key.pem
TLSVerifyClient off

# The passwords in MySQL are encrypted using CRYPT

SQLAuthTypes            Plaintext Crypt
SQLAuthenticate         users* groups*
AuthOrder     mod_sql_mysql.c

# used to connect to the database
# databasename@host database_user user_password

SQLConnectInfo  ftp@localhost proftpd 6f4cvWGO

# Here we tell ProFTPd the names of the database columns in the "usertable"
# we want it to interact with. Match the names with those in the db

SQLUserInfo     ftpuser userid passwd uid gid homedir shell

# Here we tell ProFTPd the names of the database columns in the "grouptable"
# we want it to interact with. Again the names match with those in the db

SQLGroupInfo    ftpgroup groupname gid members

# set min UID and GID - otherwise these are 999 each

SQLMinID        30

# create a user's home directory on demand if it doesn't exist

SQLHomedirOnDemand on

# Update count every time user logs in

SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser

# Update modified everytime user uploads or deletes a file

SQLLog  STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser

# User quotas

QuotaEngine on
QuotaDirectoryTally on
QuotaDisplayUnits Mb
QuotaShowQuotas on
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 ftpquotalimits 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 ftpquotatallies 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}'" ftpquotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4}, %{5}, %{6}, %{7}" ftpquotatallies
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
SQLNamedQuery gettally  SELECT "ROUND((bytes_in_used/1048576),2) FROM ftpquotatallies WHERE name='%u'"
SQLNamedQuery getlimit  SELECT "ROUND((bytes_in_avail/1048576),2) FROM ftpquotalimits WHERE name='%u'"
SQLNamedQuery getfree   SELECT "ROUND(((ftpquotalimits.bytes_in_avail-ftpquotatallies.bytes_in_used)/1048576),2) FROM ftpquotalimits,ftpquotatallies WHERE ftpquotalimits.name = '%u' AND ftpquotatallies.name = '%u'"
SQLShowInfo   LIST    "226" "Used %{gettally}MB from %{getlimit}MB. You have %{getfree}MB available space."

dann der Debug bei "proftpd -n -d 9", wenn ich mich einloggen versuche bei einen Systemuser:



Gespeichert
Küspert
ProFTPD
*
Offline Offline

Beiträge: 19


Profil anzeigen
« Antwort #1 am: 09. August 2006, 22:28:03 »

Code:
root@rbi0046:~# proftpd -n -d 9
 - mod_tls/2.0.7: using OpenSSL 0.9.7e 25 Oct 2004
 - 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 'ServerAdmin' to module mod_core
 - dispatching directive 'ShowSymlinks' to module mod_ls
 - dispatching directive 'MultilineRFC2228' to module mod_core
 - dispatching directive 'DefaultServer' to module mod_core
 - 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 0x812e630.
 - 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_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 'DelayEngine' to module mod_delay
 - 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
 - dispatching directive 'DefaultRoot' to module mod_auth
 - dispatching directive '<Limit>' to module mod_core
 - dispatching directive 'DenyGroup' to module mod_core
 - dispatching directive '</Limit>' to module mod_core
 - dispatching directive '<Global>' to module mod_core
 - dispatching directive 'RootLogin' to module mod_auth
 - dispatching directive 'RequireValidShell' to module mod_auth
 - dispatching directive '</Global>' to module mod_core
 - dispatching directive 'UseReverseDNS' to module mod_core
 - dispatching directive 'IdentLookups' to module mod_core
 - dispatching directive 'AllowForeignAddress' to module mod_core
 - dispatching directive 'LogFormat' to module mod_log
 - FS: using system read()
 - 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 'TLSEngine' to module mod_tls
 - dispatching directive 'TLSLog' to module mod_tls
 - dispatching directive 'TLSProtocol' to module mod_tls
 - dispatching directive 'TLSOptions' to module mod_tls
 - dispatching directive 'TLSRSACertificateFile' to module mod_tls
 - FS: using system lstat()
 - dispatching directive 'TLSRSACertificateKeyFile' to module mod_tls
 - FS: using system lstat()
 - dispatching directive 'TLSVerifyClient' to module mod_tls
 - 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
 - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated.  Use AuthOrder for setting authoritativeness
 - dispatching directive 'AuthOrder' to module mod_core
 - dispatching directive 'SQLConnectInfo' to module mod_sql
 - FS: using system read()
 - dispatching directive 'SQLUserInfo' to module mod_sql
 - dispatching directive 'SQLGroupInfo' to module mod_sql
 - dispatching directive 'SQLMinID' to module mod_sql
 - dispatching directive 'SQLHomedirOnDemand' to module mod_sql
 - dispatching directive 'SQLLog' to module mod_sql
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'SQLLog' to module mod_sql
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'QuotaEngine' to module mod_quotatab
 - dispatching directive 'QuotaDirectoryTally' to module mod_quotatab
 - dispatching directive 'QuotaDisplayUnits' to module mod_quotatab
 - dispatching directive 'QuotaShowQuotas' to module mod_quotatab
 - FS: using system read()
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'QuotaLimitTable' to module mod_quotatab
 - dispatching directive 'QuotaTallyTable' to module mod_quotatab
 - FS: using system read()
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'SQLNamedQuery' to module mod_sql
 - dispatching directive 'SQLShowInfo' to module mod_sql
 - FS: using system read()
 - FS: using system close()
rbi0046.giga-dns.com -
rbi0046.giga-dns.com - Config for =|PWF|= FTPserver:
rbi0046.giga-dns.com - Limit
rbi0046.giga-dns.com -  DenyGroup
rbi0046.giga-dns.com - /*
rbi0046.giga-dns.com -  Umask
rbi0046.giga-dns.com -  DirUmask
rbi0046.giga-dns.com -  AllowOverwrite
rbi0046.giga-dns.com -  ShowSymlinks
rbi0046.giga-dns.com -  DisplayLogin
rbi0046.giga-dns.com -  DisplayFirstChdir
rbi0046.giga-dns.com -  ListOptions
rbi0046.giga-dns.com -  DenyFilter
rbi0046.giga-dns.com -  AllowForeignAddress
rbi0046.giga-dns.com -  SQLAuthTypes
rbi0046.giga-dns.com -  SQLAuthenticate
rbi0046.giga-dns.com -  SQLConnectInfo
rbi0046.giga-dns.com -  SQLMinID
rbi0046.giga-dns.com -  SQLHomedirOnDemand
rbi0046.giga-dns.com -  SQLLog_PASS
rbi0046.giga-dns.com -  SQLNamedQuery_updatecount
rbi0046.giga-dns.com -  SQLLog_STOR
rbi0046.giga-dns.com -  SQLLog_DELE
rbi0046.giga-dns.com -  SQLNamedQuery_modified
rbi0046.giga-dns.com -  SQLNamedQuery_get-quota-limit
rbi0046.giga-dns.com -  SQLNamedQuery_get-quota-tally
rbi0046.giga-dns.com -  SQLNamedQuery_update-quota-tally
rbi0046.giga-dns.com -  SQLNamedQuery_insert-quota-tally
rbi0046.giga-dns.com -  SQLNamedQuery_gettally
rbi0046.giga-dns.com -  SQLNamedQuery_getlimit
rbi0046.giga-dns.com -  SQLNamedQuery_getfree
rbi0046.giga-dns.com -  SQLShowInfo_LIST
rbi0046.giga-dns.com -  RootLogin
rbi0046.giga-dns.com -  RequireValidShell
rbi0046.giga-dns.com - DeferWelcome
rbi0046.giga-dns.com - ShowSymlinks
rbi0046.giga-dns.com - DefaultServer
rbi0046.giga-dns.com - AllowOverwrite
rbi0046.giga-dns.com - TimeoutNoTransfer
rbi0046.giga-dns.com - TimeoutStalled
rbi0046.giga-dns.com - TimeoutIdle
rbi0046.giga-dns.com - DisplayLogin
rbi0046.giga-dns.com - DisplayFirstChdir
rbi0046.giga-dns.com - ListOptions
rbi0046.giga-dns.com - DenyFilter
rbi0046.giga-dns.com - UserID
rbi0046.giga-dns.com - UserName
rbi0046.giga-dns.com - GroupID
rbi0046.giga-dns.com - GroupName
rbi0046.giga-dns.com - DelayEngine
rbi0046.giga-dns.com - DefaultRoot
rbi0046.giga-dns.com - IdentLookups
rbi0046.giga-dns.com - AllowForeignAddress
rbi0046.giga-dns.com - ExtendedLog
rbi0046.giga-dns.com - ExtendedLog
rbi0046.giga-dns.com - TLSEngine
rbi0046.giga-dns.com - TLSLog
rbi0046.giga-dns.com - TLSOptions
rbi0046.giga-dns.com - TLSRSACertificateFile
rbi0046.giga-dns.com - TLSRSACertificateKeyFile
rbi0046.giga-dns.com - TLSVerifyClient
rbi0046.giga-dns.com - SQLAuthTypes
rbi0046.giga-dns.com - SQLAuthenticate
rbi0046.giga-dns.com - AuthOrder
rbi0046.giga-dns.com - SQLConnectInfo
rbi0046.giga-dns.com - SQLUserTable
rbi0046.giga-dns.com - SQLUsernameField
rbi0046.giga-dns.com - SQLPasswordField
rbi0046.giga-dns.com - SQLUidField
rbi0046.giga-dns.com - SQLGidField
rbi0046.giga-dns.com - SQLHomedirField
rbi0046.giga-dns.com - SQLShellField
rbi0046.giga-dns.com - SQLGroupTable
rbi0046.giga-dns.com - SQLGroupnameField
rbi0046.giga-dns.com - SQLGroupGIDField
rbi0046.giga-dns.com - SQLGroupMembersField
rbi0046.giga-dns.com - SQLMinID
rbi0046.giga-dns.com - SQLHomedirOnDemand
rbi0046.giga-dns.com - SQLLog_PASS
rbi0046.giga-dns.com - SQLNamedQuery_updatecount
rbi0046.giga-dns.com - SQLLog_STOR
rbi0046.giga-dns.com - SQLLog_DELE
rbi0046.giga-dns.com - SQLNamedQuery_modified
rbi0046.giga-dns.com - QuotaEngine
rbi0046.giga-dns.com - QuotaDirectoryTally
rbi0046.giga-dns.com - QuotaDisplayUnits
rbi0046.giga-dns.com - QuotaShowQuotas
rbi0046.giga-dns.com - SQLNamedQuery_get-quota-limit
rbi0046.giga-dns.com - SQLNamedQuery_get-quota-tally
rbi0046.giga-dns.com - SQLNamedQuery_update-quota-tally
rbi0046.giga-dns.com - SQLNamedQuery_insert-quota-tally
rbi0046.giga-dns.com - QuotaLimitTable
rbi0046.giga-dns.com - QuotaTallyTable
rbi0046.giga-dns.com - SQLNamedQuery_gettally
rbi0046.giga-dns.com - SQLNamedQuery_getlimit
rbi0046.giga-dns.com - SQLNamedQuery_getfree
rbi0046.giga-dns.com - SQLShowInfo_LIST
rbi0046.giga-dns.com - RootLogin
rbi0046.giga-dns.com - RequireValidShell
rbi0046.giga-dns.com - ROOT PRIVS at ../../../modules/mod_tls.c:584
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../modules/mod_tls.c:586
rbi0046.giga-dns.com - ROOT PRIVS at ../../../modules/mod_tls.c:632
rbi0046.giga-dns.com - mod_tls/2.0.7: passphrase locked into memory
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../modules/mod_tls.c:638
rbi0046.giga-dns.com - dispatching auth request "getgroups" to module mod_radius
rbi0046.giga-dns.com - dispatching auth request "getgroups" to module mod_sql
rbi0046.giga-dns.com - dispatching auth request "getgroups" to module mod_auth_file
rbi0046.giga-dns.com - dispatching auth request "getgroups" to module mod_auth_unix
rbi0046.giga-dns.com - SETUP PRIVS at ../../../src/main.c:2736
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/main.c:1970
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/main.c:1977
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/main.c:2325
rbi0046.giga-dns.com - opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/main.c:2351
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/inet.c:322
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/inet.c:380
rbi0046.giga-dns.com - ProFTPD 1.2.10 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/main.c:2188
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/main.c:2190
rbi0046.giga-dns.com - FS: using system lstat()
rbi0046.giga-dns.com - FS: using system lstat()
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/main.c:1162
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/main.c:1166
rbi0046.giga-dns.com - FS: using system lstat()
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - ROOT PRIVS at ../../../src/main.c:1011
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - SETUP PRIVS at ../../../src/main.c:1016
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - FTP session requested from unknown class
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - performing module session initializations
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - ROOT PRIVS at ../../../modules/mod_tls.c:2632
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - RELINQUISH PRIVS at ../../../modules/mod_tls.c:2634
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - ROOT PRIVS at ../../../modules/mod_tls.c:662
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - RELINQUISH PRIVS at ../../../modules/mod_tls.c:670
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - ROOT PRIVS at ../../../modules/mod_tls.c:1085
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - RELINQUISH PRIVS at ../../../modules/mod_tls.c:1149
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - mod_tls/2.0.7: scrubbing all passphrases from memory
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - FTP session closed.
rbi0046.giga-dns.com - FS: using system lstat()

Und bei einen User in der Datenbank:

Code:
rbi0046.giga-dns.com - SQLNamedQuery_update-quota-tally
rbi0046.giga-dns.com - SQLNamedQuery_insert-quota-tally
rbi0046.giga-dns.com - QuotaLimitTable
rbi0046.giga-dns.com - QuotaTallyTable
rbi0046.giga-dns.com - SQLNamedQuery_gettally
rbi0046.giga-dns.com - SQLNamedQuery_getlimit
rbi0046.giga-dns.com - SQLNamedQuery_getfree
rbi0046.giga-dns.com - SQLShowInfo_LIST
rbi0046.giga-dns.com - RootLogin
rbi0046.giga-dns.com - RequireValidShell
rbi0046.giga-dns.com - ROOT PRIVS at ../../../modules/mod_tls.c:584
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../modules/mod_tls.c:586
rbi0046.giga-dns.com - ROOT PRIVS at ../../../modules/mod_tls.c:632
rbi0046.giga-dns.com - mod_tls/2.0.7: passphrase locked into memory
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../modules/mod_tls.c:638
rbi0046.giga-dns.com - dispatching auth request "getgroups" to module mod_radius
rbi0046.giga-dns.com - dispatching auth request "getgroups" to module mod_sql
rbi0046.giga-dns.com - dispatching auth request "getgroups" to module mod_auth_file
rbi0046.giga-dns.com - dispatching auth request "getgroups" to module mod_auth_unix
rbi0046.giga-dns.com - SETUP PRIVS at ../../../src/main.c:2736
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/main.c:1970
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/main.c:1977
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/main.c:2325
rbi0046.giga-dns.com - opening scoreboard '/var/run/proftpd/proftpd.scoreboard'
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/main.c:2351
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/inet.c:322
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/inet.c:380
rbi0046.giga-dns.com - ProFTPD 1.2.10 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/main.c:2188
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/main.c:2190
rbi0046.giga-dns.com - FS: using system lstat()
rbi0046.giga-dns.com - ROOT PRIVS at ../../../src/main.c:1162
rbi0046.giga-dns.com - RELINQUISH PRIVS at ../../../src/main.c:1166
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - ROOT PRIVS at ../../../src/main.c:1011
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - SETUP PRIVS at ../../../src/main.c:1016
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - FTP session requested from unknown class
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - performing module session initializations
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - ROOT PRIVS at ../../../modules/mod_tls.c:2632
rbi0046.giga-dns.com - FS: using system lstat()
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - RELINQUISH PRIVS at ../../../modules/mod_tls.c:2634
rbi0046.giga-dns.com - FS: using system lstat()
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - ROOT PRIVS at ../../../modules/mod_tls.c:662
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - RELINQUISH PRIVS at ../../../modules/mod_tls.c:670
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - ROOT PRIVS at ../../../modules/mod_tls.c:1085
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - RELINQUISH PRIVS at ../../../modules/mod_tls.c:1149
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - mod_tls/2.0.7: scrubbing all passphrases from memory
rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - FTP session closed.
rbi0046.giga-dns.com - FS: using system lstat()

So nun noch der Daemon.log:

Code:
Aug  9 21:43:12 rbi0046 proftpd[32135]: rbi0046.giga-dns.com - ProFTPD 1.2.10 standalone mode SHUTDOWN
Aug  9 21:46:52 rbi0046 proftpd[32285]: rbi0046.giga-dns.com - ProFTPD 1.2.10 (stable) (built do mrt 22 18:28:32 CET 2001) standalone mode STARTUP
Aug  9 21:48:07 rbi0046 proftpd[32292]: rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - FTP session closed.
Aug  9 21:48:10 rbi0046 proftpd[32294]: rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - FTP session closed.
Aug  9 21:48:12 rbi0046 proftpd[32295]: rbi0046.giga-dns.com (84.147.46.151[84.147.46.151]) - FTP session closed.
Aug  9 21:48:41 rbi0046 proftpd[32285]: rbi0046.giga-dns.com - ProFTPD killed (signal 15)
Aug  9 21:48:41 rbi0046 proftpd[32285]: rbi0046.giga-dns.com - ProFTPD 1.2.10 standalone mode SHUTDOWN

Ja also ich kann mich sobald ich MySQL User angelegt habe und es in die *.conf eingetragen habe alle nicht mehr einloggen zuvor geht es aber mit dem Systemuser.

Ich habe mich zum teil an diesen HowTo orientiert:

http://www.howtoforge.de/proftpd_mysql_virtual_hosting_p2

Und ich sitze wirklich schon lange hier aber komme nicht drauf sry.

Gespeichert
Küspert
ProFTPD
*
Offline Offline

Beiträge: 19


Profil anzeigen
« Antwort #2 am: 09. August 2006, 22:28:33 »

Falls ihr noch den dump der Datenbank braucht könnt ihr ihn habe.

Sind eh nur Testuser.
Gespeichert
Küspert
ProFTPD
*
Offline Offline

Beiträge: 19


Profil anzeigen
« Antwort #3 am: 10. August 2006, 00:01:32 »

Hi,

also ich hab ein wenig gefriemelt und rasu kam das beim SQL.log:

Zitat
Aug 09 23:53:47 mod_sql/4.11[509]: backend module 'mod_sql_mysql/4.04'
Aug 09 23:53:47 mod_sql/4.11[509]: backend api    'mod_sql_api_v1'
Aug 09 23:53:47 mod_sql/4.11[509]: >>> sql_getconf
Aug 09 23:53:47 mod_sql/4.11[509]: entering    mysql cmd_defineconnection
Aug 09 23:53:47 mod_sql/4.11[509]:  name: 'default'
Aug 09 23:53:47 mod_sql/4.11[509]:  user: 'proftpd'
Aug 09 23:53:47 mod_sql/4.11[509]:  host: 'localhost'
Aug 09 23:53:47 mod_sql/4.11[509]:    db: 'ftp'
Aug 09 23:53:47 mod_sql/4.11[509]:  port: '3306'
Aug 09 23:53:47 mod_sql/4.11[509]:   ttl: '0'
Aug 09 23:53:47 mod_sql/4.11[509]: exiting    mysql cmd_defineconnection
Aug 09 23:53:47 mod_sql/4.11[509]: entering    mysql cmd_open
Aug 09 23:53:47 mod_sql/4.11[509]: exiting    mysql cmd_open
Aug 09 23:53:47 mod_sql/4.11[509]: unrecoverable backend error
Aug 09 23:53:47 mod_sql/4.11[509]: error: '1251'
Aug 09 23:53:47 mod_sql/4.11[509]: message: 'Client unterstützt das vom Server erwartete Authentifizierungsprotokoll nicht. Bitte aktualisieren Sie Ihren MySQL-Client'

Ja ich hab eaber die libmysqlclient12-dev drauf und die libmysqlclient12 / 14 auch.

Hmmm

Mfg
Gespeichert
Küspert
ProFTPD
*
Offline Offline

Beiträge: 19


Profil anzeigen
« Antwort #4 am: 10. August 2006, 00:18:18 »

Ok es ist 00:11 Uhr und nach 4 Stunden habe ich es geschafft Smiley

Es war mein mysqld Zwinkernd

Ich hatte das --old-passwords vergessen bzw. in der my.cnf old-passwords = 1

Naja egal.

GN8
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.147 Sekunden mit 15 Zugriffen.