Обсуждение: Problem with windows installer
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)
Andreas 'ads' Scherbaum wrote: > 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. See the FAQ at http://www.postgresql.org/docs/faqs.FAQ_windows.html#3.3 (question 3.3). //Magnus
Magnus Hagander wrote: > Andreas 'ads' Scherbaum wrote: >> 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. > > See the FAQ at http://www.postgresql.org/docs/faqs.FAQ_windows.html#3.3 > (question 3.3). I discussed this briefly with Robert on IM yesterday - he told me the account was installer created. Without a PC at the time I couldn't look into it further :-( Regards, Dave.
On Thu, 04 Jan 2007 22:55:52 +0000 Dave Page <dpage@postgresql.org> wrote: > Magnus Hagander wrote: > > > See the FAQ at http://www.postgresql.org/docs/faqs.FAQ_windows.html#3.3 > > (question 3.3). > > I discussed this briefly with Robert on IM yesterday - he told me the > account was installer created. Without a PC at the time I couldn't look > into it further :-( We tried both, let the installer create the user (this works, he also added the service part) and create the user manually (and let the installer do the service part). In any case the installer stops at initdb. Bye -- Andreas 'ads' Scherbaum Failure is not an option. It comes bundled with your Microsoft product.(Ferenc Mantfeld)
> >> 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. > > > > See the FAQ at http://www.postgresql.org/docs/faqs.FAQ_windows.html#3.3 > > (question 3.3). > > I discussed this briefly with Robert on IM yesterday - he told me the > account was installer created. Without a PC at the time I couldn't look > into it further :-( The faq still applies as the most likely reason. It can certainly happen with the installer created account as well, forexample due to a group policy on the computer or domain. /Magnus
Magnus Hagander wrote: >> I discussed this briefly with Robert on IM yesterday - he told me the >> account was installer created. Without a PC at the time I couldn't look >> into it further :-( > > The faq still applies as the most likely reason. It can certainly happen > with the installer created account as well, for example due to a group > policy on the computer or domain. Of course, but what was also not mentioned is that this is a standalone machine with auto-login, so GP would not be an issues. Local policy could be I guess, but I would imagine Andreas hasn't tweaked that given that he's got no access control in place. Regards, Dave.
On Fri, Jan 05, 2007 at 08:30:58AM +0000, Dave Page wrote: > Magnus Hagander wrote: > >> I discussed this briefly with Robert on IM yesterday - he told me the > >> account was installer created. Without a PC at the time I couldn't look > >> into it further :-( > > > > The faq still applies as the most likely reason. It can certainly happen > > with the installer created account as well, for example due to a group > > policy on the computer or domain. > > Of course, but what was also not mentioned is that this is a standalone > machine with auto-login, so GP would not be an issues. Local policy > could be I guess, but I would imagine Andreas hasn't tweaked that given > that he's got no access control in place. > Point. I'm back to referring to the FAQ suggestion to enable auditing to see exactly what it's failing on. ;-) //Magnus