Bug #63803 mysqld launched with --help using 5.0.12 /MXJ
Submitted: 19 Dec 2011 22:15 Modified: 6 Jun 2012 12:45
Reporter: Dowell Griffin Email Updates:
Status: Unsupported Impact on me:
None 
Category:Connector / MXJ Severity:S2 (Serious)
Version:5.0.12 OS:Any
Assigned to: CPU Architecture:Any
Tags: jboss

[19 Dec 2011 22:15] Dowell Griffin
Description:
I converted from 5.0.11 to 5.0.12 and when the mbean launches mysqld it is passing "--help --verbose" on the command line.  This causes the help text to print and then mysqld exits (as one would expect).

The only change I made was to remove 5.0.11 jars and install the 5.0.12 jars.  

JBoss AS 5.1.0GA
Windows 7 

How to repeat:
1) Put mysql-connector-mxj-gpl-5-0-11-db-files and mysql-connector-mxj-gpl-5-0-11 into folder  ...\jboss-5.1.0.GA\common\lib   (remove older version if present)

2) place mysqld-service.xml file so JBossMysqldDynamicMBean will be deployed and launch mysqld

3) If MXJ was used before remove old bin and share folders created to build the mysql executable environment to make sure you are using the jars just installed.  Those are in  ...\jboss-5.1.0.GA\server\default\data\mysql (bin & share).

4) start JBoss

This shown below will appear in the log output which shows --help was passed as an argument.  You can see the command line.

2011-12-19 15:40:47,055 ERROR [STDERR] (main) [
2011-12-19 15:40:47,055 ERROR [STDERR] (main) HelpOptionsParser
2011-12-19 15:40:47,055 ERROR [STDERR] (main) ] 
2011-12-19 15:40:47,055 ERROR [STDERR] (main) Divider="--------------------------------- -----------------------------"
2011-12-19 15:40:47,055 ERROR [STDERR] (main) [
2011-12-19 15:40:47,055 ERROR [STDERR] (main) HelpOptionsParser
2011-12-19 15:40:47,055 ERROR [STDERR] (main) ] 
2011-12-19 15:40:47,055 ERROR [STDERR] (main) found at: -1
2011-12-19 15:40:47,055 ERROR [STDERR] (main) [
2011-12-19 15:40:47,055 ERROR [STDERR] (main) HelpOptionsParser
2011-12-19 15:40:47,055 ERROR [STDERR] (main) ] 
2011-12-19 15:40:47,055 ERROR [STDERR] (main) Start Position:62
2011-12-19 15:40:47,055 ERROR [STDERR] (main) [
2011-12-19 15:40:47,055 ERROR [STDERR] (main) HelpOptionsParser
2011-12-19 15:40:47,055 ERROR [STDERR] (main) ] 
2011-12-19 15:40:47,055 ERROR [STDERR] (main) End Text="To see what values a running"
2011-12-19 15:40:47,055 ERROR [STDERR] (main) [
2011-12-19 15:40:47,055 ERROR [STDERR] (main) HelpOptionsParser
2011-12-19 15:40:47,055 ERROR [STDERR] (main) ] 
2011-12-19 15:40:47,055 ERROR [STDERR] (main) found at: 77118
2011-12-19 15:40:47,055 ERROR [STDERR] (main) [
2011-12-19 15:40:47,055 ERROR [STDERR] (main) HelpOptionsParser
2011-12-19 15:40:47,055 ERROR [STDERR] (main) ] 
2011-12-19 15:40:47,055 ERROR [STDERR] (main) HELP TEXT BEGIN
2011-12-19 15:40:47,055 ERROR [STDERR] (main) [
2011-12-19 15:40:47,055 ERROR [STDERR] (main) HelpOptionsParser
2011-12-19 15:40:47,055 ERROR [STDERR] (main) ] 
2011-12-19 15:40:47,055 ERROR [STDERR] (main) [C:\myj2eeapp\swserver\jboss-5.1.0.GA\server\default\data\mysql\bin\mysqld.exe][--no-defaults][--console][--port=3306][--enable-named-pipe=true][--help][--verbose][--character-set-server=utf8][--socket=mysql.sock][--default-storage-engine=InnoDB][--basedir=C:\myj2eeapp\swserver\jboss-5.1.0.GA\server\default\data\mysql][--datadir=C:\myj2eeapp\swserver\jboss-5.1.0.GA\server\default\data\mysql\data][--pid-file=C:\myj2eeapp\swserver\jboss-5.1.0.GA\server\default\data\mysql\data\MysqldResource.pid]
[19 Dec 2011 22:17] Dowell Griffin
I should have added: If I revert back to the 5.0.11 jars it works as it should.
[6 Jun 2012 12:45] Sveta Smirnova
Thank you for the report.

Connector/MXJ has been deprecated and would not be supported. So I am closing the report as "Unsupported".