Cisco Cisco Prime Network Registrar 8.1 Installation Guide
Cisco Prime Network Registrar IPAM 8.1.2 Logging Overview
•
7
log4j.category.com.diamondip.netcontrol=WARN
log4j.category.com.diamondip.ipcontrol=WARN
log4j.category.com.diamondip.ipcontrol=WARN
MySQL Database
MySQL logging must be enabled by modifying the mysqld_start script. One or more of the
following clauses corresponding to chosen logging functionality should be inserted into the
./bin/mysqld_safe line of $INCHOME/etc/mysqld_start.
following clauses corresponding to chosen logging functionality should be inserted into the
./bin/mysqld_safe line of $INCHOME/etc/mysqld_start.
Query Log – This log provides a general record of MySQL activities, such as client connection
or disconnection, as well as each SQL statement received from clients. The following clause
should be added to the mysql_start script per above to log to the $INCHOME/log/mysql-
queries.log file:
or disconnection, as well as each SQL statement received from clients. The following clause
should be added to the mysql_start script per above to log to the $INCHOME/log/mysql-
queries.log file:
--log=${INCHOME}/log/mysql-queries.log
Error Log
–
This log includes information indicating when mysqld was started, restarted, and
stopped, as well as any critical errors that occurred while mysqld was running. The following
clause should be added to the mysql_start script per above to log to the $INCHOME/log/mysql-
error.log file:
clause should be added to the mysql_start script per above to log to the $INCHOME/log/mysql-
error.log file:
--log-error=${INCHOME}/log/mysql-error.log
Binary Log – The binary log contains all statements that update data or potentially could have
updated data (e.g., an update query with no matching records). This does not include queries that
do not update data (show or select).
updated data (e.g., an update query with no matching records). This does not include queries that
do not update data (show or select).
--log-bin=${INCHOME}/log/base_name
Slow Query Log – This log records queries which took longer to execute than the value of the
long_query_time
variable, which defaults to 10 seconds.
--log-slow-queries=${INCHOME}/log/mysql-slowqueries.log
Cisco Prime Network Registrar IPAM Executive Services
The following services run on the Executive with corresponding logging destinations. Most of
these services utilize the log4j java logging utility. The log levels for output can be set per service
by editing the corresponding <service>_log4j.properties file in $INCHOME as discussed below
for each service, though the corresponding service will need to be restarted to enact any changes.
these services utilize the log4j java logging utility. The log levels for output can be set per service
by editing the corresponding <service>_log4j.properties file in $INCHOME as discussed below
for each service, though the corresponding service will need to be restarted to enact any changes.
Task Manager – The Task Manager uses log4j and logs to $INCHOME/log/taskmgr.log by
default. This output destination can be changed by editing the
$INCHOME/task_manager_log4j.properities file by editing the line:
default. This output destination can be changed by editing the
$INCHOME/task_manager_log4j.properities file by editing the line:
log4j.appender.RollingFile.File=${INCX_HOME}/log/taskmgr.log