Getting detailed info on db queries

Does there exist any verbose or debug flag within RT somewhere which
would allow one to see the actual database queries that are being
performed by RT? (e.g., log the exact queries performed by RT to a
file)

Thanks,

ph.

Does there exist any verbose or debug flag within RT somewhere which
would allow one to see the actual database queries that are being
performed by RT?

Nope. Use your databases query logging facility.

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

There are several methods of logging queries.

The relational db you have chosen will have its own method: consult the
manuals.

Perl’s DBI module is used in RT. It’s docs are here:

The debugging section for DBI is here:

Exporting the DBI_TRACE variable prior to starting Apache will allow you
to log DBI calls.

Assuming you are using Apache 1.3.x and modperl1, in httpd.conf you can
add:

PerlSetEnv DBI_TRACE 2=/opt/rt3/var/log/dbi.log

which came from here:

sEnv

touch /opt/rt3/var/log/dbi.log and chown it to have the proper
user/group (i.e. the one Apache is running under.

Now restart Apache (i.e. RT).

/opt/rt3/var/log/dbi.log will start to fill up as you do searches in RT.

It sounds like the logging facility of your relational db is more what
you are looking for. Looking at the DBI level can give some insight
into what modules are making which queries.

Gurdon