PDA

View Full Version : I can't install postgreSQL



Enath93
07-17-2011, 06:17 PM
Hello,

It's my first message here, so I'm gonna present myself first of all.

I'm 18 and come from Switzerland, I've been playing NL online cash game for 2 months and as I appear to love it, decided I was needing a tracker, and chose yours.

However, as I tried to install the trial version, postgreSQL refuses to install.
Here's a screen : http://s3.noelshack.com/uploads/images/1208742873624_hmfaitchier.png
I tried to install PostgreSQL separetly, but it didn't work either, and I also saw that maybe I should change something in windows 32, but the html is already correct, so I'm totally lost currently because I really need the tracker.

Thanks a lot for having read me,

Nath

P.S. Please forgive the mistakes I may have done, my english isn't perfect, but I tried my best :)

Patvs
07-17-2011, 07:51 PM
Make sure the secondary logon is running:
The secondary logon service is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services. Starting it once should insure it works in the future also.


Manually install PostgreSQL 8.4.4 with the installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)
http://faq.holdemmanager.com/questions/91/Can%27tConnect%7B47%7DFailedToStartPostgreSQL

Enath93
07-18-2011, 05:56 PM
Hi again.

I switched the secondary logon as you adviced me to. I then retried to install postgreSQL with the "combo installer" but encountered the same problem.

When I try to install it separately, it asks me a superueser passowrd. I put twice a random passowrd as I'm supposed to (I guess), but he says it's incorrect. So there's probably a password saved somewhere but I've no idea what it is (I tried all the passwords I use normally, but none seems to work.

Patvs
07-18-2011, 06:33 PM
Try: postgrespass

If it doesn't accept it, delete the postgres user: click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.
(and it will accept any password... use: postgrespass)

Enath93
07-19-2011, 04:27 PM
Ok, I could change the password, which is now postgrespass and I think (even if I'm not sure) Postgresql may have been installed correctly.

However, what do I have to do here, as the base doesen't appear ?http://cislashack.com/images/hm0.png

If I try to create a base, he tells me this :
"The following error occured when trying to initialise the Holdem Manager Database :ERROR 42704 : role "nath" doese not exist. "

Even if it seems very complicated, I want to take for the time you already used for me.

Also, I'm beginning to think that I should call an infromaticien, do you think he can help solve the matter, even if he knows nothing about poker ?

Patvs
07-19-2011, 05:56 PM
Open dbcontrolpanel.exe again.
Username: postgres (not: Nath)
Password: postgrespass



Then try creating a database.

Enath93
07-19-2011, 06:40 PM
I can only connect mysel with the "nath" login (I chose the first time I installed it). However I can't change, if I try to supress postgresql, redo it and change the login, he sais me a login is already effective and that I can't change it.

netsrak
07-20-2011, 03:57 AM
So you postgresql up and running and you can connect with the "nath" user?
That should work, enter this user in the HEM database management and create a new database.

Enath93
07-20-2011, 09:00 AM
What do you mean ?

In the DBcontrol Panel, I can only connect myself with the Nath login (postgres / postgrespass... all donīt work ). But after I am connected, if I try to create a new base, he tells me I canīt beacause the "role" (no idea what a role is :) ) nath (my login) doesenīt exist.

Iīve no clue where that comes from. The fact that I can connect with and only with "Nath" shows that this login should work.

Does that mean, that postgreSQL isnīt installed afterall (even if I didnīt get any error that time) ?

Patvs
07-20-2011, 02:11 PM
"Nath" is your main user account right?

PostgreSQL requires a secondary user called "postgres".
So reinstall PostgreSQL with the installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)
User = postgres
password = postgrespass

sjokkomoes
07-21-2011, 11:10 AM
I am also having this problem, I am doing a full reinstall and getting the same error message.

sjokkomoes
07-21-2011, 11:16 AM
In attachment a screenshot with detailed error code.

Patvs
07-21-2011, 06:58 PM
Use the 8.4.8 installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

sjokkomoes
07-22-2011, 07:36 AM
I can't find where to download the installer for 8.4.8. The website is very confusing if you are not into computer stuff.

sjokkomoes
07-22-2011, 07:57 AM
Hi Ive found an easier fix, ive ran the HEM installer as admin, which seems to have solved postgreSQL not installing

Enath93
07-30-2011, 11:23 AM
Hi again,

Yean "Nath" is my account name. I tried to uninstall and reinstall multiple times, but he doesen't let me change the logins and password. He tells me that I have to clear the datas to change the stuff (which I have no idea how to do).

Moreover, my 15 days are over now... It's not a problem for me to buy the definitive version, because I know HM Manager works very well and don't really need to try it but I just want to be sure, it's going to work.

Patvs
07-30-2011, 05:28 PM
PM sent