[Bug 15894] New: postgresql fails to install
http://bugs.winehq.org/show_bug.cgi?id=15894 Summary: postgresql fails to install Product: Wine Version: 1.1.7 Platform: Other URL: http://wwwmaster.postgresql.org/download/mirrors- ftp?file=%2Fbinary%2Fv8.3.4%2Fwin32%2Fpostgresql-8.3.4- 1.zip OS/Version: other Status: NEW Keywords: download, Installer Severity: normal Priority: P2 Component: -unknown AssignedTo: wine-bugs(a)winehq.org ReportedBy: jeffz(a)jeffz.name Created an attachment (id=17056) --> (http://bugs.winehq.org/attachment.cgi?id=17056) +process log wine-1.1.7 - postgresql-8.3.4-1.zip Run the setup.bat, click next on the installer, a message appears "failed to create process: 2!" and the installer exits. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Dan Kegel <dank(a)kegel.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dank(a)kegel.com --- Comment #1 from Dan Kegel <dank(a)kegel.com> 2009-03-10 22:37:25 --- +msi,+process shows: trace:process:CreateProcessW app L"msiexec.exe" cmdline L"msiexec.exe /i \"Z:\\home\\dank\\installers\\misc\\postgress83\\postgresql-8.3-int.msi\" INTERNALLAUNCH=1 INSTALLLANG=en" trace:process:open_exe_file looking for L"msiexec.exe" trace:msi:wait_thread_handle waiting for L"instpg" ... trace:msi:DllThread custom action (19) returned 1603 err:msi:ITERATE_Actions Execution halted, action L"instpg" returned 1603 -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |alexander.scott.johns+wineb | |ug(a)googlemail.com --- Comment #2 from Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> 2010-01-26 19:46:19 --- Bug still present with postgresql-8.3.9-1.zip [1] and wine-1.1.37-103-g356b06f. I was able to progress a bit by directly running the internal installer: $ wine msiexec /i postgresql-8.3-int.msi INTERNALLAUNCH=1 INSTALLLANG=en If I uncheck "Install as a service" on the "Service configuration" page, the installation starts, then stops with a "Fatal error" - "Installation ended prematurely because of an error:" message (I assume something is meant to appear after the ':'). If I leave "Install as a service" checked, the installer allows me to create a new user (not sure if this worked), then displays another error: "Service check" - "Failed to open the Secondary Logon service: Service does not exist". After I manage to get past this error, I then get the "Fatal error", as before. After the installation aborts (in both cases), I have some rather odd behaviour. Any attempt to run Wine displayed a postgres error message in the terminal: pg_ctl: no operation specified Try "pg_ctl --help" for more information I have to do a wineserver -k and rm -rf $WINEPREFIX/drive_c/Program\ Files/PostgreSQL/8.3 to get Wine into a sane state again. [1]: http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.3.9/win32/pos... -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #3 from Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> 2010-01-26 19:55:38 --- Created an attachment (id=25905) --> (http://bugs.winehq.org/attachment.cgi?id=25905) +msi log of attempting to install postgresql-8.3-int.msi This is with "Install as a service" unchecked. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #4 from Hans Leidekker <hans(a)meelstraat.net> 2010-01-27 02:46:02 --- Created an attachment (id=25908) --> (http://bugs.winehq.org/attachment.cgi?id=25908) msi: Name and arguments in the service control table are formatted strings. Does this patch help? -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #5 from Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> 2010-01-27 06:53:00 --- (In reply to comment #4)
Created an attachment (id=25908) --> (http://bugs.winehq.org/attachment.cgi?id=25908) [details] msi: Name and arguments in the service control table are formatted strings.
Does this patch help?
No. There is a slight change in the log (I think), but I still get the "Service check" and "Fatal Error" messages. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #6 from Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> 2010-01-27 06:54:55 --- Created an attachment (id=25909) --> (http://bugs.winehq.org/attachment.cgi?id=25909) +msi log of attempting to install postgresql-8.3-int.msi, after applying patch I unchecked "Install as a service" again. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Hans Leidekker <hans(a)meelstraat.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |hans(a)meelstraat.net --- Comment #7 from Hans Leidekker <hans(a)meelstraat.net> 2010-01-27 07:07:00 ---
trace:msi:MSI_GetPropertyW returning L"pgsql-8.3" for property L"SERVICEID" trace:msi:msiobj_release object 0x906058 destroyed err:msi:ITERATE_StartService Failed to start service L"pgsql-8.3"
So it uses the correct service name now, but fails to start the service. What happens if you leave "Install as a service" checked? -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #8 from Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> 2010-01-27 09:16:43 --- (In reply to comment #7)
trace:msi:MSI_GetPropertyW returning L"pgsql-8.3" for property L"SERVICEID" trace:msi:msiobj_release object 0x906058 destroyed err:msi:ITERATE_StartService Failed to start service L"pgsql-8.3"
So it uses the correct service name now, but fails to start the service. What happens if you leave "Install as a service" checked?
No change from comment #2; it dies in the same place. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #9 from Hans Leidekker <hans(a)meelstraat.net> 2010-01-27 09:32:43 --- A +msi,+relay,+service log might tell us why it fails to start the service. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #10 from Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> 2010-01-27 10:15:17 --- Created an attachment (id=25911) --> (http://bugs.winehq.org/attachment.cgi?id=25911) +msi,+relay,+service log of attempting to install postgresql-8.3-int.msi, after applying patch Last 900000 lines of log; compressed with rzip. I pressed ^C in the terminal when the "Fatal error" appeared. I RelayExclude'd kernel32.lstrcmpW; ntdll.RtlAllocateHeap; ntdll.RtlFreeHeap; kernel32.GetProcessHeap. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Hans Leidekker <hans(a)meelstraat.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #25908|0 |1 is obsolete| | --- Comment #11 from Hans Leidekker <hans(a)meelstraat.net> 2010-01-28 03:18:48 --- Created an attachment (id=25918) --> (http://bugs.winehq.org/attachment.cgi?id=25918) msi: Name and arguments in the service control table are formatted strings. The OpenService call succeeds, so the service exists. It's the StartService call that fails but unfortunately it's not clear why. Can you try once more with this patch applied? -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #12 from Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> 2010-01-28 08:31:56 --- (In reply to comment #11)
The OpenService call succeeds, so the service exists. It's the StartService call that fails but unfortunately it's not clear why. Can you try once more with this patch applied?
err:msi:ITERATE_StartService Failed to start service L"pgsql-8.3" (1056) According to winerror.h, 1056 is ERROR_SERVICE_ALREADY_RUNNING. Oops... This might have something to do with the 10+ installation attempts I did in this prefix without 'rm -rf'ing it. In a clean prefix, it seemed to start the service, and then pg_ctl: no operation specified Try "pg_ctl --help" for more information. appeared in the terminal, and the trace stopped. The installer was frozen! I had to ^C it from the terminal (and it took a few seconds to respond). Then this message appeared in the terminal: Deleting active MRSW lock (0x131fe4), expect failure and the "Fatal error" messagebox appeared again. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #13 from Alexander Scott-Johns <alexander.scott.johns+winebug(a)googlemail.com> 2010-01-28 08:34:39 --- Created an attachment (id=25920) --> (http://bugs.winehq.org/attachment.cgi?id=25920) +msi,+relay,+service log of attempting to install postgresql-8.3-int.msi, after applying 2nd patch This was after rm -rf'ing the prefix and with "Install as a service" unchecked. tail -n900000 of the log, rzipped. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #14 from Hans Leidekker <hans(a)meelstraat.net> 2010-02-01 13:23:55 --- Commit 7c9cb1e1be3d78aafadcce55864e071718f7a08f makes sure we treat the service name as a formatted string. Commit 246f9305e9f8eb18e54018746143d95afed887be fixes the install failure when the service is already running. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Colin Close <itchka(a)compuserve.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |itchka(a)compuserve.com --- Comment #15 from Colin Close <itchka(a)compuserve.com> 2010-03-09 20:04:17 --- I have looked into this problem in some detail and have determined that even with these patches the postmaster service is not starting. The reason for this is twofold. Firstly when the installer runs it executes a program called initdb.exe this is a standard utility in postgresql. This program creates the directory and files for the basic administrative db. Alas on completion this program attempts to start the postmaster service. If this fails then the previously created configuration files are deleted. The postmaster service will always fail as it must be started as an unprivileged user. The installer tries to create this user but fails because wine does not know how to create a password. It is forbidden to start the service by the db owner.
From version postgresql 8.2 onward it is possible to start the service using the pg_ctl.exe binary. This new feature starts the server and then drops all privileges. This functionality is not available in the initdb.exe program which tries to start postmaster as an unprivileged user. the pg_ctl functionality is I think intended as a test mode. I have been able to test this mode by doing the following:- Obtain the windows binary tree from the postgresql site, unzip it and copy everything under the psql directory into a directory named postgresql in the wine c_drive. Run the following commands from within the bin directory of the tree:- wine cmd initdb -n -D c:\postgresql\data The -n flag disables the deletion of the files created even though the server fails to start properly. Remember initdb does not have the special functionality.
If one exits the wine console and checks the process tree one finds that the wineservice appears to be running but any attempt to connect to it failed for me. Kill these services. Run "wine cmd" again and after some time the following message will be displayed. pg_ctl: no operation specified Try "pg_ctl --help" for more information. Wine has tried to start the server using pg_ctl but its registry entry is not complete. If you exit you will again find that the wine services processes are running. Kill them again (I thinks wineserver -k may not be enough, I found that services.exe continued to run.). Open the the system registry in a text editor and search for pg_ctl service edit the the Start key such that dword:00000003 this disables the service at start up so that it can be started manually. Now from the posresql bin directory run "pg_ctl.exe start -D c:\postgresql\data" to try and manually start the server. This what you get. fixme:advapi:CreateRestrictedToken (0xbc, 0x1, 2, 0x81f45c, 0, (nil), 0, (nil), 0x81f44c): stub Failed to create restricted token: 120 pg_ctl: could not start server: exit code was 5 Alas we are at a fixme. Can anything be done with this? I have run the various utilities such as psql and pgadmin3 under wine and have been able to connect the a linux postgresql server with full functionality so it is only the server part of postgresql that is broken In summary it would be possible to install and run postgresql in wine by using a "winetricks" approach given that CreateRestrictedToken can be fixed. It will not be possible to use the distributed msi installer for postgresql because it uses initdb to set up and start the server. The installer could be changed (it's available from cvs) to implement the workaround but in truth a simple script and the binary sources would suffice. Colin Close -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Dmitry Timoshkov <dmitry(a)baikal.ru> changed: What |Removed |Added ---------------------------------------------------------------------------- URL|http://wwwmaster.postgresql |ftp://ftp-archives.postgres |.org/download/mirrors-ftp?f |ql.org/pub/binary/v8.3.4/wi |ile=%2Fbinary%2Fv8.3.4%2Fwi |n32/postgresql-8.3.4-1.zip |n32%2Fpostgresql-8.3.4-1.zi | |p | -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Anastasius Focht <focht(a)gmx.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Fixed by SHA1| |7c9cb1e1be3d78aafadcce55864 | |e071718f7a08f Status|NEW |RESOLVED CC| |focht(a)gmx.net Component|-unknown |msi Resolution| |FIXED Summary|postgresql fails to install |PostgreSQL 8.3 service | |installation fails --- Comment #16 from Anastasius Focht <focht(a)gmx.net> 2012-02-10 13:52:22 CST --- Hello, the initial issues with service installation failure were fixed some time ago (comment #14). Marking fixed before this bug gets recycled again. --- quote --- fixme:advapi:CreateRestrictedToken (0xbc, 0x1, 2, 0x81f45c, 0, (nil), 0, (nil), 0x81f44c): stub Failed to create restricted token: 120 pg_ctl: could not start server: exit code was 5 Alas we are at a fixme. Can anything be done with this? I have run the various utilities such as psql and pgadmin3 under wine and have been able to connect the a linux postgresql server with full functionality so it is only the server part of postgresql that is broken In summary it would be possible to install and run postgresql in wine by using a "winetricks" approach given that CreateRestrictedToken can be fixed. It will not be possible to use the distributed msi installer for postgresql because it uses initdb to set up and start the server. The installer could be changed (it's available from cvs) to implement the workaround but in truth a simple script and the binary sources would suffice. --- quote --- This is bug 25834 Regards -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Alexandre Julliard <julliard(a)winehq.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED --- Comment #17 from Alexandre Julliard <julliard(a)winehq.org> 2012-02-11 13:53:23 CST --- Closing bugs fixed in 1.4-rc3. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 --- Comment #18 from Dan Kegel <dank(a)kegel.com> 2012-09-03 23:46:14 CDT --- I'd be happy to add a winetricks verb for this, if someone provides at least a skeletal recipe. -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.
http://bugs.winehq.org/show_bug.cgi?id=15894 Anastasius Focht <focht(a)gmx.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Hardware|Other |x86 OS|other |Linux -- Do not reply to this email, post in Bugzilla using the above URL to reply. You are receiving this mail because: You are watching all bug changes.
participants (1)
-
wine-bugs＠winehq.org