Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask
 
PerlMonks  

How to use Apache::DBI with CGI scripts

( #116851=categorized question: print w/ replies, xml ) Need Help??
Contributed by nagesh on Oct 05, 2001 at 02:33 UTC
Q&A  > CGI programming


Description:

I am loading Apache::DBI module when the apache server starts.
I have
PerlModule Apache::DBI
in httpd.conf and

use Apache::DBI
in startup.pl

and my CGI script looks like this
#! /usr/bin/perl
use strict;
use DBI;
use CGI;
my $date1=time();
my $database="blabla";
my $hostname="blabla";
my $dbh;
$dbh =DBI->connect("DBI:mysql:$database:$hostname","user","his") or die "could not connect to the database:$dbh->errstr\n";
etc., etc.,

the program shows the required results.
So, that should take care of persistant connections ,right??
In other words the connect request would be taken care by Apache::DBI??


how do i check?? if yes
I tried using
$Apache::DBI::DEBUG=2;
and tailing error_log
i see

__________
3516 Apache::DBI PerlChildInitHandler
3516 Apache::DBI PerlChildInitHandler
3517 Apache::DBI PerlChildInitHandler
3517 Apache::DBI PerlChildInitHandler
3519 Apache::DBI PerlChildInitHandler
3519 Apache::DBI PerlChildInitHandler
3518 Apache::DBI PerlChildInitHandler
3518 Apache::DBI PerlChildInitHandler
Thu Oct 4 18:14:55 2001 notice Apache/1.3.19 (Unix) (Red-Hat/Linux) mod_ssl/2.8.1 OpenSSL/0.9.6 DAV/1.0.2 PHP/4.0.4pl1 mod_perl/1.24_01 configured -- resuming normal operations Thu Oct 4 18:14:55 2001 notice suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)

_______
when apache starts but nothing when the page is refreshed.

Please help by answering as much as possible.
thanx in advance..
cheers!
~nagesh

Answer: How to use Apache::DBI with CGI scripts
contributed by cjensen

In your startup script you need to call Apache::DBI->connect_on_init with the same parameters that you pass to DBI->connect.

Make sure things work without with vanilla DBI before adding the Apache::DBI layer.

Just look at netstat to see if there are open connections between your web servers and your database.

The answers to all your questions are here:

http://perl.apache.org/guide/databases.html

Please (register and) log in if you wish to add an answer



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others about the Monastery: (6)
    As of 2015-07-04 02:14 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









      Results (57 votes), past polls