Re^2: DBI trace has limited output


XP is just a number
	PerlMonks

Re^2: DBI trace has limited output

by Anonymous Monk

on Oct 25, 2021 at 10:51 UTC ( [id://11138004]=note: print w/replies, xml )

Need Help??

in reply to Re: DBI trace has limited output
in thread DBI trace has limited output

Thanks a lot for your effort.I found what happens.I had to wrap the following in a BEGIN block at the top of the CGI script:

BEGIN { $ENV{DBI_TRACE}='15=/var/www/xx/dbitrace.log';use DBI; }

The output now shows everything including the sql statements and the data retrieved.
What does BEGIN do and why has it made such a big difference? I think it has something to do with the environment that Apache/CGI runs,like that Apache initializes something before the perl script runs? What do you think?

Comment on Re^2: DBI trace has limited output

Replies are listed 'Best First'.
Re^3: DBI trace has limited output by bliako (Monsignor) on Oct 25, 2021 at 20:36 UTC
This is equivalent to `DBI_TRACE=15 perl myscript.pl`. Your solution looks to me to be the nuclear option. I would investigate further. With Apache, since Re: DBI trace has limited output (this has already done it for you without Apache.	[reply] [d/l]
Re^3: DBI trace has limited output by Anonymous Monk on Oct 25, 2021 at 11:24 UTC
"A BEGIN code block is executed as soon as possible, that is, the moment it is completely defined, even before the rest of the containing file (or string) is parsed." and use "is exactly equivalent to `BEGIN { require Module; Module->import( LIST ); }`" so it sets the variable before DBI is even loaded so DBI can pick it up immediately	[reply] [d/l]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://11138004]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others having an uproarious good time at the Monastery: (3)

As of 2024-04-19 19:00 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found