PDA

View Full Version : Error opening HM



raulfl89
09-30-2010, 06:25 AM
the following error occurred when trying to open the database: No se puede escribir datos de en la conexión de transporte: Se ha forzado la interrupción de una conexión existente por el host remoto

I stop, restart the postgress and reset pc.
I delete the postmaster.pid and reset pc.
I unselected de UAC and reset pc.
I uninstall the Mc Afee and reset pc.

And then run, but not the HUD.

I close and open the HM, and not run.

-Windows Vista
-HM 1.11.04
-Postgress 8.3

raulfl89
09-30-2010, 09:53 AM
Now is running, but not the HUD..

http://img707.imageshack.us/img707/9241/40941412.jpg

netsrak
09-30-2010, 10:25 AM
Please try with the latest Beta: http://www.holdemmanager.com/downloads/Holdem_Manager_Beta.exe

raulfl89
09-30-2010, 10:56 AM
The same with the Beta. No HUD in stars.

And no import from folders. I think that is the problem now..

10 minuts later, HM not run..

raulfl89
09-30-2010, 11:35 AM
http://img443.imageshack.us/img443/6236/hm2to.jpg

Patvs
10-01-2010, 12:13 AM
This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

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. And reboot.

Add exceptions to the windows firewall, even if it is off.



If that doesn't help you will have to reinstall PostgreSQL completely


Try installing a more recent version of SQL to a different port.
i.e. SQL 8.4.4 (or 9.0.0) from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) to port 5433

raulfl89
10-01-2010, 09:42 AM
Installing postgres appear one error..

Now 127.0.0.1, and when I go to postgres-->data--> to delete postmaster.pid don't see anything, no files..

adrian.alex
10-01-2010, 09:59 AM
hey ! same error for me.

pls check this :

http://forums.holdemmanager.com/manager-bugs/37204-unable-start-hm-unable-open-database-pls-help.html#post179010

raulfl89
10-01-2010, 11:10 AM
I tried all, and not run, I don't know what can I do..

Errors installing postgres:

http://img193.imageshack.us/img193/3693/error1instal.jpg (http://img193.imageshack.us/i/error1instal.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

http://img831.imageshack.us/img831/7308/error3install.jpg (http://img831.imageshack.us/i/error3install.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

http://img814.imageshack.us/img814/5701/error4instal.jpg (http://img814.imageshack.us/i/error4instal.jpg/)

http://img833.imageshack.us/img833/7599/error5instal.jpg (http://img833.imageshack.us/i/error5instal.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

Patvs
10-01-2010, 01:38 PM
Check if the sec loggon is running: 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. Starting it once should insure it works in the future also.

Try installing SQL 8.2: PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.17/win32/postgresql-8.2.17-1.zip)

Install it to a different port

raulfl89
10-01-2010, 02:12 PM
Secondary logon is started.

raulfl89
10-01-2010, 02:41 PM
Well, with postgres 8.2 and port 5434 it runs by now.

Thanks.

raulfl89
10-13-2010, 07:22 AM
Same problem today.

Patvs
10-13-2010, 08:01 AM
add pg_ctl.exe and postgres.exe to the exception list of your firewall.



delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.

raulfl89
12-20-2010, 05:40 PM
Today same problem..I reinstall HM and Postgres, I delete .pid, every month the same problem..I'm so tired.

Patvs
12-20-2010, 08:23 PM
If the problem keeps coming back, some OTHER program on your computer is messing/blocking with the SQL server.

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

Add the entire PostgreSQL folder to the exceptions list of Windows DEFENDER.
Add pg_ctl.exe and postgres.exe to the exception list of the WINDOWS firewall.
Uninstall programs such a Spybot Search & Destroy, Comodo, Kaspersky.

Open your hosts file in the Windows/System32/Drivers/etc/ folder

The file should read




# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost




If that file has a long list of localhost names and numbers, some program on your computer (like Spybot Search & Destroy) is adding those lines and you should delete those extra lines and uninstall the program.

raulfl89
12-21-2010, 05:57 PM
If the problem keeps coming back, some OTHER program on your computer is messing/blocking with the SQL server.

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

Add the entire PostgreSQL folder to the exceptions list of Windows DEFENDER.
Add pg_ctl.exe and postgres.exe to the exception list of the WINDOWS firewall.
Uninstall programs such a Spybot Search & Destroy, Comodo, Kaspersky.

Open your hosts file in the Windows/System32/Drivers/etc/ folder

The file should read




# Copyright (c) 1993-2009 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost




If that file has a long list of localhost names and numbers, some program on your computer (like Spybot Search & Destroy) is adding those lines and you should delete those extra lines and uninstall the program.

I'm using Windows Vista, no antivirus, all the exceptions are right. No idea about firewall. And this is the file:

# Copyright (c) 1993-2006 Microsoft Corp.
#
# This is a sample HOSTS file used by Microsoft TCP/IP for Windows.
#
# This file contains the mappings of IP addresses to host names. Each
# entry should be kept on an individual line. The IP address should
# be placed in the first column followed by the corresponding host name.
# The IP address and the host name should be separated by at least one
# space.
#
# Additionally, comments (such as these) may be inserted on individual
# lines or following the machine name denoted by a '#' symbol.
#
# For example:
#
# 102.54.94.97 rhino.acme.com # source server
# 38.25.63.10 x.acme.com # x client host

127.0.0.1 localhost
::1 localhost

morny
12-22-2010, 09: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 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)

If you cant complete a step or get an error please post the exact details of that error