Hello,

I emailed to the group last week about being able to access one of my
postgres databases from other machines on my network. I thought the
problem was a installation of 8.2.10 that I had been testing an
upgrade on had clobbered some of the files that the system needed. I
had been testing implementing enabling of ssl, so I thought that I had
gotten a partial installation that was causing my password
authentication failure. I did a package add on another machine of the
same package that was used to load our original 8.2.3 with everything
the same. I still can't connect. I think the pg_hba.conf file is
fine. Where else should I be looking?

Carol Walter


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

On Tuesday 21 July 2009 10:35:46 Carol Walter wrote:
> Hello,
>
> I emailed to the group last week about being able to access one of my
> postgres databases from other machines on my network. I thought the
> problem was a installation of 8.2.10 that I had been testing an
> upgrade on had clobbered some of the files that the system needed. I
> had been testing implementing enabling of ssl, so I thought that I had
> gotten a partial installation that was causing my password
> authentication failure. I did a package add on another machine of the
> same package that was used to load our original 8.2.3 with everything
> the same. I still can't connect. I think the pg_hba.conf file is
> fine. Where else should I be looking?
>
> Carol Walter
it sounds like either a network issue, or a pg_hba.conf issue.

If you send me the following, I'll have a look:

- pg_hba.conf file from the target machine (the one you're trying to connect
to)

- the i.p.'s/hostnames of both boxes

- the command you're using to try and connect



--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

This is a cryptographically signed message in MIME format.

--------------ms060307080809060905020204
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit


> #----------------------------------------------------------- ----------------
>
> # CONNECTIONS AND AUTHENTICATION
> #----------------------------------------------------------- ----------------
>
>
> # - Connection Settings -
>
> #listen_addresses = 'localhost' # what IP address(es) to listen
> on;
> # comma-separated list of addresses;
> # defaults to 'localhost', '*' = all
>
>
> listen_addresses = '*'
>
> #port = 5432
That seems ok. I don't know what OS you use, but check if postgres is
listening to port 5432. Also check your firewall settings.

--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050


--------------ms060307080809060905020204
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIGJjCC
Aw8wggJ4oAMCAQICCQCB1aFglJHbtzANBgkqhkiG9w0BAQQFADBNMQswCQYD VQQGEwJMVDEL
MAkGA1UECBMCTFQxDjAMBgNVBAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDER MA8GA1UEAxMI
blNvZnQgQ0EwHhcNMDkwNjI1MTgyNDUzWhcNMTAwNjI1MTgyNDUzWjBpMQsw CQYDVQQGEwJM
VDEQMA4GA1UEBxMHVmlsbml1czEOMAwGA1UEChMFblNvZnQxGDAWBgNVBAMT D0p1bGl1cyBU
dXNrZW5pczEeMBwGCSqGSIb3DQEJARYPanVsaXVzQG5zb2Z0Lmx0MIGfMA0G CSqGSIb3DQEB
AQUAA4GNADCBiQKBgQC73A+rjzOkfYrVAGaI/pYg0F8RzO7Dti2hhk+bctS4 Ibaz3uPCQi+7
siuWP6zx8wKF6ck3vNVBOMveZzvmjMFeAXnbbBaf0o2QFZ0L083vJawq7lic fLTI5QTTPqvP
jgC8KBWyvWpq6qy1Q7jp3or7A2FKE3fBo68eKr9l/yfE3wIDAQABo4HaMIHX MAkGA1UdEwQC
MAAwLAYJYIZIAYb4QgENBB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmlj YXRlMB0GA1Ud
DgQWBBRtQ3sJDUF6zNynzZXcGFkSbQVCzTB9BgNVHSMEdjB0gBS/CyhXUMKf LMp4f10XvzPh
YV5vRKFRpE8wTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBggkAgdWhYJSR27Iw DQYJKoZIhvcN
AQEEBQADgYEAeSEQ2HdWubGGZWZf+AUFFdsoiFTe4QL6V3z8X1tk7/nOZHOf HdViQRjoGoeg
MVEr5WEv072Pd6Q9IhE2euAB4gVHy3BM3MKGFgB94irjEpm4uHSpRWHF+yp9 up+51F75M8aG
4tZWtbqd7zU0NXwR1ibRWnprWrpmRwgSiN+xVqYwggMPMIICeKADAgECAgkA gdWhYJSR27cw
DQYJKoZIhvcNAQEEBQAwTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4w DAYDVQQKEwVu
U29mdDEOMAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBMB4XDTA5 MDYyNTE4MjQ1
M1oXDTEwMDYyNTE4MjQ1M1owaTELMAkGA1UEBhMCTFQxEDAOBgNVBAcTB1Zp bG5pdXMxDjAM
BgNVBAoTBW5Tb2Z0MRgwFgYDVQQDEw9KdWxpdXMgVHVza2VuaXMxHjAcBgkq hkiG9w0BCQEW
D2p1bGl1c0Buc29mdC5sdDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA u9wPq48zpH2K
1QBmiP6WINBfEczuw7YtoYZPm3LUuCG2s97jwkIvu7Irlj+s8fMChenJN7zV QTjL3mc75ozB
XgF522wWn9KNkBWdC9PN7yWsKu5YnHy0yOUE0z6rz44AvCgVsr1qauqstUO4 6d6K+wNhShN3
waOvHiq/Zf8nxN8CAwEAAaOB2jCB1zAJBgNVHRMEAjAAMCwGCWCGSAGG+EIB DQQfFh1PcGVu
U1NMIEdlbmVyYXRlZCBDZXJ0aWZpY2F0ZTAdBgNVHQ4EFgQUbUN7CQ1Beszc p82V3BhZEm0F
Qs0wfQYDVR0jBHYwdIAUvwsoV1DCnyzKeH9dF78z4WFeb0ShUaRPME0xCzAJ BgNVBAYTAkxU
MQswCQYDVQQIEwJMVDEOMAwGA1UEChMFblNvZnQxDjAMBgNVBAsTBW5Tb2Z0 MREwDwYDVQQD
EwhuU29mdCBDQYIJAIHVoWCUkduyMA0GCSqGSIb3DQEBBAUAA4GBAHkhENh3 VrmxhmVmX/gF
BRXbKIhU3uEC+ld8/F9bZO/5zmRznx3VYkEY6BqHoDFRK+VhL9O9j3ekPSIR NnrgAeIFR8tw
TNzChhYAfeIq4xKZuLh0qUVhxfsqfbqfudRe+TPGhuLWVrW6ne81NDV8EdYm 0Vp6a1q6ZkcI
EojfsVamMYICjTCCAokCAQEwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMC TFQxDjAMBgNV
BAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0EC CQCB1aFglJHb
tzAJBgUrDgMCGgUAoIIBiTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJ
BTEPFw0wOTA3MjQwNzA3MTNaMCMGCSqGSIb3DQEJBDEWBBR2c8IuRqJfZQ0N 70KOkMCQAp2I
kTBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIA gDANBggqhkiG
9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDBpBgkrBgEEAYI3EAQx XDBaME0xCzAJ
BgNVBAYTAkxUMQswCQYDVQQIEwJMVDEOMAwGA1UEChMFblNvZnQxDjAMBgNV BAsTBW5Tb2Z0
MREwDwYDVQQDEwhuU29mdCBDQQIJAIHVoWCUkdu3MGsGCyqGSIb3DQEJEAIL MVygWjBNMQsw
CQYDVQQGEwJMVDELMAkGA1UECBMCTFQxDjAMBgNVBAoTBW5Tb2Z0MQ4wDAYD VQQLEwVuU29m
dDERMA8GA1UEAxMIblNvZnQgQ0ECCQCB1aFglJHbtzANBgkqhkiG9w0BAQEF AASBgLNIvPNA
/ECATPOSPQNtX7hKIYsWKa2HWIhQSuP2kVVvM3V5ULncRYiIxBXVfZ0afNg/ 6RHnkGjRuKBs
c5xZ7HINXv6heLGD5oZjMZm29fKN8sY18vqxwuiQ3u+ecT/iVCkN2BFUFNoz yyoou61I9OxO
WyXEkWZ3BDlmK5XloVY0AAAAAAAA
--------------ms060307080809060905020204--

I'm running Solaris 10.

Carol

On Jul 24, 2009, at 3:07 AM, Julius Tuskenis wrote:

>
>> #----------------------------------------------------------- ----------------
>> # CONNECTIONS AND AUTHENTICATION
>> #----------------------------------------------------------- ----------------
>>
>> # - Connection Settings -
>>
>> #listen_addresses = 'localhost' # what IP address(es) to
>> listen on;
>> # comma-separated list of addresses;
>> # defaults to 'localhost', '*' = all
>>
>>
>> listen_addresses = '*'
>>
>> #port = 5432
> That seems ok. I don't know what OS you use, but check if postgres
> is listening to port 5432. Also check your firewall settings.
>
> --
> Julius Tuskenis
> Programavimo skyriaus vadovas
> UAB nSoft
> mob. +37068233050
>


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

This is a cryptographically signed message in MIME format.

--------------ms010806050003010106010609
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hello, Carol

try command "netstat -l --numeric-ports" to see all ports your system
listens to. You should see something like this:
tcp 0 0 *:5432 *:* LISTE=
N
If you see the line - your postgres is configured to listen. It is
likely to be true as you can connect to postgres localy.
Then from other computer try telneting the port. If you will succeed -
then I'd say theres something wrong with your pg_hba.conf.
Also see postgres log files. Maybe they will tell you what is wrong.


Carol Walter ra=C5=A1=C4=97:
> I'm running Solaris 10.
>
> Carol
>
> On Jul 24, 2009, at 3:07 AM, Julius Tuskenis wrote:
>
>>
>>> #----------------------------------------------------------- ---------=
-------
>>>
>>> # CONNECTIONS AND AUTHENTICATION
>>> #----------------------------------------------------------- ---------=
-------
>>>
>>>
>>> # - Connection Settings -
>>>
>>> #listen_addresses =3D 'localhost' # what IP address(es) to
>>> listen on;
>>> # comma-separated list of addresses;
>>> # defaults to 'localhost', '*' =3D all
>>>
>>>
>>> listen_addresses =3D '*'
>>>
>>> #port =3D 5432
>> That seems ok. I don't know what OS you use, but check if postgres is =

>> listening to port 5432. Also check your firewall settings.
>>
>> --
>> Julius Tuskenis
>> Programavimo skyriaus vadovas
>> UAB nSoft
>> mob. +37068233050
>>
>
>


--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050



--------------ms010806050003010106010609
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEH AQAAoIIGJjCC
Aw8wggJ4oAMCAQICCQCB1aFglJHbtzANBgkqhkiG9w0BAQQFADBNMQswCQYD VQQGEwJMVDEL
MAkGA1UECBMCTFQxDjAMBgNVBAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDER MA8GA1UEAxMI
blNvZnQgQ0EwHhcNMDkwNjI1MTgyNDUzWhcNMTAwNjI1MTgyNDUzWjBpMQsw CQYDVQQGEwJM
VDEQMA4GA1UEBxMHVmlsbml1czEOMAwGA1UEChMFblNvZnQxGDAWBgNVBAMT D0p1bGl1cyBU
dXNrZW5pczEeMBwGCSqGSIb3DQEJARYPanVsaXVzQG5zb2Z0Lmx0MIGfMA0G CSqGSIb3DQEB
AQUAA4GNADCBiQKBgQC73A+rjzOkfYrVAGaI/pYg0F8RzO7Dti2hhk+bctS4 Ibaz3uPCQi+7
siuWP6zx8wKF6ck3vNVBOMveZzvmjMFeAXnbbBaf0o2QFZ0L083vJawq7lic fLTI5QTTPqvP
jgC8KBWyvWpq6qy1Q7jp3or7A2FKE3fBo68eKr9l/yfE3wIDAQABo4HaMIHX MAkGA1UdEwQC
MAAwLAYJYIZIAYb4QgENBB8WHU9wZW5TU0wgR2VuZXJhdGVkIENlcnRpZmlj YXRlMB0GA1Ud
DgQWBBRtQ3sJDUF6zNynzZXcGFkSbQVCzTB9BgNVHSMEdjB0gBS/CyhXUMKf LMp4f10XvzPh
YV5vRKFRpE8wTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4wDAYDVQQK EwVuU29mdDEO
MAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBggkAgdWhYJSR27Iw DQYJKoZIhvcN
AQEEBQADgYEAeSEQ2HdWubGGZWZf+AUFFdsoiFTe4QL6V3z8X1tk7/nOZHOf HdViQRjoGoeg
MVEr5WEv072Pd6Q9IhE2euAB4gVHy3BM3MKGFgB94irjEpm4uHSpRWHF+yp9 up+51F75M8aG
4tZWtbqd7zU0NXwR1ibRWnprWrpmRwgSiN+xVqYwggMPMIICeKADAgECAgkA gdWhYJSR27cw
DQYJKoZIhvcNAQEEBQAwTTELMAkGA1UEBhMCTFQxCzAJBgNVBAgTAkxUMQ4w DAYDVQQKEwVu
U29mdDEOMAwGA1UECxMFblNvZnQxETAPBgNVBAMTCG5Tb2Z0IENBMB4XDTA5 MDYyNTE4MjQ1
M1oXDTEwMDYyNTE4MjQ1M1owaTELMAkGA1UEBhMCTFQxEDAOBgNVBAcTB1Zp bG5pdXMxDjAM
BgNVBAoTBW5Tb2Z0MRgwFgYDVQQDEw9KdWxpdXMgVHVza2VuaXMxHjAcBgkq hkiG9w0BCQEW
D2p1bGl1c0Buc29mdC5sdDCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA u9wPq48zpH2K
1QBmiP6WINBfEczuw7YtoYZPm3LUuCG2s97jwkIvu7Irlj+s8fMChenJN7zV QTjL3mc75ozB
XgF522wWn9KNkBWdC9PN7yWsKu5YnHy0yOUE0z6rz44AvCgVsr1qauqstUO4 6d6K+wNhShN3
waOvHiq/Zf8nxN8CAwEAAaOB2jCB1zAJBgNVHRMEAjAAMCwGCWCGSAGG+EIB DQQfFh1PcGVu
U1NMIEdlbmVyYXRlZCBDZXJ0aWZpY2F0ZTAdBgNVHQ4EFgQUbUN7CQ1Beszc p82V3BhZEm0F
Qs0wfQYDVR0jBHYwdIAUvwsoV1DCnyzKeH9dF78z4WFeb0ShUaRPME0xCzAJ BgNVBAYTAkxU
MQswCQYDVQQIEwJMVDEOMAwGA1UEChMFblNvZnQxDjAMBgNVBAsTBW5Tb2Z0 MREwDwYDVQQD
EwhuU29mdCBDQYIJAIHVoWCUkduyMA0GCSqGSIb3DQEBBAUAA4GBAHkhENh3 VrmxhmVmX/gF
BRXbKIhU3uEC+ld8/F9bZO/5zmRznx3VYkEY6BqHoDFRK+VhL9O9j3ekPSIR NnrgAeIFR8tw
TNzChhYAfeIq4xKZuLh0qUVhxfsqfbqfudRe+TPGhuLWVrW6ne81NDV8EdYm 0Vp6a1q6ZkcI
EojfsVamMYICjTCCAokCAQEwWjBNMQswCQYDVQQGEwJMVDELMAkGA1UECBMC TFQxDjAMBgNV
BAoTBW5Tb2Z0MQ4wDAYDVQQLEwVuU29mdDERMA8GA1UEAxMIblNvZnQgQ0EC CQCB1aFglJHb
tzAJBgUrDgMCGgUAoIIBiTAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwG CSqGSIb3DQEJ
BTEPFw0wOTA3MjUwNzAzMzlaMCMGCSqGSIb3DQEJBDEWBBTSrBOOA1bKoshn 7Ci0ki8t8XRB
4TBSBgkqhkiG9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIA gDANBggqhkiG
9w0DAgIBQDAHBgUrDgMCBzANBggqhkiG9w0DAgIBKDBpBgkrBgEEAYI3EAQx XDBaME0xCzAJ
BgNVBAYTAkxUMQswCQYDVQQIEwJMVDEOMAwGA1UEChMFblNvZnQxDjAMBgNV BAsTBW5Tb2Z0
MREwDwYDVQQDEwhuU29mdCBDQQIJAIHVoWCUkdu3MGsGCyqGSIb3DQEJEAIL MVygWjBNMQsw
CQYDVQQGEwJMVDELMAkGA1UECBMCTFQxDjAMBgNVBAoTBW5Tb2Z0MQ4wDAYD VQQLEwVuU29m
dDERMA8GA1UEAxMIblNvZnQgQ0ECCQCB1aFglJHbtzANBgkqhkiG9w0BAQEF AASBgCq/lA54
I6gFZa2b/OFAT/BJRx1LEp5ltajGyGMjZLjSFNupea74wz6FXNEpEyTozeVS cCSgsnwOa/qW
1/etE8U0Y1QMQVQwl7zXwQeuPv5lOGcMuNCe4Zb4Mn/nRNORhV5rn2LQPGPZ ZRcsj8ZVwgvW
RGzc4IbLZGSswrlsi1MlAAAAAAAA
--------------ms010806050003010106010609--

Problem solved. I don't know why!

Nothing in the pg_hba.conf file or the postgresql.conf file appeared
to be a problem. I was still getting password authorization
failures. I thought the password had changed, perhaps, without my
knowing it. I changed the password to what it was originally was -
and it worked! Then I tried to get into my test database with my test
user. It didn't work. Then I reset the password to what it already
was and it worked. Then I tried this with several other accounts. It
behaved the same way each time.

Does anyone know what might have caused this behavior?

Carol
On Jul 24, 2009, at 1:39 PM, Carol Walter wrote:

> I'm running Solaris 10.
>
> Carol
>
> On Jul 24, 2009, at 3:07 AM, Julius Tuskenis wrote:
>
>>
>>> #----------------------------------------------------------- ----------------
>>> # CONNECTIONS AND AUTHENTICATION
>>> #----------------------------------------------------------- ----------------
>>>
>>> # - Connection Settings -
>>>
>>> #listen_addresses = 'localhost' # what IP address(es) to
>>> listen on;
>>> # comma-separated list of addresses;
>>> # defaults to 'localhost', '*' = all
>>>
>>>
>>> listen_addresses = '*'
>>>
>>> #port = 5432
>> That seems ok. I don't know what OS you use, but check if postgres
>> is listening to port 5432. Also check your firewall settings.
>>
>> --
>> Julius Tuskenis
>> Programavimo skyriaus vadovas
>> UAB nSoft
>> mob. +37068233050
>>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin