HM2 cant connect to Database

[itocesana]

Hi there! I have a problem starting the database for HM2. HM works fine and connects all the time. But HM2 stops wen:
Creating Database, an error window pops up an say:

"Holdem Manager cannot connect to the PostgreSQL Database. This can be cause by firewall or Windows update. Please see this FAQ for a solution."

I read the suggested solutions but all have to do with the original HM which is working fine, I am scare to damage the HM trying to fix the HM2.
Please if someone can explain how to do it i will appreciated.
Thanks.

[Sarek]

Connection settings are all the same?
Port, ip, user, password

[itocesana]

Hi! Thanks for replay.
HM2 connect to Server 127.0.0.1
Port 5432
username:.....
password:......
it says:
Success. Please click Next to continue
I press Next and another window appears, it says:
SELECT DATABASE
Create a new HM@ database with this name
Holdem Manager2
Use default database parent folder location
Database parent folder
C:\User\Itork\AppData\Roaming
Then I press Next
Another window says

Ready to start
Click Finish to start Holdem Manager 2
*Create database Holdem Manager2
It may take a few seconds to create your database. Please be patient.
I click Finish
A small window appear says
Create database
Creating database "holdem Manager2"
Work in progress. Please stand by...

Instantly an error window will appear that says
Database error
Holdem manager cannot connect to the PostgreSQL Database. this can be caused by firewall or Windows update; Please see this FAQ for a solution.

So it get stuck there.

Answering your question, I don really know how to check the ip, port, username, password in the original HM, But I think the sist4em goes trough that stage successfully. I try to put windows fire wall off but still the same.

I am doing somthing wrong? Please help sins I not very good st solving this problems.
Thanks.

[udbrky]

Make sure Windows is fully updated.

What is your firewall and antivirus? Any other security software?

[itocesana]

I only have Microsoft Security Essentials. Windows 7 is up to date.
But remember that HM is connecting OK, so should HM2 connect too?

[udbrky]

So you're using Windows 7 firewall? It's separate from MSE - MSE is antivirus.

Add postgresql, holdemmanager.exe and hudfuncapps.exe to your firewall exception list.

[Sarek]

pg_ctl.exe and postgres.exe in postgresql/bin folder
AND - the whole folder postgresql/data

[marw84]

hello,
i have absolutely the same problem.

win 7 (uptodate), hem is working correctly, hem2 - i get the same error, but i know postgresql login and password is correct.

i use comodo firewall and avast antivirus, but even if i shut them down and turn off win 7 integrated firewall problem remains same

[itocesana]

Yeah!! I give up trying. Im using HEM at the moment. May be they should find the way to be more user friendly.

[udbrky]

Do you have a 2.0 DB set up already? You can find the port/ip address/info in the C:\Program Files (x86)\RVG Software\Holdem Manager\DBControlPanel.exe

The issue is, it's not connecting to postgres. We need to know what the connection information is on both to make sure it's the same. You also shouldn't use 2 firewalls at the same time, it causes a lot of trouble. Pick one and use it.

[pinchehussey]

i have windows 7 and have the exact same problem and i've tried everything that has been said and still nothing
29291

[Sarek]

which Postgres is installed? full version #
and where it is installed - in default paths? Or custom? If custom - post paths to postgres/bin folder and postgres/data folder
And: do you have PT3 installed on PC? Or Elephant?
Is your postgres user/password different from default postgres/postgrespass?
Then please open CMD and type there
net user
then press Enter
and post screen with result

[pinchehussey]

postges 8.3 i have installed, and i'm pretty sure it's fullversion and i'ts installed in default path.

i do have elephant installed

and progress user/password are diffrent from default postgres/postgrespass.

i've also incluided a picture of how the setup wizard of HM2 recognizes he user/pass that i use.

29351

[morny]

Please email hm2support@holdemmanager.com and well setup a teamviewer session to look at the issue

[Sarek]

Try to do this without Teamviewer:

A. If Posgres user is non-default, there must be a Database (any), named exactly as this user.
B. For HM2 can create databases, anyway we need user/role "postgres"
To do this:
1. Run PGAdmin, connect to server
2. Right-click on Databases - Create new DB
3. In window opened we nave to enter database name equal to postgres user name. If user is named "poker" - DB name have to be "poker". If user is names "elephant", DB name have to be "elephant". Etc.
4. Click on Plus in Login roles and check if there is user "postgres"
If not exists: right-click Login Roles - New login role,
set field Role name as "postgres" (without quotes), set Connection limit as "-1" (also without qoutes)
then set all flags in Role privileges Tab (see picture for PG9, in PG8 these flags are on first tab)

[pinchehussey]

can't find PGAdmin anywhere ?¿?¿?¿

upgrading postgres to 9, would it help?

[Parasar]

I have the same problem and the same picture and i can't find pgadmin .How can I fix this?

[udbrky]

Start - all programs - postgres folder - pgadminIII

[pinchehussey]

i'm afraid that i dont have that feature, i looked everywhere and nothing

[udbrky]

Go to my computer

c:\program files\postgresql\version#\bin\pgAdmin3.exe

[pinchehussey]

29521

not there sorry

[udbrky]

pgAdmin: Download - Windows ™ (http://www.pgadmin.org/download/windows.php)

[pinchehussey]

do i install it in the BIN folder??

[Sarek]

No difference where you install PGadmin.
Anyway it will see Postgres

[pinchehussey]

sorry tu be a pest, but the zip pgadmin folder, says it not valid coz it's empty

[Sarek]

PostgreSQL: Choose a Mirror (http://www.postgresql.org/download/mirrors-ftp/pgadmin3/release/v1.14.0/win32/pgadmin3-1.14.0.zip)
allmost 13 MB

[pinchehussey]

file seems to be damaged, doesnt decompress

[Sarek]

Then take this 1.12.3 PostgreSQL: Choose a Mirror (http://www.postgresql.org/download/mirrors-ftp/pgadmin3/release/v1.12.3/win32/pgadmin3-1.12.3.zip)
no matter

[pinchehussey]

no go mate! they all say error

29531

dunno what's going on

[Sarek]

See link in private message, please.

[pinchehussey]

ok installed! now what do i do? :)

[Parasar]

HM2 now start but then says that postgres does not exist
:(

[Sarek]

It says "role" not exists
see my post earlier how to workaround

[Parasar]

I do not understand how to connect and create the new database with pgadmin.Can you help me with teamviewer?

[Sarek]

Please download www.holdemmanager.com/teamviewer.exe
This is version 5 (five) as our license dont support teamviewer 6 yet

set firewall = OFF and send me TV5 ID and passw via private messages
right now, if possible

OR: email hm2support@holdemmanager.com to schedule TV session

[Parasar]

Thank you so much assistance, for others who have had the same problem was due to the fact that I had only installed the update

[Sarek]

Due to "only update" you had Stattrigger error message.
All other is Postgres-related.

[pinchehussey]

may i request teamviewer asistance? i'm lost :)

[udbrky]

may i request teamviewer asistance? i'm lost :)


Please download www.holdemmanager.com/teamviewer.exe
This is version 5 (five) as our license dont support teamviewer 6 yet

set firewall = OFF and send me TV5 ID and passw via private messages
right now, if possible

OR: email hm2support@holdemmanager.com to schedule TV session

Email with a time and day that is best for you (also your time zone).

[pinchehussey]

i'm available right now, if it's possible

[udbrky]

If you email, we can work in a schedule for one.

[RoflVomitCall]

I just bought HM a while back and barely used it. I wanted to start with it
now and then I saw this. Is HM2 an update or actually new software you have to
buy again?
If that's the case than i'm fucked beyond believe.

[Sarek]

This is NEW software. If you purchased HM1 after May, 1, 2011 - you will get HM2 for free.
All other pricing and discounts policy is not determined yet.

[RoflVomitCall]

This is NEW software. If you purchased HM1 after May, 1, 2011 - you will get HM2 for free.
All other pricing and discounts policy is not determined yet.
Yeah I haven't used HM1 yet, but bought it a while ago. Although time flies i'm sure I bought it after May, 1, 2011. How can I check this to be sure?

[wallshHU]

Hi Guys!

After 10 hours of strugle to repair my postgreSQL i officially gave up. Try sollutions from the HM forum unistall,reinstall multipul times. Tweak my windows firewall and windows updater. Nothing works. Last time tryed the new HM2 installer for HM+posgreSQL but it never finish.
The error message:
31871

Every time the postgreSQL unexpectedly shot down. Or the HM cannot connect to the DB.

Please help. I'm open for Team view session from 8 to 24 (GMT+1).

[udbrky]

Wallsh, email hm2support@holdemmanager.com with a request for a teamviewer.

rofl, log into your Hold'em Manager Poker Software - Best Poker Tracking Software (http://www.holdemmanager.com) account it should show there.

[RoflVomitCall]

Wallsh, email hm2support@holdemmanager.com with a request for a teamviewer.

rofl, log into your Hold'em Manager Poker Software - Best Poker Tracking Software (http://www.holdemmanager.com) account it should show there.

Gracias, I got it for free yeah...
Since I don't know how to use HM1 properly, could that be a problem with using HM2.
Is there already a tutorial out that explains all the basics of HM2?
Much appreciated, thank you.

[jakobgold]

i have the same problem and dont know what to do, when this message appears i just exit hem2 and launch it again its pretty anoyinng this is happening to many times in a day, please help

[DogNamedBluff]

Gracias, I got it for free yeah...
Since I don't know how to use HM1 properly, could that be a problem with using HM2.
Is there already a tutorial out that explains all the basics of HM2?
Much appreciated, thank you.

See this FAQ for a good starting point: http://hm2faq.holdemmanager.com/questions/1601/Transitioning+from+HM1+to+HM2

[DogNamedBluff]

i have the same problem and dont know what to do, when this message appears i just exit hem2 and launch it again its pretty anoyinng this is happening to many times in a day, please help Please send the log file to hm2support@holdemmanager.com with a link to this thread.

Where is my log file?

7: C:\Users\{username}\AppData\Roaming\HoldemManager\

Showing hidden files: How to show hidden files in Windows 7 (http://www.bleepingcomputer.com/tutorials/tutorial151.html)

XP: C:\Documents and Settings\User_name\Application Data\HoldemManager

Showing hidden files: Microsoft Corporation (http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/win_fcab_show_file_extensions.mspx?mfr=true)

[kasspav]

Ok guys, I'm really getting angry with this. Before the installation of Note caddy, Hm2 seemed to work ok, I had some importing issues, but that another thing. So after notecaddy, importing new hands and the Hud works for awhile ok...and then suddenly the same msg appears:
"Holdem Manager cannot connect to the PostgreSQL Database. This can be cause by firewall or Windows update. Please see this FAQ for a solution."

Any ideas? Done the upgrade, firewall is ok...dont know whatelse to do...

[udbrky]

Please email a log file with a link to this thread to hm2support@holdemmanager.com so we can look into this.

Where is:
My log file
7: C:\Users\{username}\AppData\Roaming\HoldemManager\
Showing hidden files and sytem files and folders: How to show hidden files in Windows 7 (http://www.bleepingcomputer.com/tutorials/tutorial151.html)
XP: C:\Documents and Settings\User_name\Application Data\HoldemManager
Showing hidden files and sytem files and folders: Microsoft Corporation (http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/win_fcab_show_file_extensions.mspx?mfr=true)

Did you add holdemmanager.exe and hudfuncapps.exe to your firewall's exceptions? What is your firewall?

[kasspav]

I have ESET 4 smart security.

[udbrky]

Please try this in the latest version, send us a new log if there is a drop.