ok so now i have tried using warn and i get check1 and check2 but not check3.
I am thinking that it must be something in my setup rather than my code.
in my httpd.conf I have...
Alias /perl/ /var/www/perl/
PerlModule Apache::PerlRun
PerlModule DBI
PerlModule DBD::mysql
<Location /perl/>
SetHandler perl-script
PerlHandler Apache::PerlRun
Options +ExecCGI
PerlSendHeader On
allow from all
</Location>
stats for my system.......
OpenBSD 3.8 GENERIC#138 i386
perl v5.8.6
Apache/1.3.29 (Unix) mod_perl/1.29 mod_ssl/2.8.16 OpenSSL/0.9.7g
mysql Ver 12.22 Distrib 4.0.24
At 01:29 p.m. 6/02/2006, Michael Peters wrote:
Derek Robson wrote:
>
>
> print "check1";
> my $dbArgs = { RaiseError => 1, AutoCommit => 0 , TraceLevel => 3 ,
> PrintError => 1 };
> print "check2";
> my $dbh = DBI->connect("DBI:mysql:database=answerguy;",
> "robsonde", "ur4xgod",$dbArgs )
> or die "Cannot connect to database: $!";
> print "check3";
>
>
>
> with this code i get check1 and check 2 but not check3 or any error.
Not to be harsh, but you didn't follow my advice, or the advice of the poster
previous to me. User "warn" not "print" so that it goes to your apache error
log, not the browser. Then if that doesn't help, try starting in
single process
mode and using the Perl debugger.
Using DBI and querying a database from mod_perl can be done the same
as from the
command line, so something is really weird with your setup.
> I think I hate modperl
I'm not sure I blame you, but wouldn't it be nice to find out why this is
happening since it doesn't happen to anyone else?
--
Michael Peters
Developer
Plus Three, LP
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.2/251 - Release Date: 4/02/2006
