PDA

View Full Version : Holdem manager wont work after laptop dies??



Grindation
03-26-2011, 08:08 PM
While i was in game my laptop ran out of battery. when i got the laptop working again HEM wouldn't work and a popup saying 'Holdem Manager needs to know where to find the database. Please enter the details below and click connect' After clicking connect another popup came up saying ' Connection Error: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote gost.
System.IOIOException: Unable to read data from the transport connection: An eisting connection was forcibly closed by remote host. --->System.net.sockets.SocketException: An existing connection was forcibly closed by the remote host'
and a lot of file names were listed below which i don't want to type in because it would take too long.

can someone please help me because i have a big sunday schedual!

olliepower
03-26-2011, 08:51 PM
This is usually a firewall or windows update issue and the following guide will help you to fix this problem.

Go to Start > Programs (or all programs) > PostgreSQL 8.x > choose Stop Service

Start > Programs (or all programs) > PostgreSQL 8.x and choose Start Service. This may take some time and a black dos window may appear while it?s starting. If it fails to start delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. Do not delete any other files

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 - Windows Firewall / Defender Problems

If none of those worked Please reboot and try following these FAQs, step by step:

1) 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 ? http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+DatabaseReinst all PostgreSQL Preserving Old Database

Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you won?t have access to the hands in the old database but since you can?t connect to the database your already in that situation. In the case it?s not possible to reconnect you can either contact the PostgreSQL forums who may be able to help with advanced connection issues or you can reinstall. I?ve listed 3 PostgreSQL forums below
PostgreSQL Help Forums (http://forums.devshed.com/postgresql-help-21/)
PostgreSQL (http://old.nabble.com/PostgreSQL-f759.html)
PostgreSQL - dBforums (http://www.dbforums.com/postgresql/)

1) Uninstall PostgreSQL via Control Panel > Programs & Features (Add/Remove Programs on XP).
2) Use our combo installer to reinstall PostgreSQL. Make sure you un-check Holdem Manager during installation. http://rvgsoftware.fileburst.com/Holdem_Manager_Setup.exe

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

The secondary logon service is a standard windows service which is available on every windows computer and is required to be running to install PostgreSQL. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.

Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:

net user postgres /delete

Try installing this version of PostgreSQL ? http://rvgsoftware.fileburst.com/Postgres_8.3.9-v1.0.7.exe
If that also fails Please follow step A again and try this version PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.17/win32/postgresql-8.2.17-1.zip)

Grindation
03-27-2011, 07:02 AM
I don't get how any of this is relevent to my problem? everything was working fine before my laptop shut down. How would that have any sort of an effect on my firewalls acceptance of HEM?

Grindation
03-27-2011, 07:03 AM
PM me your skype if you can help me ouif anyone thinks they can help me out. we can skype chat and solve the problem via screen share.

Grindation
03-27-2011, 07:29 AM
HEM can't connect to my database. It's sunday and i can't play because of this problem. so if anyone could please help would be very appreciated!

Grindation
03-27-2011, 08:53 AM
it says that it was forcibly deleted. is there a way to get everything back?!?!
getting steamed about this. it's ruined my sunday grind and i've had to unreg for all my tourneys.

fozzy71
03-27-2011, 09:49 AM
I don't get how any of this is relevent to my problem? everything was working fine before my laptop shut down. How would that have any sort of an effect on my firewalls acceptance of HEM?

Your database was likely damaged when the laptop shutdown unexpectedly. Power outages and windows crashes during database use is the most common cause of corrupt, damaged, or disconnected databases.

Firewall issues are more common during new installs with new customers, but it is important you check everything so he gave you the entire canned response for this problem. If you follow those steps it will resolve your problems, one way or another. Chances are the only solution may be to completely reinstall postgresql and rebuild your database as the last steps in the first reply suggest.

Grindation
03-27-2011, 01:36 PM
Problem solved thanks to everyone that helped!