troubleshooting installation of PostgreSQL

[zdmjack]

the installation of PostgreSQL is always a headache to me.
Here is the problem:
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: 1
starting seclogon
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
granting write permission on top level postgres directory
found dir
try rename C:\PostgreSQL --> C:\PostgreSQL-prev-2012-20-May-10-09-35
Create folder: C:\PostgreSQL-prev-2012-20-May-10-09-35
Moving files: C:\PostgreSQL\*.* to C:\PostgreSQL-prev-2012-20-May-10-09-35\
Remove folder: C:\PostgreSQL\
renamed dir
wrote testfile
Extract: postgresql-8.4.7-1-windows.exe... 100%
Create folder: c:\postgreSQL
Execute: "C:\Program Files (x86)\PSQLINSTALL\postgresql-8.4.7-1-windows.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

[DogNamedBluff]

If you have Win7 (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.
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 )

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".

12) Finally, if you use the automatic combo install in Holdem Manager to install HM and PostgreSQL together. If you run into the problem, password "postgrespass" does not comply with domain password requirements. Please manually install PostgreSQL and enter another password to make it work. PostgreSQL: The world's most advanced open source database

If you continue to have problems, please reproduce the issue and attach your log.txt file in an email to support with a link to this thread.-

http://hm2faq.holdemmanager.com/ques...ger+Support%3F

[zdmjack]

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?

what does this mean? Does that related to my internet.

I have done all the steps it just stop here.

I probably will choose a vew version at PostgreSQL: The world's most advanced open source database
Are both Version 9.1.4 Version 9.0.8 ok for hm2

[Patvs]

You can use 8.2, 8.3, 8.4, or 9.0.x
Don't use 9.1.x

Is your secondary logon running? 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.

Is 127.0.01 added to your hosts file? Read:
http://holdemmanager.net/forum/showthread.php?t=8182


Try installing PostgreSQL with the installer from PostgreSQL: The world's most advanced open source database
If 8.4.x (preferred) doesn't install, try http://ftp.postgresql.org/pub/binary...l-8.2.22-1.zip

Also install it to a different port, for example 5433, as a firewall may have already blocked port 5432.

[zdmjack]

This is what the post saying

PHP Code:
**************************************************
# 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


This is what in my note book
# 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

They are different. I am not sure if it is already ok?
I am using win7 64

[Patvs]

Remove the # in front of the localhost... and remove ::1 so yours looks like:

This is what in my note book
# 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

and reboot.


Then reinstall. If 8.4.x won't install, try 8.2.x (see link in my previous post)

[road_runner]

un-comment the # 127.0.0.1 localhost to be just like this: 127.0.0.1 localhost

In this way you will enable IPv4 resolution of localhost, otherwise localhost will resolve to IPv6 address which often gives troubles to mysql or postgresql dbs

[zdmjack]

It still does not work when I install the postgres in hm2

So I tried installling the 8.2 seperately.

After that I installed the hm2. It still showed I need to install postgres so I unclick it. (Was that suppose to be unclick automaticly.)



I tried running the hm2.
Everytime I did, the system showed me it stopped working and asked me to close it

This is the problem
问题事件名称: APPCRASH
应用程序名: HoldemManager.exe
应用程序版本: 2.0.0.6866
应用程序时间戳: 4fb8fac8
故障模块名称: wmp.dll
故障模块版本: 12.0.7601.17514
故障模块时间戳: 4ce7ca81
异常代码: c0000005
异常偏移: 00000000002c1141
OS 版本: 6.1.7601.2.1.0.256.1
区域设置 ID: 2052
其他信息 1: 113f
其他信息 2: 113fde42d145c185dee64ab639be0e89
其他信息 3: 9f68
其他信息 4: 9f6809526f1c3656c51c89b04279dcb1



this is the trouble shooting

C:\Users\Administrator\AppData\Local\Temp\WER26A4. tmp.WERInternalMetadata.xml
C:\Users\Administrator\AppData\Local\Temp\WER431B. tmp.appcompat.txt
C:\Users\Administrator\AppData\Local\Temp\WER4C9D. tmp.mdmp

[DogNamedBluff]

Hi.

In the error report it shows you are running and older version of HM2.

Please update to this version: http://www.holdemmanager.com/Downloa...AutoUpdate.exe (7053)

Make sure to install on an administrator account and run as an administrator.

Please turn off User Account Control. Turn User Account Control on or off

Add holdemmanager.exe, hudfuncapps.exe and postgres to the exceptions list in your firewall and antivirus.

Make sure that Windows is fully 100% up to date.

You need to make sure that this folder

7/Vista: C:\Users\{username}\AppData\Roaming\HoldemManager\
Showing hidden files and sytem files and folders: http://www.bleepingcomputer.com/tuto...torial151.html
XP: C:\Documents and Settings\User_name\Application Data\HoldemManager
Showing hidden files and sytem files and folders: http://www.microsoft.com/resources/d....mspx?mfr=true

is not read only and that all permissions are set to full for your user name. The folder will continue showing read only after that, this is an issue in Windows.

If you continue to have problems, please reproduce the problem, describe exactly what you were doing, and attach your log.txt file -
http://hm2faq.holdemmanager.com/ques...ger+Support%3F

Thank you,
DNB

[zdmjack]

I have done everything and update the hm2. But it is still not working.

Please carefully study the following analysis. I do not think it is because of the update issue.And a table scanner plugin notbok just pop out and I can not close it.

Why it is so complicate to use hm2. I am not supposed to be a computer experts. I just want to use a software. It seems like a virus. I have to change this change that, install different pieces.

问题事件名称: APPCRASH
应用程序名: HoldemManager.exe
应用程序版本: 2.0.0.7053
应用程序时间戳: 4fea5cda
故障模块名称: wmp.dll
故障模块版本: 12.0.7601.17514
故障模块时间戳: 4ce7ca81
异常代码: c0000005
异常偏移: 00000000002c1141
OS 版本: 6.1.7601.2.1.0.256.1
区域设置 ID: 2052
其他信息 1: 113f
其他信息 2: 113fde42d145c185dee64ab639be0e89
其他信息 3: 9f68
其他信息 4: 9f6809526f1c3656c51c89b04279dcb1