Database formats available in Kiwi Syslog Server
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 |