|
Titel: Problem mit SQL-Tabelle zugriff Beitrag von: GreenRover am 02. November 2004, 20:35:03 also ich habe den Server nun installier doch bekomme ich einfach ncith dazu ein login zu akzeptieren.
Hier der Inhalt meiner SQL datenbank -- Datenbank: `wwwserver` -- Tabellenstruktur für Tabelle `users` CREATE TABLE `users` ( `userid` varchar(30) NOT NULL default '', `passwd` varchar(30) NOT NULL default '', `uid` int(11) default NULL, `gid` int(11) default NULL, `homedir` varchar(255) default NULL, `shell` varchar(255) default NULL, UNIQUE KEY `userid` (`userid`), UNIQUE KEY `uid` (`uid`) ) TYPE=MyISAM; -- -- Daten für Tabelle `users` -- INSERT INTO `users` VALUES ('root', '7621701', 1000, 65534, '/www/vhosts', 'yes'); Und hier meine Config: ServerName "Wilkommen auf meine FTP Server (-; " ServerType standalone ServerAdmin greenrover@wwwserver.local.de ServerIdent on "wwwserver" DeferWelcome on DefaultServer on Port 21 Umask 022 MaxInstances 30 <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 # Zugangskontrolle SQLAuthTypes Plaintext SQLAuthenticate users* SQLConnectInfo wwwserver@localhost root 7621701 SQLDefaultGID 65534 SQLDefaultUID 65534 SQLMinUserGID 100 SQLMinUserUID 500 Danke im Vorraus für euhre Hilfe, weil ich hier sonst noch verzweifel. Titel: mein Debug Logbuch Beitrag von: GreenRover am 02. November 2004, 22:00:56 Hier noch mein Debuglogbuch:
Code: wwwserver:/etc # /usr/local/sbin/proftpd -nd 5 - parsing '/etc/proftpd.conf' configuration - <Directory />: adding section for resolved path '/' - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness wwwserver.local - wwwserver.local - Config for Wilkommen auf meine FTP Server (-; : wwwserver.local - / wwwserver.local - AllowOverwrite wwwserver.local - Umask wwwserver.local - AllowForeignAddress wwwserver.local - MaxClientsPerHost wwwserver.local - MaxClients wwwserver.local - AllowStoreRestart wwwserver.local - AllowRetrieveRestart wwwserver.local - RequireValidShell wwwserver.local - TransferLog wwwserver.local - SQLAuthTypes wwwserver.local - SQLAuthenticate wwwserver.local - SQLConnectInfo wwwserver.local - SQLDefaultGID wwwserver.local - SQLDefaultUID wwwserver.local - SQLMinUserGID wwwserver.local - SQLMinUserUID wwwserver.local - ServerIdent wwwserver.local - DeferWelcome wwwserver.local - DefaultServer wwwserver.local - Umask wwwserver.local - AllowForeignAddress wwwserver.local - MaxClientsPerHost wwwserver.local - MaxClients wwwserver.local - MaxLoginAttempts wwwserver.local - AllowStoreRestart wwwserver.local - AllowRetrieveRestart wwwserver.local - DefaultRoot wwwserver.local - RequireValidShell wwwserver.local - TransferLog wwwserver.local - ExtendedLog wwwserver.local - ExtendedLog wwwserver.local - ExtendedLog wwwserver.local - SQLAuthTypes wwwserver.local - SQLAuthenticate wwwserver.local - SQLConnectInfo wwwserver.local - SQLDefaultGID wwwserver.local - SQLDefaultUID wwwserver.local - SQLMinUserGID wwwserver.local - SQLMinUserUID wwwserver.local - SQLUserTable wwwserver.local - SQLUsernameField wwwserver.local - SQLPasswordField wwwserver.local - SQLUidField wwwserver.local - SQLGidField wwwserver.local - SQLHomedirField wwwserver.local - SQLShellField wwwserver.local - deleting existing scoreboard '/var/proftpd/proftpd.scoreboard' wwwserver.local - Failed binding to 0.0.0.0, port 21: Address already in use wwwserver.local - Check the ServerType directive to ensure you are configured correctly. wwwserver:/etc/init.d # /usr/local/sbin/proftpd -nd5 2>&1 >/var/log/porftpd_error_log - parsing '/etc/proftpd.conf' configuration - <Directory />: adding section for resolved path '/' - SQLAuthenticate: use of * in SQLAuthenticate has been deprecated. Use AuthOrder for setting authoritativeness wwwserver.local - wwwserver.local - Config for Wilkommen auf meine FTP Server (-; : wwwserver.local - / wwwserver.local - AllowOverwrite wwwserver.local - Umask wwwserver.local - AllowForeignAddress wwwserver.local - MaxClientsPerHost wwwserver.local - MaxClients wwwserver.local - AllowStoreRestart wwwserver.local - AllowRetrieveRestart wwwserver.local - RequireValidShell wwwserver.local - TransferLog wwwserver.local - SQLAuthTypes wwwserver.local - SQLAuthenticate wwwserver.local - SQLConnectInfo wwwserver.local - SQLDefaultGID wwwserver.local - SQLDefaultUID wwwserver.local - SQLMinUserGID wwwserver.local - SQLMinUserUID wwwserver.local - ServerIdent wwwserver.local - DeferWelcome wwwserver.local - DefaultServer wwwserver.local - Umask wwwserver.local - AllowForeignAddress wwwserver.local - MaxClientsPerHost wwwserver.local - MaxClients wwwserver.local - MaxLoginAttempts wwwserver.local - AllowStoreRestart wwwserver.local - AllowRetrieveRestart wwwserver.local - DefaultRoot wwwserver.local - RequireValidShell wwwserver.local - TransferLog wwwserver.local - ExtendedLog wwwserver.local - ExtendedLog wwwserver.local - ExtendedLog wwwserver.local - SQLAuthTypes wwwserver.local - SQLAuthenticate wwwserver.local - SQLConnectInfo wwwserver.local - SQLDefaultGID wwwserver.local - SQLDefaultUID wwwserver.local - SQLMinUserGID wwwserver.local - SQLMinUserUID wwwserver.local - SQLUserTable wwwserver.local - SQLUsernameField wwwserver.local - SQLPasswordField wwwserver.local - SQLUidField wwwserver.local - SQLGidField wwwserver.local - SQLHomedirField wwwserver.local - SQLShellField wwwserver.local - ProFTPD 1.2.10 (stable) (built Tue Nov 2 17:41:24 CET 2004) standalone mode STARTUP wwwserver.local (192.168.0.1[192.168.0.1]) - FTP session opened. wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching PRE_CMD command 'USER root' to mod_core wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching PRE_CMD command 'USER root' to mod_core wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching PRE_CMD command 'USER root' to mod_auth wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching CMD command 'USER root' to mod_auth wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching POST_CMD command 'USER root' to mod_sql wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching LOG_CMD command 'USER root' to mod_sql wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching LOG_CMD command 'USER root' to mod_log wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_core wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching PRE_CMD command 'PASS (hidden)' to mod_auth wwwserver.local (192.168.0.1[192.168.0.1]) - dispatching CMD command 'PASS (hidden)' to mod_auth wwwserver.local (192.168.0.1[192.168.0.1]) - USER root (Login failed): User in /etc/ftpusers wwwserver.local (192.168.0.1[192.168.0.1]) - Maximum login attempts (1) exceeded wwwserver.local (192.168.0.1[192.168.0.1]) - FTP session closed. Was soll das: User in /etc/ftpusers Ich habe doch wie im Tutorial bei SQLAuhtentificatin users* gesetzt Titel: Problem mit SQL-Tabelle zugriff Beitrag von: stonki am 03. November 2004, 08:19:09 USER root (Login failed): User in /etc/ftpusers
in /etc/ftpusers sind User aufgelistet, die auf _keinen Fall_ FTP Zugang bekommen dürfen. Lösche dort einfach "root". cu stonki |