Re: [GENERAL] beginner: what permissions required to install on windows 2000+
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 [EMAIL PROTECTED] 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.
Re: [GENERAL] 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 (0xc022). 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=130) 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.
Re: [GENERAL] beginner: what permissions required to install on windows 2000+
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 [EMAIL PROTECTED] 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 (0xc022). 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.
Re: [GENERAL] beginner: what permissions required to install on windows 2000+
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 (0xc022). 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=130) 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
Re: [GENERAL] beginner: what permissions required to install on windows 2000+
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 [EMAIL PROTECTED] --- ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] beginner: what permissions required to install on windows 2000+
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 (0xc022). 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! ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [GENERAL] 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 [EMAIL PROTECTED] 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 (0xc022). 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.
[GENERAL] beginner: what permissions required to install on windows 2000+
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 (0xc022). 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.
