A.1.3 The config.properties file

File location

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

Table A.3 Default Location of config.properties File

Operating System	File Location
Microsoft Windows	..\Monitor\apache-tomcat\webapps\ROOT\WEB-INF
UNIX/Linux	../monitor/apache-tomcat/webapps/ROOT/WEB-INF
macOS	../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

The following examples shows a generated config.properties file:

#SymmetricKey was auto generated.
#Thu Aug 15 13:35:56 PDT 2013
mysql.use_ssl=true
mysql.user=service_manager
mysql.port=13306
key=8577667A79DF5275
mysql.pass=BMcsacZdrMmM7mrnFExURHDuxp4C3hcrZyxcpC2QhiE\=
mysql.verify_server_cert=false
mysql.server=localhost
mysql.db=mem

Note

The mysql.pass is encrypted.

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 A.4 Optional config.properties Values

Property Name	Property Type	Default
dbpool.default.initialSize	Integer	20
dbpool.default.maxActive	Integer	70
dbpool.default.maxIdle	Integer	20
dbpool.default.maxWaitMillis	String	30 seconds
dbpool.default.minEvictableIdleTimeMillis	String	15 seconds
dbpool.default.minIdle	Integer	0
dbpool.default.timeBetweenEvictionRunsMillis	String	5 seconds
dbpool.ui.initialSize	Integer	5
dbpool.ui.maxActive	Integer	15
dbpool.ui.maxIdle	Integer	5
dbpool.ui.maxWaitMillis	String	30000 seconds
dbpool.ui.minEvictableIdleTimeMillis	String	15 seconds
dbpool.ui.minIdle	Integer	0
dbpool.ui.timeBetweenEvictionRunsMillis	String	5000 milliseconds

• dbpool.ui.initialSize(5)

  Type	Integer
  Default Value	5

  The initial number of connections that are created when the pool is started.

• dbpool.ui.maxActive(15)

  Type	Integer
  Default Value	15

  The maximum number of active connections that can be allocated from this pool at the same time.

• dbpool.ui.minIdle(0)

  Type	Integer
  Default Value	0

  The minimum number of established connections that should be kept in the pool at all times. Default value is derived from ???.

• dbpool.ui.maxIdle(5)

  Type	Integer
  Default Value	5

  The maximum number of connections kept in the pool at all times. Idle connections are checked periodically, if enabled, and connections idle for longer than minEvictableIdleTimeMillis are released.

• dbpool.ui.maxWaitMillis(30 seconds)

  Type	String
  Default Value	30000 seconds

  The maximum number of milliseconds the pool waits for a connection to be returned before throwing an exception. Set to -1 to wait indefinitely.

• dbpool.ui.timeBetweenEvictionRunsMillis(5 seconds)

  Type	String
  Default Value	5000 milliseconds

  The number of milliseconds to sleep between runs of the idle connection validation or cleaner thread. Do not set this value to less than 1 second. It specifies how often checks are performed for idle connections, and how often idle connections are validated.

• dbpool.ui.minEvictableIdleTimeMillis(15 seconds)

  Type	String
  Default Value	15 seconds

  The minimum amount of time an object may sit idle in the pool before it is eligible for eviction.

• dbpool.default.initialSize(20)

  Type	Integer
  Default Value	20

  The initial number of connections created when the pool is started.

• dbpool.default.maxActive(70)

  Type	Integer
  Default Value	70

  The maximum number of active connections allocated from this pool at the same time.

• dbpool.default.minIdle(0)

  Type	Integer
  Default Value	0

  The minimum number of established connections kept in the pool at all times.

• dbpool.default.maxIdle(5)

  Type	Integer
  Default Value	20

  The maximum number of connections kept in the pool at all times.

• dbpool.default.maxWaitMillis(30 seconds)

  Type	String
  Default Value	30 seconds

  The maximum number of milliseconds the pool waits for a connection to be returned before throwing an exception.

• dbpool.default.timeBetweenEvictionRunsMillis(5 seconds)

  Type	String
  Default Value	5 seconds

  The number of milliseconds to sleep between runs of the idle connection validation or cleaner thread. Do not set this value to less than 1 second. It specifies how often checks are performed for idle connections, and how often idle connections are validated.

• dbpool.default.minEvictableIdleTimeMillis(15 seconds)

  Type	String
  Default Value	15 seconds

  The minimum amount of time an object may sit idle in the pool before it is eligible for eviction.