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: -
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.