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

Jay Lee <jleepbu.edu> writes:

> 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?

I can't remember when this was enabled, but depending on
your minor
version, 'loglevel pcache' could give you hints.


-Dieter

-- 
Dieter Klünter | Systemberatung
http://www.dkluenter.de
GPG Key ID:8EF7B6C6

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.caopenldap.org
[mailto:openldap-software-bounces+jpb=entel.caopenldap.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