R@fi
-
Zawartość
1143 -
Rejestracja
-
Ostatnio
-
Wygrane dni
4
Wszystko napisane przez R@fi
-
awaria została osunięta pozdrawiam
-
Ja mam takie pytanie czy ktoś z was słyszał o takiej aplikacji sudo pod linuxa do czego ona służy ??
-
witam zainstalowałem direct admina lecz nie spisalem danych do aminki po zakończeniu instalacji .Wiem ze sa zapisane w którymś z plików lecz nie wiem gdzie moze ktos pomoc ??
-
nie nie to nie oto chodzi gdzies w pliku po ukonczeniu instalacji zapisuja sie koncowe dane czyli login do glownej bazy i hasło tylko zapomnialem gdzie ;/ dzięki kolego browarek dla ciebie za moment będę miał kolejne pytanie w dziale piaskownica
-
Witam poraz kolejny mam do was takie pytanie czy jeest mozliwosc podpiecia domeny i subdomeny bez direct admina jesli tak to jak to zrobić
-
Moze jasniej zobaczcie na screenie http://img521.imageshack.us/img521/8646/screen1ruy.jpg po zalożeniu konta nie łączy z FTP w Mysqlu Tworzy sie user na ftp tworzy sie tez katalog z userem a polaczenia ftp niema chodzi o to aby proftpd tak ustawić aby pobieral dane czyli login i haslo w tym wypadku i tworzyl usera jesli nie wgram direct admina zainstaluje i skonfiguruje proftpd ftp sie samo tworzy po dodaniu usera natomiast jak wgram Direct Admina ta konfiguracja nie cuś nie chula i w tym caly dylemat ze niewiem czemu ;/;/ az juz panowie osiwialem
-
witam mam takie pytanie jak prze konfigurować proftpd.conf tak panel którego używam kozystal z innego PLIKU passwd niż DA
-
tak właśnie to trzeba tak ustawić aby proftpd łączył się z baza danych pobierał z niej login i hasło z bazy utworzonego usera i na tej podstawie tworzył dostęp do FTP
-
prosze kogos o pomoc sam nie daje juz rady nie mam pomyslu jak to zrobic wr..... ;/
-
ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP (80.54.177.65[80.54.177.65]): FTP session closed. (80.54.177.65[80.54.177.65]): FTP session closed. ProFTPD killed (signal 15) Jul 15 09:13:02ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 15 09:13:04 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 15 09:18:11 ProFTPD killed (signal 15) Jul 15 09:18:11 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 15 18:51:44 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 15 18:51:48 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 18:53:50 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 18:54:54 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 18:56:36 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 19:03:23 ProFTPD killed (signal 15) Jul 15 19:03:23 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 15 19:03:25 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 15 19:05:55 (194.181.245.190[194.181.245.190]): FTP session closed. Jul 15 19:11:15 ProFTPD killed (signal 15) Jul 15 19:11:15 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 15 19:12:20 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 15 19:21:16 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 19:59:21 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 20:40:01 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 20:53:09 (194.181.245.190[194.181.245.190]): FTP session closed. Jul 15 20:53:14 (194.181.245.190[194.181.245.190]): FTP session closed. Jul 15 20:53:19 (194.181.245.190[194.181.245.190]): FTP session closed. Jul 15 20:53:24 (194.181.245.190[194.181.245.190]): FTP session closed. Jul 15 21:33:04 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 22:34:16 (80.54.177.65[80.54.177.65]): FTP session closed. Jul 15 22:47:11 ProFTPD killed (signal 15) Jul 15 22:47:11 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 15 22:47:13 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 15 22:51:44 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 15 23:00:52 (208.72.155.178[208.72.155.178]): error deleting scoreboard entry: Connection reset by peer Jul 15 23:00:52 (208.72.155.178[208.72.155.178]): FTP session closed. Jul 15 23:12:59 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 00:35:43 ProFTPD killed (signal 15) Jul 16 00:35:43 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 00:35:45 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 00:40:04 (194.181.245.190[194.181.245.190]): FTP session closed. Jul 16 00:42:17 ProFTPD killed (signal 15) Jul 16 00:42:17 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 00:42:19 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 00:42:52 FTP session opened. Jul 16 00:42:52 no such user 'lol' Jul 16 00:42:52 USER lol: no such user found from 194.181.245.190 [194.181.245.190] to 91.121.156.120:21 Jul 16 00:43:51 (194.181.245.190[194.181.245.190]): FTP session closed. Jul 16 00:43:51 killed (signal 15) Jul 16 00:43:51 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 01:54:19 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 01:55:41 ProFTPD killed (signal 15) Jul 16 01:55:41 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 01:55:46 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 01:56:07 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 01:57:57 ProFTPD killed (signal 15) Jul 16 01:57:57 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 01:57:59 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 01:58:03 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 01:59:12 ProFTPD killed (signal 15) Jul 16 01:59:12 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 01:59:14 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 01:59:20 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session opened. Jul 16 01:59:21 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:01:55 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session opened. Jul 16 02:01:57 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): no such user 'edek' Jul 16 02:01:57 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): USER edek: no such user found from aru7.neoplus.adsl.tpnet.pl [83.26.206.7] to 91.121.156.120:21 Jul 16 02:01:58 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): no such user 'edek' Jul 16 02:01:58 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): USER edek: no such user found from aru7.neoplus.adsl.tpnet.pl [83.26.206.7] to 91.121.156.120:21 Jul 16 02:02:12 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): no such user 'edek' Jul 16 02:02:12 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): USER edek: no such user found from aru7.neoplus.adsl.tpnet.pl [83.26.206.7] to 91.121.156.120:21 Jul 16 02:02:12 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): Maximum login attempts (3) exceeded Jul 16 02:02:12 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:03:23 ProFTPD killed (signal 15) Jul 16 02:03:23 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 02:03:25 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 02:03:29 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:04:56 ProFTPD killed (signal 15) Jul 16 02:04:56 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 02:04:58 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 02:05:03 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:07:10 ProFTPD killed (signal 15) Jul 16 02:07:10 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 02:07:12 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 02:07:17 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:07:20 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:09:10 ProFTPD killed (signal 15) Jul 16 02:09:10 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 02:09:12 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 02:09:16 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:10:09 ProFTPD killed (signal 15) Jul 16 02:10:09 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 02:10:11 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 02:10:15 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:11:16 ProFTPD killed (signal 15) Jul 16 02:11:16 ProFTPD 1.3.0 standalone mode SHUTDOWN Jul 16 02:11:18 ProFTPD 1.3.0 (stable) (built Tue Nov 4 14:38:05 UTC 2008) standalone mode STARTUP Jul 16 02:11:27 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:11:32 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:14:41 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 02:14:45 (aru7.neoplus.adsl.tpnet.pl[83.26.206.7]): FTP session closed. Jul 16 07:52:41 (ns24718.ovh.net[91.121.25.110]): FTP session closed. Jul 16 08:27:28 (80.54.177.65[80.54.177.65]): FTP session closed. oto log proftpd
-
Ok będę wdzięczny Teraz zrobiłem taką konfigurację # # /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file. # To really apply changes reload proftpd after modifications. # # Includes DSO modules Include /etc/proftpd/modules.conf # Set off to disable IPv6 support which is annoying on IPv4 only boxes. UseIPv6 off ServerName "Debian" ServerType standalone DeferWelcome off DefaultRoot ~ MultilineRFC2228 on DefaultServer on ShowSymlinks on TimeoutNoTransfer 600 TimeoutStalled 600 TimeoutIdle 1200 DisplayLogin welcome.msg DisplayFirstChdir .message ListOptions "-l" DenyFilter \*.*/ # Port 21 is the standard FTP port. Port 21 # In some cases you have to specify passive ports range to by-pass # firewall limitations. Ephemeral ports can be used for that, but # feel free to use a more narrow range. # PassivePorts 49152 65534 # 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 proftpd Group nogroup # Umask 022 is a good standard umask to prevent new files and dirs # (second parm) from being group and world writable. Umask 022 022 # Normally, we want files to be overwriteable. AllowOverwrite on # Uncomment this if you are using NIS or LDAP to retrieve passwords: # PersistentPasswd off # Be warned: use of this directive impacts CPU average load! # # Uncomment this if you like to see progress and transfer rate with ftpwho # in downloads. That is not needed for uploads rates. # UseSendFile off TransferLog /var/log/proftpd/xferlog SystemLog /var/log/proftpd/proftpd.log <IfModule mod_tls.c> TLSEngine off </IfModule> <IfModule mod_quota.c> QuotaEngine on </IfModule> <IfModule mod_ratio.c> Ratios on </IfModule> # Delay engine reduces impact of the so-called Timing Attack described in # http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02 # It is on by default. <IfModule mod_delay.c> DelayEngine on </IfModule> <IfModule mod_ctrls.c> ControlsEngine on ControlsMaxClients 2 ControlsLog /var/log/proftpd/controls.log ControlsInterval 5 ControlsSocket /var/run/proftpd/proftpd.sock </IfModule> <IfModule mod_ctrls_admin.c> AdminControlsEngine on </IfModule> # A basic anonymous configuration, no upload directories. # <Anonymous ~ftp> # User ftp # Group nogroup # # We want clients to be able to login with "anonymous" as well as "ftp" # UserAlias anonymous ftp # # Cosmetic changes, all files belongs to ftp user # DirFakeUser on ftp # DirFakeGroup on ftp # # RequireValidShell off # # # Limit the maximum number of anonymous logins # MaxClients 10 # # # We want 'welcome.msg' displayed at login, and '.message' displayed # # in each newly chdired directory. # DisplayLogin welcome.msg # DisplayFirstChdir .message # # # Limit WRITE everywhere in the anonymous chroot # <Directory *> # <Limit WRITE> # DenyAll # </Limit> # </Directory> # # # Uncomment this if you're brave. # # <Directory incoming> # # # Umask 022 is a good standard umask to prevent new files and dirs # # # (second parm) from being group and world writable. # # Umask 022 022 # # <Limit READ WRITE> # # DenyAll # # </Limit> # # <Limit STOR> # # AllowAll # # </Limit> # # </Directory> # # </Anonymous> SQLAuthTypes Plaintext Crypt SQLAuthenticate users* groups* SQLConnectInfo admin_pp@localhost admin_pp gddsddsfdsf 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 RootLogin off RequireValidShell off podmieniłem wszędzie pliki proftpd.conf i jak chce sie polaczyc z FTP to ok jest uruchomione ale wyskakuej takie cuś http://img195.imageshack.us/i/czasend.jpg/ co jeszcze jest źle ?
-
i teraz wkleic kod do polaczenia z baza czylli to SQLAuthTypes Plaintext Crypt SQLAuthenticate users* groups* SQLConnectInfo admin_pp@localhost admin_pp zdKra0UH 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 pomorze ??
-
a czy jest jakakolwiek konfiguracja która rozwiąże ten problem ??
-
# # /etc/proftpd/proftpd.conf -- This is a basic ProFTPD configuration file. # To really apply changes reload proftpd after modifications. # # Includes DSO modules Include /etc/proftpd/modules.conf # Set off to disable IPv6 support which is annoying on IPv4 only boxes. UseIPv6 off ServerName "Debian" ServerType standalone DeferWelcome off DefaultRoot ~ MultilineRFC2228 on DefaultServer on ShowSymlinks on TimeoutNoTransfer 600 TimeoutStalled 600 TimeoutIdle 1200 DisplayLogin welcome.msg DisplayFirstChdir .message ListOptions "-l" DenyFilter \*.*/ # Port 21 is the standard FTP port. Port 21 # In some cases you have to specify passive ports range to by-pass # firewall limitations. Ephemeral ports can be used for that, but # feel free to use a more narrow range. # PassivePorts 49152 65534 # 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 proftpd Group nogroup # Umask 022 is a good standard umask to prevent new files and dirs # (second parm) from being group and world writable. Umask 022 022 # Normally, we want files to be overwriteable. AllowOverwrite on # Uncomment this if you are using NIS or LDAP to retrieve passwords: # PersistentPasswd off # Be warned: use of this directive impacts CPU average load! # # Uncomment this if you like to see progress and transfer rate with ftpwho # in downloads. That is not needed for uploads rates. # UseSendFile off TransferLog /var/log/proftpd/xferlog SystemLog /var/log/proftpd/proftpd.log <IfModule mod_tls.c> TLSEngine off </IfModule> <IfModule mod_quota.c> QuotaEngine on </IfModule> <IfModule mod_ratio.c> Ratios on </IfModule> # Delay engine reduces impact of the so-called Timing Attack described in # http://security.lss.hr/index.php?page=details&ID=LSS-2004-10-02 # It is on by default. <IfModule mod_delay.c> DelayEngine on </IfModule> <IfModule mod_ctrls.c> ControlsEngine on ControlsMaxClients 2 ControlsLog /var/log/proftpd/controls.log ControlsInterval 5 ControlsSocket /var/run/proftpd/proftpd.sock </IfModule> <IfModule mod_ctrls_admin.c> AdminControlsEngine on </IfModule> # A basic anonymous configuration, no upload directories. # <Anonymous ~ftp> # User ftp # Group nogroup # # We want clients to be able to login with "anonymous" as well as "ftp" # UserAlias anonymous ftp # # Cosmetic changes, all files belongs to ftp user # DirFakeUser on ftp # DirFakeGroup on ftp # # RequireValidShell off # # # Limit the maximum number of anonymous logins # MaxClients 10 # # # We want 'welcome.msg' displayed at login, and '.message' displayed # # in each newly chdired directory. # DisplayLogin welcome.msg # DisplayFirstChdir .message # # # Limit WRITE everywhere in the anonymous chroot # <Directory *> # <Limit WRITE> # DenyAll # </Limit> # </Directory> # # # Uncomment this if you're brave. # # <Directory incoming> # # # Umask 022 is a good standard umask to prevent new files and dirs # # # (second parm) from being group and world writable. # # Umask 022 022 # # <Limit READ WRITE> # # DenyAll # # </Limit> # # <Limit STOR> # # AllowAll # # </Limit> # # </Directory> # # </Anonymous> SQLAuthTypes Plaintext Crypt SQLAuthenticate users* groups* SQLConnectInfo [b]( tu były hasła do bazy danych, ludzie, strzeżcie swojego świętego spokoju!;) - beliq )[/b] 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 RootLogin off RequireValidShell off niewiem czemu przed wgraniem DA ta konfiguracja jest dobra wszystko dziala jak powinnno po wgraniu da i ustawienia pliku identycznie nic nie dziala ftp wogole moze ktos pomoc
-
jest to skrypt obsługujący serwery shoutcast autopiloty i potrzebne mi jest FTP na mp3 próbowalem skonfigurowac tak 1. Instalacja pakietów Bierzemy się do roboty i ściągamy potrzebne pakiety. Użuwamy do tego wydajemy polecenie: apt-get install proftpd-mysql proftpd-common mysql-client mysql-common mysql-server libmysqlclient10 2. Konfiguracja ProFTPd-mysql W pliku konfiguracyjny proftpd-mysql, to znaczy w katalogu /etc znajduje plik proftpd.conf w którym musimy dopisać następujące linijki: SQLConnectInfo proftpd@localhost:3306 proftpd naszehaslo SQLUserInfo users name pass uid gid home shell SQLGroupInfo groups name gid members SQLAuthenticate users* groups* SQLAuthTypes PlainText A teraz opisze co każda z tych zmiennych oznacza. SQLConnectInfo - ta zmienna określa połącznie z bazą danych, czyli nazwę bazy danych, adres serwera bazy danych oraz port. Następnie po spacji podajemy użytkownika i hasło, które podajemy w formie zwykłego tekstu (plaintext). SQLUserInfo - Dyrektywa ta zawiera informacje o wyszukiwaniu informacji o użytkowniku w bazie danych. Podajemy tu najpierw nazwę bazy, a następnie nazwy kolumn o użytkowniku. SQLGroupInfo - Podobnie jak zmienna SQLUserInfo, tylko że zawiera informacje o grupach. SQLAuthenticate - Tu podajemy metodę autoryzacji. W przykładzie mamy opcje: users* groups*. Takie parametry pozwalają na zalogowanie się jedynie użytkowników zapisanych w bazie, wraz z weryfikacją ich przynależności do grup. W przeciwnym przypadku (brak groups*), gid = 65533 ew. inny jeśli zdefiniujemy SQLDefaultGID. Obowiązuje również powiązanie numerów z bazy z numerami systemowymi. SQLAuthTypes - Zmienna ta określa jak kodowane są hasła. Dla PlainText pozwala na umieszczenie haseł w tabeli w postaci zwykłego tekstu. Dostępne są również inne opcje, które oczywiście decydują o bezpieczeństwie dotępu do serwera. W przypadku braku tej dyrektywy, jak i poprzedniej, MySQL nie będzie używany do autoryzacji użytkowników. Można także zamiast PlainText użyć: OpenSSL, Crypt oraz Backend. No to mamy skonfigurowany ProFTPd do działania z bazą MySQL, teraz wystarczy utworzyć tylko bazę i tabele, lecz najpierws omówię jeszcze parę przydatnych dyrektyw. DefaultRoot - ta dyrektywa określa nam do jakiego katalogu ma się logować użytkownik. Można ją np. ustawić na ~/public_html/. Teraz użytkownik będzie miał dostęp tylko do katalogu public_html w swoim katalogu domowym. MaxClients - tu ustawiamy ile użytkowników może byc jednocześnie zalogowanych na serwerze. MaxClientsPerHost - podobneie jak wyżej, tylko że to jest ograniczenie z jednego adresu IP. 3. Konfiguracja MySQL Teraz zajmiemy się konfiguracją serwera MySQL, lecz to wiąże się tylko z utworzeniem bazy danych. USE mysql; INSERT INTO user (Host, User, Password) VALUES ('localhost','proftpd',password('naszehaslo')); CREATE DATABASE proftpd; USE proftpd; CREATE TABLE users ( name varchar(30) NOT NULL default '', pass varchar(30) NOT NULL default '', uid int(11) NOT NULL auto_increment, gid int(11) NOT NULL, home varchar(255) NOT NULL, shell varchar(255) NOT NULL, PRIMARY KEY (uid), UNIQUE KEY name (name) ) TYPE=MyISAM AUTO_INCREMENT=50; USE proftpd; CREATE TABLE groups ( name varchar(30) NOT NULL default '', gid int(11) NOT NULL, members text NOT NULL, PRIMARY KEY (gid), UNIQUE KEY name (name) ) TYPE=MyISAM AUTO_INCREMENT=50; I to już wyszystko :) 4. Dodanie nowego konta ftp No to kończymy, czyli dodamy użytkownika ftp. USE proftpd; INSERT INTO users (name,pass,gid,home,shell) VALUES ('konto1','haslo','2000','/home/ftp/konto1','/bin/sh'); INSERT INTO groups (name,gid,members) VALUES ('grupa1','2000','konto1'); To teraz siadamy sobie wygodnie i kopiujemy pliki na serwer. Życzę Wam szybkiego stawiania takiego serwera. tylko nie wiem jak to skonfigurowac w pliku proftpd.conf
-
tak tak malu wiem ze to sie konfiguruje w pliku proftpd ale niewiem jak ps wszystko jest oki tworzy userów w bazie katalog z nazwa usera a ftp niee
-
Moze inaczej posiadam Panel który ogółnie dziala super dodaje userów do bazy lecz nie tworzy konta ftp z danymi ktore wczesniej podalem w formularzu rejestracyjnym Panelu . Chciałbym zaznaczyć że na serwerze wgrany jest DA i teraz Pytanie czy da sie jakos ustawic aby Panel tworzyl konta FTP z wgranym DA ??
-
hm czy ktos moglby mi pomoc prywatnie bo niestety nie daje rady tego ustawic
-
a jak się zmienia port serwera ftp ??
-
o to logi
-
a czy da jest jakiś sposób aby to uruchomić??
