Re: A few simple ones (I hope)

Здравствуйте Iceic,

Sunday, March 23, 2003, 10:01:29 AM, you wrote:

I> I'm running the LogSQLMassVirtualHosting directive as I'm running apache
I> in a similar fashion.

Can  you  write  what  module  did you use for mass virtual hosting in
apache? I think this discussion also will be interest.

I> 1- Is it possible to control what logging information is being outputted
I> to the db? Most of what I can 
I>     find regarding this is restricted to VirtualHost directives, which I
I> don't use. 
I> 2- I don't foresee any need for the headout, headin, notes and cookies
I> tables in my application, and as such
I>     I'd like to be able to tell mod_log_sql to not bother outputting
I> them, as it'll just consume disk space?
I> 3- Whilst I can appreciate that this is the way it does things, I
I> thought I might ask if anyone had found a 
I>     way around it. In a LogSQLMassVirtualHosting environment visits to
I> the site www.blah.com <http://www.blah.com/>  and blah.com are 
I>     recorded under two separate tables. Whilst it's possible for me to
I> code the application around this I thought I might
I>     just double check if there's an easy way to get this done in the
I> logging process. 

My  Directives  of  mod_log_sql,  and  howto  limit logs. In Directive
LogSQLTransferLogFormat you write param whish should be written in db.

### ModLogSQL
LogSQLLoginInfo localhost login password
LogSQLDatabase apachelogs
LogSQLCreateTables on
LogSQLMassVirtualHosting on  # or add in virtualhost directive LogSQLTransferLogTable table_name
LogSQLSocketFile /var/lib/mysql/mysql.sock
LogSQLTransferLogFormat bHmUshuARTS
# A - user agent
# b - bytes_transfer
# H - protocol
# h - remote user
# m - method
# R - refferer
# S - timestamp
# s - HTTP status
# T - serve time
# U - request
# u - user
# v - virtual host

Also I use mod_accounting to see request traffic.

### Mod Accounting
AccountingQueryFmt "INSERT INTO ipaccounting VALUES ('%h', '%r', '%s', null)"
AccountingDatabase accounting
AccountingDatabaseDriver mysql
AccountingDBHost localhost 3306
AccountingLoginInfo login password


-- 
ICQ: 157534201
Успехов в бизнесе,
  Руденко Илья

__________________________________________________________________
Reminder: to unsubscribe, send email to <[email protected]>
with the words "unsubscribe mod_log_sql" in the body (w/o quotes).
The module homepage is http://www.grubbybaby.com/mod_log_sql/