[pgsql-jp: 36696] Re: ローカルネットワーク越しのPostgreSQLにACCESSからODBC接続できません。
Yamada Kazuo
yamada @ sampoji.or.jp
2006年 1月 27日 (金) 15:02:25 JST
やまだ@三宝寺です。
On Fri, 27 Jan 2006 14:47:14 +0900
hideki56520 <hideki56520 @ yahoo.co.jp> wrote:
> やまだ@三宝寺さま。
>
> iptables -L
> の結果を以下に表示させます。
>
> ---ここから---
>
> Chain FORWARD (policy ACCEPT)
> target prot opt source destination
> RH-Firewall-1-INPUT all -- anywhere anywhere
>
> Chain INPUT (policy ACCEPT)
> target prot opt source destination
> RH-Firewall-1-INPUT all -- anywhere anywhere
>
> Chain OUTPUT (policy ACCEPT)
> target prot opt source destination
>
> Chain RH-Firewall-1-INPUT (2 references)
> target prot opt source destination
> ACCEPT all -- anywhere anywhere
> ACCEPT icmp -- anywhere anywhere icmp any
> ACCEPT ipv6-crypt-- anywhere anywhere
> ACCEPT ipv6-auth-- anywhere anywhere
> ACCEPT udp -- anywhere 224.0.0.251 udp dpt:5353
> ACCEPT udp -- anywhere anywhere udp dpt:ipp
> ACCEPT all -- anywhere anywhere state RELATED,ESTABLISHED
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:https
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:ftp
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:http
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:ssh
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:smtp
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:pop3
> ACCEPT udp -- anywhere anywhere state NEW udp dpt:pop3
> ACCEPT udp -- anywhere anywhere state NEW udp dpt:imap
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:imaps
> ACCEPT udp -- anywhere anywhere state NEW udp dpt:imaps
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:pop3s
> ACCEPT udp -- anywhere anywhere state NEW udp dpt:pop3s
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:5901
> ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-ns
> ACCEPT udp -- anywhere anywhere state NEW udp dpt:netbios-dgm
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:netbios-ssn
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:microsoft-ds
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:swat
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:5800
> ACCEPT tcp -- anywhere anywhere state NEW tcp dpt:5801
> REJECT all -- anywhere anywhere reject-with icmp-host-prohibited
>
> ---ここまで---
>
これではpostgresqlで使う5432番のポートは通りませんから、駄目ですね。
取り敢えず、
/etc/init.d/iptables stop
としてiptablesの設定を無効にした上で、試されては如何でしょうか。
# iptablesの設定は、postgresのtcpでの通信の確認が出来てからされた方が良いよ
# うに思いますが
--
0----+----1----+----2----+----3----+----4----+----5----+----6----+----7----#
山田 和雄 MailTo:yamada @ sampoji.or.jp
Yamada Kazuo HomePage:http://shadow.sampoji.jp/
pgsql-jp メーリングリストの案内