PDA

View Full Version : Failure to establish connection



Glenhelder
06-08-2011, 08:29 AM
Can you guys help me with a problem that has recently arisen when I start up HEM.

On opening Holdem Manager, I get the error message "failure to establish connection to database 120.xx.xx". Then on the database control panel, after pressing connect, it says ''a connection to PostgreSQL could not be made. Would you have Holdem Manager attempt to start the service". After pressing 'Yes', Holdem Manager is still unable to start the service.

Excuse me if this is a noob question but I have zero experience with databases.

Thanks

fozzy71
06-08-2011, 09:25 AM
This is usually a firewall or windows update issue.

Which Operating System, Firewall, and Anti-Virus are you using?


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', 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.

Glenhelder
06-10-2011, 11:38 AM
Thanks,

This was the step that did it:

"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."