Hi,
I'm trying to use mod_perl to get persistant database connections in a perl
CGI script. I'm experiencing a problem with an extraneous:
Connection: close
line between my http info and my html info.
If you can help, a tarball with details (possibly more than you'll ever
want to know!) is available.
In brief, I'm running Red Hat 6.0 with Apache 1.3.6, mod_perl 1.21, MySql
3.22.27, DBI 1.13 and Apache::DBI 0.87.
My program is designed to assist my friends in maintaining their own
web-site. HTML page information is stored in a database, where new pages
can be added, and existing pages can be modified.
The program solicits username and password, does an initial connect, then
redirects itself to self_url, with action=Select Page (and with
username/password info). Function select_page is called, based on the
action. It does another connect (hopefully, with the assistance of
Apache::DBI, simply returning a hashed value). Then selects the name and
description of stored pages into a list for use in a scrolled_list control.
All this happens fine, except that the extraneous Connection: close line
crops up in the middle of the returned HTML, which throws the browser for a
loop: it cannot display the page/form as desired, simply displays the
entire text of the page (control info included), with the extraneous line
intruding.
In contrast, when I invoke the script from command line, the extraneous
line is not included.
I could easily spend a long time bleeding here. I have no idea what or
where the problem could be. (Although it happens both when I have the line:
use Apache::DBI;
in my mod_perl startup.pl script, and when I have the line commented out.
Hence I suspect it could be more of a mod_perl problem than an Apache::DBI
problem.)
Any and all help you can give will be greatly appreciated.
Mike Harrison
