MySQL Server on Windows Vista x64 Setup Guide, An Install That Works!!!

After hours of beat­ing our heads against a wall, we’ve finally come up with a solid MySQL install guide. It wasn’t easy, but it’s some­thing we needed, and obvi­ously some­thing our fel­low devel­op­ers needed. We spent hours read­ing through end­less threads with errors such as;

Can­not Cre­ate Win­dows Ser­vice for MySQL. Error:0,
Vista x64 could not start the ser­vice mysql,
Win­dows could not start the mysql ser­vice on local com­puter error 1067,
Can’t create/write to file,
Can’t con­nect to [local] MySQL server,
Table ‘tbl_name’ doesn’t exist,

Yet even after read­ing through what seemed like hun­dreds of cries for help, and just as many sup­posed fixes, we were still no closer to resolv­ing this issue. So after com­ing to the real­iza­tion that there was lit­tle help to be had online, we just attacked our install, and dealt with the issues one by one. After repeated failed installs, and botched setups, we were able to get MySQL loaded prop­erly. The setup instruc­tions you see below were repeat­able on 4 dif­fer­ent machines, when fol­lowed prop­erly. If you run into an issue, please let us know. Good luck with your setup.

(more…)

Sep 01, 2009 | Computer Repair and Networks | 8 Comments »

Setup failed while installing sub-component Exchange ActiveSync with error code 0xC0070643

In the process of set­ting up a new 2003 Exchange Server, we were con­fronted with the fol­low­ing error while installing Ser­vice Pack 2.

Setup failed while installing sub-component Exchange ActiveSync with error code 0xC0070643 (please con­sult the instal­la­toin logs for a detailed descrip­tion). You may can­cel the instal­la­tion or try the failed setup again.

Dig­ging into the instal­la­tion logs we see that the setup is fail­ing while attempt­ing to install MSXML:

[18:52:22] Call­ing MSXML installer with com­mand line: “msiexec /i msxml3.msi /q reboot=“ReallySuppress”“
[18:52:22] Process cre­ated … wait­ing (-1)
[18:52:23] Process has exited with 0x000643
[18:52:23] The command

msiexec /i msxml3.msi /q reboot=“ReallySuppress”

failed, return­ing error code 1603 (Fatal error dur­ing instal­la­tion.). — ID:31136 — ScCre­ateProcess (f:\tisp2\admin\src\libs\exsetup\hiddenw1.cxx:1821)
Error code 0XC0070643 (1603): Fatal error dur­ing installation.

The event logs sub­se­quently tells us:

Event Type: Error
Event Source: Msi­In­staller
Event ID: 1013
Descrip­tion:
Prod­uct: Microsoft XML Parser — Your sys­tem has newer ver­sion of MSXML3 SP5 than the ver­sion you are attempt­ing to install. Setup will quit.

(more…)

Nov 22, 2008 | Server 2003 | 12 Comments »