RE: 2 problems with mod_perl/Apache::DBI
startup.pl cannot be run from the command line when it contains apache server specific modules. But you can put those (Apache specific) modules in your httpd.conf instead as PerlModule Apache::DBI Apache::Status and avoid compilation warnings in startup.pl. But you should clearly note this, both in startup.pl and httpd.conf, as explanatory comments. Otherwise, you *will* forget that you did this... :-) However, when run under Apache PerlRequire /usr/local/etc/apache/startup.pl [Mon Aug 6 17:33:09 2001] [error] Can't load '/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/auto/DBI/DBI.so ' for module DBI: /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/auto/DBI/DBI.so: Undefined symbol PL_dowarn at Not sure what's up. As far as the DBI error, is there a possibility that you are NOT using the same build of perl as was compiled into Apache? try rebuilding mod_perl/apache at the same time. L8r, Rob #!/usr/bin/perl -w use Disclaimer qw/:standard/;
2 problems with mod_perl/Apache::DBI
uwb-02-chroot# uname -a FreeBSD uwb-02.cdsnet.net 4.3-STABLE FreeBSD 4.3-STABLE #0: Fri Aug 3 11:43:20 PDT 200 uwb-02-chroot# perl -v This is perl, v5.6.1 built for i386-freebsd uwb-02-chroot# cat /usr/local/etc/apache/startup.pl #!/usr/bin/perl use Apache; use Apache::Status; use Apache::DBI; use Apache::DBILogger; 1; uwb-02-chroot# ./startup.pl Can't locate object method module via package Apache (perhaps you forgot to load Apache?) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 202. Compilation failed in require at ./startup.pl line 5. BEGIN failed--compilation aborted at ./startup.pl line 5. So if I comment out the Apache-module(Apache::Status) temporarily, it runs from the command prompt. However, when run under Apache PerlRequire /usr/local/etc/apache/startup.pl [Mon Aug 6 17:33:09 2001] [error] Can't load '/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/auto/DBI/DBI.so' for module DBI: /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/auto/DBI/DBI.so: Undefined symbol PL_dowarn at /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206. at /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/DBI.pm line 185 BEGIN failed--compilation aborted at /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/DBI.pm line 185. 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 /usr/local/etc/apache/startup.pl line 5. BEGIN failed--compilation aborted at /usr/local/etc/apache/startup.pl line 5. Compilation failed in require at (eval 1) line 1. Not sure what's up.
Re: 2 problems with mod_perl/Apache::DBI
startup.pl cannot be run from the command line when it contains apache server specific modules. Jaye Mathisen wrote: uwb-02-chroot# uname -a FreeBSD uwb-02.cdsnet.net 4.3-STABLE FreeBSD 4.3-STABLE #0: Fri Aug 3 11:43:20 PDT 200 uwb-02-chroot# perl -v This is perl, v5.6.1 built for i386-freebsd uwb-02-chroot# cat /usr/local/etc/apache/startup.pl #!/usr/bin/perl use Apache; use Apache::Status; use Apache::DBI; use Apache::DBILogger; 1; uwb-02-chroot# ./startup.pl Can't locate object method module via package Apache (perhaps you forgot to load Apache?) at /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 202. Compilation failed in require at ./startup.pl line 5. BEGIN failed--compilation aborted at ./startup.pl line 5. So if I comment out the Apache-module(Apache::Status) temporarily, it runs from the command prompt. However, when run under Apache PerlRequire /usr/local/etc/apache/startup.pl [Mon Aug 6 17:33:09 2001] [error] Can't load '/usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/auto/DBI/DBI.so' for module DBI: /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd/auto/DBI/DBI.so: Undefined symbol PL_dowarn at Not sure what's up. -- ___cliff [EMAIL PROTECTED]http://www.genwax.com/
RE: DBD - Oracle Error connecting to Oracle on HP-UX 11.00 with Apache 1.3.12, mod_perl/1.22, DBI/1.14, DBD(1.06)
thanks Geoff, I appreciate your feedback. is there any bug databse for DBI/DBD on internet where I can serach for of any known issues with these on HP-UX 11.0 ? thanks Arun -- From: Geoffrey Young[SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 05:20 To: 'EXT-Sethi, Arun' Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: DBD - Oracle "Error connecting to Oracle" -Original Message- From: EXT-Sethi, Arun [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 27, 2001 10:07 PM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: DBD - Oracle "Error connecting to Oracle" Geoff / Daniel, this is in ref. to your emails (as given below) in the "mod_perl" users group. I am going through the same errors in my error_log ie getting: Use of inherited AUTOLOAD for non-method DBD::Oracle::ORA_OCI() is deprecated at /oracle/product/9iAS/Apache/perl/lib/site_perl/5.005/PA-RISC2. 0-thread/DBD/Oracle.pm line 48. I was never able to figure out that exact error but I think it had something to do with DBI trying (unsucessfully) to load DBD::Oracle twice. That is, I would only see it from my log handler after my content handler bombed for the other reasons listed in the thread. In both cases I was just use()ing DBI and relying on DBI to pull in DBD::Oracle (however it does that) when I try to connect to oracle from aperl program from the web using DBD::Oracle (1.0.3 as wel as DBD 1.0.6) and I have no problem connecting to oracle when I run the perl program from thw shell (command line) It looks like you are on linux platform, and in my case I am on hp-ux 11.0 box. I am not sure if Daniel is also on linux box or some other box. I have experience with this on both solaris and linux - the below patch helped on both platforms. no experience on HP for me, though. sorry --Geoff I have also tried as follows but that does not help in my case the short answer/path is to edit DBD::Oracle Makefile.PL and build it again -$::opt_b = 1; # try to use Oracle's own 'build' rule +$::opt_b = 0; # try to use Oracle's own 'build' rule Question: I would appreciate to know if there is some thing I am missing or if this is some bug in DBD:Oracle (1.03/1.0.6) on HP-UX or any other information that can help me resolve/workaround this problem. thanks Arun [snip]
mod_perl and DBI Weirdness
Hi All, I have built Apache 1.3.14 with mod_perl 1.24_01 and PHP 4.0.4, and Ingres is installed on the system. Everything works except for one truly odd thing... Before I proceed here's my configuration information as it relates to mod_perl: Directory "/app/www/cgi-bin" AllowOverride None Order allow,deny Allow from all Options ExecCGI PerlHandler Apache::Registry /Directory (There are no PerlRequire statments in the httpd.conf file.) Now for the weirdness... Somebody has written a Perl script that talks to the Ingres database via DBI. Using the above configuration information the script does what its supposed to, and everything is right with the world. But if I add in: SetHandler perl-script to the middle of the Directory directive above, the script blows up. error_log says: DBI-connect(::) failed: E_LQ0001 Failed to connect to DBMS session . E_LC0001 GCA protocol service (GCA_INITIATE) failure. Internal service status E_GC0006 -- Duplicate initiate request. at /app/www/ cgi-bin/phone.pl line 74 [Wed Jan 31 09:27:13 2001] [error] E_LQ0001 Failed to connect to DBMS session. E_LC0001 GCA protocol service (GCA_INITIATE) failure. Internal service status E_GC0006 -- Duplicate initiate request. at /app/www/ cgi-bin/phone.pl line 74. (Line 74 is the first time the script attempts to connect to Ingres.) Why does SetHandler perl-script cause an otherwise functional CGI to completely blow up? Any help is appreciated. John -- +I speak for myself.+ | John Jung ([EMAIL PROTECTED]) | Unigraphics Solutions | | Global Technical Access Center| 10824 Hope Street, Cypress Pointe | | Operating Systems Group | Cypress, California 90630 | +--(800) 955----+
Re: mod_perl and DBI::Proxy
It has promise but needs someone to polish it up. (I didn't write it and have barely looked at the code.) Tim. On Tue, Sep 19, 2000 at 12:50:57PM -0700, Tom Lancaster wrote: I know, seems promising, doesn't it, especially after the overview in the DBI book. On the other hand, you can do most things another way - SSH port forwarding for encrypted data transmission, straight DBI/DBD available for most dbs, etc. Bill McCabe wrote: That's a shame. I can see good use for it. Is it the RPC chunk that is slow and unreliable or the DBI part? Or has no one really pursued making a production-quality module out of it? Bill At 11:24 AM -0700 9/19/00, Tom Lancaster wrote: My experience of using DBI::Proxy several months ago is that it's terribly slow, and breaks all the time. It's not meant to be used in a production environment ( and that's according to the authors ). I managed to get it running, on linux and NT, but due to the lack of a working fork() or threads support in perl on NT, I could only use a single instance of the server at a time. If you can get it working *nix to *nix, your mileage may be better. Regards. Bill McCabe wrote: Hi All I'm thinking of restructuring my setup so that I have my apache/mod_perl servers access database servers remotely using DBI::Proxy, rather than locally. Does anyone have a sense of what kind of performance degradation I should expect? Will it come chiefly from network latency (leaving encryption out for the moment)? Also, I've never managed to install DBI::Proxy successfully on any system (AIX 4.2.1/4.3.2/4.3.3, Red Hat 6.0/1/2; perl 5.005/5.6.0; apache 1.3.12/mod_perl 1.24). The tests always fails for the RPC piece. Is the RPC module typically this problematic? TIA Bill
mod_perl and DBI::Proxy
Hi All I'm thinking of restructuring my setup so that I have my apache/mod_perl servers access database servers remotely using DBI::Proxy, rather than locally. Does anyone have a sense of what kind of performance degradation I should expect? Will it come chiefly from network latency (leaving encryption out for the moment)? Also, I've never managed to install DBI::Proxy successfully on any system (AIX 4.2.1/4.3.2/4.3.3, Red Hat 6.0/1/2; perl 5.005/5.6.0; apache 1.3.12/mod_perl 1.24). The tests always fails for the RPC piece. Is the RPC module typically this problematic? TIA Bill
Re: mod_perl and DBI::Proxy
My experience of using DBI::Proxy several months ago is that it's terribly slow, and breaks all the time. It's not meant to be used in a production environment ( and that's according to the authors ). I managed to get it running, on linux and NT, but due to the lack of a working fork() or threads support in perl on NT, I could only use a single instance of the server at a time. If you can get it working *nix to *nix, your mileage may be better. Regards. Bill McCabe wrote: Hi All I'm thinking of restructuring my setup so that I have my apache/mod_perl servers access database servers remotely using DBI::Proxy, rather than locally. Does anyone have a sense of what kind of performance degradation I should expect? Will it come chiefly from network latency (leaving encryption out for the moment)? Also, I've never managed to install DBI::Proxy successfully on any system (AIX 4.2.1/4.3.2/4.3.3, Red Hat 6.0/1/2; perl 5.005/5.6.0; apache 1.3.12/mod_perl 1.24). The tests always fails for the RPC piece. Is the RPC module typically this problematic? TIA Bill
Re: mod_perl and DBI::Proxy
I know, seems promising, doesn't it, especially after the overview in the DBI book. On the other hand, you can do most things another way - SSH port forwarding for encrypted data transmission, straight DBI/DBD available for most dbs, etc. Bill McCabe wrote: That's a shame. I can see good use for it. Is it the RPC chunk that is slow and unreliable or the DBI part? Or has no one really pursued making a production-quality module out of it? Bill At 11:24 AM -0700 9/19/00, Tom Lancaster wrote: My experience of using DBI::Proxy several months ago is that it's terribly slow, and breaks all the time. It's not meant to be used in a production environment ( and that's according to the authors ). I managed to get it running, on linux and NT, but due to the lack of a working fork() or threads support in perl on NT, I could only use a single instance of the server at a time. If you can get it working *nix to *nix, your mileage may be better. Regards. Bill McCabe wrote: Hi All I'm thinking of restructuring my setup so that I have my apache/mod_perl servers access database servers remotely using DBI::Proxy, rather than locally. Does anyone have a sense of what kind of performance degradation I should expect? Will it come chiefly from network latency (leaving encryption out for the moment)? Also, I've never managed to install DBI::Proxy successfully on any system (AIX 4.2.1/4.3.2/4.3.3, Red Hat 6.0/1/2; perl 5.005/5.6.0; apache 1.3.12/mod_perl 1.24). The tests always fails for the RPC piece. Is the RPC module typically this problematic? TIA Bill
Apache, mod_perl and DBI
hello people me again with the Apache::DBI and apache problems the scenario - a very basic install of redhat 6.1 downloaded mod_perl 1.21 apache-1.3.11 from cpan Apache::DBI v0.87 DBI v1.13 DBD::mysql v2.0218 using the default httpd.conf with mod_perl added as a module I add the line at the end of the config PerlModule Apache::DBI the server refuses to start, no logs, no nothing. running strace on apache shows that it crashes when it spawns the client and loads the DBI modules any ideas? -- Adam Cassar Senior Web Developer ___ NetRegistry http://www.netregistry.com.au Tel: +61 2 9699 6099 | Fax: +61 2 9699 6088 PO Box 270 Broadway NSW 2007 Australia
mod_perl and DBI
I'm making a first attempt to run a working Perl CGI run under mod_perl. It uses perl dbi successfully under CGI. When invoking the script under mod_perl, I get the following error: [Tue Nov 2 11:49:43 1999] [error] Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBI.so' for module DBI: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBI.so: undefined symbol: PL_dowarn at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. Would someone kindly point me in the right direction? Thanks, Dan
Re: mod_perl and DBI
I'm making a first attempt to run a working Perl CGI run under mod_perl. It uses perl dbi successfully under CGI. When invoking the script under mod_perl, I get the following error: [Tue Nov 2 11:49:43 1999] [error] Can't load '/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBI.so' for module DBI: /usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI/DBI.so: undefined symbol: PL_dowarn at /usr/lib/perl5/5.00503/i386-linux/DynaLoader.pm line 169. Would someone kindly point me in the right direction? http://perl.apache.org/guide/warnings.html#Can_t_load_auto_DBI_DBI_so_ Thanks, Dan ___ Stas Bekman mailto:[EMAIL PROTECTED]www.singlesheaven.com/stas Perl,CGI,Apache,Linux,Web,Java,PC at www.singlesheaven.com/stas/TULARC www.apache.org www.perl.com == www.modperl.com || perl.apache.org single o- + single o-+ = singlesheavenhttp://www.singlesheaven.com