Adam Williams used his Toshiba laptop running OpenSuSE v10.x and the SVGA projector to display 26 slides prepared with OpenOffice.org Impress about cross-platform network system level logging. He was wearing a t-shirt that declared that "open source is addictive." The often apparent smile on Adam’s face indicates that this is a very positive addiction.
Adam’s presentation covered setting up syslog and syslog-ng clients to record to a centralized syslog-ng log server. The pipe function is used to deliver the data to the destination. This can log the activity of both Windows and Linux systems. On the central server the logs can be recorded to basically any store, but in this case the example will be a PostgreSQL database. Storing your logs into an SQL database provides a great deal of functionality in regards to analysis and system reporting.
DbVisualizer is a cross-platform database visualization and management tool. This is the program that Adam uses to view the syslog data after conversion by the SQL creating script. Just point and click to browse the SQL data from syslog -ng.