RE: Help needed for using Apache::DBI
Perhaps sending your startup.pl might help. Then only time I had problems with Apache::DBI, I loaded Apache.pm in a BEGIN{} block then everything else after and outside the block in my startup.pl. That was to deal with an error when Apache::DBI was loaded. --Jeff At 10:28 AM 7/18/00 +0530, PHANI MADHAVI wrote: Hi, All the guidelines given in the guide have been followed. Specifically, there is a section which goes by the title ' my apache does not work ' { Make sure you have it installed. Make sure you configured mod_perl with EVERYTHING=1. Use the example script eg/startup.pl (in the mod_perl distribution). Remove the comment from the line. # use Apache::DebugDBI; and adapt the connect string. Do not change anything in your scripts for use with Apache::DBI. } we have gone through all the guidelines But it is not working. It is still trying to search the 'module' in Apache.pm which obviously is not defined. Madhavi -Original Message- From: darren chamberlain [mailto:[EMAIL PROTECTED]] Sent: Monday, July 17, 2000 5:52 PM To: [EMAIL PROTECTED] Subject: Re: Help needed for using Apache::DBI PHANI MADHAVI ([EMAIL PROTECTED]) said something to this effect: IF AT ALL ANYBODY KNOWS HOW TO MAKE APACHE::DBI WORK,PLEASE HELP The guide is quite clear on how to use and set up Apache::DBI: http://perl.apache.org/guide/databases.html#Apache_DBI_Initiate_a_persist http://search.cpan.org/doc/MERGL/ApacheDBI-0.87/DBI.pm Jeff Beard __ Web:www.cyberxape.com Email: jeff at cyberxape dot com Location: Boulder, Colorado, USA
RE: Help needed for using Apache::DBI
On Tue, 18 Jul 2000, PHANI MADHAVI wrote: we have gone through all the guidelines But it is not working. It is still trying to search the 'module' in Apache.pm which obviously is not defined. You can't tell much about the Apache.pm module just by looking at the perl source because it's partly in C. You should check the standard list of things that usually cause problems for people: - Is your mod_perl built with the exact same perl binary that's on your system? - Have you tried building mod_perl statically? - Does your "use Apache::DBI" come before anything else that might use DBI? - Can you verify that mod_perl is working, using the techniques in the guide at http://perl.apache.org/guide/install.html#How_can_I_tell_whether_mod_perl_ ? If all of that checks out, you should send your startup.pl and the relevant section of your httpd.conf, as described in the SUPPORT doc. - Perrin
Re: Help needed for using Apache::DBI
Hi, I've had the same bug for the past 3 weeks. As far as I can tell mod_perl has been installed fine (EVERYTHING=1 etc..) so I'm at loss to explain why ... A couple of other people have mentioned this bug recently too ... has anyone solved it? NIge On Mon, 17 Jul 2000, PHANI MADHAVI wrote: Hi All, we have installed Apache::DBI module ( system os is linux, web server apache, running mod_perl and mysql is rdbms) in our systems. But it is not working. When i try to compile a sample file to test db connectivity using Apache::DBI, it does not work. Same thing works if I use DBI. The error is " can't locate object method "module" in the DBI.pm file" We checked the DBI.pm file and there is one statement which goes like this: if ($INC{"Apache.pm"} and Apache-module("Apache::Status")); And we searched for Apache.pm. We could find the file but not the "module". Please let me know how should we proceed. Regards, Madhavi -Original Message- From: Vincent Bruijnes [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 16, 2000 12:30 AM To: Sam Carleton Cc: [EMAIL PROTECTED] Subject: Re: getting mod_perl configured on FreeBSD Well i had the same problem on freebsd too. first goto mod_perl directory: perl Makefile.PL PREP_HTTPD=1 USE_APACI=1 then make make test and make install Goto your apache directory ./configure --prefix=/www --enable-shared=max --activate-modules=src/modules/perl/libperl.a --disable-shared=perl then make and make install. and voila your apache is configured as statically mod_perl and you have DSO enabled so you never need to recompile apache if you want to add optional modules. Good Luck and let me know if I can help you any more. Vincent Bruijnes At 21:21 14-7-00 -0400, you wrote: I have successfully gotten Apache/mod_perl to compile under Linux many a times. This is my first attempt at compiling it on FreeBSD and I am having problems. The problem is that when to do the "make test", apache never starts up. I had once run into this on Linux and that was because the .makepl_args.mod_perl was pointing to a non-existing layout file and I did not catch the error from the "perl Makefile.PL". But I have looked and look at the output of the "perl Makefile.PL" and see nothing wrong. I am going to post the output of "perl Makefile.PL", along with my .makepl_args.mod_perl and my layout file in hopes that one of you can find my error. Thanks output from "perl Makefile.PL" Will run tests as User: 'nobody' Group: 'wheel' Configuring for Apache, Version 1.3.12 + using installation path layout: maineville (/usr/src/apache.config.layout) + activated perl module (modules/perl/libperl.a) Creating Makefile Creating Configuration.apaci in src + enabling mod_so for DSO support + id: mod_perl/1.24 + id: Perl/5.00503 (freebsd) [perl] Creating Makefile in src + configured for FreeBSD 4.0 platform + setting C pre-processor to cc -E + checking for system header files + adding selected modules o rewrite_module uses ConfigStart/End enabling DBM support for mod_rewrite o dbm_auth_module uses ConfigStart/End o perl_module uses ConfigStart/End + mod_perl build type: DSO + setting up mod_perl build environment + adjusting Apache build environment ** Error: Cannot build mod_include with Perl support (USE_PERL_SSI) ** ** when mod_perl is compiled as DSO because of cross-module calls. ** ** Ignoring PERL_SSI flag now. ** + checking sizeof various data types + doing sanity check on compiler and options Creating Makefile in src/support Creating Makefile in src/os/unix Creating Makefile in src/ap Creating Makefile in src/main Creating Makefile in src/modules/standard Creating Makefile in src/modules/proxy Creating Makefile in src/modules/perl Reading Makefile.PL args from ../.makepl_args.mod_perl Will configure via APACI cp apaci/Makefile.libdir /usr/src/apache/src/modules/perl/Makefile.libdir cp apaci/Makefile.tmpl /usr/src/apache/src/modules/perl/Makefile.tmpl cp apaci/README /usr/src/apache/src/modules/perl/README cp apaci/configure /usr/src/apache/src/modules/perl/configure cp apaci/libperl.module /usr/src/apache/src/modules/perl/libperl.module cp apaci/mod_perl.config.sh /usr/src/apache/src/modules/perl/mod_perl.config.sh cp apaci/load_modules.pl.PL /usr/src/apache/src/modules/perl/load_modules.pl.PL cp apaci/find_source.PL /usr/src/apache/src/modules/perl/find_source.PL cp apaci/apxs_cflags.PL /usr/src/apache/src/modules/perl/apxs_cflags.PL cp apaci/mod_perl.exp /usr/src/apache/src/modules/perl/mod_perl.exp PerlDispatchHandler.enabled PerlChildInitHandlerenabled PerlChildExitHandlerenabled PerlPostReadRequestHandler..enabled PerlTransHandlerenabled PerlHeaderParserHandler.enabled
RE: Help needed for using Apache::DBI
Hi, Yes... installed apache, mod_perl, mysql, dbi and dbd modules using their source code. and mod_perl has been installed with the option EVERTYTHING=1. But of no use.. IF AT ALL ANYBODY KNOWS HOW TO MAKE APACHE::DBI WORK,PLEASE HELP Regards, Madhavi -Original Message- From: Nigel Hamilton [mailto:[EMAIL PROTECTED]] Sent: Monday, July 17, 2000 1:48 PM To: PHANI MADHAVI Cc: [EMAIL PROTECTED] Subject: Re: Help needed for using Apache::DBI Hi, I've had the same bug for the past 3 weeks. As far as I can tell mod_perl has been installed fine (EVERYTHING=1 etc..) so I'm at loss to explain why ... A couple of other people have mentioned this bug recently too ... has anyone solved it? NIge On Mon, 17 Jul 2000, PHANI MADHAVI wrote: Hi All, we have installed Apache::DBI module ( system os is linux, web server apache, running mod_perl and mysql is rdbms) in our systems. But it is not working. When i try to compile a sample file to test db connectivity using Apache::DBI, it does not work. Same thing works if I use DBI. The error is " can't locate object method "module" in the DBI.pm file" We checked the DBI.pm file and there is one statement which goes like this: if ($INC{"Apache.pm"} and Apache-module("Apache::Status")); And we searched for Apache.pm. We could find the file but not the "module". Please let me know how should we proceed. Regards, Madhavi -Original Message- From: Vincent Bruijnes [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 16, 2000 12:30 AM To: Sam Carleton Cc: [EMAIL PROTECTED] Subject: Re: getting mod_perl configured on FreeBSD Well i had the same problem on freebsd too. first goto mod_perl directory: perl Makefile.PL PREP_HTTPD=1 USE_APACI=1 then make make test and make install Goto your apache directory ./configure --prefix=/www --enable-shared=max --activate-modules=src/modules/perl/libperl.a --disable-shared=perl then make and make install. and voila your apache is configured as statically mod_perl and you have DSO enabled so you never need to recompile apache if you want to add optional modules. Good Luck and let me know if I can help you any more. Vincent Bruijnes At 21:21 14-7-00 -0400, you wrote: I have successfully gotten Apache/mod_perl to compile under Linux many a times. This is my first attempt at compiling it on FreeBSD and I am having problems. The problem is that when to do the "make test", apache never starts up. I had once run into this on Linux and that was because the .makepl_args.mod_perl was pointing to a non-existing layout file and I did not catch the error from the "perl Makefile.PL". But I have looked and look at the output of the "perl Makefile.PL" and see nothing wrong. I am going to post the output of "perl Makefile.PL", along with my .makepl_args.mod_perl and my layout file in hopes that one of you can find my error. Thanks output from "perl Makefile.PL" Will run tests as User: 'nobody' Group: 'wheel' Configuring for Apache, Version 1.3.12 + using installation path layout: maineville (/usr/src/apache.config.layout) + activated perl module (modules/perl/libperl.a) Creating Makefile Creating Configuration.apaci in src + enabling mod_so for DSO support + id: mod_perl/1.24 + id: Perl/5.00503 (freebsd) [perl] Creating Makefile in src + configured for FreeBSD 4.0 platform + setting C pre-processor to cc -E + checking for system header files + adding selected modules o rewrite_module uses ConfigStart/End enabling DBM support for mod_rewrite o dbm_auth_module uses ConfigStart/End o perl_module uses ConfigStart/End + mod_perl build type: DSO + setting up mod_perl build environment + adjusting Apache build environment ** Error: Cannot build mod_include with Perl support (USE_PERL_SSI) ** ** when mod_perl is compiled as DSO because of cross-module calls. ** ** Ignoring PERL_SSI flag now. ** + checking sizeof various data types + doing sanity check on compiler and options Creating Makefile in src/support Creating Makefile in src/os/unix Creating Makefile in src/ap Creating Makefile in src/main Creating Makefile in src/modules/standard Creating Makefile in src/modules/proxy Creating Makefile in src/modules/perl Reading Makefile.PL args from ../.makepl_args.mod_perl Will configure via APACI cp apaci/Makefile.libdir /usr/src/apache/src/modules/perl/Makefile.libdir cp apaci/Makefile.tmpl /usr/src/apache/src/modules/perl/Makefile.tmpl cp apaci/README /usr/src/apache/src/modules/perl/README cp apaci/configure /usr/src/apache/src/modules/perl/configure cp apaci/libperl.module /usr/src/apache/src/modules/perl/libperl.module cp apaci/mod_perl.config.sh /usr/src/apach
Re: Help needed for using Apache::DBI
PHANI MADHAVI ([EMAIL PROTECTED]) said something to this effect: IF AT ALL ANYBODY KNOWS HOW TO MAKE APACHE::DBI WORK,PLEASE HELP The guide is quite clear on how to use and set up Apache::DBI: http://perl.apache.org/guide/databases.html#Apache_DBI_Initiate_a_persist http://search.cpan.org/doc/MERGL/ApacheDBI-0.87/DBI.pm (darren) -- Jesus saves, passes to Moses; shoots, SCORES!
Re: Help needed for using Apache::DBI
PHANI MADHAVI wrote: Hi All, we have installed Apache::DBI module ( system os is linux, web server apache, running mod_perl and mysql is rdbms) in our systems. But it is not working. When i try to compile a sample file to test db connectivity using Apache::DBI, it does not work. Same thing works if I use DBI. The error is " can't locate object method "module" in the DBI.pm file" We checked the DBI.pm file and there is one statement which goes like this: if ($INC{"Apache.pm"} and Apache-module("Apache::Status")); And we searched for Apache.pm. We could find the file but not the "module". Please let me know how should we proceed. Regards, Madhavi in the next release I'll mention it in the README twice and in bold letters: It's not only supposed to be used with the Apache server together with an embedded perl interpreter like mod_perl, it can ONLY be used when running as mod_perl script. It can NOT be run in any script from the command-line. Edmund -- Edmund Mergl mailto:[EMAIL PROTECTED] http://www.edmund-mergl.de fon: +49 700 EDEMERGL
RE: Help needed for using Apache::DBI
Hi, The script is running as a mod_perl script ( httpd.conf of Apache webserver has been modified so that the scripts run under mod_perl rather than under CGI). Madhavi -Original Message- From: Edmund Mergl [mailto:[EMAIL PROTECTED]] Sent: Monday, July 17, 2000 11:08 PM To: PHANI MADHAVI Cc: [EMAIL PROTECTED] Subject: Re: Help needed for using Apache::DBI PHANI MADHAVI wrote: Hi All, we have installed Apache::DBI module ( system os is linux, web server apache, running mod_perl and mysql is rdbms) in our systems. But it is not working. When i try to compile a sample file to test db connectivity using Apache::DBI, it does not work. Same thing works if I use DBI. The error is " can't locate object method "module" in the DBI.pm file" We checked the DBI.pm file and there is one statement which goes like this: if ($INC{"Apache.pm"} and Apache-module("Apache::Status")); And we searched for Apache.pm. We could find the file but not the "module". Please let me know how should we proceed. Regards, Madhavi in the next release I'll mention it in the README twice and in bold letters: It's not only supposed to be used with the Apache server together with an embedded perl interpreter like mod_perl, it can ONLY be used when running as mod_perl script. It can NOT be run in any script from the command-line. Edmund -- Edmund Mergl mailto:[EMAIL PROTECTED] http://www.edmund-mergl.de fon: +49 700 EDEMERGL
RE: Help needed for using Apache::DBI
Hi, All the guidelines given in the guide have been followed. Specifically, there is a section which goes by the title ' my apache does not work ' { Make sure you have it installed. Make sure you configured mod_perl with EVERYTHING=1. Use the example script eg/startup.pl (in the mod_perl distribution). Remove the comment from the line. # use Apache::DebugDBI; and adapt the connect string. Do not change anything in your scripts for use with Apache::DBI. } we have gone through all the guidelines But it is not working. It is still trying to search the 'module' in Apache.pm which obviously is not defined. Madhavi -Original Message- From: darren chamberlain [mailto:[EMAIL PROTECTED]] Sent: Monday, July 17, 2000 5:52 PM To: [EMAIL PROTECTED] Subject: Re: Help needed for using Apache::DBI PHANI MADHAVI ([EMAIL PROTECTED]) said something to this effect: IF AT ALL ANYBODY KNOWS HOW TO MAKE APACHE::DBI WORK,PLEASE HELP The guide is quite clear on how to use and set up Apache::DBI: http://perl.apache.org/guide/databases.html#Apache_DBI_Initiate_a_persist http://search.cpan.org/doc/MERGL/ApacheDBI-0.87/DBI.pm
Help needed for using Apache::DBI
Hi All, we have installed Apache::DBI module ( system os is linux, web server apache, running mod_perl and mysql is rdbms) in our systems. But it is not working. When i try to compile a sample file to test db connectivity using Apache::DBI, it does not work. Same thing works if I use DBI. The error is " can't locate object method "module" in the DBI.pm file" We checked the DBI.pm file and there is one statement which goes like this: if ($INC{"Apache.pm"} and Apache-module("Apache::Status")); And we searched for Apache.pm. We could find the file but not the "module". Please let me know how should we proceed. Regards, Madhavi -Original Message- From: Vincent Bruijnes [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 16, 2000 12:30 AM To: Sam Carleton Cc: [EMAIL PROTECTED] Subject: Re: getting mod_perl configured on FreeBSD Well i had the same problem on freebsd too. first goto mod_perl directory: perl Makefile.PL PREP_HTTPD=1 USE_APACI=1 then make make test and make install Goto your apache directory ./configure --prefix=/www --enable-shared=max --activate-modules=src/modules/perl/libperl.a --disable-shared=perl then make and make install. and voila your apache is configured as statically mod_perl and you have DSO enabled so you never need to recompile apache if you want to add optional modules. Good Luck and let me know if I can help you any more. Vincent Bruijnes At 21:21 14-7-00 -0400, you wrote: I have successfully gotten Apache/mod_perl to compile under Linux many a times. This is my first attempt at compiling it on FreeBSD and I am having problems. The problem is that when to do the "make test", apache never starts up. I had once run into this on Linux and that was because the .makepl_args.mod_perl was pointing to a non-existing layout file and I did not catch the error from the "perl Makefile.PL". But I have looked and look at the output of the "perl Makefile.PL" and see nothing wrong. I am going to post the output of "perl Makefile.PL", along with my .makepl_args.mod_perl and my layout file in hopes that one of you can find my error. Thanks output from "perl Makefile.PL" Will run tests as User: 'nobody' Group: 'wheel' Configuring for Apache, Version 1.3.12 + using installation path layout: maineville (/usr/src/apache.config.layout) + activated perl module (modules/perl/libperl.a) Creating Makefile Creating Configuration.apaci in src + enabling mod_so for DSO support + id: mod_perl/1.24 + id: Perl/5.00503 (freebsd) [perl] Creating Makefile in src + configured for FreeBSD 4.0 platform + setting C pre-processor to cc -E + checking for system header files + adding selected modules o rewrite_module uses ConfigStart/End enabling DBM support for mod_rewrite o dbm_auth_module uses ConfigStart/End o perl_module uses ConfigStart/End + mod_perl build type: DSO + setting up mod_perl build environment + adjusting Apache build environment ** Error: Cannot build mod_include with Perl support (USE_PERL_SSI) ** ** when mod_perl is compiled as DSO because of cross-module calls. ** ** Ignoring PERL_SSI flag now. ** + checking sizeof various data types + doing sanity check on compiler and options Creating Makefile in src/support Creating Makefile in src/os/unix Creating Makefile in src/ap Creating Makefile in src/main Creating Makefile in src/modules/standard Creating Makefile in src/modules/proxy Creating Makefile in src/modules/perl Reading Makefile.PL args from ../.makepl_args.mod_perl Will configure via APACI cp apaci/Makefile.libdir /usr/src/apache/src/modules/perl/Makefile.libdir cp apaci/Makefile.tmpl /usr/src/apache/src/modules/perl/Makefile.tmpl cp apaci/README /usr/src/apache/src/modules/perl/README cp apaci/configure /usr/src/apache/src/modules/perl/configure cp apaci/libperl.module /usr/src/apache/src/modules/perl/libperl.module cp apaci/mod_perl.config.sh /usr/src/apache/src/modules/perl/mod_perl.config.sh cp apaci/load_modules.pl.PL /usr/src/apache/src/modules/perl/load_modules.pl.PL cp apaci/find_source.PL /usr/src/apache/src/modules/perl/find_source.PL cp apaci/apxs_cflags.PL /usr/src/apache/src/modules/perl/apxs_cflags.PL cp apaci/mod_perl.exp /usr/src/apache/src/modules/perl/mod_perl.exp PerlDispatchHandler.enabled PerlChildInitHandlerenabled PerlChildExitHandlerenabled PerlPostReadRequestHandler..enabled PerlTransHandlerenabled PerlHeaderParserHandler.enabled PerlAccessHandler...enabled PerlAuthenHandler...enabled PerlAuthzHandlerenabled PerlTypeHandler.enabled PerlFixupHandlerenabled PerlHandler.enabled PerlLogHandler..enabled PerlInitHandler.enabled PerlCleanupHandler..enabled PerlRestartHandler..enabled PerlStackedHandlers.enabled PerlMethodHandlers..enabled