Error: Fatal: 3D000... during install

[sarvam]

Greetings.

I'm trying install HM2 and receive this error

http://img32.imageshack.us/img32/2647/3d000.png

This happened when I tried install HM2 without install PostgreSQL, because I already have it (v8.3) when install for first time the Pokerstrategy.com Elephant. (also installed HM1 after Elephant and there was no problems).

So I uninstalled HM2 and tried install again this time selecting PostgreSQL install too.
Then this window appears

http://img96.imageshack.us/img96/6060/postgredetected.png

I put the right data (user: elephant / pwd: 111111) and the fatal error appear again.


Thanks in advance.

[sarvam]

I've tried this:
Went to pgAdmin III and created a new database with the name elephant.
Whit this I get success.

http://img35.imageshack.us/img35/2011/sucessn.png

By clicking in Next, appear a new window to create a new database with the name HoldemManager2

http://img89.imageshack.us/img89/9893/holdemmanager2.png

I've clicked in Next--> selected Import from HM1--> Next and the following errors occurred

http://img198.imageshack.us/img198/9771/error42704.png

http://img706.imageshack.us/img706/5807/cantcontinue.png

http://img96.imageshack.us/img96/1068/restarty.png

I've tried again this time selecting Not import and the errors occurred again.


Now I have no idea how fix this. Almost cried :D

[sarvam]

Finally I did it!

I've installed PostgreSQL 8.4 from here Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows) (without uninstall 8.3 version).

Then during the installation I put the postgrespass as password to the postgres user.

http://img41.imageshack.us/img41/4213/57466692.png

The installer set 5433 as the number of the port.

Then I went to pgAdmin III and deleted the elephant database (only doing this I was allowed to put the new data when open the HM2).

http://img685.imageshack.us/img685/9162/success5433.png

This appear again

http://img89.imageshack.us/img89/9893/holdemmanager2.png

I've clicked Next. But this time the window to select a db to import doesn't show. But its ok, its working.


Now I wonder if there is a easy way to solve this problem (if this is really a problem and not something I've mad wrong :D)
Can you developers tell me where or what I did wrong?


Cheers.

[Sarek]

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)

[sarvam]

Hey Sarek,

This worked just very fine. Thanks for the quick answer.


Cheers.