PDA

View Full Version : HEM1 problems on both computers



centgas
06-04-2012, 07:55 PM
Desktop; Vista

"Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host"

- I have v8.3 of postgres
- I have tried stopping and starting postgres, as well as restarting computer several times.

Only thing thats recently changed is Malwarebytes wanting to quarentine something C:\\WINDOWS\INSTALLER\..etc Seemed to be around the same time. I keep getting these, if they are part of the problem how do I stop them?

Laptop, Windows 7 ********EDIT this one now works ***************

Had this problem a couple of weeks ago but now its returned, the stats are delayed and show for players of previous hands.

Both computers have the May31st HEM1 update, have windows updates installed, firewalls etc disabled (Malwarebytes usually is and is now), have PS+HEM running as admin.

Thanks

netsrak
06-05-2012, 04:30 AM
This error usually means that a firewall is blocking the communication between postgresql and holdemmanager. Although your firewall may be disabled it still may block this.
Please configure exceptions: http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29

If that doesn't work there may be something else wrong with your postgresql. Try this:

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+

centgas
06-05-2012, 11:11 AM
This error usually means that a firewall is blocking the communication between postgresql and holdemmanager. Although your firewall may be disabled it still may block this.
Please configure exceptions: http://faq.holdemmanager.com/questions/339/Software+Security+Problems+%28Firewall%29

If that doesn't work there may be something else wrong with your postgresql. Try this:

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+

I dont have a firewall installed, and windows firewall is off.

Tried rebooting, deleting postmaster, changed logon to local system account etc. Still not working?

netsrak
06-06-2012, 04:50 AM
Can you access your database server via pgadmin?
Is the postgresql service running?

centgas
06-06-2012, 11:23 AM
Can you access your database server via pgadmin?
Is the postgresql service running?

I'm a little lost with these kind of things. Do I need to dowload pgadmin?

I have stopped and started postgresql before and it still didnt work, does that answer the second question? Although when I press start service, a box comes up saying the Postgresql Databse Server 8.3 is starting.... but doesnt go any further.

Patvs
06-06-2012, 07:54 PM
Turn on the secondary Logon. 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.


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

Try http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip

Patvs
06-06-2012, 07:54 PM
Which Firewall, and Anti-Virus are you using?

Also run a manual Windows Update and install all updates, including all .net framework updates.

And check your hosts file:
http://holdemmanager.net/forum/showthread.php?t=8182

centgas
06-08-2012, 12:48 PM
Turn on the secondary Logon. 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.


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

Try http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip

It says 'service status: Started', I assume that crosses that one out?

windows firewall isnt running, and I dont have anti virus/firewall apart from that (that I know of...).

I went to the directory where the host file is meant to be ( C:\Windows\System32\drivers ) but it wasnt there...

Patvs
06-08-2012, 07:33 PM
C:\Windows\system32\drivers\etc\

enable the option to see Hidden System Files: How to see hidden files in Windows (http://www.bleepingcomputer.com/tutorials/tutorial62.html)
http://rvgsoftware.fileburst.com/images/hidden.jpg

centgas
06-10-2012, 02:32 PM
C:\Windows\system32\drivers\etc\

enable the option to see Hidden System Files: How to see hidden files in Windows (http://www.bleepingcomputer.com/tutorials/tutorial62.html)
http://rvgsoftware.fileburst.com/images/hidden.jpg

I have done this, applied, restarted computer, and still cant find a 'hosts' file.

I do have one windows update that keeps failing when i try to install it, "Securiy update for SQL server 2005 service pack (KB970892)"

Would someone be able to take a look via teamviewer?

Thanks for the help.

Patvs
06-10-2012, 10:54 PM
If the file doesn't exist, create a file called 'hosts' (with NO extention) in that folder.
The file should contain the line: 127.0.0.1 localhost

See:
http://holdemmanager.net/forum/showthread.php?t=8182


Then reboot