mysqld.exe and other binaries not compatible with Windows 7 x86

[wabson]

Running version 0.9.0 of the plugin, using MySQL 5.6.21, on a Windows 7 x86 machine yields warnings and then an error that the mysqld.exe file is not compatible with this version of Windows.

[INFO] --- jcabi-mysql-maven-plugin:0.9:classify (mysql-test) @ project-distribu
tion ---
[INFO] ${mysql.classifier} set to "windows-x86"
[INFO]
[INFO] --- maven-dependency-plugin:2.9:unpack (unpack-mysql) @ project-distribut
ion ---
[INFO] Configured Artifact: com.jcabi:mysql-dist:windows-x86:5.6.21:zip
Downloaded: https://repo.maven.apache.org/maven2/com/jcabi/mysql-dist/5.6.21/mys
ql-dist-5.6.21-windows-x86.zip (335651 KB at 1228.8 KB/sec)
[INFO] Unpacking C:\Users\IEUser\.m2\repository\com\jcabi\mysql-dist\5.6.21\mysq
l-dist-5.6.21-windows-x86.zip to C:\Users\IEUser\Project\packaging\distribution\
target\mysql-dist with includes "" and excludes ""
[INFO]
[INFO] --- jcabi-mysql-maven-plugin:0.9:start (mysql-test) @ project-distributio
n ---
[INFO] jcabi-aspects 0.18/55a5c13 started new daemon thread jcabi-cacheable for
automated cleaning of expired @Cacheable values
Jan 26, 2015 3:53:43 AM org.hibernate.validator.internal.util.Version <clinit>
INFO: HV000001: Hibernate Validator 5.1.2.Final
[ERROR] JSR-303 validator failed to initialize: Unable to instantiate Configurat
ion. (see http://aspects.jcabi.com/jsr-303.html)
[INFO] jcabi-aspects 0.18/55a5c13 started new daemon thread jcabi-loggable for w
atching of @Loggable annotated methods
[INFO] reuse existing database false
[INFO] created C:\Users\IEUser\Project\packaging\distribution\target\mysql-data
directory
[INFO] $ perl C:\Users\IEUser\Project\packaging\distribution\target\mysql-dist\s
cripts\mysql_install_db.pl --defaults-file=C:\Users\IEUser\Project\packaging\dis
tribution\target\mysql-data\my-default.cnf --force --innodb_use_native_aio=0 --d
atadir=C:\Users\IEUser\Project\packaging\distribution\target\mysql-data\data --b
asedir=C:\Users\IEUser\Project\packaging\distribution\target\mysql-dist
[WARNING] >> This version of C:\Users\IEUser\Project\packaging\distribution\targ
et\mysql-dist\bin\my_print_defaults.exe is not compatible with the version of Wi
ndows you're running. Check your computer's system information to see whether yo
u need a x86 (32-bit) or x64 (64-bit) version of the program, and then contact t
he software publisher.
[WARNING] >> This version of C:\Users\IEUser\Project\packaging\distribution\targ
et\mysql-dist\bin\mysqld.exe is not compatible with the version of Windows you'r
e running. Check your computer's system information to see whether you need a x8
6 (32-bit) or x64 (64-bit) version of the program, and then contact the software
 publisher.
[INFO] >> Installing MySQL system tables...OK
[INFO] >>
[WARNING] >> This version of C:\Users\IEUser\Project\packaging\distribution\targ
et\mysql-dist\bin\mysqld.exe is not compatible with the version of Windows you'r
e running. Check your computer's system information to see whether you need a x8
6 (32-bit) or x64 (64-bit) version of the program, and then contact the software
 publisher.
[INFO] >> Filling help tables...OK
[INFO] >>
[INFO] >> To start mysqld at boot time you have to copy
[INFO] >> support-files/mysql.server to the right place for your system
[INFO] >>
[INFO] >> PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
[INFO] >> To do so, start the server, then issue the following commands:
[INFO] >>
[INFO] >>   C:\Users\IEUser\Project\packaging\distribution\target\mysql-dist/bin
/mysqladmin -u root password 'new-password'
[INFO] >>   C:\Users\IEUser\Project\packaging\distribution\target\mysql-dist/bin
/mysqladmin -u root -h IE9Win7 password 'new-password'
[INFO] >>
[INFO] >> Alternatively you can run:
[INFO] >>
[INFO] >>   C:\Users\IEUser\Project\packaging\distribution\target\mysql-dist/bin
/mysql_secure_installation
[INFO] >>
[INFO] >> which will also give you the option of removing the test
[INFO] >> databases and anonymous user created by default.  This is
[INFO] >> strongly recommended for production servers.
[INFO] >>
[INFO] >> See the manual for more instructions.
[INFO] >>
[INFO] >> You can start the MySQL daemon with:
[INFO] >>
[INFO] >>   cd . ; C:\Users\IEUser\Project\packaging\distribution\target\mysql-d
ist/bin/mysqld_safe &
[INFO] >>
[INFO] >> You can test the MySQL daemon with mysql-test-run.pl
[INFO] >>
[INFO] >>   cd mysql-test ; perl mysql-test-run.pl
[INFO] >>
[INFO] >> Please report any problems at http://bugs.mysql.com/
[INFO] >>
[INFO] >> The latest information about MySQL is available on the web at
[INFO] >>
[INFO] >>   http://www.mysql.com
[INFO] >>
[INFO] >> Support MySQL by buying support/licenses at http://shop.mysql.com
[INFO] >>
[INFO] >> New default config file was created as C:\Users\IEUser\Project\packagi
ng\distribution\target\mysql-dist/my.ini and
[INFO] >> will be used by default by the server when you start it.
[INFO] >> You may edit this file to change server settings
[INFO] >>
[INFO] $ C:\Users\IEUser\Project\packaging\distribution\target\mysql-dist\bin\my
sqld.exe --no-defaults --user=IEUser --general_log --console --innodb_buffer_poo
l_size=64M --innodb_log_file_size=64M --log_warnings --innodb_use_native_aio=0 -
-binlog-ignore-db=root --basedir=C:\Users\IEUser\Project\packaging\distribution\
target\mysql-dist --lc-messages-dir=C:\Users\IEUser\Project\packaging\distributi
on\target\mysql-dist\share --datadir=C:\Users\IEUser\Project\packaging\distribut
ion\target\mysql-data\data --tmpdir=C:\Users\IEUser\Project\packaging\distributi
on\target\mysql-data\temp --socket=C:\Users\IEUser\Project\packaging\distributio
n\target\mysql-data\mysql.sock --pid-file=C:\Users\IEUser\Project\packaging\dist
ribution\target\mysql-data\mysql.pid --port=33061
[ERROR] #start('Config(tcpport=33061, dbuser=root, dbpassword=roo..14..=[connect
-timeout=60, max_connections=150])', C:\Users\IEUser\Project\packaging\distribut
ion\target\mysql-dist, C:\Users\IEUser\Project\packaging\distribution\target\mys
ql-data, false, NULL): thrown java.io.IOException(Cannot run program "C:\Users\I
EUser\Project\packaging\distribution\target\mysql-dist\bin\mysqld.exe" (in direc
tory "C:\Users\IEUser\Project\packaging\distribution\target\mysql-dist"): Create
Process error=216, This version of %1 is not compatible with the version of Wind
ows you're running. Check your computer's system information to see whether you
need a x86 (32-bit) or x64 (64-bit) version of the program, and then contact the
 software publisher) out of java.lang.ProcessBuilder#start[1048] in 7s
[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 10:05 min
[INFO] Finished at: 2015-01-26T03:53:50-08:00
[INFO] Final Memory: 67M/359M
[INFO] ------------------------------------------------------------------------

[yegor256]

@wabson thanks, we'll investigate!

[dmarkov]

we'll find someone to do this task, soon

[dmarkov]

@maurezen the task is yours, go ahead

[maurezen]

@wabson seems like 5.6.21 mysql-distr package got confused x86 and x64, see #47 or #62. I could make jcabi-mysql-maven-plugin use mysql 5.6.14, which is packaged correctly in mysql-distr. Will that be okay for you?

[maurezen]

@wabson @dmarkov created a pull request here: #64

[wabson]

Unfortunately it seems MySQL 5.6.14 will not work on Windows due to issue #39. I confirmed that 5.5.34 works OK on this platform.

[maurezen]

@wabson @yegor256 we're blocked by #62, then, since 5.6.21 is the latest mysql version packaged by mysql-distr.

[yegor256]

@dmarkov let's wait for #62 here

[dmarkov]

@dmarkov let's wait for #62 here

@yegor256 sure, we'll wait for #62

[dmarkov]

@nikoladespotoski please pick this up, and keep in mind these instructions. Any technical questions - ask right here; The cost of this task is 30 mins (this is exactly how much will be paid, not less not more), when the task is done

[NikolaDespotoski]

@dmarkov assign someone else

[dmarkov]

@dmarkov assign someone else

@nikoladespotoski I will try to find someone else