[Mod_log_sql] Funny table names patch

Thomas Goirand thomas at goirand.fr
Sun Apr 27 08:52:48 EDT 2008


Edward Rudd wrote:
> On Apr 27, 2008, at 7:33 AM, Thomas Goirand wrote:
>> Hi,
>>
> 
> Thanks for the patch..  would you mind attaching it to http:// 
> issues.outoforder.cc/view.php?id=83

Hi,

The patch is now attached to this bug issue (I like Mantis, we use it
too... :)).

> I'll be starting into mod_log_sql development again, now that some  
> other bigger projects are completed. (http://www.penumbra- 
> overture.com/ and http://www.penumbrablackplague.com/site/)

Wow, Edward, I'm impressed! I didn't know you were also doing game
programming! :) What part do you do in it?

> I would very much like the script yes. mod_log_sql SVN is in a  
> transition stage with a new configuration system to handle table  
> configuration.  So instead of saying I want to log "V"  you would log  
> "virtual_host" and you can configure "virtual_host" to be logging the  
> virtual_host metric into the table field "MyVHost"  along with  
> associated data types (VARCHAR(255)). So that I can write a  
> mechanism that will upgrade the DB tables, when the configuration  
> changes.

Would it be possible to have a hook at the start of apache to do DB
maintenance? To me, that would be the best way: you'd check it once, and
possibly send errors to the log files of Apache if there is the need to
do it. Then no need to do extra checks at run time.

> Also I have a DBD module for mod_log_sql for use with  
> apache 2.2 (aka proper threading support with on demand DB  
> connections!!)

DBD has so many meanings, here is only the one related to our subjects:

Dabase Description
Database Design
base Dictionary (file extension)
Day-By-Day
Design Basis Document

Can you explain more?

>> Also, does any of you knows a RELIABLE and EASY way to get the  
>> login and
>> password for the SQL database out of the apache configuration? That
>> would be great to be able to do this, so we could get the login and
>> password from the config files directly, but as there are lot's of
>> include possibilities, it might be quite hard to do it.
> 
> yup.. tis quite fun.. the only easy way is to just parse in the  
> "Include" directive and follow the includes and watch for the  
> mod_log_sql configuration directives.

I'm sure I'm not the only one having the problem, I'll see if I can find
someone or some project that address it.

Thomas



More information about the Mod_log_sql mailing list