Database formats available in Kiwi Syslog Server — Legacy
This snippet is used for legacy 9.8.3 topics that link to a KSS NG topic of the same name.
When you add an action to log messages to a database, you can choose any of the following standard database formats:
- Microsoft Access
- Microsoft SQL
- MySQL
- Oracle
You can also create a custom database format.
The following sections describe the table columns used to store message field values. If you choose to create the table manually before you add a Log to Database action, use the table design for the selected database type.
Default Microsoft Access database table design
| Field | Name | Type | Size |
|---|---|---|---|
| Date | MSGDATE | Date | 10 |
| Time | MSGTIME | Time | 8 |
| Priority | MSGPRIORITY | Text | 30 |
| Hostname | MSGHOSTNAME | Text | 255 |
| Message text | MSGTEXT | Memo | 1024 |
Default Microsoft SQL and generic SQL database table design
| Field | Name | Type | Size |
|---|---|---|---|
| Date | MSGDATE | Date | 10 |
| Time | MSGTIME | Time | 8 |
| Priority | MSGPRIORITY | VarChar | 30 |
| Hostname | MSGHOSTNAME | VarChar | 255 |
| Message text | MSGTEXT | VarChar | 1024 |
Default MySQL database table design
| Field | Name | Type | Size |
|---|---|---|---|
| Date | MSGDATE | Date | 10 |
| Time | MSGTIME | Time | 8 |
| Priority | MSGPRIORITY | VarChar | 30 |
| Hostname | MSGHOSTNAME | VarChar | 255 |
| Message text | MSGTEXT | Text | 1024 |
Default Oracle database table design
| Field | Name | Type | Size |
|---|---|---|---|
| Date | MSGDATE | Date | 10 |
| Time | MSGTIME | Time | 8 |
| Priority | MSGPRIORITY | VarChar2 | 30 |
| Hostname | MSGHOSTNAME | VarChar2 | 255 |
| Message text | MSGTEXT | VarChar2 | 1024 |