Re: mod_perl and connect by DBD::Informix

Fri, 03 Jan 2003 22:28:53 -0800 

Maras Michal wrote:

 I wrote simple Apache::ASP page
-------
<HTML>
<BODY>
<%
use DBI;
use DBD::Informix;
You don't need to 'use DBD::Informix'; it will be automagically loaded when you run the connect.

my $dbh = DBI->connect("DBI:Informix:\@server", "", "",{ PrintError =>
0, AutoCommit => 1, });
When there are problems, I'd recommend trying PrintError=>1 and/or RaiseError=>1, especially if you aren't prepared to test whether you've got a valid $dbh before trying to use it.

my $rc=$dbh->disconnect;
%>
</BODY>
</HTML>
-------

This page (perl asp script) work fine, but only first time on
apache child process. Second attemp to run this script cause
segmentation fault of child apache process. When main apache
process then create new child, all is OK, but only for one script
run again, and so on.

What is wrong?

I run perl 5.6.1 without thread on AIX 4.3, apache 1.3.20  mod_perl/1.26
Apache 1.3.20 should be upgraded to avoid some security bugs (1.3.27 is current, I believe). You can debate whether Perl should be 5.8.0. I don't keep the mod_perl version information at hand. However, it is also entirely fair to say that these versions are not relevant to the problem.

You don't say which version of DBD::Informix or DBI you are using;
that would be useful to know. You also don't mention whether you are
using Apache::DBI; that too might be relevant. You don't say which
version of ESQL/C or the Informix database server you are using; those
might be relevant.

It also isn't clear to me how you tell that the page works on the first pass -- the example does not seem to display anything.


--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) #include <disclaimer.h>
Guardian of DBD::Informix 1.04.PC1 -- http://dbi.perl.org/

Reply via email to