I'm hearing rumblings that sound like PHP and mod_perl/mysql don't tend to
work very well together... I hope I can work around that.

  Anyway, here is a pared down version of the Embperl File that is causing
the Sigmentation fault (11).

http://gmbp.m8rix.net/steve/test.phtml
--------------------------------------------
<html>
<head>
</head>
<body>
[-
use DBI;
DBI->trace(4, "dbitrace.log");
-]
<pre>

[$ if (!($dbc_gmbp = DBI->connect("dbi:mysql:buypower", "testuser",
"testuser",
{PrintError => 1, RaiseError => 1}))) $]
        DBI Connection failed: [+ $DBI::errstr +]
[$ else $]
        [- $sth = $dbc_gmbp->prepare("select * from role_desc"); -]
        [- $sth->execute(); -]

        [$ while (@aRow = $sth->fetchrow_array) $]
                [+ join("\t", @aRow) +]
        [$ endwhile $]
        [-
        $sth->finish;
        $dbc_gmbp->disconnect;
        -]
[$ endif $]

</pre>
...End
</html>
--------------------------------------------

  You can see the dbitrace.log at:
http://gmbp.m8rix.net/steve/dbitrace.log -- I'm not worried about the
"testuser" id.  It's only a temporary MySQL user ID.

Here are some pieces of httpd.conf:
--------------------------------------------
PerlModule HTML::Embperl
SetEnv EMBPERL_DEBUG 2285
SetEnv EMBPERL_VIRTLOG /tmp/embperl.log
PerlModule Apache::DBI

# When Mod_perl is installed...
<Location /perl-status>
    AllowOverride None
    SetHandler perl-script
    PerlHandler Apache::Status
    allow from all
    PerlSendHeader On
</Location>

# Mod_perl default Location
<Location /perl>
    #AllowOverride None
    SetHandler perl-script
    PerlHandler Apache::Registry
    Options ExecCGI
    allow from all
    # PerlSendHeader On
    PerlSendHeader Off
</Location>

# EmbedPerl files...
<Files *.phtml>
  SetHandler  perl-script
  PerlHandler HTML::Embperl
  Options     ExecCGI
  PerlSendHeader On
</Files>
AddType text/html .phtml
--------------------------------------------

You can take a look at http://gmbp.m8rix.net/perl-status

No RPMs.  Everything compiled and installed.  I have mod_perl compiled as a
DSO.

Any help would be appreciated...

Steve Wilder
Matrix Interactive, Inc.
http://www.matrixinteractive.net/
Desk: 248.814.8235
Cell: 248.894.3128
Fax : 248.814.8236
BEGIN:VCARD
VERSION:2.1
N:Wilder;Steve
FN:Steve Wilder
ORG:Matrix Interactive, Inc.
TITLE:President
TEL;WORK;VOICE:(248) 814-8235
TEL;CELL;VOICE:(248) 894-3128
TEL;WORK;FAX:(248) 814-8236
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20000814T125443Z
END:VCARD

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to