Detailing tracking of user activity for in depth BI

[semiwiki]

Sorry if this is a FAQ, if so please point me in the right direction.

I want to collect and report on all user (by user name) activity related to forum posts. For example, for the post at http://www.semiwiki.com/forum/conten...han-intel.html, for every view of the post I'd like to gather:
- time
- user name
- (match against web server log) referrer
- (match against web server log) ip address
- (match against user profile) to grab other stored info about the user
- (match against metadata of forum post) to grab categories, etc.

I understand that most of this is available via google analytics, but it's anonymous. I don't know how to include user name.
If necessary I'm willing to scan the webserver logs and mysql tables directly.

What are the names of the mysql tables I need to scan?
Do I need to enable any logging, or add plugins to do the logging?

Thanks.