Find the answer to your Linux question:
Results 1 to 8 of 8
OK, I feel kind of stupid for not finding anything, but I'm starting to think that it actually doesn't exist. You know, for Apache pre-2, there is mod_log_sql for logging ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578

    MySQL logging


    OK, I feel kind of stupid for not finding anything, but I'm starting to think that it actually doesn't exist.
    You know, for Apache pre-2, there is mod_log_sql for logging the Apache access logs to a MySQL database, but that module is incompatible with Apache 2, since they've changed the mod API in Apache 2. However, I cannot find anything similar for Apache 2, and I'd really like MySQL logging. Is there really no such module for Apache 2? Does anyone know?

  2. #2
    Linux Engineer
    Join Date
    Apr 2003
    Location
    Sweden
    Posts
    796
    I can look at this when i come to work tommorow to see if i can find anything...Cool though i didnt know you could do that, can you explain a little bit how you set it up....

    Just enable the module and create a valid database and table?? How to know how the table should look like??

    Regards
    Regards

    Andutt

  3. #3
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578
    It comes with a SQL script that you can use as input for the MySQL command line client that sets up all the tables as it wants them. Since I have Apache 2.x, I never tried setting it up, so I don't know exactly what directives to use. I'd really love to have it though; just imagine being able to produce any statistic you could ever want with a single SQL command.
    I'm almost considering downgrading to apache 1.3 just to be able to use it.

  4. #4
    Linux Engineer
    Join Date
    Apr 2003
    Location
    Sweden
    Posts
    796
    I´m relly into it to...so if you found anything let me know. I will look into it also...But you say that it existed in 1.3 but not in the 2.x versions??

    Regards
    Regards

    Andutt

  5. #5
    Linux Engineer
    Join Date
    Apr 2003
    Location
    Sweden
    Posts
    796
    Dolda... What was the name of that module... are you sure it was called mod_log_sql, because i cant find it in any of apache:s module trees. What i find that it think can be god to use is:CustomLog where you can specifie a binary that apache will execute with the logpost as standard in... i think it can be useful.

    I was thinking of putting up a program for that... But if you could find that u used it will be better of course.. then i dont have to do it myself..

    Regards
    Regards

    Andutt

  6. #6
    Linux Engineer
    Join Date
    Apr 2003
    Location
    Sweden
    Posts
    796
    Loooook what i found!!

    http://www.grubbybaby.com/mod_log_sql

    Its ported for 2.x also.....

    Code:
    Id: CHANGELOG,v 1.20 2002/12/18 01:39:28 helios Exp $
    
    TODO:
    * Rethink documentation flow and rewrite?
    * Port connection portion to other DBMS?  Genericize the module?  Start with 
      PostgreSQL.
    * GNU autoconf
    * merge server config into vh config
    * port to Apache 2.x

    Regards
    Regards

    Andutt

  7. #7
    Linux Guru
    Join Date
    Oct 2001
    Location
    Täby, Sweden
    Posts
    7,578
    No, that's in their TODO. It's not ported yet.

  8. #8
    Linux Engineer
    Join Date
    Apr 2003
    Location
    Sweden
    Posts
    796
    Yea right...though maybe i should read next time...

    Regards
    Regards

    Andutt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •