PDA

View Full Version : Problem opening HEM



Jeans
11-13-2010, 12:42 PM
Hey, I recently ran a registry booster program and it might have something to do with my problem, basically HEM has been working great for a long time but suddenly when I try to open it I get "The following error occurred when trying to open the database: Failed to establish a connection to '127.0.0.1'"
the postgres window opens up and if I press on connect I get '"A connection to PostgreSQL could not be made. Would you like to have Holdem Manager attempt to start the service?" If I click yes a message appears "Sorry, Holdem Manager was unable to start the service" clicking OK on this and one last message "Holdem Manager has started the service. Please try again."
And then this pops out:
http://img585.imageshack.us/img585/2232/hemproblem.jpg

Any idea of the problem?

morny
11-13-2010, 10:04 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 its 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 - 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


If none of those worked Please reboot and 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

Failing that you will probably have to reinstall PostgreSQL completely and reimport your archived hands using these instructions. Once you do this you wont have access to the hands in the old database but since you cant connect to the database your already in that situation. In the case its 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. Ive 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:
A) Go to Start > Programs (All Programs) > Accessories > Command Prompt > Right-Click on command prompt and choose Run As Administrator
net user postgres /delete
B) 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)

Jeans
11-15-2010, 09:03 PM
Hey, I did try almost all of the steps you mentioned which didnt seem to work, I then uninstalled postgres completely and reinstalled HEM with the comboinstaller. Now Hem seems to be working normally but I was wondering how I'd get the old handhistories imported again? I saved the postgres folder before uninstalling it, aswell as copied my old HEM folder. Thanks in advance

Patvs
11-15-2010, 11:55 PM
Reimport all the original handhistories, by running a IMPORT FROM FOLDER on your old archive folder: default C:/HMArchive

Jeans
11-16-2010, 02:26 PM
Hey, sorry to disturb more but I did that and nowhere near all of my old hands appeared to the new hem database. Is it somehow possible to get the rest from the old postgres folders? I also tried to replace the new Holdem Manager folder with the old one in hopes of getting my old settings back (aliases etc) but didnt work either... Thanks for the help again.

Patvs
11-16-2010, 02:33 PM
It''s not possible to extract handhistories from the SQL database if you can't connect to it.

On which pokersite did you play your hands?
If Stars, Full Tilt, Party, email them and they will email you every hand you've ever played