Go back to group page
Go to next unread message | Full plain text message | Fixed font - Proportional font

Subject: Vista - PostgreSQL - PROBLEM / SOLUTION
Author: Roberto Artigas Jr
Date: 2 Jun 2008

This is a multi-part message in MIME format.
-----------------0968272571
Content-Type: text/plain; charset=us-ascii

Heavenes -

I am on Vista Ultimate and today I got a problem that began to occur on my program connecting to a PostgreSQL backend.

The wonderfull thing about this is that the PgAdmin3 was connecting with the backend and showing me records.

A search on the internet showed a couple of places with the problem and one of them mentioned something about a firewall.

I do not use the Windows Firewall, I use Zone Alarm. After a bit of fidling I found the answer.

I have no idea about the "why" the error started occuring. My wild ass guess is some Vista (or other) update somewhere changed some condition that triggered this to begin happening.


PROBLEM:

Error: Could not connect to the server:
An attempt was made to access a socked in a way forbidden by its access permissions.
[127.0.0.1:5432] (08001).
Press OK to end this application.

PosgreSQL Errors page says:
08001 = SQLCLIENT UNABLE TO ESTABLISH SQLCONNECTION

SOLUTION:

The solution was to go into the "Firewall | Zones" tab of Zone Alarm and add a Local Host entry with an IP of 127.0.0.1


Hopes this helps someone out in the future.


Enjoy!
Roberto Artigas Jr
Why waste time learning when ignorance is instantaneous?


-----------------0968272571
Content-Type: text/html;
name="html1.htm"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="html1.htm"

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBU
cmFuc2l0aW9uYWwvL0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgaHR0cC1l
cXVpdj1Db250ZW50LVR5cGUgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0
PWlzby04ODU5LTEiPg0KPE1FVEEgY29udGVudD0iTVNIVE1MIDYuMDAuNjAw
MS4xODAyMyIgbmFtZT1HRU5FUkFUT1I+DQo8U1RZTEU+PC9TVFlMRT4NCjwv
SEVBRD4NCjxCT0RZPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj5I
ZWF2ZW5lcyAtPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFs
IHNpemU9Mj48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9
QXJpYWwgc2l6ZT0yPkkgYW0gb24gVmlzdGEgVWx0aW1hdGUgYW5kIHRvZGF5
IEkgZ290IGEgcHJvYmxlbSANCnRoYXQgYmVnYW4gdG8gb2NjdXIgb24gbXkg
cHJvZ3JhbSBjb25uZWN0aW5nIHRvIGEgUG9zdGdyZVNRTCANCmJhY2tlbmQu
PC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj48
L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6
ZT0yPlRoZSB3b25kZXJmdWxsIHRoaW5nIGFib3V0IHRoaXMgaXMgdGhhdCB0
aGUgDQpQZ0FkbWluMyB3YXMgY29ubmVjdGluZyB3aXRoIHRoZSBiYWNrZW5k
IGFuZCBzaG93aW5nIG1lIHJlY29yZHMuPC9GT05UPjwvRElWPg0KPERJVj48
Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8
RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPkEgc2VhcmNoIG9uIHRoZSBp
bnRlcm5ldCBzaG93ZWQgYSBjb3VwbGUgb2YgcGxhY2VzIA0Kd2l0aCB0aGUg
cHJvYmxlbSBhbmQgb25lIG9mIHRoZW0gbWVudGlvbmVkIHNvbWV0aGluZyBh
Ym91dCBhIA0KZmlyZXdhbGwuPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBm
YWNlPUFyaWFsIHNpemU9Mj48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxG
T05UIGZhY2U9QXJpYWwgc2l6ZT0yPkkgZG8gbm90IHVzZSB0aGUgV2luZG93
cyBGaXJld2FsbCwgSSB1c2UgWm9uZSANCkFsYXJtLiBBZnRlciBhIGJpdCBv
ZiBmaWRsaW5nIEkgZm91bmQgdGhlIGFuc3dlci48QlI+Jm5ic3A7PEJSPkkg
aGF2ZSBubyBpZGVhIA0KYWJvdXQgdGhlICJ3aHkiIHRoZSBlcnJvciBzdGFy
dGVkIG9jY3VyaW5nLiBNeSB3aWxkIGFzcyBndWVzcyBpcyBzb21lIFZpc3Rh
IChvciANCm90aGVyKSB1cGRhdGUgc29tZXdoZXJlIGNoYW5nZWQgc29tZSBj
b25kaXRpb24gdGhhdCB0cmlnZ2VyZWQgdGhpcyB0byBiZWdpbiANCmhhcHBl
bmluZy4gPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNp
emU9Mj48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9QXJp
YWwgc2l6ZT0yPjwvRk9OVD48QlI+PEZPTlQgZmFjZT1BcmlhbCANCnNpemU9
Mj48U1RST05HPlBST0JMRU06PC9TVFJPTkc+PC9GT05UPjwvRElWPg0KPERJ
Vj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj48L0ZPTlQ+Jm5ic3A7PC9ESVY+
DQo8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPkVycm9yOiBDb3VsZCBu
b3QgY29ubmVjdCB0byB0aGUgc2VydmVyOjxCUj5BbiANCmF0dGVtcHQgd2Fz
IG1hZGUgdG8gYWNjZXNzIGEgc29ja2VkIGluIGEgd2F5IGZvcmJpZGRlbiBi
eSBpdHMgYWNjZXNzIA0KcGVybWlzc2lvbnMuPEJSPlsxMjcuMC4wLjE6NTQz
Ml0gKDA4MDAxKS48QlI+UHJlc3MgT0sgdG8gZW5kIHRoaXMgDQphcHBsaWNh
dGlvbi48L0ZPTlQ+PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6
ZT0yPjwvRk9OVD4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1Bcmlh
bCBzaXplPTI+UG9zZ3JlU1FMIEVycm9ycyBwYWdlIHNheXM6PEJSPjA4MDAx
ID0gU1FMQ0xJRU5UIA0KVU5BQkxFIFRPIEVTVEFCTElTSCBTUUxDT05ORUNU
SU9OPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9
Mj48L0ZPTlQ+Jm5ic3A7PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9QXJpYWwg
c2l6ZT0yPjxTVFJPTkc+U09MVVRJT046PC9TVFJPTkc+PC9GT05UPjwvRElW
Pg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj48L0ZPTlQ+Jm5ic3A7
PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPlRoZSBzb2x1
dGlvbiB3YXMgdG8gZ28gaW50byB0aGUgIkZpcmV3YWxsIHwgWm9uZXMiIA0K
dGFiIG9mIFpvbmUgQWxhcm0gYW5kIGFkZCBhIExvY2FsIEhvc3QgZW50cnkg
d2l0aCBhbiBJUCBvZiANCjEyNy4wLjAuMTwvRk9OVD48L0RJVj4NCjxESVY+
PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+PC9GT05UPiZuYnNwOzwvRElWPg0K
PERJVj48QlI+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+SG9wZXMgdGhpcyBo
ZWxwcyBzb21lb25lIG91dCBpbiB0aGUgDQpmdXR1cmUuPEJSPjwvRk9OVD48
L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+PC9GT05UPiZu
YnNwOzwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj5Fbmpv
eSE8QlI+Um9iZXJ0byBBcnRpZ2FzIEpyPEJSPldoeSB3YXN0ZSB0aW1lIA0K
bGVhcm5pbmcgd2hlbiBpZ25vcmFuY2UgaXMgaW5zdGFudGFuZW91cz88QlI+
PC9GT05UPjwvRElWPjwvQk9EWT48L0hUTUw+DQoNCg==
-----------------0968272571--