AnsweredAssumed Answered

How to specify the MySQL database parameters from the command line

Question asked by hui_hu on Jan 22, 2013
Latest reply on Jan 24, 2013 by hui_hu
According to http://www.mapr.com/doc/display/MapR/Configuring+the+Cluster#ConfiguringtheCluster-metricspostinstall ,  to specify the MySQL database parameters from the command line, run the configure.sh script:
<pre>
configure.sh -R -d host:port -du database_username -dp database_password -ds metrics
</pre>
However, after run this script and navigate to https://<web_server>:8443  Navigation -> Cluster -> Jobs:
<pre>
== Actual Result ==
 it shows up the Metrics DB Connection Param dialog, and the dialog shows all the data specified by configure.sh (with the password displayed as ****),  if click 'Save' button, the '****' (4 charactors) will be saved as the password. 
== Expected Result ==
it should not display the Metrics DB Connection Param dialog, because I have already configured db conn param.
</pre>

Fortunately, I figured out a workaround:  after run configure.sh -R -d host:port -du database_username -dp database_password -ds metrics , run this command :
<pre>
maprcli config save -values "{'jm_db.url': '{mysql_host}:{mysql_port}', 'jm_db.user': '{mysql_user}', 'jm_db.passwd': '{mysql_pwd}', 'jm_db.schema': '{mysql_schema}'}"
</pre>
then the dialog won't show up.

I guess this is a MapR bug (I'm using MapR 2.1.1).  Could anyone for MapR give some advise please?

Outcomes