[Bug 15770] MySQL 5.1 service fails to start due to missing HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Parameters registry subkey

[wine-bugs at winehq.org]

http://bugs.winehq.org/show_bug.cgi?id=15770

Anastasius Focht <focht at gmx.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |focht at gmx.net
          Component|advapi32                    |tools
            Version|unspecified                 |1.1.7
            Summary|MySQL 5.1 service fails to  |MySQL 5.1 service fails to
                   |start                       |start due to missing
                   |                            |HKEY_LOCAL_MACHINE\SYSTEM\C
                   |                            |urrentControlSet\Services\T
                   |                            |CPIP\Parameters registry
                   |                            |subkey
           Severity|enhancement                 |normal

--- Comment #6 from Anastasius Focht <focht at gmx.net> 2012-01-10 16:06:09 CST ---
Hello,

confirming, still present.
The culprit are some registry keys that are checked by the mysql service to
determine if TCPIP is applicable:

--- snip ---
...
0027:Call advapi32.RegOpenKeyExA(80000002,00c1d5a0
"SYSTEM\\CurrentControlSet\\Services\\Tcpip\\Parameters",00000000,00020019,0117e610)
ret=008d9cb9
0027:Ret  advapi32.RegOpenKeyExA() retval=00000002 ret=008d9cb9
0027:Call advapi32.RegOpenKeyExA(80000002,00c1d5d4
"SYSTEM\\CurrentControlSet\\Services\\Winsock2\\Parameters",00000000,00020019,0117e610)
ret=008d9ce1
0027:Ret  advapi32.RegOpenKeyExA() retval=00000002 ret=008d9ce1
0027:Call advapi32.RegOpenKeyExA(80000002,00c1d60c
"SYSTEM\\CurrentControlSet\\Services\\Winsock\\Parameters",00000000,00020019,0117e610)
ret=008d9d09
0027:Ret  advapi32.RegOpenKeyExA() retval=00000002 ret=008d9d09 
...
--- snip ---

At least one of these keys needs to be present.
The service will successfully start in TCPIP mode and bind to desired port.

To verify: create a clean WINEPREFIX and execute:

--- snip ---
$ wine reg add "HKLM\\System\\CurrentControlSet\\Services\\Tcpip\\Parameters"
--- snip ---

This allows the (post)installer to start and configure the service properly.

Creating Tcpip service "Parameters" key by default through "wine.inf" without
having a real service shouldn't do any harm (will be skipped by service control
manager).

$ sha1sum mysql-5.1.47-win32.msi 
4e84e3e4c4cd86d2e7a1bc18bc93df5957bf027d  mysql-5.1.47-win32.msi

$ wine --version
wine-1.3.36-269-g662f3ab2

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.