Table of Contents
This chapter documents the available schemas in the standard Lire suite. For each superservice, the base schema is explained, followed by any extended and derived schemas.
Schema ID: database
Timestamp Field: time
A record in the database DLF schema represents one event in the database. This may be a connection from a client, a SQL query, etc.
Fields in the Schema
Type: timestamp
Defaults: 0
The time at which the event occured.
Type: string
Defaults: -
The name of the user who executed the command.
Type: hostname
Defaults: -
The host from which the user executed the command.
Type: string
Defaults: -
The command that was executed. Commands you are likely to encounter are connect, disconnect, shutdown and query.
Type: string
Defaults: -
The database name on which the command was executed.
Type: string
Defaults: -
When the command field is a query, this field contains the actual SQL query that was executed.
Type: bool
Defaults: -
Did the command succeeded?
Type: string
Defaults: -
When the success field is false, i.e. when the command failed, this field should contains the logged error message.
Type: int
Defaults: 0
An "appropriate" "connection label" for the backend that can be used for session analysis in conjunction with the timestamp, username and database fields. This can be a connection identifier, a PID, a real session ID or whatever makes sense in the particular backend.