C.1.5 The config.properties file

File location

The repository user name and password are stored in the config.properties file. The following table shows the location of this file on various operating systems:

Table C.5 MySQL Enterprise Monitor: Default path of the config.properties File

Operating SystemFile Location
WindowsC:\Program Files\MySQL\Enterprise\Monitor\apache-tomcat\webapps\ROOT\WEB-INF
Linux and Unix/opt/mysql/enterprise/monitor/apache-tomcat/webapps/ROOT/WEB-INF
Mac OS X/Applications/mysql/enterprise/monitor/apache-tomcat/webapps/ROOT/WEB-INF

Make sure that the file is secured at the filesystem level so that it cannot be read by anybody but the administrator, or MySQL Enterprise Monitor.

Usage

A generated config.properties file will look similar to:


#SymmetricKey was auto generated.
#Wed Feb 27 17:32:14 PST 2013
mysql.port=13306
mysql.user=service_manager
quanal.collect=00\:01\:00
mysql.db=mem
default.maxActive=70
mysql.use_ssl=true
mysql.server=127.0.0.1
mysql.pass=l33t
key=8E15928C7732FA85
mysql.verify_server_cert=false

The application has two connection pools, one to service agent traffic, and the other for the UI. You can configure them as one logical pool with a 85/15 (agent/ui) percentage split, and use "dbPool" as the pool name in the further settings. Or, you can configure each pool separately, where the pool names are "default" and "ui". Note that the names after the "." come verbatim from DBCP at http://commons.apache.org/proper/commons-dbcp/configuration.html.

Table C.6 Optional config.properties values