beginner: what permissions required to install on windows 2000+

Anyone?

Or is there a better list for asking installation questions? I could really use some help on this one.

Dee <devlists.email@yahoo.com> wrote: What are the permissions required to install postgres as a service on windows 2000/2003? I have followed the instructions, as I understand them, but the program will not install.

It either fails with "The application failed to initialize properly (0xc0000022). Click on OK to terminate the application." or "Invalid username specified: A required privlege is not held by the client".

---------------------------------
Never miss a thing. Make Yahoo your homepage.

---------------------------------
Never miss a thing. Make Yahoo your homepage.

On 01/03/2008 00:42, Dee wrote:

Or is there a better list for asking installation questions? I could
really use some help on this one.

I can't answer your immediate question, but I seem to recall this one
coming up more than once in the past - have you had a trawl through the
archives? - http://archives.postgresql.org/

HTH,

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

Dee,

What are the permissions required to install postgres as a service on
windows 2000/2003? I have followed the instructions, as I understand them,
but the program will not install.

It either fails with "The application failed to initialize properly
(0xc0000022). Click on OK to terminate the application." or "Invalid
username specified: A required privlege is not held by the client".

1.) you should prefer windows 2003 for your first PostgreSQL install
on windows. Installation on Windows 2000 is a lot more challenging.
BTW: main stream support for 2000 by Microsoft ended on 2005-06-30, so
unless you have contracts with MS for extended support...

2.) please be very carefull about the different permissions for
"INSTALLING" and "RUNNING" PostgreSQL on windows

To install PostgreSQL on windows you need permissions to:
- install software
- create a service
- change permissions on files / directories

To RUN PostgreSQL as a service on windows your serivce user needs
"LOGON_AS_SERVICE" privilege.

the usual install:
-> logon as Administrator
-> run the installer
-> the installer creates the windows-user postgres, per default for
the local machine, and adds the LOGON_AS_SERVICE privilege to the user

So, to drill down to your problem:
a) when did you get this error? During installation? That would point
more to problems with wrong version of installer, broken MSI-files....

--- if on running the service:
a) what user is the service configured to use to log on?
b) what policies are in effect on that user? Please be aware that a
lot of defaul policies do take away the "LOGON_AS_SERVICE" privilege
c) whats within the log files?

Harald
--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
fx 01212-5-13695179
-
EuroPython 2008 will take place in Vilnius, Lithuania - Stay tuned!

Ray

have you had a trawl through the archives?

Thanks for the response. Yes, I did. I tried a few things but did not find anything that seemed to apply. Though it's possible I may have missed something.

Dee <devlists.email@yahoo.com> wrote: What are the permissions required to install postgres as a service on windows 2000/2003? I have followed the instructions, as I understand them, but the program will not install.

It either fails with "The application failed to initialize properly (0xc0000022). Click on OK to terminate the application." or "Invalid username specified: A required privlege is not held by the client".

---------------------------------
Never miss a thing. Make Yahoo your homepage.

---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.

Harald,

Thanks for the response.

1.) you should prefer windows 2003 for your first PostgreSQL install
on windows. Installation on Windows 2000 is a lot more challenging.
BTW: main stream support for 2000 by Microsoft ended on 2005-06-30, so
unless you have contracts with MS for extended support...

Yes, you are right. Unfortunately, I am stuck with an old 2000 box for the moment. Though hopefully I will move it to one with a newer o/s in the near future.

2.) please be very carefull about the different permissions for
"INSTALLING" and "RUNNING" PostgreSQL on windows

Understood

So, to drill down to your problem:
a) when did you get this error? During installation? That would point
more to problems with wrong version of installer, broken MSI-files....

The error occurs during the installation of version postgresql-8.3.msi (8.3.0-1).

- I was logged in as a user with admin rights. Firewall s/w was disabled.
- In case that was not sufficient, I also tried the installation while logged in as the Adminstrator and after completely uninstalling firewall s/w. The same errors occur.

I have tried 2 approaches:

1) I accepted all of the default settings and allowed the installation program to create the windows-user postgres. An error occurs when the program reaches the status point "Starting services":

"The application failed to initialize properly (0xc0000022). Click on OK to terminate the application."

I have included a snippet from the installation log and a message from the windows event log below.

2) I also tried creating the local user acccount before the installation.
- I deleted the previous windows account and created a new one
- I granted the account "Log on Locally" and "Log on as service rights".
- When I try and run the installation again, I receive the error message
"Invalid username specified: A required privilege is not held by the client"

==== start: snippet from error log ==============================================================
Action 0:17:48: StartServices. Starting services
MSI (s) (BC:98) [00:17:48:875]: Executing op: ProgressTotal(Total=2,Type=1,ByteEquivalent=1300000)
MSI (s) (BC:98) [00:17:48:875]: Executing op: ServiceControl(,Name=pgsql-8.3,Action=1,Wait=1,)
StartServices: Service: PostgreSQL Database Server 8.3
MSI (c) (E4:E0) [00:20:45:062]: Note: 1: 2205 2: 3: Error
MSI (c) (E4:E0) [00:20:45:062]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2888
DEBUG: Error 2888: Executing the TextStyle view failed
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2888. The arguments are: TextStyle, ,
Action 0:20:46: Cancel. Dialog created
MSI (c) (E4:E0) [00:21:01:421]: Note: 1: 2205 2: 3: Error
MSI (c) (E4:E0) [00:21:01:421]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2888
DEBUG: Error 2888: Executing the TextStyle view failed
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2888. The arguments are: TextStyle, ,
MSI (s) (BC:98) [00:21:20:843]: Note: 1: 2205 2: 3: Error
MSI (s) (BC:98) [00:21:20:843]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1920
MSI (s) (BC:98) [00:21:20:875]: Note: 1: 2205 2: 3: Error
MSI (s) (BC:98) [00:21:20:875]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709
MSI (s) (BC:98) [00:21:20:875]: Product: PostgreSQL 8.3 -- Error 1920. Service 'PostgreSQL Database Server 8.3' (pgsql-8.3) failed to start. Verify that you have sufficient privileges to start system services.

MSI (s) (BC:98) [00:21:20:890]: Note: 1: 2205 2: 3: Error
MSI (s) (BC:98) [00:21:20:890]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1602
MSI (c) (E4:E0) [00:21:20:890]: Note: 1: 2205 2: 3: Error
MSI (c) (E4:E0) [00:21:20:890]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2835
DEBUG: Error 2835: The control ErrorIcon was not found on dialog ErrorDlg
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2835. The arguments are: ErrorIcon, ErrorDlg,
MSI (c) (E4:E0) [00:21:20:890]: Note: 1: 2205 2: 3: Error
MSI (c) (E4:E0) [00:21:20:890]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2888
DEBUG: Error 2888: Executing the TextStyle view failed
The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2888. The arguments are: TextStyle, ,
Are you sure you want to cancel?
==== end: snippet from error log ==============================================================

==== start: event log message ==============================================================
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7005
Date: 3/4/2008
Time: 12:20:50 AM
User: N/A
Computer: DEV
Description:
The LoadUserProfile call failed with the following error:
Access is denied.
==== end: event log message ==============================================================

---------------------------------
Looking for last minute shopping deals? Find them fast with Yahoo! Search.