[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 メーリングリストの案内