PDA

View Full Version : Cannot log into postgre



ccpsc
10-07-2009, 10:17 PM
Hi, I have just installed HM and i allready had postres installed but HM won't log in.

I start HM and the db control panel comes up and I click connect, a popup comes up and it says "The username and/or password was incorrect. Would you like to have HM configure the db to accept this login and password?".

I click yes another popup come up and it says "HM updated PostgreSQL. Please try connecting again."

I click OK and then click on Connect again only to be taken through the same proceedure again.

How do I fix this?

netsrak
10-08-2009, 02:27 AM
You had postgresql installed with another application?
Then you need to use the same settings as in this older application - there should be a possibility to view this settings (for example in Pokertracker 3 its database management).

After successful connection with Holdemmanager you need to create a new database.

ccpsc
10-08-2009, 02:31 AM
I have Vista so I tried compatability for the exe and hud files and it works. thanks

Lievaai
10-15-2009, 08:31 PM
hi

i have the same problem.
i used to have pt3 wich i deleted, and now hm cant connect to postgre.
since i allready deleted my pt3, i cant view the login settings for postgre..

what should i do?

fozzy71
10-15-2009, 08:48 PM
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



Otherwise you can do a clean reinstall of postgresql if you dont care about the old data.


For uninstalling SQL 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

Lievaai
10-16-2009, 11:39 AM
thank you :)