PDA

View Full Version : Connection Error: Unable to read data from the transport connection:



Donut
07-03-2010, 03:11 AM
An existing connection was forcibly closed by the remote host.

Attached is a screen capture of the DB Control Panel error message.

I have Vista Business. I just changed to the newest version of Zonealarm
ZoneAlarm version:9.2.057.000
TrueVector version:9.2.057.000
Driver version:9.2.031.000
ZoneAlarm Browser Security 1.5.227.0

At the same time when I restarted my computer installed Hotfix for Windows KB981889 and Definition Update for Windows Defender KB915587 (Defenition 1.85.1218.0) Also on 6/30 Update for Windows KB970158 was installed and not sure if I ran HM since then.

Thanks,

Donut

_Loki_
07-03-2010, 03:36 AM
Hi Donut

###
This FAQ is for any of the following PostgreSQL problems:
** Failed to establish a connection to ‘127.0.0.1’ Service 'PostgreSQL Database Server 8.x' (pgsql-8.x) failed to start. Verify that you have sufficient privileges to start system services
** Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host
** The PostgreSQL Database service started then stopped, Some services stop automatically if they have no work to do...
** Windows just updated and PostgreSQL doesn't work anymore
** Or any PostgreSQL type error when trying to open Holdem Manager

###
Basic PostgreSQL Troubleshooting
Note: Make sure (UAC) User Account Control is off before proceeding. See the following links for information about UAC.

- Windows 7 UAC Help (http://faq.holdemmanager.com/questions/30/Turning+Off+UAC+%28Windows+7%29)
- Vista UAC Help (http://faq.holdemmanager.com/questions/29/Turning+Off+UAC+%28Vista%29)

###
Restart PostgreSQL service & Reboot
Go to Start > Programs > PostgreSQL > 8.x > Stop Service (If its already started)
Then go to Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file (it may not be there, that is perfectly fine)
Finally, if none of the above works a simple reboot can often resolve the issue

###
99% of the time PostgreSQL connection problems can be fixed by completely uninstalling software security products
<o>You can also enable features inside of your software security products without completely uninstalling them. Details Here (http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29)
</o>
We suggest you completely uninstall: (Don't just disable these products!!!) Disabling these products doesn't work because they are still running in the background. Reboot after uninstall too

Antivirus (Avast & AVG are free solutions with no known problems)<o></o>
Spyware Tools
3rd Party Firewalls

Note: Mcaffe, Comodo, F-Secure, Panda and Norton are the worst offenders here. If you are getting the errors and have 1 or more of these products installed, there is a very good chance that once these Antivirus programs are completely removed from your PC, PostgreSQL and Holdem Manager will be working together again.

Note: If you're a Software Security nit, chances are you have a couple antivirus programs with a couple spyware programs. Uninstall everything for now.

Note: Once PostgreSQL is working, we can install Software Security programs, but only 1 at a time testing our PostgreSQL connection each time.

<hr> Logon using Local System Account:


1. Go to Start / Control Panel / Administrative Tools(Need to be using classic view in Windows Vista) / Services. The Services dialog will pop up.
2. Scroll toPostgreSQL Database Server. If it isn't started (as indicated in the status column) right click on itand choose Start. If it starts and then stops or was already started, follow the steps below:
3. Right click on PostgreSQL Database Sever and choose Properties. You should see the following dialog.
4. Click on the Log On tab. Copy the username in the This Account field and paste it into Notepad in case you need to use it again. Make sure you know your password as well.
5. Select Local System Account and then click Apply then OK.
6. Restart your PC and see if you still get the error.
7. If it does not fix it, please switch to logon as This Account and enter your username and password again and reboot and continue with the rest of the FAQ.



<hr> Testing PostgreSQL Connection: <o>
</o>While there's multiple ways to do this, the easiest is to just open Holdem Manager.<o></o>
Launch Holdem Manager
If Holdem Manager opens you are done.
If you still get a PostgreSQL error, PostgreSQL is not connected or working.

<hr> Still Not Working?

Now we need to rule out the following:


Windows Firewall (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems)
Windows Defender (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems)
Windows Update (http://faq.holdemmanager.com/questions/276/Windows+Update)<o></o>

Donut
07-03-2010, 03:59 AM
Hi Donut

###
This FAQ is for any of the following PostgreSQL problems:
** Failed to establish a connection to ‘127.0.0.1’ Service 'PostgreSQL Database Server 8.x' (pgsql-8.x) failed to start. Verify that you have sufficient privileges to start system services
** Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host
** The PostgreSQL Database service started then stopped, Some services stop automatically if they have no work to do...
** Windows just updated and PostgreSQL doesn't work anymore
** Or any PostgreSQL type error when trying to open Holdem Manager

###
Basic PostgreSQL Troubleshooting
Note: Make sure (UAC) User Account Control is off before proceeding. See the following links for information about UAC.

- Windows 7 UAC Help (http://faq.holdemmanager.com/questions/30/Turning+Off+UAC+%28Windows+7%29)
- Vista UAC Help (http://faq.holdemmanager.com/questions/29/Turning+Off+UAC+%28Vista%29)

###
Restart PostgreSQL service & Reboot
Go to Start > Programs > PostgreSQL > 8.x > Stop Service (If its already started)
Then go to Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file (it may not be there, that is perfectly fine)
Finally, if none of the above works a simple reboot can often resolve the issue

###
99% of the time PostgreSQL connection problems can be fixed by completely uninstalling software security products
<o>You can also enable features inside of your software security products without completely uninstalling them. Details Here (http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29)
</o>
We suggest you completely uninstall: (Don't just disable these products!!!) Disabling these products doesn't work because they are still running in the background. Reboot after uninstall too

Antivirus (Avast & AVG are free solutions with no known problems)<o></o>
Spyware Tools
3rd Party Firewalls

Note: Mcaffe, Comodo, F-Secure, Panda and Norton are the worst offenders here. If you are getting the errors and have 1 or more of these products installed, there is a very good chance that once these Antivirus programs are completely removed from your PC, PostgreSQL and Holdem Manager will be working together again.

Note: If you're a Software Security nit, chances are you have a couple antivirus programs with a couple spyware programs. Uninstall everything for now.

Note: Once PostgreSQL is working, we can install Software Security programs, but only 1 at a time testing our PostgreSQL connection each time.

<hr> Logon using Local System Account:


1. Go to Start / Control Panel / Administrative Tools(Need to be using classic view in Windows Vista) / Services. The Services dialog will pop up.
2. Scroll toPostgreSQL Database Server. If it isn't started (as indicated in the status column) right click on itand choose Start. If it starts and then stops or was already started, follow the steps below:
3. Right click on PostgreSQL Database Sever and choose Properties. You should see the following dialog.
4. Click on the Log On tab. Copy the username in the This Account field and paste it into Notepad in case you need to use it again. Make sure you know your password as well.
5. Select Local System Account and then click Apply then OK.
6. Restart your PC and see if you still get the error.
7. If it does not fix it, please switch to logon as This Account and enter your username and password again and reboot and continue with the rest of the FAQ.



<hr> Testing PostgreSQL Connection: <o>
</o>While there's multiple ways to do this, the easiest is to just open Holdem Manager.<o></o>
Launch Holdem Manager
If Holdem Manager opens you are done.
If you still get a PostgreSQL error, PostgreSQL is not connected or working.

<hr> Still Not Working?

Now we need to rule out the following:


Windows Firewall (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems)
Windows Defender (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems)
Windows Update (http://faq.holdemmanager.com/questions/276/Windows+Update)<o></o>


Thanks so much for the quick reply.

This worked:

Go to Start > Programs > PostgreSQL > 8.x > Stop Service (If its already started)
Then go to Start > Programs > PostgreSQL > 8.x > Start Service

I can't believe the first, simplest suggestion did it. That's not the norm for me with computer problems, lol.

Donut