Service user account could not be created

First of all an apology if I've posted on the wrong forum but it wasn't obvious to me where the best place was to ask questions about postgreSQL installation issues for Windows. Any advice ?

I'm trying to install postgreSQL 8.3 using the "postgreSQL8.3.5-1-windows.exe" installer application on a Windows 2003 Server SP2.

The installation appears to fail and the error message I get is "Problem running post-install step. Installation may not complete correctly. The service user account 'postgres' could not be created".

But when I check in "Active Directory Users and Computers" the new 'postgres' account is there.

I do end up with a new "PostgreSQL8.3 / pgAdminIII" application but when I go into it there are no Servers (i.e. Servers(0) ).
And when I go to the "Services.msc" there is no mention of anything to do with postgres.

So what I'm not sure about is have I successfully installed postgreSQL or not ? And if I have what do I need to do next to set up the Servers ?

Thanks
Peter Turvey

I seem to have made a bit of progress now.
I used the pgInstaller instead of the one-click installer and that seemed to be a lot better.

I now have a service called "PostgreSQL Database Server 8.3" and when I run up pgAdmin it looks a lot healthier than it did before.

One thing I did have to do was turn on a service called "Secondary Logon Service" which apparantly was needed to initialize the database.
The one-click installer did not tell me this so that's probably why it didn't work.

Just for future reference, am I posting on the correct forum ?

Cheers
Peter Turvey

Peter_T wrote:I seem to have made a bit of progress now.
I used the pgInstaller instead of the one-click installer and that seemed to be a lot better.

I now have a service called "PostgreSQL Database Server 8.3" and when I run up pgAdmin it looks a lot healthier than it did before.

One thing I did have to do was turn on a service called "Secondary Logon Service" which apparantly was needed to initialize the database.
The one-click installer did not tell me this so that's probably why it didn't work.

Hi Peter,

Is the server a domain controller, or member of a domain?

In your temp directory (normally under C:\Documents and Settings\<username>\Local Settings\Temp), there should be an installation log called bitrock_installer.log (there may be a number in the filename as well). Can you post the tail end of the log, where it runs the installer scripts after it finishes copying files please? Be sure to mask out any instances of the password you selected first!

Peter_T wrote:
Just for future reference, am I posting on the correct forum ?

No, but that's our fault for not properly labeling the correct forum (which is being fixed). For future threads, there is another forum for the one-click installers at http://forums.enterprisedb.com/forums/show/9.page. Sorry about that.

Regards, Dave.

Thanks for the reply Dave.

Yes the Server is a Domain Controller.

There didn't appear to be a "bitrock_installer.log" for my successful installation when I used pgInstaller.
When I used this Installer I got asked a few more questions than I had done using the one-click installer. When I was asked to create a user called "postgres" there was another box on the form where I entered the domain name.

The unsuccessful installation when I used the "postgresql-8.3.5-1-windows.exe" one-click installer did have a "bitrock_installer.log".
The error message was

Executing d:\Program Files\PostgreSQL\8.3\installer\server\createuser.exe
Script stderr :
Internal account lookup failure : No mapping between account names and security IDs was done.
Error running "d:\Program Files\PostgreSQL\8.3\installer\server\createuser.exe". "postgres" <password> :
Internal account lookup failure : No mapping between account names and security IDs was done.

Peter_T wrote:Thanks for the reply Dave.

Yes the Server is a Domain Controller.

There didn't appear to be a "bitrock_installer.log" for my successful installation when I used pgInstaller.
When I used this Installer I got asked a few more questions than I had done using the one-click installer. When I was asked to create a user called "postgres" there was another box on the form where I entered the domain name.

The unsuccessful installation when I used the "postgresql-8.3.5-1-windows.exe" one-click installer did have a "bitrock_installer.log".
The error message was

Executing d:\Program Files\PostgreSQL\8.3\installer\server\createuser.exe
Script stderr :
Internal account lookup failure : No mapping between account names and security IDs was done.
Error running "d:\Program Files\PostgreSQL\8.3\installer\server\createuser.exe". "postgres" <password> :
Internal account lookup failure : No mapping between account names and security IDs was done.

Hi Peter,

You will only get the bitrock_installer.log from the one-click installer (which is the one that we - EnterpriseDB - publish). The other installer is a community project (which I also happen to work on, but that's another story).

Anyway, thanks for the info - I'll setup a test domain here and try to figure out the problem for future users.

Dave_P wrote:
Anyway, thanks for the info - I'll setup a test domain here and try to figure out the problem for future users.

This has now been fixed for the next release (8.3.5-2 or 8.3.6-1).

Regards, Dave.

The bug was not fixed in the latest version 8.3.6-1

The simple and funny solution is re-install with a complex password

.
The program should ask for a complex password at first or give the reason of failure

null wrote:The bug was not fixed in the latest version 8.3.6-1
The simple and funny solution is re-install with a complex password .
The program should ask for a complex password at first or give the reason of failure

If the problem you see is related to password complexity, then it is not the same problem as originally reported on this thread (although, the generic error message may well be the same).

We don't have any way to tell what the password complexity requirements of a given security policy are, but we should be able to give an appropriate error message if a password is rejected for the reason. I'll look into that.

I have tried to install postgresql-8.3.7-1-windows.exe and found a dialogbox with the message 'CREATE~1.EXE hat ein Problem festgestellt und muss beendet werden.'. Aftre I clicked on 'nicht senden' button came another dialogbox with the message 'The service user account 'postgres counld not be created.' Install faild.

Hi jian,

Can you please share some more details?
i.e. Operating System, Locale, etc.

Thanks,
Ashesh

Hi,

I had the same issue, and the problem seemed to be the password complexity.
Installing again, with a complex password resolved it.

Hello

im from brazil, i dont speack english.

I have the same problem.

sussesso installation will only take place if the account is.

if the server is installed with the active directory will not work.

I have not found a solution

can someone help me?

Even if the password already meets the password complexity requirements (password I was using was dgh@4563689), I still get the error in domain controller windows server standard 2008 IBM x series server. Server is running Active Directory.

Postgres version I am using is 8.4.1.6 STANDARD(the bitrock installer) and installation is in in silent mode.

I searched several similar threads but none could solve the issue.

There are two different ways in which i tried installing:

Way 1:
When I tried installing with username "postgres", I get the error: "User postgres already exists." - I searched the local Domain Controller PC as well as the active directory but there was no postgres user. At this situation I created a postgres user using NET USER successfully but I do not know why the postgres is telling me that a user already exists.

Way 2:
When I tried installing with DOMAINNAME\postgres or postgres@DOMAINNAME, I get message "User postgres successfully hidden from logon" and then the error: "No mapping between account names and security IDs was done. "

What am I missing, or is there any other way out of this problem so that postgres can be installed in Domain Controller without any problem ?

Any help would be greatly appreciated..

Thanks ..