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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
