Zentyal log queries

Zentyal provides an infrastructure that allows its modules to log all types of events that may be useful for the administrator. These logs are available through the Zentyal interface. Logs are stored in a database so making queries, reports and updates is easier and more efficient. The database manager used is MySQL [1].

Zentyal offers logs for the following services:

To enable the module, go to Module status and check the logs box. To obtain reports from the existing logs, you can go to the Logs ‣ Query logs section via the Zentyal menu.

You can obtain a Full report of all log domains.

Query log

Query log screen

In the Full report you have a list of all registered actions for the selected domain. The information provided depends on each domain. For example, for the OpenVPN domain you can see the connections to a VPN server of a client with a specific certificate, therefore, you can create a customised query which allows you to filter by time period or other values that depend on the type of domain.

Full report

Full report screen


Configuration of Zentyal logs

Once you have seen how to check the logs, it is also important to know that you can configure them in the Logs ‣ Configure logs section from Zentyal menu.

Configure logs

Log configuration screen

The values you can configure for each installed domain are:

If this option is not enabled, no logs are written for this domain.
Purge logs older than:
This option establishes the maximum time during which the logs will be saved. All the values that are older than the specified time will be discarded.

In addition, you can also force the instant removal of all the logs before a certain time period. You can do this by clicking on the Purge in the Force log purge section. This allows selection of different intervals, ranging from one hour to 90 days.

Log Audit for Zentyal administrators

In addition to the logs available for the different Zentyal services, there are two other log registries not associated with any of the services, but rather with the Zentyal’s administrative panel itself. This feature is specially useful for servers managed by more that one person, since you have a stored log of the successive configuration changes, and executed actions for each user, with their associated timestamps.

By default, this feature is disabled. If you want to enable it, you just have to go to Logs ‣ Configure logs and enable the Configuration changes, Administrator sessions domain, as explained in the former section.

Setting up audit log

Setting up audit log

Once you have saved these changes, go to Logs ‣ Query logs to see the following two tables:

  • Configuration changes: Here you can see the module, section, type of event, and current and former changes (if applicable) for all the configuration changes made after the audit log was enabled.
  • Administrator sessions: It contains the information related with all the administration login attempts, successful or not, session log outs and expired sessions for the different users, with their associated IP addresses.
Query audit logs

Query administration logs

Since there are some actions in Zentyal that take effect instantly, like restarting a server, and some others that are not applied until you save the changes, like most of the configuration changes, the audit log treats them in a different way. The instant actions will be logged permanently (until the registry is purged) and the ones pending to save will be displayed in the save changes interface itself, offering the system administrator a summary of all the modifications since the last save point, or, in case you want to discard changes, the actions will be removed from the log.

Save Changes log

Logs saving changes