MySQL Bugs: #30823: Error in manifest prevents MySQLInstanceConfig from running on Windows Vista

Bug #30823	Error in manifest prevents MySQLInstanceConfig from running on Windows Vista
Submitted:	5 Sep 2007 11:26	Modified:	5 May 20:46
Reporter:	Tonci Grgin
Status:	Closed
Category:	Server: Config Wizard	Severity:	S3 (Non-critical)
Version:	5.1.21, 5.0.51a	OS:	Microsoft Windows (Vista)
Assigned to:	Iggy Galarza	Target Version:	5.1.24
Triage:	D2 (Serious)

Description:
Following on Bug#30744 I found out that MySQL Instance Config does not start from setup
even if one specifically asked for that. Problem was repeated on Vista Ultimate x64 and
Vista Business x32 with appropriate version (essentials) of MySQL server (MySQL server
5.1.21-beta-winx64.msi 28969KB and 32 bit).

How to repeat:
Download essentials .msi from our site, install on Vista with Complete option. Same .msi
file works correctly on my WinXP Pro x64 SP1.

Suggested fix:
-

I believe this to be the same problem, (instance manager also not starting after install)
32bit Vista business.

Running the instance manager manually via cmdline or explorer also causes error (copied
from error log);

Log Name:      Application
Source:        SideBySide
Date:          2/5/2008 2:04:16 PM
Event ID:      63
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      adixonlap
Description:
Activation context generation failed for "C:\Program Files\MySQL\MySQL Server
5.0\bin\MySQLInstanceConfig.exe".Error in manifest or policy file "C:\Program
Files\MySQL\MySQL Server 5.0\bin\MySQLInstanceConfig.exe" on line 6. The value
"asAdministrator" of attribute "level" in element
"urn:schemas-microsoft-com:asm.v1^requestedPrivileges" is invalid.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="SideBySide" />
    <EventID Qualifiers="49409">63</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2008-02-05T03:34:16.000Z" />
    <EventRecordID>5864</EventRecordID>
    <Channel>Application</Channel>
    <Computer>adixonlap</Computer>
    <Security />
  </System>
  <EventData>
    <Data>urn:schemas-microsoft-com:asm.v1^requestedPrivileges</Data>
    <Data>level</Data>
    <Data>asAdministrator</Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>C:\Program Files\MySQL\MySQL Server 5.0\bin\MySQLInstanceConfig.exe</Data>
    <Data>C:\Program Files\MySQL\MySQL Server 5.0\bin\MySQLInstanceConfig.exe</Data>
    <Data>6</Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
    <Data>
    </Data>
  </EventData>
</Event>

Bug 30823 I have the exact same problem as Adam Dixon. What's the solution?

Karine

I think the correct value for the manifest is "requiresAdministrator", not
"asAdministrator"

The only fix I found was installing a previous version of MySQL and upgrading to the
latest one afterwards

Of course, there is the solutions of opening the file with a resource editor and deleting
the manifest completely.

Index: build/SignBinary.cmd
===================================================================
--- build/SignBinary.cmd	(revision 168)
+++ build/SignBinary.cmd	(working copy)
@@ -11,7 +11,7 @@
 cd ..\bin\windows
  
 echo Creating Manifest ...
-cscript /nologo ..\..\build\create_manifest.js name=MySQLInstanceConfig.exe arch=x86
exe_level=asAdministrator outfile=MySQLInstanceConfig.exe.manifest
+cscript /nologo ..\..\build\create_manifest.js name=MySQLInstanceConfig.exe arch=x86
exe_level=requireAdministrator outfile=MySQLInstanceConfig.exe.manifest

Ok to push

1)  Verified on 32bit Vista Ultimate - presence of existing bug with current Instance
Config.exe as well as correction of bug with revised Instance Config wizard.

2)  Also tested on 32 bit XP to ensure nothing changed with existing functionality (no
problems were present on XP - wanted to ensure nothing developed from changes.

Marked bug# 34340 as a duplicate.

Marked Bug#34559 as a duplicate.

Hello,

as suggested in this thread, I tried modifying the exe(changed "asAdministrator" by
"requireAdministrator"). Just used standard windows editor (I am not an expert, not sure
this should work in an .exe file, but I tried).

Error changed, now indicates that release is not compatible with windows vista, so I
should check x86 or x64. Not to say, I modified and tried with both versions, but I find
the same error message. My questions:

- Is the way I modified the file proper?
- As it seems, is the x64 wizard version incorect?
- If trying to install an older version, exist a config wizard that works in Vista - 64
bits, that somebody has worked out

Thank you in advance. Best regards,

Pedro

I found a piece of information that could help. It is a tutorial to install also mySQL5.1
and to workaround problems for 64 bits config wizard.

find it in:
http://blondr.blogspot.com/2006/11/set-up-iis-7-w-mysql-and-php-5.html

For your reference, I extract relevant:

"...
Once you downloaded the MySQL installer, 32bit users, all you have to do is go through the
Installer steps (Click next,next next next) and you should be fine.

64bit users, you still got some little work, after installing the MySQL, i had a problem
running the configuration wizard, in order to solve that problem, i used the following
trick.

I downloaded the 32bit zip package (without installer), inside C:\Program
Files\MySQL\MySQL Server 5.1\bin i renamed the file libmySQL.dll to libmySQL64.dll and
copied the 32bit file into the directory instead. Then i ran the configuration wizard, and
this time it worked.

After the configuration process was completed, delete the 32bit file from the directory
and rename the file libmySQL64.dll back to libmySQL.dll.
..."

Regards,

Pedro

Pedro, thanks for providing us with more info. As you can see, patch is pending and it
will most probably be available in next release. I have already tested it and it works as
expected.

Thanks for your interest in MySQL.

Bug#34824 has been marked as duplicate of this one.

Thanks Tonci,

I replaced "asAdministrator" to "requireAdministrator". But the problem still exists.

And the error log looks like this:

Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
  <Provider Name="SideBySide" /> 
  <EventID Qualifiers="49409">63</EventID> 
  <Level>2</Level> 
  <Task>0</Task> 
  <Keywords>0x80000000000000</Keywords> 
  <TimeCreated SystemTime="2008-02-26T08:26:38.000Z" /> 
  <EventRecordID>4634</EventRecordID> 
  <Channel>Application</Channel> 
  <Computer>sangeetha-PC</Computer> 
  <Security /> 
  </System>
- <EventData>
  <Data>urn:schemas-microsoft-com:asm.v1^requestedPrivileges</Data> 
  <Data>level</Data> 
  <Data>requiresAdministrator</Data> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data>C:\MySQL\MySQL Server 5.0\bin\MySQLInstanceConfig.exe</Data> 
  <Data>C:\MySQL\MySQL Server 5.0\bin\MySQLInstanceConfig.exe</Data> 
  <Data>6</Data> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data /> 
  <Data /> 
  </EventData>
  </Event>

To install MySQL Server 5.0.51a in Vista

1. Use mysql-essential-5.0.51a-win32.msi

2. Download and run Resource Hacker http://www.angusj.com/resourcehacker/
3. Open ...\MySQL Server 5.0\bin\MySQLInstanceConfig.exe with Resource Hacker
4. Navigate to 24\1\1033
5. Delete all text in the window
6. Press "Compile script"
7. Exit Resource Hacker and save the result (overwrite the initial
MySQLInstanceConfig.exe)
8. Now MySQLInstanceConfig.exe should start normally.

Gunnar, thanks for helping others and thanks for your interest in MySQL!

Bug #34974 was marked as duplicate of this one.

thanks Gunnar Gudvardarson 
I tried this steps and it works.
[26 Feb 21:36] Gunnar Gudvardarson

thanks Gunnar Gudvardarson 
I tried this steps and it works.
[26 Feb 21:36] Gunnar Gudvardarson

thanks Gunnar Gudvardarson 
I tried this steps and it works.
[26 Feb 21:36] Gunnar Gudvardarson

Bug: http://bugs.mysql.com/bug.php?id=35686 was marked as duplicate of this
one.

Bug http://bugs.mysql.com/bug.php?id=35865 has been marked as duplicate
of this bug.

Noted in 5.1.24 changelog.

Manifest problems prevented MySQLInstanceConfig.exe from running on
Windows Vista.

Resetting report to Patch queued waiting for push into 6.0.x.

Thanks! just download 5.1.24 and worked first time.

Noted in 6.0.5 changelog.