PDA

View Full Version : PostgreSQL and HEM problem



Goobertron
10-23-2009, 01:13 PM
I formatted my pc yesterday to do a clean install of Windows 7 and i have just now tried to install postgreSQL and HEM. I downloaded the latest version of Postgresql and it installed with no issues. I then restored my backed up database following the FAQ. I then installed the latest beta of HEM. When i launch HEM i get an error message saying 'Could not find Config\Holdemmanager.config file. Make sure you are running holdem manager from the correct directory.'

After click OK a bunch of times (the message repeats about 5 times) i eventually get to the Database Control Panel. When i click connect it says 'The username and/or password are incorrect. Would you like Holdem Manager to configure the database to accept this login and password?' I click yes and then get the message 'Sorry, Holdem manager was unable to make this change.'

I've read some of the other threads but didn't come across a solution.

Thanks.

fozzy71
10-23-2009, 02:30 PM
Did you install the same version of postgresql that was on the old PC? When creating the new DB to restore to, did you choose sqlascii encoding? or utf?



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