PDA

View Full Version : Connection establishment timeout



johco
02-10-2010, 07:02 PM
HEM always works after a computer restart. But have importing for a while (maybe an hour, sometimes more sometimes less time) I will go to import and I get an error message, "error: Connection establishment timeout. Increase timeout value in connectionString"

I then have to restart for HEM to work again. Solution?

firewall or antivirus not turned on either.

morny
02-10-2010, 09:44 PM
Can you attach your holdemmanager.config file from C:/Program Files/RVGSoftware/HoldemManager/Config folder please and ill take a look you might have something wrong in the import folders

You mention its been importing for a while, are you importing many hands and are you using import from file or import from folder or the auto import to import them?

johco
02-12-2010, 02:22 AM
attached

netsrak
02-12-2010, 07:59 AM
We need more informations about your operating system, Postgresql version, HM version.
And please answer mornys other questions.

Is your harddisk very full?

johco
02-12-2010, 08:42 PM
Always autoimporting.
windows xp, postgres 8.4, latest HEM.

I'm almost getting a error message at the 2nd startup of HEM (if HEM is closed after the initial problem) which says,"failed to establish connection to 127.0.0.1

morny
02-13-2010, 12:43 PM
This is usually a firewall or windows update issue.

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

Start > Programs > PostgreSQL > 8.x > Start 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 - FAQ - Hold'em Manager Poker Tracking Software :: Windows Firewall / Defender Problems (http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems) - Windows Firewall / Defender Problems

Please try following these FAQs, step by step:

1) FAQ - Hold'em Manager Poker Tracking Software :: Can't Connect / Failed to Start PostgreSQL (http://faq.holdemmanager.com/questions/91/Can't+Connect+%7B47%7D+Failed+to+Start+PostgreSQL+ ) Can't Connect / Failed to Start PostgreSQL
2) reinstall the same version of postgresql, using the same \data folder - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinst all) PostgreSQL Preserving Old Database
3) Still Can't Connect to PosgreSQL? Try This! - Holdem Manager Forums (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:
A) Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator

net user postgres /delete
B) Reboot.
C) Try installing this version of PostgreSQL - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe