PDA

View Full Version : Setting up HM on 2nd CPU Postgres Problems



George Jackson
07-15-2009, 11:27 PM
I have loaded HM to my 2nd cpu.. installed postgres but it wont let me start HM.


install completed and i hit the hm icon and the database control panel came up.. i hit connect and it said.." the username/password is incorrect. Would you like to have HM configure the database to accept this login and password"?

i hit yes and it said "holdem manager updated PostgreSQL please try connecting again and the same thing happens... keep getting the same msg and it wont connect...


thanks for your help

I am available all night if need be.

fozzy71
07-16-2009, 12:41 AM
Did you already have PostgreSQl installed, for PT3 perhaps?

The easiest option may be to simply remove the need for a password.

PT3's default name/password is - postgres/dbpass

If that password isn't right, you can try using svcpass, or postgrespass.


If neither of those work, you can remove the need for a password by editing the pg_hba.conf file.

Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf

The file should open with Notepad

Scroll to the bottom where you will see this code




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5


You need to change the first 'md5' to 'trust', like this




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5



Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration



If none of that works, or you need help or don't understand something, please let me know. I am off to bed soon though, so I may not be available til tomorrow morning/afternoon.

George Jackson
07-16-2009, 01:41 AM
i tried everything that you said....none off passwords worked... when i changed md5 to trust it wont let me save it.. keeps saying..

cannot create the C:/program files (x86)PostgreSQL\8.3\data\pg_hbas.confile.

make sure the path and file name are correct.



I have HM on my main cpu and everything works great every single time.

I finally got a 2nd cpu and I am trying to put HM on it also. I will be available tomorrow evening.

Thanks again for your help. See you then.

netsrak
07-16-2009, 04:16 AM
cannot create the C:/program files (x86)PostgreSQL\8.3\data\pg_hbas.confile.

make sure the path and file name are correct.


It must be pg_hba.conf !

George Jackson
07-16-2009, 02:40 PM
It must be pg_hba.conf !

what does this mean ??

what do i have to do to get HM working on my new cpu ??

netsrak
07-16-2009, 02:54 PM
You created / edited the wrong file. The name of the file for which Fozzy posted the description is pg_hba.conf not pg_hbas.confile.
And you must change it as administrator.

I think the best is if we help you out: Please schedule a remote support session with our support manager. Email fabio@holdemmanager.net, with a link to this thread and your forum name, so he can setup a Teamviewer session.

fozzy71
07-16-2009, 02:56 PM
what does this mean ??

what do i have to do to get HM working on my new cpu ??

It means you need to edit and save this file:



........
Edit pg_hba.conf
......

That file is located at: C:\Program Files\PostgreSQL\8.3\data


It seems you made a typo at some point:


....

cannot create the C:/program files (x86)PostgreSQL\8.3\data\pg_hbas.confile.

make sure the path and file name are correct.


......

If you need assistance with getting this sorted out, you can email me to setup a remote support session.

Please email fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer (http://www.teamviewer.com) session. Download and install the Teamviewer software using all the default settings.

George Jackson
07-16-2009, 03:16 PM
It means you need to edit and save this file:




That file is located at: C:\Program Files\PostgreSQL\8.3\data


It seems you made a typo at some point:



If you need assistance with getting this sorted out, you can email me to setup a remote support session.

Please email fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer (http://www.teamviewer.com) session. Download and install the Teamviewer software using all the default settings.



wow.. i feel dumb.. sending email right now.