Re: [HACKERS] Problem with windows installer
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. ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
Re: [HACKERS] Problem with windows installer
On Fri, Jan 05, 2007 at 08:30:58AM +, 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 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] Problem with windows installer
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 ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Problem with windows installer
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. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [HACKERS] Problem with windows installer
On Thu, 04 Jan 2007 22:55:52 + Dave Page [EMAIL PROTECTED] 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) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] 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. 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, for example due to a group policy on the computer or domain. /Magnus ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] 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't patch;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,[EMAIL PROTECTED],CustomActionData=1033;C:\Programme\PostgreSQL\8.0\;C:\Programme\PostgreSQL\8.0\data\;NET1;postgres;uNDDZarK/UM%RmfmZdyBB=)t_~|Qet) MSI (s) (A4:84) [22:40:18:359]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI25.tmp, Entrypoint: [EMAIL PROTECTED] MSI (s) (A4:4C) [22:40:19:546]: Executing op: ActionStart(Name=RunInitdb,Description=Initializing database cluster (this may 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,[EMAIL PROTECTED],CustomActionData=1033;C:\Programme\PostgreSQL\8.0\;C:\Programme\PostgreSQL\8.0\data\;5432;;C;SQL_ASCII;postgres;sick2468;NET1;postgres;uNDDZarK/UM%RmfmZdyBB=)t_~|Qet) MSI (s) (A4:BC) [22:40:19:562]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI26.tmp, Entrypoint: [EMAIL PROTECTED] 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 diesem Computer 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) ---(end of broadcast)--- TIP 6: explain analyze is your friend
