Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Transparent wrapper around DBI for debugging purposes
Posted on 2004-09-08
I have a large code base (which runs under mod_perl) to which I would like to add some debugging code.
I would like to be able to run a bit of code everytime DBI is used to connect, prepare or execute. How can I add this debugging code _without_ editing every call to those methods and _without_ editing the DBI module itself.
I would like to be able to run a bit of code everytime DBI is used to connect, prepare or execute. How can I add this debugging code _without_ editing every call to those methods and _without_ editing the DBI module itself.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
4 Comments
DBI can generate debugging information itself:
set
DBI->trace(2 => "/tmp/logfile");
somewhere near the top of your script.
Or set the environment variable
DBI_PROFILE=2
See manuals for DBI::Profile and DBI::Trace.
(Found this at http://www.class-dbi.com/cgi-bin/wiki/index.cgi?SeeAllSQL)
set
DBI->trace(2 => "/tmp/logfile");
somewhere near the top of your script.
Or set the environment variable
DBI_PROFILE=2
See manuals for DBI::Profile and DBI::Trace.
(Found this at http://www.class-dbi.com/cgi-bin/wiki/index.cgi?SeeAllSQL)
Also see DBI::ProfileDumper::Apache
Here's the synopsis from the manual:
Add this line to your httpd.conf:
PerlSetEnv DBI_PROFILE DBI::ProfileDumper::Apache
Then restart your server. Access the code you wish to test using a web browser, then shutdown your server. This will create a set of dbi.prof.* files in your Apache log directory. Get a profiling report with dbiprof:
dbiprof /usr/local/apache/logs/dbi
When you're ready to perform another profiling run, delete the old files
rm /usr/local/apache/logs/dbi
and start again.
Here's the synopsis from the manual:
Add this line to your httpd.conf:
PerlSetEnv DBI_PROFILE DBI::ProfileDumper::Apache
Then restart your server. Access the code you wish to test using a web browser, then shutdown your server. This will create a set of dbi.prof.* files in your Apache log directory. Get a profiling report with dbiprof:
dbiprof /usr/local/apache/logs/dbi
When you're ready to perform another profiling run, delete the old files
rm /usr/local/apache/logs/dbi
and start again.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads), installed and started the daemon, and had a console window open.
After an hour or two of playing at the command …
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions.
Consider email address RFCs:
Look at HTML5 form input element (with type=email) regex pattern:
T…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month3 days, 15 hours left to enroll
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.