Problem with windows installer - Mailing list pgsql-hackers

From Andreas 'ads' Scherbaum
Subject Problem with windows installer
Date
Msg-id 20070104013125.7be3f44b.adsmail@wars-nicht.de
Whole thread Raw
Responses Re: Problem with windows installer  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Hello all,

a friend of mine ran into a problem installing PostgreSQL 8.0.9 on a
Windows XP Pro machine. Before anyone is asking: it has to be a 8.0.x
version and we even tried to install 8.2 and it did not work.

Ok, the problem is: after installing all the files the installer wants
to init the db and fails with the following error:

"Failed to create process for initdb: Anmeldung fehlgeschlagen: Dem
Benutzer wurde der geforderte Anmeldetyp auf diesem Computer nicht
erteilt."

The german message means: "Login failed: a requested login
type was not given to the user on this computer."
Since the message was returned in german and the installer was
started in english, the message is generated by windows.


The (imho) relevant part from the install log is here:

----- log -----
MSI (s) (A4:4C) [22:40:18:343]: 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) (A4:4C) [22:40:18:343]: File: C:\Programme\PostgreSQL\8.0\doc\contrib\README.vacuumlo;    To be installed;
Won'tpatch;    No existing file
 
MSI (s) (A4:4C) [22:40:18:343]: Source for file 'vacuumlotxt' is compressed
InstallFiles: File: README.vacuumlo,  Directory: C:\Programme\PostgreSQL\8.0\doc\contrib\,  Size: 1449
MSI (s) (A4:4C) [22:40:18:343]: Note: 1: 2318 2: C:\Programme\PostgreSQL\8.0\doc\contrib\README.vacuumlo 
MSI (s) (A4:4C) [22:40:18:343]: Executing op: CacheSizeFlush(,)
MSI (s) (A4:4C) [22:40:18:343]: Executing op: InstallProtectedFiles(AllowUI=1)
MSI (s) (A4:4C) [22:40:18:343]: Executing op: ActionStart(Name=SetPermissions,Description=Setting filesystem
permissions...,)
Action 22:40:18: SetPermissions. Setting filesystem permissions...
MSI (s) (A4:4C) [22:40:18:343]: Executing op:
CustomActionSchedule(Action=SetPermissions,ActionType=1025,Source=BinaryData,Target=SetPermissions@4,CustomActionData=1033;C:\Programme\PostgreSQL\8.0\;C:\Programme\PostgreSQL\8.0\data\;NET1;postgres;uND&DZarK/UM%RmfmZdyBB=)t_~|Qet)
MSI (s) (A4:84) [22:40:18:359]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI25.tmp, Entrypoint:
SetPermissions@4
MSI (s) (A4:4C) [22:40:19:546]: Executing op: ActionStart(Name=RunInitdb,Description=Initializing database cluster
(thismay take a minute or two)...,)
 
Action 22:40:19: RunInitdb. Initializing database cluster (this may take a minute or two)...
MSI (s) (A4:4C) [22:40:19:546]: Executing op:
CustomActionSchedule(Action=RunInitdb,ActionType=1025,Source=BinaryData,Target=RunInitdb@4,CustomActionData=1033;C:\Programme\PostgreSQL\8.0\;C:\Programme\PostgreSQL\8.0\data\;5432;;C;SQL_ASCII;postgres;sick2468;NET1;postgres;uND&DZarK/UM%RmfmZdyBB=)t_~|Qet)
MSI (s) (A4:BC) [22:40:19:562]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI26.tmp, Entrypoint:
RunInitdb@4
MSI (c) (18:E0) [22:40:20:375]: Note: 1: 2205 2:  3: Error 
MSI (c) (18:E0) [22:40:20:375]: 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) (18:E0) [22:40:20:390]: Font created.  Charset: Req=0, Ret=0, Font: Req=MS Shell Dlg, Ret=MS Shell Dlg

Failed to create process for initdb: Anmeldung fehlgeschlagen: Dem Benutzer wurde der angeforderte Anmeldetyp auf
diesemComputer nicht erteilt.
 

MSI (s) (A4!E4) [22:40:52:421]: Note: 1: 2205 2:  3: Error 
MSI (s) (A4!E4) [22:40:52:421]: Note: 1: 2228 2:  3: Error 4: SELECT `Message` FROM `Error` WHERE `Error` = 1709 
MSI (s) (A4!E4) [22:40:52:421]: Product: PostgreSQL 8.0 -- Failed to create process for initdb: Anmeldung
fehlgeschlagen:Dem Benutzer wurde der angeforderte Anmeldetyp auf diesem Computer nicht erteilt.
 


Action ended 22:40:52: InstallFinalize. Return value 3.
MSI (s) (A4:4C) [22:40:52:421]: User policy value 'DisableRollback' is 0
MSI (s) (A4:4C) [22:40:52:421]: Machine policy value 'DisableRollback' is 0
----- log -----

Has anyone an idea, what's going wrong here and how to fix this?

Here are some ideas we already tried:
- manual creating of the postgres user
- remove all remnants of the installation including the created user
- checking for being a windows superuser
- testing the same package/version on two different systems, one XP Home and one XP Pro, works without errors
- and yes, some reboots


Thanks in advance for your help

--             Andreas 'ads' Scherbaum
Failure is not an option. It comes bundled with your Microsoft product.(Ferenc Mantfeld)


pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Tuning single row operations
Next
From: Jim Nasby
Date:
Subject: Re: Added the word TODO in comments