Thread: Help! "Access is Denied" Installation on WinXP rolled back
Hi All! I googled for a solution to my problem and then searched the PostgreSQL site for solutions and since neither produced an answer I thought I'd see if anyone else out there knows how to resolve my dilemna... Any assistance is appreciated! Essentially what happens is that I just attempt to install PostgreSQL 8.0.2 with the default options and it nearly completes the installation but then on the step where it initializes (or whatever it's called) the database it crashes and rolls back the install. When I check the log file it tells me to check before it deletes it in the rollback it says repeatedly something about "access is denied". Below is the actual install log (or a small portion of it, near the end where the error occurs). Any ideas? Regards, Abe p.s. this is a repost from my initial post on the novice list... which I've become aware is relatively inactive. MSI (s) (C0:74) [11:03:22:531]: Source for file 'user_lockstxt' is compressed InstallFiles: File: README.user_locks, Directory: C:\Program Files\PostgreSQL\8.0\doc\contrib\, Size: 2723 MSI (s) (C0:74) [11:03:22:531]: Note: 1: 2318 2: C:\Program Files\PostgreSQL\8.0\doc\contrib\README.user_locks MSI (s) (C0:74) [11:03:22:531]: Executing op: FileCopy(SourceName=readm~1.vac|README.vacuumlo,SourceCabKey=vacuumlotxt,DestName=README.vacuumlo,Attributes=0,FileSize=1449,PerTick=32768,,VerifyMedia=1,,,,,CheckCRC=0,,,InstallMode=58982400,HashOptions=0,HashPart1=-1578222883,HashPart2=1022240769,HashPart3=1742458498,HashPart4=808312946,,) MSI (s) (C0:74) [11:03:22:531]: File: C:\Program Files\PostgreSQL\8.0\doc\contrib\README.vacuumlo; To be installed; Won't patch; No existing file MSI (s) (C0:74) [11:03:22:531]: Source for file 'vacuumlotxt' is compressed InstallFiles: File: README.vacuumlo, Directory: C:\Program Files\PostgreSQL\8.0\doc\contrib\, Size: 1449 MSI (s) (C0:74) [11:03:22:531]: Note: 1: 2318 2: C:\Program Files\PostgreSQL\8.0\doc\contrib\README.vacuumlo MSI (s) (C0:74) [11:03:22:531]: Executing op: CacheSizeFlush(,) MSI (s) (C0:74) [11:03:22:531]: Executing op: InstallProtectedFiles(AllowUI=1) MSI (s) (C0:74) [11:03:22:531]: Executing op: ActionStart(Name=SetPermissions,Description=Setting filesystem permissions...,) Action 11:03:22: SetPermissions. Setting filesystem permissions... MSI (s) (C0:74) [11:03:22:531]: Executing op: CustomActionSchedule(Action=SetPermissions,ActionType=1025,Source=BinaryData,Target=SetPermissions@4,CustomActionData=1033;C:\Program Files\PostgreSQL\8.0\;C:\Program Files\PostgreSQL\8.0\data\;MYTHOS;postgres;u35351364) MSI (s) (C0:14) [11:03:22:546]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI100.tmp, Entrypoint: SetPermissions@4 MSI (s) (C0:74) [11:03:23:375]: Executing op: ActionStart(Name=RunInitdb,Description=Initializing database cluster (this may take a minute or two)...,) Action 11:03:23: RunInitdb. Initializing database cluster (this may take a minute or two)... MSI (s) (C0:74) [11:03:23:390]: Executing op: CustomActionSchedule(Action=RunInitdb,ActionType=1025,Source=BinaryData,Target=RunInitdb@4,CustomActionData=1033;C:\Program Files\PostgreSQL\8.0\;C:\Program Files\PostgreSQL\8.0\data\;5432;1;C;SQL_ASCII;postgres;u35351364;MYTHOS;postgres;u35351364) MSI (s) (C0:14) [11:03:23:390]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI101.tmp, Entrypoint: RunInitdb@4 MSI (c) (04:34) [11:03:27:031]: Note: 1: 2205 2: 3: Error MSI (c) (04:34) [11:03:27:031]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 2867 DEBUG: Error 2867: The error dialog property is not set The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2867. The arguments are: , , MSI (c) (04:34) [11:03:27:031]: Font created. Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg Failed to run initdb: 1! Please see the logfile in 'C:\Program Files\PostgreSQL\8.0\tmp\initdb.log'. Note! You must read/copy this logfile before you click OK, or it will be automatically removed. MSI (s) (C0!3C) [11:03:32:093]: Note: 1: 2205 2: 3: Error MSI (s) (C0!3C) [11:03:32:093]: Note: 1: 2228 2: 3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 MSI (s) (C0!3C) [11:03:32:093]: Product: PostgreSQL 8.0 -- Failed to run initdb: 1! Please see the logfile in 'C:\Program Files\PostgreSQL\8.0\tmp\initdb.log'. Note! You must read/copy this logfile before you click OK, or it will be automatically removed. Action ended 11:03:32: InstallFinalize. Return value 3. MSI (s) (C0:74) [11:03:32:109]: User policy value 'DisableRollback' is 0 MSI (s) (C0:74) [11:03:32:109]: Machine policy value 'DisableRollback' is 0 MSI (s) (C0:74) [11:03:32:531]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=848320614,LangId=1033,Platform=0,ScriptType=2,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1) MSI (s) (C0:74) [11:03:32:531]: Executing op: DialogInfo(Type=0,Argument=1033) MSI (s) (C0:74) [11:03:32:531]: Executing op: DialogInfo(Type=1,Argument=PostgreSQL 8.0) MSI (s) (C0:74) [11:03:32:531]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1]) Action 11:03:32: Rollback. Rolling back action:
Attachment
> log file it tells me to check before it deletes it in the rollback it says > repeatedly something about "access is denied". Below is the actual install > log (or a small portion of it, near the end where the error occurs). Any > ideas? > Regards, Abe > p.s. this is a repost from my initial post on the novice list... which I've > become aware is relatively inactive. Did you check the initdb.log that was referenced in your Windows error message? I do not "know" this to be your issue but I am guess that you tried to install PostgreSQL with Administrator (or as an Administrator) rights. PostgreSQL must be installed as a non Administrative user on Windows. Sincerely, Joshua D. Drake -- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564 Custom programming, 24x7 support, managed services, and hosting Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG Reliable replication, Mammoth Replicator - http://www.commandprompt.com/
Thanks for helping Joshua! While I do attempt to install PostgreSQL using my normal windows account (which of course has administrative rights), I've installed PostgreSQL before and never run into this problem. It appears that as long as you establish a different user name which isn't an administrator to run the service under then it should be ok. The problem with actually attempting to do the entire install under a non-administrative account is that naturally windows doesn't let it touch any system directories (i.e. the Windows directory - which PostgreSQL needs access to) and won't let it modify any permissions. Essentially, literally installing an application with a non-administrative account is nearly impossible because that's the whole purpose of having such things as non-administrative accounts. I'm probably preaching to the choir here. Sorry about that. Here's the contents of my init.db log if it helps... >>>>>>>>>>>>>>>>>>>>>>>>>> The files belonging to this database system will be owned by user "Administrator". This user must also own the server process. The database cluster will be initialized with locale C. fixing permissions on existing directory C:/Program Files/PostgreSQL/8.0/data ... ok creating directory C:/Program Files/PostgreSQL/8.0/data/global ... ok creating directory C:/Program Files/PostgreSQL/8.0/data/pg_xlog ... ok creating directory C:/Program Files/PostgreSQL/8.0/data/pg_xlog/archive_status ... ok creating directory C:/Program Files/PostgreSQL/8.0/data/pg_clog ... ok creating directory C:/Program Files/PostgreSQL/8.0/data/pg_subtrans ... ok creating directory C:/Program Files/PostgreSQL/8.0/data/base ... ok creating directory C:/Program Files/PostgreSQL/8.0/data/base/1 ... ok creating directory C:/Program Files/PostgreSQL/8.0/data/pg_tblspc ... ok selecting default max_connections ... Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. 10 selecting default shared_buffers ... Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. Access is denied. 50 creating configuration files ... ok creating template1 database in C:/Program Files/PostgreSQL/8.0/data/base/1 ... ok initializing pg_shadow ... Access is denied. child process was terminated by signal 1 initdb: removing contents of data directory "C:/Program Files/PostgreSQL/8.0/data" Joshua D. Drake wrote: >> log file it tells me to check before it deletes it in the rollback >> it says repeatedly something about "access is denied". Below is the >> actual install log (or a small portion of it, near the end where the >> error occurs). Any ideas? Regards, Abe p.s. this is a repost from my >> initial post on the novice list... which I've become aware is >> relatively inactive. > > > Did you check the initdb.log that was referenced in your Windows error > message? > > I do not "know" this to be your issue but I am guess that you tried to > install PostgreSQL with Administrator (or as an Administrator) rights. > > PostgreSQL must be installed as a non Administrative user on Windows. > > Sincerely, > > Joshua D. Drake > > > >
Attachment
On Tue, Apr 19, 2005 at 11:31:50AM -0600, Abe Burnett wrote: > Essentially, literally installing an application with a > non-administrative account is nearly impossible because that's the > whole purpose of having such things as non-administrative accounts. > I'm probably preaching to the choir here. Sorry about that. Here's the > contents of my init.db log if it helps... [snip] > selecting default max_connections ... Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > 10 > selecting default shared_buffers ... Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > Access is denied. > 50 Judging by the content of your log, I'd say the access that was denied has nothing to do with file or directory creation; it has to do with being able to set up shared memory. If the account you are using for installation doesn't have permissions to set even a minimally sized shared memory segment, there's no way Postgres can run. Note those settings are chosen not because they did work, but because they were the last setting that was tried. I think this is a bug: initdb should fail if not even the lowest setting can be used, instead of going ahead. -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) Officer Krupke, what are we to do? Gee, officer Krupke, Krup you! (West Side Story, "Gee, Officer Krupke")