Error Message

[Goosey]

When trying to open HEM I get the following-

"The following error occured when trying to open the database: Unable to read data from the transport connection: An exsisting connection was forcibly closed by the remote host"

I have tried each of the steps in this thread-

http://forums.holdemmanager.com/manager-general/22409-failed-establish-unable-read-data-database-service-started-stopped.html

After deleting my PostgresSQL and trying to reinstall firstly the combo installer and after that failed the new version. Both when downloading popped up and said failed to download that version.

I am stuck now and dont know what to do.

Thanks

[Patvs]

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.

Check your hosts file:
It should look like: http://holdemmanager.net/forum/showthread.php?t=8182


Install SQL 8.2 to a different port:
http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip
http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL

[Goosey]

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.

Check your hosts file:
It should look like: http://holdemmanager.net/forum/showthread.php?t=8182


Install SQL 8.2 to a different port:
http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip
http://faq.holdemmanager.com/questions/70/ReinstallPostgreSQL

Hi and thanks for the reply.

I still couldnt get it to work. Only thing I did different from your instructions is change the port to 5234 as it said port 5232 was already used.

I got as for as "Starting Services" in the Installing part of the postgress 8.2, however it stalls at this part of the download and I get the message

"Service PostresSQL Database Server 8.2 (pgsql-8.2) failed to start. Verify that you have sufficent privileges to start system services"

Any suggestions what to do now?

[netsrak]

Are you using any 3rd party firewall, anti-spyware, adaware, tuning or registry cleaning programs? And if yes which ones?

[Goosey]

Are you using any 3rd party firewall, anti-spyware, adaware, tuning or registry cleaning programs? And if yes which ones?

Mcafee and windows security centre,

thanks

[Patvs]

PC name must be in English and "in one word" - requires reboot after changing.
2) The same for Windows user name. If not - create new Win user with EN name and reboot PC for this user when install Postgres. And he must have admin rights. After installation you can kill this new user - his mission is completed.
This means: if you have Russian (or French, or else) Windows - your PC name possibly contains "non-english" letters.
Like "Вася-PC" or "Rene-PC"
The same with windows username. Or spaces in the name.
Postgres doesn't like that - and won't run as a result of it.
3) Secondary logon service must be set to "Autostart".
This 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.
4) UAC = OFF ( How to Disable and Turn Off UAC in Windows 7 « My Digital Life (http://www.mydigitallife.info/2008/12/30/how-to-disable-and-turn-off-uac-in-windows-7/) )
5) Disable firewall and antivirus when installing Postgres and HM. Or uninstall them at all.
6) All installations must run "as admin" (by right-click on file). And do them as first thing after PC reboot.
7) If you want to change install path for Postgres (or to set non-default folder for database cluster) - download "standalone" installation file from Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows)
8) If your Windows is not in English - you have to install Postgres not in default folder in Program_Files. Create new (example: c:\postgresql) first and select it when install.
9) Install Postgres and HM separarelly, one after one. As admin. If HM (when runs for the 1st time) says "no database" - simply create it via DBControlpanel.
10) If Postgres install fails - after uninstalling don't forget to kill windows user named "postgres":
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /del
exactly as shown. You should get a confirmation if it was successful.