[CLUE-Tech] GPL FTP analysis program?

[greg at knaddison.com]

If you are happy with putting it into a database and running SQL against
that...why not do it?

There are also text ODBC drivers to make the text file act like a database table:

http://edas.visaci.cz/en/unixodbc/

So that you could create the ODBC link to the text file and not have to import
it.  I believe that Oracle can use a text file as a table, but I've never worked
with that.  I don't know about MySQL or PostgreSQL's ability to do that.

Greg

Quoting Jeff Cann <j.cann at isuma.org>:
> Can anyone recommend a versatile FTP log analysis program?  I am not looking
> 
> for standard traffic / size analysis (like you get with webalizer).  I want 
> to scan logs and aggregate data based on the user.  Here are some examples of
> 

> (at work) are coming to me for more analysis.  Ideally, I should have put 
> parsed data into a database and then it would be a snap to answer novel 
> business questions by writing SQL queries.
>