SCM

[#1000733] Cannot create user (Windows Vista only)

View Trackers | Bugs | Download .csv | Monitor

Date:
2006-09-19 14:05
Priority:
3
State:
Closed
Submitted by:
John Meyer (pueblonative)
Assigned to:
Dave Page (dpage)
Category:
Installer error
Group:
Final release
Summary:
Cannot create user (Windows Vista only)

Detailed description
Installing under Windows Vista: Starter, and get through the installer, almost all the way, when it says, "cannot create user postgres: access denied" and it just rollsback

Followup

Message
Date: 2007-03-22 12:24
Sender: Dave Page

I've committed changes to the installer for 8.3 to allow installation on Vista whilst UAC is running. As this is quite an invasive change, it won't be backported to 8.2 or earlier.
Date: 2007-03-21 03:30
Sender: Nobody

Does anybody know how to install Postgres 8.2 on Windows Vista?
Date: 2007-01-13 17:16
Sender: d na

I execute the final 8.2.1 msi installer as Administrator and this works well, without any problems on Vista Buissness Edition.
Date: 2007-01-06 23:17
Sender: Nobody

I don't know if this will be helpful to anybody or not, but here's my approach to this situation.

Rather than [temporarily] disable UAC (both enabling and disabling UAC requires a perhaps timely reboot), run a Command Prompt as Administrator (by right-clicking on the shortcut), then directly execute the postgresql-8.2.msi from that command prompt. Doing this, I had no installation problems on Vista RTM.
Date: 2006-12-03 00:56
Sender: Nobody

I found that you can work around this issue by (temporarily) disabling User Account Control (UAC) feature of windows vista (setting configurable in control panel user account management)
Date: 2006-10-30 22:06
Sender: Nobody

I donĀ“t sepeak english, but:

For windows vista RC1

1. Log as user member of administrators

2. Start
Control panel
Administrative tools
Local security policy
Security settings
Local policies
Security options
Accounts: Administrator acount status
double click
Enable

3. start
right click "computer section"
manage
Local users and tools
users
right click administrator
set password
enter new password

4. log off

5. log as administrator

6. install postgress

7. for security reverse point number one and two to disable.

Camilo

Date: 2006-09-28 23:10
Sender: Zied Fakhfakh

I'm having the same issue
I created the user postgres, as normal and as administrator manually and still got an error, different from the first:
"Invalid username specified: Logon failure: the user has not been granted the requested logon type at this computer"

Hope it helps
Date: 2006-09-24 14:45
Sender: Magnus Hagander

Spoke to Dave, this is definitly confirmed. Also, changed the title to indicate that the problem exists only on Vista.

This won't be fixde in time for beta-1, but I'm not giving up on getting it done before release 8.2 :)
Date: 2006-09-19 14:58
Sender: Harald Armin Massa

"""I have created the user postgres, both as an administrator
and a normal user, and the installer still does not seem to
see it. It keeps saying "could not find user
COMPUTERNAME/postgres."
"""
Thanks for the clarification, John.

Is "COMPUTERNAME" really the output that is given by the
installer, or are you using it as a placeholder for you
actual computername?

I am asking this question as ONE possible error could be the
installer failing in getting the "COMPUTERNAME"

Within the Installer-Dialogs, can you please try to enter
your actual computername in the DOMAIN-Field?

And, please try to check the "availability" of that user,
maybe with:

runas /user:postgres@<computername> cmd

or
runas /user:<computername>/postgres cmd

(<computername> is of course to be substituted by your
computers name)

To find more information about the problem: You should be
able to install PostgreSQL WITHOUT installing PostgreSQL as
a service and WITHOUT creating a database cluster.

THEN you can login as postgres to your computer and run
initdb.exe as that user, creating the database. You should
than be able to manually start Postgres. (pg_ctl.exe)

THAT is of course no long time solution. But it can help to
"get over the installer problems" and see if there are
actual PostgreSQL Problems on Vista.

Thanks for your feedback so far,

Harald
Date: 2006-09-19 14:34
Sender: John Meyer

I have created the user postgres, both as an administrator
and a normal user, and the installer still does not seem to
see it. It keeps saying "could not find user
COMPUTERNAME/postgres."
And yes, I even tried installing it as user postgres, with
no luck.
Date: 2006-09-19 14:17
Sender: Harald Armin Massa

"""postgresql doesn't seem to be able to see the user."""

John, what exactly do you describe with "postgresql seeing
the user" ?

PostgreSQL has no real need to "see" a user - it just "has
to be logged in" as a user.

Or are you referring to "the installer does not detect the
postgres user" ?

To use an existing postgres user together with the
installer, it is your responsibility to give correct user
and password within the install dialogs.

Are you able to login as user postgres?

Can you do something along

runas /user:postgres cmd

from the commandline?

Harald


Date: 2006-09-19 14:10
Sender: John Meyer

Also, when the user is created, either as an administrator
or standard user, postgresql doesn't seem to be able to see
the user.

Attached Files:

Changes:

Field Old Value Date By
status_idOpen2007-03-22 12:24dpage
close_date2007-03-22 12:242007-03-22 12:24dpage
assigned_tonone2006-09-29 07:23mha
summaryCannot create user2006-09-24 14:45mha
Powered By FusionForge