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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s