RE: Query Log and stats?

[Paul Blondé <jpb@entel.ca>]

In slapd.conf, you need to set your log level.

Search for the line that contains "loglevel" or "logging parameters".

Edit or add the line:

loglevel	###

where ### is built from this info:

Level		Information recorded
-1		Everything
0		Nothing
1		Trace function calls
2		Packet-handling debugging information
4		Heavy trace debugging
8		Connection management
16		Packets sent and received
32		Search filter processing
64		Configuration file processing
128		Access control list processing
256		Statistics for connections, operations and results
512		Statistics for results returned to clients
1024		Communication with shell backends
2048		Print entry parsing debug information

(you can AND/add these values to get more than one active, i.e.: 7 would
give you function calls, packet-handling and heavy trace debugging)

You also need the entry

local4.debug		/var/log/slapd.log (or whatever file you prefer,
this is standard)

in your /etc/syslog.conf file and 

kill -HUP

the syslogd to force it to re-read the file.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Paul Blondé


-----Original Message-----
From: openldap-software-bounces+jpb=entel.ca@openldap.org
[mailto:openldap-software-bounces+jpb=entel.ca@openldap.org] On Behalf Of
Jay Lee
Sent: Wednesday, July 18, 2007 2:44 PM
To: OpenLDAP Software List
Subject: Query Log and stats?


I am using OpenLDAP 2.3 as a proxy cache to our primary eDirectory LDAP 
Server.  The proxy is working but in order to optimize the cache, I need 
to specify the search queries and attributes to index in slapd.conf.  Is 
there an easy way to log what queries are being run and how often?

Jay Lee