[Zope] Logging to a DBMS

[Hannu Krosing]

Douglas Bates wrote:
> 
> I am using zope on a Debian GNU/Linux 2.2 system (the zope_2.1.4-3
> Debian package).  I notice that the access logs are written to a plain
> text file /var/lib/zope/var/Z2.log.
> 
> Are there facilities within Zope to cause it to write its logs to a
> DBMS?  I didn't see anything like this in the documentation except for
> the ability to set ZSYSLOG_SERVER which I don't really think is for
> the access logs.
>

I have hacked me a way to log info in postgres db by

1. writing a function smart_log(user,path) in a separate module 

file: PGSQLLogger.py 
-----8<-----------8<-----------8<-----------8<-----------8<------
import pg,time

def smart_log(user,path):
    f = open('/tmp/Asmartlog.txt','a')
    f.write(user+path+'\n')
    f.close()
    if path[:4] != '/pt/': return
    if user == '-': return
    log_time = '%d-%d-%d %d:%s:%d' % time.localtime(time.time())[:6]
    con = pg.connect('ptweb',user='hannu')
    path = 'http://www.puidutali.ee%s' % path
    con.query("""
        insert into
            access_log(access_when,who,what)
            values('%s','%s','%s')""" % (log_time,user,path))
    con.close()
-----8<-----------8<-----------8<-----------8<-----------8<------

and then using it from a fixed (current logging mechanisms in Zope2 don't log
users ;-O)
PCGIServer.py

fixed log_request() looks like this:
-----8<-----------8<-----------8<-----------8<-----------8<------
    def log_request(self, bytes):
        if self.env.has_key('PATH_INFO'):
            path=self.env['PATH_INFO']
        else:
            path='%s/' % self.server.module
        if self.env.has_key('REQUEST_METHOD'):
            method=self.env['REQUEST_METHOD']
        else:
            method="GET"
        if self.env.has_key('HTTP_CGI_AUTHORIZATION'):
            raw_user = self.env['HTTP_CGI_AUTHORIZATION']
            if not raw_user:
                auth_user = '-'
            else:
                auth_type, auth_string = string.split(raw_user)
                if auth_type != 'Basic':
                    auth_user = '?'
                else:
                    decoded_auth_string = base64.decodestring(auth_string)
                    auth_user = string.split(decoded_auth_string,':')[0]
        else:
            auth_user = '-'
 
        smart_log(auth_user,path)

        addr=self.addr
        if addr and type(addr) is TupleType:
            self.server.logger.log (
                addr[0],
                ' %d - %s [%s] "%s %s" %d %d' % (
                    addr[1],
                    auth_user,
                    time.strftime (
                    '%d/%b/%Y:%H:%M:%S ',
                    time.gmtime(time.time())
                    ) + tz_for_log,
                    method, path, self.reply_code, bytes
                    )
                )
        else:
            self.server.logger.log (
                '127.0.0.1',
                ' - %s [%s] "%s %s" %d %d' % (
                    auth_user,
                    time.strftime (  
                    '%d/%b/%Y:%H:%M:%S ',
                    time.gmtime(time.time())
                    ) + tz_for_log,
                    method, path, self.reply_code, bytes
                    )
                )
-----8<-----------8<-----------8<-----------8<-----------8<------

if you are using any other *Server.py-s you will have to add extracting the
user 
info yourself. Possibly you must also fix the log format as it may be broken
(as 
it was in PCGIServer.py)

------------------------
Hannu