Problems installing HM2, special regard to PostgreSQL

[Hielkuh]

Hi there,

I decided that I wanted to try out HM2, as it would most likely be a worthwhile investment to improve my poker game. But unfortunately I have been busy for the last 3 hours installing the program... The errors I get vary from problems with running Microsoft VC++, as well as writing in a temporary environment. For those of you who look at these words and a bell starts ringing: YES, it is a problem with installing PostgreSQL.

I have tried almost everything and by everything, I refer to the about 15 solutions I could find on the web, and to be honest I am getting tired of trying. I do not have a firewall installed on my computer, I do not have an antivirus on at the time, I do have WSH scripting on, I pretty much checked every possible solution. Here is the bug report that i received last when installing PostgreSQL. This is my last attempt, if I cant find a solution here, I'll find a program that suits my needs just as well, but without all the software hassle.

Below you can find the error report that i received when installing HM2:

Output folder: C:\Program Files (x86)\PSQLINSTALL
top level install dir -->C:
Is admin account
fs=NTFS
.NET found
Extract: TestFirewall.exe... 100%
Extract: TestFirewall.exe.config... 100%
Antivirus Installed: False
test antivirus returned 0
seclogon error status: 0
seclogon status: 4
firewall enabled: 0
firewall not enabled
postgresql error status: 1060
postgresql status: 0
starting pgsql-8.3
postgresql error status: 1060
postgresql status: 0
postgresql error status: 1060
postgresql status: 0
starting postgresql-8.4
postgresql error status: 1060
postgresql status: 0
postgres installdir: C:\Program Files (x86)\PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient
no existing install dir
wrote testfile
Delete file: C:\testfile
Create folder: c:\postgreSQL
Execute: "C:\Program Files (x86)\PSQLINSTALL\postgres84.exe" --mode unattended --superpassword postgrespass --prefix c:\postgreSQL --datadir c:\postgreSQL\data
postgres installdir: C:\Program Files (x86)\PSQLINSTALL
==================== running PsqlTestClient
try userid: postgres
try pass: postgrespass
try pass: postgrespass
Connection to database failed: -->could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "127.0.0.1" and accepting
TCP/IP connections on port 5432?
<--error
1
testclient return status: 1
testclient return from file: 1
==================== finished PsqlTestClient



If you could help me out, that'd be great,

Yours sincerely,

Hielkuh

[Hielkuh]

Hi guys, I am still terribly stuck on the installation of PostgreSQL. I have tried everything, from turning off User Account Control, to about 15 other solutions that are listed on forums. Hell, I'm even up for some assistance via taking over my computer. Please just give me a solution here, I'd like to use your software, but you sure are not making it easy for me to do so :/. Was hoping I could get a response, but we are many hours further, I spent about 4-5 hours searching forums to fix an installation of your product. Please help a guy out...

[udbrky]

- Please see these steps to fix postgresql installation issues:

- Please update windows fully. Please keep checking until it shows twice five minutes apart that there are no more updates.

If you have Win7 or 8 (or Vista), consider the following:
1) 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.
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 )
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
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.
11) Run all pokerclients "as admin" too.


- Please update your network adapter. Open device manager and find the model #. Search google for the model # drivers to download.

- Please run the windows repair on your winsock:

How to determine and to recover from Winsock2 corruption in Windows Server 2003, in Windows XP, and in Windows Vista

If you are using Mcafee, Norton, Comodo or AVG for security, they have been causing a lot of issues with postgres lately. We recommend using a different program, such as Microsoft's firewall and Microsoft Security Essential. If you do feel that you need Comodo or AVG, uninstall first, install postgres, then reinstall after it is working. See this guide for Windows Firewall:

http://hm2faq.holdemmanager.com/ques...ender+Problems

Download from Download PostgreSQL | EnterpriseDB - do not use 9.1 or 9.3.

Right click the setup file, click properties. Click the unblock button at the bottom.

Empty the c:\temp and/or c:\Users\Username\AppData\Local\Temp folders.

If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file.

Try downloading 8.3 pginstaller. Also, make sure you right-click, go to properties and unblock the setup file first.

[Hielkuh]

Thank you kindly for the response. After trying for a while i was able to contact a friend of mine who uses table ninja. In the end i managed to install the 8.2 version that works. I do still have some problems with post flop bet sizing but i will ask that question in the appropriate forum section. Thank you for the reaction though!