Re: beginner: what permissions required to install on windows 2000+
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.
Import Notes
Resolved by subject fallback