Another Apache::DBI problem

2001-09-06 Thread Mauricio Herrera

Hi!

I'm running modperl 1.26 and apache 1.3.20 on a Solaris machine. I added
Apache::DBI and other DBI modules.

I added the following line to the httpd.conf line to use Apache::DBI

PerlModule Apache::DBI

Before any other DBI command as stated on the docs. Here's the error I get
at starting apache:

Syntax error on line 304 of /export/apache/conf/httpd.conf:
Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so' for
module DBI: ld.so.1: /export/apache/bin/httpd: fatal: relocation error:
file /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so:
symbol main: referenced symbol not found at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.
 at /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 189
BEGIN failed--compilation aborted at
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 189.
Compilation failed in require at
/usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 4.
BEGIN failed--compilation aborted at
/usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 4.
Compilation failed in require at (eval 4) line 3.

Line 304 of httpd.conf is the PerlModule Apache::DBI command.

Any ideas? 

Thanks for your help!

Mauricio




Re: Another Apache::DBI problem

2001-09-06 Thread Perrin Harkins

 Syntax error on line 304 of /export/apache/conf/httpd.conf:
 Can't load
 '/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so' for
 module DBI: ld.so.1: /export/apache/bin/httpd: fatal: relocation error:
 file /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so:
 symbol main: referenced symbol not found at
 /usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.
  at /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 189
 BEGIN failed--compilation aborted at
 /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 189.
 Compilation failed in require at
 /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 4.
 BEGIN failed--compilation aborted at
 /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 4.
 Compilation failed in require at (eval 4) line 3.

 Line 304 of httpd.conf is the PerlModule Apache::DBI command.

 Any ideas?

This looks like a DBI installation problem, not an Apache::DBI problem.
Does DBI work when you don't use Apache::DBI?
- Perrin




Re: Another Apache::DBI problem

2001-09-06 Thread Mauricio Herrera

This looks like a DBI installation problem, not an Apache::DBI problem.
Does DBI work when you don't use Apache::DBI?
- Perrin

You are right. It gives me the same error when I try to use DBI alone:

[error] Can't load
'/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so' for
module DBI: ld.so.1: /export/apache/bin/httpd: fatal: relocation error:
file /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI/DBI.so:
symbol main: referenced symbol not found at
/usr/local/lib/perl5/5.6.1/sun4-solaris/DynaLoader.pm line 206.
 at /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 189
BEGIN failed--compilation aborted at
/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/DBI.pm line 189.
Compilation failed in require at /export/www/perl/dbi.html line 1.
BEGIN failed--compilation aborted at /export/www/perl/dbi.html line 1.


The DBI installation went fine, I used CPAN. DBI version is 1.20. I looked
for the DBI.so and the DBI.pm files and they are in the correct paths. 

What may be the problem?

Thanks!

Mauricio




Re: Another Apache::DBI problem

2001-09-06 Thread Perrin Harkins

 The DBI installation went fine, I used CPAN. DBI version is 1.20. I looked
 for the DBI.so and the DBI.pm files and they are in the correct paths.

 What may be the problem?

I don't know, but you might have more luck asking about it on the DBI list.
Or you could do some searching on Google for similar error messages.
- Perrin




Re: Apache::DBI problem

2001-05-06 Thread Edmund Mergl

Grigoriy G. Vovk wrote:
 
 Here are my files:
 
 httpd.conf -
 
 Alias /perl/ /usr/local/www/perl/
 PerlModule Apache::DBI
 PerlRequire /usr/local/www/startup.pl
 PerlModule Apache::Registry
 PerlModule Apache::DBI
 PerlSetEnv PERLDB_OPTS NonStop=1 LineInfo=/tmp/db.out AutoTrace=1 frame=2
 PerlModule Apache::DB
 Location /perl
 PerlFixupHandler Apache::DB
 SetHandler perl-script
 PerlHandler Apache::Registry
 Options +ExecCGI
 AllowOverride None
 Order allow,deny
 Allow from all
 PerlSendHeader on
 /Location
 
 startup.pl -
 
 use strict;
 $ENV{MOD_PERL} or die not running under mod_perl!;
 use Apache::DBI ();
 use Apache;
 use Apache::Cookie;
 use Apache::Request;
 use Carp();
 $SIG{__WARN__} = \Carp::cluck;
 sub My::ProxyRemoteAddr ($) {
   my $r = shift;
   return unless ($r-connection-remote_ip eq 127.0.0.1);
   if (my ($ip) = $r-header_in('X-Forwarded-For') =~ /([^,\s]+)$/) {
 $r-connection-remote_ip($ip);
   }
   return ;
 }
 Apache::DBI-connect_on_init
 (dbi:Pg:dbname=jewelry,'','',
 {
 PrintError = 1,
 RaiseError = 0,
 AutoCommit = 1,
 });
 
 my programm -
 
 use strict;
 use Apache::DBI;


  not necessary, your script should run unchanged under Apache::DBI


 $Apache::DBI::DEBUG = 2;
 use Apache;
 use Carp();
 local $SIG{__WARN__} = \$Carp::cluck;
 my $dbh;
 $dbh = DBI-connect(dbi:Pg:dbname=jewelry, '', '');


if you don't use exactly the same connect-string, as in startup.pl, you
will not get a persistent connection.


 my $r=shift;
 $r-send_http_header('text/html');
 my $sql = select * from tbl_category;
 my $sth = $dbh-prepare($sql);
 my $rs = $sth-execute();
 my @rs;
 while(@rs = $sth-fetchrow_array){
 $r-print($rs[0]\t$rs[1]\n);
 }
 $sth-finish;
 $dbh-disconnect;
 
 and httpd-error.log -
 
 [Sat May  5 16:35:28 2001] [notice] FastCGI: process manager initialized (pid 14154)
 [Sat May  5 16:35:29 2001] [notice] Apache/1.3.19 (Unix) mod_fastcgi/2.2.10 
mod_perl/1.25
 configured -- resuming normal operations
 Default die handler restored.
 14156 Apache::DBI need ping: yes
 14156 Apache::DBI new connect to 
'dbname=jewelryPrintError=1AutoCommit=1'
 [Sat May  5 16:39:27 2001] [error] Not a subroutine reference at
 (eval 225)[/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/Apache/Registry.pm:177] 
line 73.
 
 Line 73 is my $rs = $sth-execute();


your $sth is undefined.


 
 So, does anybody understand what's going on?
 Why my programm doesn't work?
 It works as plain perl script perfect.
 And Apache::Session::Store::Postgres works perfect - it mean, mod_perl
 works with Postgres.
 
 Thank's,
 
 my best regards,
 -
 Grigoriy G. Vovk


always check the return values of all DBI-methods, eg

instead of: $dbh = DBI-connect(..);

use:$dbh = DBI-connect(..) or die db connect error;

and instead of: my $sth = $dbh-prepare($sql);

use:my $sth = $dbh-prepare($sql) or die $DBI::errstr;

or something equivalent.



Edmund

-- 
http://www.edmund-mergl.de
fon: +49 700 edemergl



Apache::DBI problem

2001-05-05 Thread Grigoriy G. Vovk

Here are my files:

httpd.conf -

Alias /perl/ /usr/local/www/perl/
PerlModule Apache::DBI
PerlRequire /usr/local/www/startup.pl
PerlModule Apache::Registry
PerlModule Apache::DBI
PerlSetEnv PERLDB_OPTS NonStop=1 LineInfo=/tmp/db.out AutoTrace=1 frame=2
PerlModule Apache::DB
Location /perl
PerlFixupHandler Apache::DB
SetHandler perl-script
PerlHandler Apache::Registry
Options +ExecCGI
AllowOverride None
Order allow,deny
Allow from all
PerlSendHeader on
/Location

startup.pl -

use strict;
$ENV{MOD_PERL} or die not running under mod_perl!;
use Apache::DBI ();
use Apache;
use Apache::Cookie;
use Apache::Request;
use Carp();
$SIG{__WARN__} = \Carp::cluck;
sub My::ProxyRemoteAddr ($) {
  my $r = shift;
  return unless ($r-connection-remote_ip eq 127.0.0.1);
  if (my ($ip) = $r-header_in('X-Forwarded-For') =~ /([^,\s]+)$/) {
$r-connection-remote_ip($ip);
  }
  return ;
}
Apache::DBI-connect_on_init
(dbi:Pg:dbname=jewelry,'','',
{
PrintError = 1,
RaiseError = 0,
AutoCommit = 1,
});

my programm -

use strict;
use Apache::DBI;
$Apache::DBI::DEBUG = 2;
use Apache;
use Carp();
local $SIG{__WARN__} = \$Carp::cluck;
my $dbh;
$dbh = DBI-connect(dbi:Pg:dbname=jewelry, '', '');
my $r=shift;
$r-send_http_header('text/html');
my $sql = select * from tbl_category;
my $sth = $dbh-prepare($sql);
my $rs = $sth-execute();
my @rs;
while(@rs = $sth-fetchrow_array){
$r-print($rs[0]\t$rs[1]\n);
}
$sth-finish;
$dbh-disconnect;

and httpd-error.log -

[Sat May  5 16:35:28 2001] [notice] FastCGI: process manager initialized (pid 14154)
[Sat May  5 16:35:29 2001] [notice] Apache/1.3.19 (Unix) mod_fastcgi/2.2.10 
mod_perl/1.25
configured -- resuming normal operations
Default die handler restored.
14156 Apache::DBI need ping: yes
14156 Apache::DBI new connect to 
'dbname=jewelryPrintError=1AutoCommit=1'
[Sat May  5 16:39:27 2001] [error] Not a subroutine reference at
(eval 225)[/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/Apache/Registry.pm:177] 
line 73.

Line 73 is my $rs = $sth-execute();

So, does anybody understand what's going on?
Why my programm doesn't work?
It works as plain perl script perfect.
And Apache::Session::Store::Postgres works perfect - it mean, mod_perl
works with Postgres.

Thank's,

my best regards,
-
Grigoriy G. Vovk




Re: Apache::DBI problem and writting a perl module!!!

2001-01-11 Thread Stas Bekman

On Thu, 11 Jan 2001, R. K . Mallah wrote:

 Stas , I do not face the problem anymore and Apache::DBI is loading
 without any problem. But i remember of facing problem at one point of time.
 may be with some older version.

Ok

 Could u please explain me  what does Apache-module do and where is
 it defined ?

Why does it matter? You won't be able to test most of the Apache:: modules
from the command line, since the environment is wrong.

From ch9 in the eagle book:

=item module()

If you need to find out if a Perl module has already been loaded, the
Imodule() method will tell you.  Pass it the package name of the
module you're interested in.  It will return a true value if the
module is loaded.

Example:

 do { #something } if Apache-module('My::Module');

This method can also be used to test if a C module is loaded.  In this
case, pass it the filename of the module, just as you would use with the
IIfModule directive.  It will return a true value if the
module is loaded.

Example:

 do { #something } if Apache-module('mod_proxy.c');


_
Stas Bekman  JAm_pH --   Just Another mod_perl Hacker
http://stason.org/   mod_perl Guide  http://perl.apache.org/guide
mailto:[EMAIL PROTECTED]   http://apachetoday.com http://logilune.com/
http://singlesheaven.com http://perl.apache.org http://perlmonth.com/





Re: Apache::DBI problem and writting a perl module!!!

2001-01-10 Thread R. K . Mallah


I faced the same problem and had posted similar email
but I found an workaround that is there in the posting.


I get following error when i do
perl -e 'use Apache::Status;use Apache::DBI'
Can't locate object method "module" via package "Apache" at /usr/lib/perl5/site_perl/5.6.0/Apache/DBI.pm
line 202.
Compilation failed in require at -e line 1.
BEGIN failed--compilation aborted at -e line 1.

the problem is when preparing menu_item for Apache::Status method
module is
not found under Apache,
do i have to install some other Apache module?
anyway i commented out the if part and made it work like
Apache::Status->menu_item(
 'DBI' => 'DBI connections',
 sub {
 my($r,
$q) = @_;
 my(@s)
= qw(TABLE>TR>TD>Datasource/TD>TD>Username/TD>/TR>);
 for (keys
%Connected) {

push @s, 'TR>TD>', join('/TD>TD>', (split($;, $_))[0,1]),
"/TD>/TR>\n";
 }
 push @s,
'/TABLE>';
 return
\@s;
 }
);
# ) if ($INC{'Apache.pm'} and Apache->module('Apache::Status'));

is it correct ?
why shouldn't it load without any modifications ?
Regards
Mallah



--
Rajesh Kumar Mallah,
Learning Universe Pvt. Ltd,
Piccadily House, 4th Floor,
275-276, Capt. Gaur Marg,
Okhla, Sriniwas puri,
New Delhi 110 065.
M : +919811255597
T : 91-11 6931601-04
W : http://www.egurucool.com
E : [EMAIL PROTECTED]







Edmar Edilton da Silva wrote:
 Hi all,
 I still didn't solve the problem of the Apache::DBI.
It can not be
loaded into the apache's startup.pl file because happens a error during
the starting of the apache, the child processes are not created. For
using the Apache::DBI I had to add the "use Apache::DBI ()" code at
the
beginning of each perl script.
Is it correct? Is the performance of the system damaged? I am working
in
this problem for some days, How I dont solve it, I intend to write
my
own connection pool. Please, can anyone tell me where I can find docs
about this? Thanks for all.


Edmar Edilton da Silva
 Bacharel em Cincia da Computaco -
UFV
 Mestrando em Cincia da Computaco - UNICAMP


--
__ Technology Rules __
Rajesh Kumar Mallah,
M : +919811255597




Re: Apache::DBI problem and writting a perl module!!!

2001-01-10 Thread Stas Bekman

On Wed, 10 Jan 2001, R. K . Mallah wrote:

  I faced the same problem and had  posted  similar email
 but I found an workaround that is there in the posting.


 
 I get following error when i do

 perl -e 'use Apache::Status;use Apache::DBI'

 Can't locate object method "module" via package "Apache" at
 /usr/lib/perl5/site_perl/5.6.0/Apache/DBI.pm line 202.
 Compilation failed in require at -e line 1.
 BEGIN failed--compilation aborted at -e line 1.


 the problem is when preparing menu_item for Apache::Status method module
 is
 not found under Apache,

 do i have to install some other Apache module?

it has nothing to do with this. You cannot test Apache modules from the
command line since you aren't running in mod_perl environment.

please read the documentation -- you have to load the Apache::Status
before Apache::DBI.

 anyway i commented out  the if part and made it work like

 Apache::Status-menu_item(

 'DBI' = 'DBI connections',
 sub {
 my($r, $q) = @_;
 my(@s) =
 qw(TABLETRTDDatasource/TDTDUsername/TD/TR);
 for (keys %Connected) {
 push @s, 'TRTD', join('/TDTD', (split($;,
 $_))[0,1]), "/TD/TR\n";
 }
 push @s, '/TABLE';
 return \@s;
}

 );

 # ) if ($INC{'Apache.pm'} and Apache-module('Apache::Status'));


 is it correct ?

 why shouldn't it load without any modifications ?

 Regards
 Mallah

 



 --
 Rajesh Kumar Mallah,
 Learning Universe Pvt. Ltd,
 Piccadily House, 4th Floor,
 275-276, Capt. Gaur Marg,
 Okhla, Sriniwas puri,
 New Delhi 110 065.
 M : +919811255597
 T : 91-11 6931601-04
 W : http://www.egurucool.com
 E : [EMAIL PROTECTED]










 Edmar Edilton da Silva wrote:

  Hi all,
 
  I still didn't solve the problem of the Apache::DBI. It can not be
 
  loaded into the apache's startup.pl file because happens a error
  during
  the starting of the apache, the child processes are not created. For
  using the Apache::DBI I had to add the "use Apache::DBI ()" code at
  the
  beginning of each perl script.
  Is it correct? Is the performance of the system damaged? I am working
  in
  this problem for some days, How I dont solve it, I intend to write my
  own connection pool. Please, can anyone tell me where I can find docs
  about this? Thanks for all.
 
  
  Edmar Edilton da Silva
  Bacharel em Ciência da Computacão - UFV
Mestrando em Ciência da Computacão - UNICAMP
  

 --
 __ Technology Rules __
 Rajesh Kumar Mallah,
 M : +919811255597








_
Stas Bekman  JAm_pH --   Just Another mod_perl Hacker
http://stason.org/   mod_perl Guide  http://perl.apache.org/guide
mailto:[EMAIL PROTECTED]   http://apachetoday.com http://logilune.com/
http://singlesheaven.com http://perl.apache.org http://perlmonth.com/





Re: Apache::DBI problem and writting a perl module!!!

2001-01-10 Thread R. K . Mallah


Stas , I do not face the problem anymore and Apache::DBI is loading
without any problem. But i remember of facing problem at one point
of time.
may be with some older version.
Could u please explain me what does Apache->module do and where
is
it defined ?
and Edmar could you please post the exact problem u are facing,
Regards
Mallah.

Stas Bekman wrote:
On Wed, 10 Jan 2001, R. K . Mallah wrote:
> I faced the same problem and had posted similar
email
> but I found an workaround that is there in the posting.
>
>
> 
> I get following error when i do
>
> perl -e 'use Apache::Status;use Apache::DBI'
>
> Can't locate object method "module" via package "Apache" at
> /usr/lib/perl5/site_perl/5.6.0/Apache/DBI.pm line 202.
> Compilation failed in require at -e line 1.
> BEGIN failed--compilation aborted at -e line 1.
>
>
> the problem is when preparing menu_item for Apache::Status method
module
> is
> not found under Apache,
>
> do i have to install some other Apache module?
it has nothing to do with this. You cannot test Apache modules from
the
command line since you aren't running in mod_perl environment.
please read the documentation -- you have to load the Apache::Status
before Apache::DBI.
> anyway i commented out the if part and made it work like
>
> Apache::Status->menu_item(
>
> 'DBI' => 'DBI connections',
> sub {
> my($r, $q) = @_;
> my(@s) =
> qw(TABLE>TR>TD>Datasource/TD>TD>Username/TD>/TR>);
> for (keys %Connected)
{
>
push @s, 'TR>TD>', join('/TD>TD>', (split($;,
> $_))[0,1]), "/TD>/TR>\n";
> }
> push @s, '/TABLE>';
> return \@s;
> }
>
> );
>
> # ) if ($INC{'Apache.pm'} and Apache->module('Apache::Status'));
>
>
> is it correct ?
>
> why shouldn't it load without any modifications ?
>
> Regards
> Mallah
>
> 
>
>
>
> --
> Rajesh Kumar Mallah,
> Learning Universe Pvt. Ltd,
> Piccadily House, 4th Floor,
> 275-276, Capt. Gaur Marg,
> Okhla, Sriniwas puri,
> New Delhi 110 065.
> M : +919811255597
> T : 91-11 6931601-04
> W : http://www.egurucool.com
> E : [EMAIL PROTECTED]
>
>
>
>
>
>
>
>
>
>
> Edmar Edilton da Silva wrote:
>
> > Hi all,
> >
> > I still didn't solve the problem of the
Apache::DBI. It can not be
> >
> > loaded into the apache's startup.pl file because happens a error
> > during
> > the starting of the apache, the child processes are not created.
For
> > using the Apache::DBI I had to add the "use Apache::DBI ()" code
at
> > the
> > beginning of each perl script.
> > Is it correct? Is the performance of the system damaged? I am working
> > in
> > this problem for some days, How I dont solve it, I intend to write
my
> > own connection pool. Please, can anyone tell me where I can find
docs
> > about this? Thanks for all.
> >
> > 
> >
Edmar Edilton da Silva
> > Bacharel em Cincia da Computaco
- UFV
> > Mestrando em Cincia da Computaco - UNICAMP
> > 
>
> --
> __ Technology Rules __
> Rajesh Kumar Mallah,
> M : +919811255597
>
>
>
>
>
_
Stas Bekman
JAm_pH -- Just Another mod_perl Hacker
http://stason.org/
mod_perl Guide http://perl.apache.org/guide
mailto:[EMAIL PROTECTED] 
http://apachetoday.com
http://logilune.com/
http://singlesheaven.com http://perl.apache.orghttp://perlmonth.com/

--
__ Technology Rules __
Rajesh Kumar Mallah,
M : +919811255597



Re: Apache::DBI problem and writting a perl module!!!

2000-12-03 Thread Perrin Harkins

Edmar Edilton da Silva wrote:
 I still didn't solve the problem of the Apache::DBI. It can not be
 loaded into the apache's startup.pl file because happens a error during
 the starting of the apache, the child processes are not created. For
 using the Apache::DBI I had to add the "use Apache::DBI ()" code at the
 beginning of each perl script.

That will not work.  You have to load Apache::DBI before DBI, as it says
in the documentation.  You need to solve the problem you're getting when
putting Apache::DBI in your startup.pl.  What's the error?  Did you
compile your Apache/mod_perl from source?  Are you using DSO?

- Perrin

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




Apache::DBI problem

2000-09-12 Thread Evelin Halling



Hi,

I am using Apache::DBI for user authentication 
and it works just fine with one exception, 
it does not kill the sql backend server process starting up during authentication,
so after some time postgres is running out of allowed backend server 
processes and authentication does not work any more.

Please help

I'm using:
perl 5.005_03, 
Apache/1.3.11 (Unix) with mod_perl/1.21,
ApacheDBI-0.87,
DBI-1.13,
PostgreSQL-7.0


thanx,

evelin






Re: Apache::DBI problem

2000-09-12 Thread Perrin Harkins

On Tue, 12 Sep 2000, Evelin Halling wrote:
 I am using Apache::DBI for user authentication and it works just fine
 with one exception, it does not kill the sql backend server process
 starting up during authentication, so after some time postgres is
 running out of allowed backend server processes and authentication
 does not work any more.

That's what Apache::DBI does.  It makes your connections persistent.  If
you want the connections to be re-established and closed on every request,
don't use Apache::DBI.  If you want to use Apache::DBI for speed, try to
get your database to handle more connections or reduce the number of
mod_perl processes by using a proxy server.

- Perrin




Re: Apache::DBI problem..

2000-04-05 Thread Niral Trivedi

Actually I already have MySQL module installed on our machine... Because
I am able to run cgi/perl script which uses DBI module..

I mean I am able to run any normal cgi script.. So, I think that
suggests that we have all the required module installed on our machine..

Niral

Rajesh Kumar Mallah wrote:
 
 Did you install DBD ?? fro the particular database you installed.
 eg for mysql install
 
 cpan install Bundle::DBD::mysql
 
 Rajesh Kumar Mallah
 ---
 Learning Universe Pvt. Ltd.
 59 Mandakini, GK IV, New Delhi 110019
 Tel: (91-11) 6412100, 6480342, 6480365
 http://www.egurucool.com
 email: [EMAIL PROTECTED]
 ---

-- 
Regards...

Niral K. Trivedi, Planet Access Network Inc.
Email : [EMAIL PROTECTED]
Phone : 973-691-4704 x134



Apache::DBI problem..

2000-04-04 Thread Niral Trivedi

All..

I am new to mod_perl so, please forgive me if this questions sounds
stupid..

I have successfully installed mod_perl 1.22 and Apache 1.3.12 under
BSD/OS BSDI 3.1 And able to run normal cgi script... But problem occurs
while I am trying to run script with DBI..

I have successfully installed Apache::DBI from CPAN site which is
version 0.87

When I am trying to start Apache after installing Apache::DBI, I am
getting following errors:
--
Syntax error on line 935 of
/zen/home/niral/Apache/apache/conf/httpd.conf:
Can't load '/usr/local/lib/perl5/site_perl/i386-bsdos/auto/DBI/DBI.o'
for module DBI: can't resolve undefined symbols: Inappropriate file type
or format at /usr/local/lib/perl5/i386-bsdos/5.00401/DynaLoader.pm line
155.

 at /usr/local/lib/perl5/site_perl/DBI.pm line 158
BEGIN failed--compilation aborted at
/usr/local/lib/perl5/site_perl/DBI.pm line 158.
BEGIN failed--compilation aborted at
/usr/local/lib/perl5/site_perl/Apache/DBI.pm line 4.

./apachectl start: httpd could not be started
---
following is the snippets from my httpd.conf file:
---
Alias /perl/  /zen/home/niral/Apache/apache/test/
#PerlRequire /zen/home/niral/Apache/apache/conf/startup.pl
PerlModule Apache::DBI ### This is line 935

Location /perl
SetHandler  perl-script
PerlHandler Apache::Registry
PerlSendHeader On
Options ExecCGI
/Location

Location /perl-status
SetHandler  perl-script
PerlHandler Apache::Status
/Location
]
I have tried to do this using startup.pl file as well.. but getting same
error.. 

After searching different mailing lists, I have found that this is very
common problem for users on RedHat Linux... But couldn't find anything
for BSDI 

I also found one link to
http://perl.apache.org/guide/troubleshooting.html#Can_t_load_auto_DBI_DBI_so_
but don't know how to check that thing?? I mean how can you check that
all modules are compiled with same perl version

Please give me some idea on this..

Thanks in advance for your help..

Niral
-- 
Regards...

Niral K. Trivedi, Planet Access Network Inc.
Email : [EMAIL PROTECTED]
Phone : 973-691-4704 x134



Apache::DBI Problem

2000-01-07 Thread Dennis Megarry

This message was sent from Geocrawler.com by "Dennis Megarry" [EMAIL PROTECTED]
Be sure to reply to that address.

Everything was running fine, i installed mod_perl 
and ApacheDBI, now, I get errors trying to 
connect to mySQL, the message showing up in my 
error_log file is this:

httpd: [Thu Jan  6 22:45:23 2000] [error] 
Undefined subroutine 
Apache::ROOTwww_2eelite_2ecom::cgi_2dbin::get_2ec
gi::configure called at /user3/elite/cgi-
bin/get.cgi line 16.

Also, when I try to start the startup.pl file 
that came with ApapcheDBI i get this error 
message:

Can't locate object method "module" via 
package "Apache" at /usr/local/lib/perl5
/site_perl/5.005/Apache/DBI.pm line 202.
BEGIN failed--compilation aborted at startup.pl 
line 11.

Anyone have an idea what I'm doing wrong?

Dennis



Geocrawler.com - The Knowledge Archive