PDA

View Full Version : How to setup when PostGreSQL exists



DukeLeto
10-23-2009, 03:01 PM
Hi everyone,

I have used Poker Tracker for a number of years and recently heard many worth appraisals of holdem manager and wanted to try it out.

PostGreSQL 8.3 exists because Poker Tracker uses it. I tried a few things, finally gave up and uninstalled it hoping my 15 days would stop counting.

How should I go about setting up hold em manager in this environment.

Thanks

fozzy71
10-23-2009, 04:07 PM
Yes, you could have probably connected HEM tot he previous SQL installation. In your case tho, please make sure it is fully uninstalled before installing it again.


Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Vista: Turn off UAC - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

For reinstalling SQL to a new/empty DB, please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > run > cmd >

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

DukeLeto
10-23-2009, 04:14 PM
Hi fozzy and thanks for the reply.

Actually, ive been too many hours at the keyboard today. What I should have said is that I unstalled Holdem Manager. PostGres is still on the computer.

What is the best way to proceed? As above, or to connect with the existing installation?

Thanks,

fozzy71
10-23-2009, 08:33 PM
Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or else you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select "Run as admin" from the popup menu. Windows 7 you MUST set all the executables to always run as admin.

Turn off Windows Firewall for installing HM and PostgreSQL. You must also add exceptions to the Windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

* Install the complete setup of HM: http://www.holdemmanager.com/downloads/holdemmanager.zip
* Download the latest patch HM: http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

* Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows



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

svcpass is another possibility


Go to your command function (for Vista users, type cmd in search) and type net user. This will show you which user groups are on your pc.

Net user will tell you what the user is on your machine.

If you still can't get connected thru HM you can either try to remove the password requirement entirely.


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



Search the FAQ for the setup guide for your poker site:

http://www.holdemmanager.net/faq/afmmain.aspx