Thread: beginner: what permissions required to install on windows 2000+

beginner: what permissions required to install on windows 2000+

From
Dee
Date:
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.

Re: beginner: what permissions required to install on windows 2000+

From
Dee
Date:
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.

Re: beginner: what permissions required to install on windows 2000+

From
Raymond O'Donnell
Date:
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
---------------------------------------------------------------

Re: beginner: what permissions required to install on windows 2000+

From
"Harald Armin Massa"
Date:
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.
Anybody else have any other suggestions?

Please CC me on any responses, so I can respond promptly.


Details:
==============================================

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="">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 ==============================================================


Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
FOLLOW UP FOR THE ARCHIVES: 
Thanks to some assistance from another forum, I was finally able to install version 8.2, using the filemon.exe utitlity to track down file permission problems. Here are the changes I made. Disclaimer, I tried a lot of different things, so it may not be everything.

Installers:
Success with installers: 8.1.11-1, 8.2.5-1 and 8.2.6-2

1. Created windows user name: postgres

2. Under Local security policy > granted user rights assignment:
- Log on as service
- Log on locally


3. Granted "postgres" account
- Read & Execute permission
- Read permission

On the following files:
=======================================
C:\WINNT\system32\cmd.exe
C:\WINNT\system32\WSOCK32.dll
C:\WINNT\system32\WS2_32.DLL
C:\WINNT\system32\WS2HELP.DLL
C:\WINNT\system32\SHFOLDER.DLL
C:\WINNT\system32\IMM32.DLL
C:\WINNT\System32\rnr20.dll
C:\WINNT\system32\DNSAPI.DLL
C:\WINNT\System32\winrnr.dll
C:\WINNT\system32\iphlpapi.dll
C:\WINNT\system32\rasadhlp.dll
C:\WINNT\system32\msafd.dll
C:\WINNT\system32\ICMP.dll
C:\WINNT\system32\RTUTILS.DLL
C:\WINNT\System32\wshtcpip.dll
C:\WINNT\system32\netmsg.dll


4. Granted "postgres" account
- Read & Execute permission
- List Folder Contents
- Read permission

On the following folders:
=======================================
C:\Documents and Settings\

Note: 8.3.0-1 never would install. Whenever I tried to use an existing windows account, the installer returns the error "
Invalid username specified: A required privilege is not held by the client"


Dee <devlists.email@yahoo.com> wrote:
Anybody else have any other suggestions?

Please CC me on any responses, so I can respond promptly.


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