The `logs` table
This table stores logs from Appender type database in config file. Example db appender:
Appender.DB=3,5,0
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| time | INT | UNSIGNED | NO | ||||
| realm | INT | UNSIGNED | NO | ||||
| type | VARCHAR(250) | SIGNED | NO | ||||
| level | TINYINT | UNSIGNED | NO | 0 | |||
| string | TEXT | SIGNED | YES |
Description of the fields
A unixtime timestamp indicating when this string was logged.
The RealmID of the realm this log string came from. 0 if realmd.
The Logger name from config Example logger:
Logger.server=4,Console Server
Depends on LogLevel in authserver.conf
| Value | Description |
|---|---|
| 1 | (Fatal) |
| 2 | (Error) |
| 3 | (Warning) |
| 4 | (Info) |
| 5 | (Debug) |
| 6 | (Trace) |
The actual string that has been logged.