PDA

View Full Version : Unable to read data from the transport...



RiverSt4rs
07-20-2011, 06:52 PM
"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host"

Well well well...I'm really getting upset after 3 hours trying to making work HEM.
For some reasons I've not been able to launch HEM for a while, I think the problem comes from postgreSQL like you could see in attached pictures.

I did read the FAQ and tried to solve the problem by myself but it's an epic fail, here what I did :

- Stop/Start postgreSQL
- Reinstall HEM several times (combo version)
- Reinstall postgreSQL several (until version 9)
- Turn off Windows Wall Defender
- Reboot (around 93 times?)

Help please

2 screens :

Imageshack - hembug.jpg (http://imageshack.us/f/148/hembug.jpg)

Imageshack - hembug2.jpg (http://imageshack.us/f/15/hembug2.jpg)

monchaos515
07-20-2011, 09:57 PM
same problem and error message with me.

i thought i fixed it 2 days ago when i deleted postSQL from windows an re-installed it. HM opened and worked!

Then the following day it failed to open. I deleted the postmaster.pid file and again it worked.

Today i no dice!!!!! it just posts the above transport error!

Help much appreciated

RiverSt4rs
07-20-2011, 11:32 PM
I also tried to restore my comp to a previous date but now I've :
" The following error occured when trying to open the database: Failed to etablish a connection to '127.0.0.1'

netsrak
07-21-2011, 05:29 AM
Unable to read... is a firewall problem, see this: http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29

can't connect... usually means that the postgresql service is not running:
Solutions:
1. Reboot your computer
2. If that doesn't help look for the hidden system file postmaster.pid in the postgresql data folder, delete it and reboot your computer again.
3. Check the postgresql service in the windows services (control panel->administration). Sometimes it helps to change the Logon As.. to "local system account"
4. Check our FAQ:
http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+

Chip&Chair
08-05-2011, 07:22 PM
I'm having the same error. I deleted the postmaster.pid and rebooted. didn't help. I have windows XP and the most current HM (1.11.07b. it worked fine last night but today i get the transport connection error. PS if you tell me to download postgresql, please tell me how because i couldn't figure it out. thanks for any help.

Patvs
08-05-2011, 09:03 PM
Install PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)
to port 5433.

Chip&Chair
08-05-2011, 09:31 PM
ok I tried to download... do i chose Http or ftp? also I don't know how to get to to download to port 5433. Anyway it didn't work because it got the following message: "This installation package could not be opened. Verify that the package exist and that you can open it, or contact the application vender to verify that this is a valid windows installer package".

Patvs
08-05-2011, 09:48 PM
Unzip the download first.
From the unzipped folder run postgresql-8.2.msi

During the installation you can pick the port: 5433
Password is: postgrespass

Chip&Chair
08-06-2011, 01:58 AM
I'm getting there and i appreciate your patience. It didn't accept the password "postgrespass"

Chip&Chair
08-06-2011, 04:14 PM
still not accepting the pw. it asks for pw then asks to verify pw... not working. does this pw work for anyone else?

Chip&Chair
08-06-2011, 07:45 PM
can someone help me with this please?

Patvs
08-07-2011, 06:04 AM
Delete the postgres user first. (and it will accept: postgrespass)

click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.

/

netsrak
08-07-2011, 06:05 AM
Did you use a different postgres password prior? You need to use this old password or you need to detelet the existing postgresql user:

Open a command box as administrator (right click - run as administrator) and enter the following:
net user postgres /delete

After completion you can assign a new password to the postgres user during the installation.

Chip&Chair
08-08-2011, 04:31 PM
It worked , tyvm! But I think i may have lost my entire hand history. is there a way i can check to see how may hands i have in my db?

Patvs
08-08-2011, 07:53 PM
Reimport your old hands by running a import from folder on your archive folder, C:/HMArchive.

Do see many hands are in the database, read: http://faq.holdemmanager.com/questions/115/Check+Total+Amount+of+Hands+in+Database+

Chip&Chair
08-08-2011, 09:29 PM
Yes, i need to reimport my hands from C:HMArchive. Please tell me how to do this. thank you

netsrak
08-09-2011, 04:17 AM
Import -> Import from folder -> open c:\hmarchive or a subfolder of this if you want to import in portions.