proftpd + mysql
Witaj lista!
hejka
proboje zmusic do dzialania proftpd-mysql z baza
robie krok po kroku wszystkie zalecenia jak dla "osiolkow" ze strony:
http://www.howtoforge.com/proftpd_mysql_virtual_hosting
proftpd.conf z sekcja dla mysql:
SQLAuthTypes Plaintext Crypt
SQLAuthenticate users* groups*
#SQLConnectInfo ftp@localhost proftpd haslo_do_bazy
SQLUserInfo ftpuser userid passwd uid gid homedir shell
SQLGroupInfo ftpgroup groupname gid members
SQLMinID 500
SQLHomedirOnDemand on
SQLLog PASS updatecount
SQLNamedQuery updatecount UPDATE "count=count+1, accessed=now() WHERE userid='%u'" ftpuser
SQLLog STOR,DELE modified
SQLNamedQuery modified UPDATE "modified=now() WHERE userid='%u'" ftpuser
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
oczywiscie dalem entery zeby to sie pomiescilo tu w mailu w konfigu
mam w jednej lini ladnie
dodalem usera z haselkiem
i podczas logowania w mysql.log mam:
10242 Connect proftpd@localhost on ftp
10242 Query SELECT userid, passwd, uid, gid, homedir, shell FROM
ftpuser WHERE (userid='uzytkownik') LIMIT 1
10242 Query SELECT groupname FROM ftpgroup WHERE (gid = 2001) LIMIT 1
10242 Query SELECT groupname, gid, members FROM ftpgroup WHERE (groupname = 'ftpgroup')
10242 Query SELECT groupname, gid, members FROM ftpgroup WHERE (members = 'bienius' OR members LIKE 'uzytkownik,%' OR members LIKE '%,uzytkownik' OR members LIKE '%,uzytkownik,%')
10242 Query SELECT groupname, gid, members FROM ftpgroup WHERE (members = 'bienius' OR members LIKE 'uzytkownik,%' OR members LIKE '%,uzytkownik' OR members LIKE '%,uzytkownik,%')
no i niestety podaje mi ze haslo jest nieprawidlowe i nie loguje mnie
katalog virtualny zostaje utworzony ten wpisany w bazie w
/home/domena.pl
hmm brakuje mi cos w pam.d ?? od mysql ? czy co moze byc przyczyna ??
--
Pozdrowienia,
bieniu gras
Reply to: