PDA

View Full Version : Unable to write data to the transport connection: An existing connection was forcib..



locky
07-01-2011, 04:34 AM
"Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host."

Hi guys, opening HM, this error started after I (stupidly) changed manually the DNS server addressess ( through Local Area Connection Properties) trying to connect with OpenDNS (after hearing you get faster and safer internet).

Of course as soon as I did that I realised that this could stuff up HM, which was true.

I have since manually changed it back to "Obtain DNS server address automatically" but this HM error pops up.

I read a couple of posts to fix the problem. First I stopped and started the server. Nothing changed. Then I uninstalled/reinstalled bit defender (anti-virus) which fixed the problem temporarily. When I try to enter HM after bit defender is reinstalled the error props up again :(

Help Please!

Regards,
Locky

netsrak
07-01-2011, 05:08 AM
The firewall is blocking the connection between HM and Postgresql:
http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29

locky
07-01-2011, 01:47 PM
Made the exceptions on my windows firewall AND my BitDefender firewall. Still get the error msg.
I am about to tear my hair out! Help!

locky
07-01-2011, 04:14 PM
Another thing, My PostgresSQL file size is upto 105GB! Is that normal? Or should I really start to think about purging my database? If so, What is the memory target suppose to be?

cheers,
locky

fozzy71
07-01-2011, 09:32 PM
Made the exceptions on my windows firewall AND my BitDefender firewall. Still get the error msg.
I am about to tear my hair out! Help!

BitDefender is likely the problem.

This is usually a firewall or windows update issue.

Many of those free Norton, Mcaffee, Comodo, Zonealarm, etc, 'internet security' bundles will not work well with holdem manager.

Please do the following steps, so we can get your computer to a state that we know will work with Holdem Manager:

1) Uninstall any 3rd party security software bundles.
2) Reboot your computer
3) Please install the latest version: http://rvgsoftware.fileburst.com/HmBetaUpdate.exe
4) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender, and add firewall exceptions for HM and SQL - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems
5) Install Microsoft Security Essentials for antivirus/malware protection and update it - Virus, Spyware & Malware Protection | Microsoft Security Essentials (http://www.microsoft.com/security_essentials/)

Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts), including Internet Explorer 9 (even if you use a different web browser) and change your Windows Control Panel > Regional Settings Format to English (USA).

The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services > secondary logon > right-click > start AND right-click > properties > startup type: automatic.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

*If UAC is enabled you have to Right-Click > Run As Administrator when you Start/Stop the service.

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems

Please try following these FAQs, step by step:

1) http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+
2) reinstall the same version of postgresql, using the same \data folder - http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database
3) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands using these instructions

1) Uninstall PostgreSQL from the Windows Control Panel.
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://www.holdemmanager.com/downloads/Holdem_Manager_Setup.exe

If that installer fails to install PostgreSQL, please reinstall PostgreSQL using the following instructions:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator


net user postgres /delete

4) reboot.
5) Install PostgreSQL 8.3.9 from this link - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

Install it to a new path such as C:\PostgreSQL\8.3 instead of the default installation path.


Another thing, My PostgresSQL file size is upto 105GB! Is that normal? Or should I really start to think about purging my database? If so, What is the memory target suppose to be?

cheers,
locky

A postgresql database is usually about 10gb per million hands, with logging disabled. If you have any old unused databases you can delete them to save space.

http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database


Logging:

I would suggest you turn off logging on any SQL installation.


To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.



------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.

# This is used when logging to stderr:
logging_collector = off # Enable capturing of stderr and csvlog


File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.


- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.



Regarding database maintenance:

You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin. You do not want to purge any Hero hands so make sure your alias is properly configured before purging.
http://faq.holdemmanager.com/questions/100/Purge+Hands+from+Database
http://faq.holdemmanager.com/questions/197/Purge+Hands

Then you can vacuum/analyze - http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+#manual

Before you defragment you should stop the PostgreSQL service:

Start > Programs > PostgreSQL 8.x > Stop Server

Use your favorite defrag tool. I recommend Smart Defrag.

After defrag I recommend you reboot your PC. If you need to access the DB before rebooting you can start the PostgreSQL service.

Start > Programs > PostgreSQL 8.x > Start Server