Datamining apache logs with NeoOffice

As Funambol community manager, one of my duties is to know such community. It sounds simple, but since lots of software is involved to gather this knowledge things get less simple. I need to dive into apache logs and I decided to use my good old friend Postgresql. If I could, I would put everything in a database 🙂 The problem is that I also need to rapidly prototype reports to transform data into information for the board. To start navigating the data, I first followed this nice tutorial to load apache logs in PostgreSQL. Connecting the database to NeoOffice was more difficult, mainly because there is no native PostgreSQL driver in NeoOffice and PSQL JDBC page is confusing. Anyway, after trial and error, I found out that on Leopard OS X 10.5 you need JDBC3 for your PSQL version 8.3 (I used the dmg packages). To install the driver I followed the instructions provided here. Now I can start diving in the logs and prepare some reports. The board will be happy soon and I’m glad I’m on my way to better knowledge of this community too.