Bug #72534 for DBD-ODBC: Unwanted debugging output appears on console

Fri Nov 18 14:10:48 2011 john.deighan [...] gmail.com - Ticket created

Subject:

Unwanted debugging output appears on console

I'm running Microsoft Windows Server 2003 SP2, ActivePerl 5.12.4, DBI 1.616 and DBD-ODBC 1.31 (in the 'site' area, ActivePerl came with 1.29 in the 'perl' area). I wrote a script to test database fetches, and in the console appeared a number of lines that just said 'HERE'. I used the debugger that comes with the ActiveState Perl Development Kit to step through the program, and the lines appeared when the statement $st->bind_param() was being called. So (using TextPad, my preferred text editor), I searched all files in my c:\Perl\site\lib directory for an all upper-case word 'HERE' and found it in the file: C:\Perl\site\lib\auto\DBD\ODBC\ODBC.dll FYI, the file properties say the file was created on Tuesday, November 08, 2011, 10:27:21 AM and has size 98,405 bytes TextPad actually allowed me to change the string 'HERE' to the string 'DEIG' and sure enough, when I re-ran my test script, the 'HERE' lines now appear as 'DEIG'. I'm assuming that someone left some debugging code in there. I hadn't seen this behavior before, but some of the recent

Fri Nov 18 14:34:23 2011 bohica [...] ntlworld.com - Correspondence added

On Fri Nov 18 14:10:48 2011, jdeighan wrote: Show quoted text

> I'm running Microsoft Windows Server 2003 SP2, ActivePerl 5.12.4, DBI > 1.616 and DBD-ODBC 1.31 (in the 'site' area, ActivePerl came with 1.29 > in the 'perl' area). I wrote a script to test database fetches, and in > the console appeared a number of lines that just said 'HERE'. I used the > debugger that comes with the ActiveState Perl Development Kit to step > through the program, and the lines appeared when the statement > $st->bind_param() was being called. So (using TextPad, my preferred text > editor), I searched all files in my c:\Perl\site\lib directory for an > all upper-case word 'HERE' and found it in the file: > > C:\Perl\site\lib\auto\DBD\ODBC\ODBC.dll > > FYI, the file properties say the file was created on Tuesday, November > 08, 2011, 10:27:21 AM and has size 98,405 bytes > > TextPad actually allowed me to change the string 'HERE' to the string > 'DEIG' and sure enough, when I re-ran my test script, the 'HERE' lines > now appear as 'DEIG'. I'm assuming that someone left some debugging code > in there. > > I hadn't seen this behavior before, but some of the recent

Gross embarressment - I always diff stuff before checking in so I'm amazed I missed this. I will remove it from the subversion trunk tonight and it will be fixed in the next release which will be in the next few days. You can remove it yourself so long as you install MinGW from ActiveState. Just download latest DBD::ODBC, untar it and edit dbdimp.c to remove the printf containing "HERE". Write it out then do run cpan and install . Thanks again for the report. The debug is in an obscure area of DBD::ODBC so few people are going to see it but it needs fixing. Martin -- Martin J. Evans Wetherby, UK

Fri Nov 18 14:34:24 2011 The RT System itself - Status changed from 'new' to 'open'

Fri Nov 18 15:17:12 2011 bohica [...] ntlworld.com - Correspondence added

Fixed in trunk of subversion now. Thanks Martin -- Martin J. Evans Wetherby, UK

Fri Nov 18 15:17:40 2011 bohica [...] ntlworld.com - Status changed from 'open' to 'patched'

Fri Nov 18 15:25:55 2011 john.deighan [...] gmail.com - Correspondence added

Subject:	Re: [rt.cpan.org #72534] Unwanted debugging output appears on console
Date:	Fri, 18 Nov 2011 15:25:45 -0500
To:	bug-DBD-ODBC [...] rt.cpan.org
From:	John Deighan <john.deighan [...] gmail.com>

No problem. Shit happens. Thanks for the quick reply. On Fri, Nov 18, 2011 at 2:34 PM, Martin J Evans via RT <bug-DBD-ODBC@rt.cpan.org> wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=72534 > > > On Fri Nov 18 14:10:48 2011, jdeighan wrote:

>> I'm running Microsoft Windows Server 2003 SP2, ActivePerl 5.12.4, DBI >> 1.616 and DBD-ODBC 1.31 (in the 'site' area, ActivePerl came with 1.29 >> in the 'perl' area). I wrote a script to test database fetches, and in >> the console appeared a number of lines that just said 'HERE'. I used the >> debugger that comes with the ActiveState Perl Development Kit to step >> through the program, and the lines appeared when the statement >> $st->bind_param() was being called. So (using TextPad, my preferred text >> editor), I searched all files in my c:\Perl\site\lib directory for an >> all upper-case word 'HERE' and found it in the file: >> >> C:\Perl\site\lib\auto\DBD\ODBC\ODBC.dll >> >> FYI, the file properties say the file was created on Tuesday, November >> 08, 2011, 10:27:21 AM and has size 98,405 bytes >> >> TextPad actually allowed me to change the string 'HERE' to the string >> 'DEIG' and sure enough, when I re-ran my test script, the 'HERE' lines >> now appear as 'DEIG'. I'm assuming that someone left some debugging code >> in there. >> >> I hadn't seen this behavior before, but some of the recent

> > Gross embarressment - I always diff stuff before checking in so I'm > amazed I missed this. I will remove it from the subversion trunk tonight > and it will be fixed in the next release which will be in the next few days. > > You can remove it yourself so long as you install MinGW from > ActiveState. Just download latest DBD::ODBC, untar it and edit dbdimp.c > to remove the printf containing "HERE". Write it out then do run cpan > and install . > > Thanks again for the report. The debug is in an obscure area of > DBD::ODBC so few people are going to see it but it needs fixing. > > Martin > -- > Martin J. Evans > Wetherby, UK >

Fri Nov 18 15:25:56 2011 The RT System itself - Status changed from 'patched' to 'open'

Fri Nov 18 15:31:24 2011 bohica [...] ntlworld.com - Status changed from 'open' to 'patched'

Tue Nov 29 06:25:19 2011 bohica [...] ntlworld.com - Status changed from 'patched' to 'resolved'

Tue Nov 29 06:25:20 2011 bohica [...] ntlworld.com - Fixed in 1.32_4 added