Problemer med Pure-FTPd med MySQL
nu har jeg prøvet med denne guide at installere Pure-ftpd-mysql:http://www.howtoforge.com/pureftpd_mysql_virtual_hosting
Har fået hul igennem, så man kan komme til login
MEN, når jeg prøver gennem cmd, og skal skrive brugernavn og kode, så melder den fejl efter at have skrevet koden.
Stumpen fra cmd:
220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
220-You are user number 1 of 50 allowed.
220-Local time is now 09:29. Server port: 21.
220-This is a private system - No anonymous login
220 You will be disconnected after 15 minutes of inactivity.
Bruger (************************): admin
331 User admin OK. Password required
Adgangskode:
530 Login authentication failed
Logon mislykkedes.
------------------------------------------------
Min mysql.conf fil:
MYSQLSocket /var/run/mysqld/mysqld.sock
#MYSQLServer localhost
#MYSQLPort 3306
MYSQLUser ************
MYSQLPassword ************
#MYSQLCrypt md5, cleartext, crypt() or password()
MYSQLCrypt md5
MYSQLGetPW SELECT Password FROM ftpd WHERE User="\L" AND status="1" AND (ip
access = "*" OR ipaccess LIKE "\R")
MYSQLGetUID SELECT Uid FROM ftpd WHERE User="\L" AND status="1" AND (ipacces
s = "*" OR ipaccess LIKE "\R")
MYSQLGetGID SELECT Gid FROM ftpd WHERE User="\L" AND status="1" AND (ipacces
s = "*" OR ipaccess LIKE "\R")
MYSQLGetDir SELECT Dir FROM ftpd WHERE User="\L" AND status="1" AND (ipacces
s = "*" OR ipaccess LIKE "\R")
MYSQLGetBandwidthUL SELECT ULBandwidth FROM ftpd WHERE User="\L" AND status=
"1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetBandwidthDL SELECT DLBandwidth FROM ftpd WHERE User="\L" AND status=
"1" AND (ipaccess = "*" OR ipaccess LIKE "\R")
MYSQLGetQTASZ SELECT QuotaSize FROM ftpd WHERE User="\L" AND status="1" AND (i
paccess = "*" OR ipaccess LIKE "\R")
MYSQLGetQTAFS SELECT QuotaFiles FROM ftpd WHERE User="\L" AND status="1" AND (
ipaccess = "*" OR ipaccess LIKE "\R")
--------------------------------------------------------------
Har derudover oprettet sql, en sql bruger, med oplysningerne passende til dem i min conf fil, sat rettigheder op for sql brugeren, sat tabel op, og lavet en ftp bruger, efter guiden..
Her er desuden lige en stump af loggen fra /var/log/messages:
May 27 17:29:46 localhost pure-ftpd: (?@skjult) [INFO] New
connection from skjult
May 27 17:29:47 localhost pure-ftpd: (?@skjult) [INFO] New
connection from skjult
May 27 17:31:47 localhost pure-ftpd: (?@skjult] New
connection from skjult
May 27 17:31:47 localhost pure-ftpd: (?@skjult]
Wrong SQL parameters : [SELECT Password FROM ftpd WHERE User="admin" AND status=
"1" AND (ipaccess = "*" OR ipaccess LIKE "skjult")]
May 27 17:31:47 localhost pure-ftpd: (?@skjult) [INFO] PAM
_RHOST enabled. Getting the peer address
May 27 17:31:49 localhost pure-ftpd: (?@skjult) [WARNING]
Authentication failed for user [admin]
Nogen der kan sige mig hvad der er i vejen?
