|
Titel: Problem mit mod_sql_mysql und Login Beitrag von: Küspert 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: Titel: Re: Problem mit mod_sql_mysql und Login Beitrag von: Küspert 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. Titel: Re: Problem mit mod_sql_mysql und Login Beitrag von: Küspert am 09. August 2006, 22:28:33 Falls ihr noch den dump der Datenbank braucht könnt ihr ihn habe.
Sind eh nur Testuser. Titel: Re: Problem mit mod_sql_mysql und Login Beitrag von: Küspert 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 Titel: Re: Problem mit mod_sql_mysql und Login Beitrag von: Küspert am 10. August 2006, 00:18:18 Ok es ist 00:11 Uhr und nach 4 Stunden habe ich es geschafft :)
Es war mein mysqld ;) Ich hatte das --old-passwords vergessen bzw. in der my.cnf old-passwords = 1 Naja egal. GN8 |