Forum Debian Users Gang

chyl-o · 2007-01-10 21:38:48

Nie mogę sobie poradzić z pewnym problemem. Robiłem proftpd do obsługi quoty, ale nie mogę się teraz zalogować na ftp.

Korzystałem z http://www.howtoforge.com/proftpd_mysql_virtual_hosting

przy próbie połączenia dostaje:

Kod:

ftp
ftp> open
(to) localhost
Connected to localhost.localdomain.
421 Service not available, remote server has closed connection
ftp> open
(to) 192.168.1.4
Connected to 192.168.1.4.
421 Service not available, remote server has closed connection

dodam jeszcze moj proftpd.conf:

Kod:

Include /etc/proftpd/modules.conf
UseIPv6                         off
ServerName                      "Proftpd serwer"
ServerType                      Standalone
ServerAdmin                     chliw-o@bullshit.com

 ServerIdent                     on "Logujesz sie czy nie..."
 DeferWelcome                  on
 DefaultServer                   on
 AllowStoreRestart               on
 Port                            21
 Umask                           022
 MaxInstances                    30
 User                            ftpuser
 Group                           ftpgroup
 DefaultRoot ~
   AllowOverwrite                on
        SQLAuthTypes            PlainText Crypt
   SQLAuthenticate         users* groups*
   SQLConnectInfo  ftp@192.168.1.4 proftpd haslo_maslo
   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

Co muszę zrobić/zmienić, żeby ten serwer wreszcie mi ruszył?

chyl-o · 2007-01-11 13:57:27

Dodam, że proftpd mam z paczki, do tego proftpd-mysql. Ma ktoś jakiś pomysł?

cim · 2007-01-12 16:35:51

A w logach nic nie ma?

chyl-o · 2007-01-17 15:56:50

No właśnie nic nie ma. Zdaje się, tak jakby miał problem z połączeniem z bazą danych a jest stworzona, do systemu dodani są użytkownicy itp.

Ma ktoś jakiś pomysł?

pasqdnik · 2007-01-17 16:03:42

Wg mnie to coś z firewallem, albo sprawdz pliki /etc/hosts.{allow,deny}.

Ewentualnie spróbuj [url=http://www.unixguide.net/linux/faq/09.25.shtml]tego.[/url][/url]

Time (s)	Query
0.00018	SET CHARSET latin2
0.00005	SET NAMES latin2
0.00199	SELECT u., g., o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='18.224.52.54' WHERE u.id=1
0.00081	REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '18.224.52.54', 1733365143)
0.00055	SELECT * FROM punbb_online WHERE logged<1733364843
0.00074	SELECT topic_id FROM punbb_posts WHERE id=49510
0.00055	SELECT id FROM punbb_posts WHERE topic_id=6427 ORDER BY posted
0.00063	SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=6427 AND t.moved_to IS NULL
0.00005	SELECT search_for, replace_with FROM punbb_censoring
0.00079	SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=6427 ORDER BY p.id LIMIT 0,25
0.00102	UPDATE punbb_topics SET num_views=num_views+1 WHERE id=6427
Total query time: 0.00736 s

Forum Debian Users Gang

Ogłoszenie

#1 2007-01-10 21:38:48

chyl-o - Członek DUG

proftpd i quota

Kod:

Kod:

#2 2007-01-11 13:57:27

chyl-o - Członek DUG

Re: proftpd i quota

#3 2007-01-12 16:35:51

cim - Użytkownik

Re: proftpd i quota

#4 2007-01-17 15:56:50

chyl-o - Członek DUG

Re: proftpd i quota

#5 2007-01-17 16:03:42

pasqdnik - Pijak ;-P

Re: proftpd i quota

Stopka forum

Informacje debugowania