Hey all,
When I use emcli to add MySQL database to EM 12c, there are some issues when property values contain character like '/' or '*, etc.
The command I use is,
./emcli add_target -name="mbh_192.168.8.31_3306" \
-type="oracle_mysql_database" \
-host="mbhvm" \
-credentials="UserName:root;password:dbaadminvm" \
-properties="mysqlhome:/usr/local/mysql-5.1.45-linux-x86_64-glibc23" \
-properties="mydelimiter:|" \
-properties="host:192.168.8.31" \
-properties="port:3306" \
-properties="username:mysqlmon" \
-properties="password:3" \
-properties="showstatus:show /*!50002 GLOBAL */ status;" \
-properties="showvariables:show global variables;" \
-properties="re_no:s/(.*).(.*)/2/g"
And the error output is,
Syntax Error: Invalid value for parameter "properties": "mysqlhome:/usr/local/mysql-5.1.45-linux-x86_64-glibc23;mydelimiter:|;host:192.168.8.31;port:3306;username:mysqlmon;password:3;showvariables:show global variables;;re_no:s/(.*).(.*)/2/g". Reason: Parameters cannot start with a delimiter: mysqlhome:/usr/local/mysql-5.1.45-linux-x86_64-glibc23;mydelimiter:|;host:192.168.8.31;port:3306;username:mysqlmon;password:3;showvariables:show global variables;;re_no:s/(.*).(.*)/2/g.
When I use the option instead like below,the command works well.
-properties="showstatus:show" \
-properties="showvariables:show" \
Could anyone can help me out?
Thanks in advance!
Best wishes,
Satine