Configuring a MySQL Server

Configuring MySQL on Windows

Firmware: 5.1.20

Collectors: Advanced Windows CollectorA type of CollectorA TLC module that gathers or receives log messages from Log Sources. that collects log messages from Windows Event1. Either a log message that a Manager has standardized (i.e. normalized) for use by TLC (a.k.a. Normalized Messages), or an event or vulnerability imported from a scanner. 2. An 'event message' collected from a Log Source. Logs on Axon AgentA system on which Tripwire Axon Agent for TLC software has been installed. systems via the Secure Sockets Layer (SSL) protocol. or WinLog CollectorA type of Collector that collects log messages from Windows Event Logs via the Windows Management Instrumentation (WMI) protocol.

On a Windows system, MySQL logs events in the Windows Event Viewer. To collect log messages from an Axon Agent with the Advanced Windows Collector, you must install and configure Tripwire Axon Agent for TLCA service that may be installed on a Windows, AIX, or Linux system to collect log messages from any log-generating application running on the system. When installed on a Windows system, this service can also collect the system's Windows Event Logs via the Secure Socket Layer (SSL) protocol. software on the MySQL Server. For instructions, see Installing Tripwire Axon Agent using a Pre-Shared Key.

No additional configuration on the Windows system is required at this time.

Next	If you are performing initial configuration of your TLC environmentConsists of all TLC software, Managers, Log Sources, Monitored Assets, Collectors, and data in your TLC installation., see Configuring your TLC Environment. Otherwise, see Adding a Monitored Asset for a new Log Source.

Configuring MySQL on UNIX or Linux

Firmware: 5.1.20

Collector: Network CollectorA type of Collector that listens for Syslog and SNMP-based log messages from network devices. - Syslog

To configure a UNIX or Linux MySQL server to send log messages to TLC:

1.

On the MySQL host system, configure the Syslog to send log messages to TLC (see Configuring a Syslog or Rsyslog Module).

2.

Open the MySQL configuration file:

/etc/my.cnf

3.

In the mysql_safe section of the configuration file, enter:

[mysqld_safe]

syslog

4.

Save the modified file.

5.

To close and restart the mysqld service, enter the following command:

system mysqld restart

Next	If you are performing initial configuration of your TLC environment, see Configuring your TLC Environment. Otherwise, see Adding a Monitored Asset for a new Log Source.