The database options are always being improved. It is recommended you download the latest version of Kiwi Syslog Daemon from our downloads page.

Below is a step by step guide explaining how to have Kiwi Syslog Daemon log to a MySQL database.

The guide below assumes that you are logging to the localhost and that you already have both MySQL and MyODBC installed on the system. If this is not the case then they are both available from here.

1. First you need to create a MySQL database to store your table in.
2. Open a dos window
3. Change to the mysqlbin directory - "cd mysqlbin"
4. Type "mysqladmin create kiwi_syslog". This will create a MySQL database called "kiwi_syslog" For a full list of commands, type "mysqladmin".
5. Close the dos window and open Kiwi Syslog Daemon.
6. Open the Properties setup window (Ctrl-P)
7. Create a "Log to ODBC database" action
8. From the right hand action settings pane, press the "ODBC Control Panel" button.
9. Press the System DSN tab
10. Press the "Add" button and select the MySQL ODBC driver from the list and press the "Finish" button.
11. Enter a Data Source Name, for example "Syslog"
12. Enter the Database Name, "kiwi_syslog"
13. Press the "Test Data Source" button. You should receive a message stating that it connected correctly.
14. Press "OK"
15. Press "OK"
16. Now back on the Kiwi Syslog Daemon setup page, press the "Browse" button.
17. Select "Syslog" from the list and press "OK".
18. Select "Kiwi MySQL format ISO yyyy-mm-dd" from the Database type/field format dropdown box.
19. Now press the "Create table" button. This will try to connect to the database and create the table called "Syslog" in the database specified by the DSN string. If that was successful then you now have a table ready to receive the syslog messages.
20. Press the "Test" button a few times to log some test messages. This should show the green tick beside the button if successful.
21. Now press the "Query table" button. This will read the last 5 lines from the database and show you the values as well as the database field format information.
22. You can now press the "OK" button on the properties window to close it and accept the changes.

The next time a message is received, it will be logged to the database.

If the create table button or test button gives an error, it will mean that the program can't contact the database via the ODBC DSN. You will need to check the specified DSN is correct. A system reboot may also help.

If you still have issues after following the instructions provided, then please use the technical support form to receive further assistance.