Re: [GENERAL] another can't connect

2009-06-30 Thread BJ Freeman
Thanks for you help found that this not connect problem is server wide. not just Isolated to postgresql. so tracking down what i did to mess it up :D BJ Freeman sent the following on 6/28/2009 8:23 PM: sorry about the post did not do a reply all and sent a personal replay yes in the chain I

Re: [GENERAL] another can't connect--solved

2009-06-30 Thread BJ Freeman
added this to iptables ACCEPT all -- localhostlocalhost BJ Freeman sent the following on 6/28/2009 8:23 PM: sorry about the post did not do a reply all and sent a personal replay yes in the chain I have ACCEPT all -- anywhere anywherestate

Re: [GENERAL] another can't connect

2009-06-29 Thread Tom Lane
BJ Freeman bjf...@free-man.net writes: sorry about the post did not do a reply all and sent a personal replay yes in the chain I have ACCEPT all -- anywhere anywherestate RELATED,ESTABLISHED it is the next to last rule. You sure that works? This notation for

[GENERAL] another can't connect

2009-06-28 Thread BJ Freeman
PostgreSQL version 8.1.11 (With schemas) I have read the recent emails and believe I have covered all the bases from net stat tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 5091/postmaster I do a psql -h 127.0.0.1 -U ofbiz -d ofbiz from a terminal on the server. and

Re: [GENERAL] another can't connect

2009-06-28 Thread Chris
BJ Freeman wrote: PostgreSQL version 8.1.11 (With schemas) I have read the recent emails and believe I have covered all the bases from net stat tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 5091/postmaster I do a psql -h 127.0.0.1 -U ofbiz -d ofbiz from a terminal

Re: [GENERAL] another can't connect

2009-06-28 Thread BJ Freeman
tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN is the only line for that port Chris sent the following on 6/28/2009 7:33 PM: BJ Freeman wrote: PostgreSQL version 8.1.11 (With schemas) I have read the recent emails and believe I have covered all the bases from net stat

Re: [GENERAL] another can't connect

2009-06-28 Thread Chris
Please don't top-post, it's so hard to follow discussions. Chris sent the following on 6/28/2009 7:33 PM: BJ Freeman wrote: PostgreSQL version 8.1.11 (With schemas) I have read the recent emails and believe I have covered all the bases from net stat tcp0 0 127.0.0.1:5432

Re: [GENERAL] another can't connect

2009-06-28 Thread Andrej
2009/6/29 BJ Freeman bjf...@free-man.net: ACCEPT tcp -- localhostlocalhost tcp dpt:postgres state NEW What about established connections? tcp0 0 127.0.0.1:5432 0.0.0.0:* LISTEN is the only line for that port I think Chris meant What

Re: [GENERAL] another can't connect

2009-06-28 Thread BJ Freeman
sorry about the post did not do a reply all and sent a personal replay yes in the chain I have ACCEPT all -- anywhere anywherestate RELATED,ESTABLISHED it is the next to last rule. Andrej sent the following on 6/28/2009 8:14 PM: 2009/6/29 BJ Freeman