DBI and Apache::DBI
Hi all, I have some questions with DBI. a) I don't understand why the database sometimes gets dropped. It happens randomly but frequently. could not prepare: Database disconnected at /dssweb/httpd/cgi-bin/feeds/viewReport line 157. b) I built mod_perl and apache with EVERYTHING=1. Should I expect DBI.pm appear in Apache directory? For some reason, it doesn't get there. Or should I add DBI module under Apached directory? If so, how. I have my own version of Perl under home directory. Thanks, Isarin __ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861 -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html
Re: DBI and Apache::DBI
> Apache::DBI comes with mod_perl, and you should see > it in your site_perl directory. It is a pure perl > module, so it would not be under an i386 > directory (or whatever your architecture is). If > you can do PerlModule Apache::DBI in your program > without failure, it means that it is there > in your @INC path. Sorry for being unclear. I mean Apache subdirectory under site_perl directory. I can seee Registry.pm under .../site_perl/5.8.3/sun4-solaris/Apache directory. (Apache::Registry) I would expect DBI in the same directory but it is not there. I figured that out after it gave me an error that it can't find Apache::DBI. I am not sure what I missed when building mod_perl / Apache. Do I need to add environmental variables? Let me recap what I did: a) Build perl under my home directory /home/dssweb/local-perl b) Add DBI module and others other modules such as LWP, HTTP are under: /home/dssweb/local-perl/lib/site_perl/5.8.3 yet my DBI module is under: /home/dssweb/local-perl/lib/site_perl/5.8.3/sun4-solaris c) Build mod_perl and apache. My mod_perl and some Apache stuff are under /home/dssweb/local-perl/lib/site_perl/5.8.3/sun4-solaris Thanks. __ Do you Yahoo!? Yahoo! Movies - Buy advance tickets for 'Shrek 2' http://movies.yahoo.com/showtimes/movie?mid=1808405861 -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html
Re: DBI and Apache::DBI
Thanks, Guys, I ended up installing Apache::DBI from CPAN and it is under /home/dssweb/local-perl/lib/site_perl/5.8.3. I was mistaken that Apache::DBI would come with apache. Event though it was, for some reason it didn't get installed. Anyways, it is working now. Cheers, Isarin Perrin Harkins <[EMAIL PROTECTED]> wrote: On Wed, 2004-05-12 at 14:32, I S wrote:> Sorry for being unclear. I mean Apache subdirectory> under site_perl directory. I can seee Registry.pm> under .../site_perl/5.8.3/sun4-solaris/Apache> directory. (Apache::Registry) I would expect DBI in> the same directory but it is not there.That's what I was saying: Apache::DBI is pure perl, so it doesn't go inthat directory. Look in /site_perl/5.8.3/Apache instead.> I figured> that out after it gave me an error that it can't find> Apache::DBI.If you have Apache::Registry installed, you should also have Apache::DBIinstalled. Look for it with find or locate, and check the permissionson the directories above it.> b) Add DBI module and others > other modules such as LWP, HTTP are under:> /home/dssweb/local-perl/lib/site_perl/5.8.3> > yet my DBI module is under:> /home/dssweb/local-perl/lib/site_perl/5.8.3/sun4-solarisAre you talking about DBI, not Apache::DBI? That's an XS module so itgoes into the architecture-dependent directory.> My mod_perl and some Apache stuff are under > /home/dssweb/local-perl/lib/site_perl/5.8.3/sun4-solarisThen you should find Apache/DBI.pm under/home/dssweb/local-perl/lib/site_perl/5.8.3.- Perrin-- Report problems: http://perl.apache.org/bugs/Mail list info: http://perl.apache.org/maillist/modperl.htmlList etiquette: http://perl.apache.org/maillist/email-etiquette.html Do you Yahoo!?Yahoo! Movies - Buy advance tickets for 'Shrek 2'
installation problem
Hi all, I am really stuck and have been looking for solutions around on Internet but with no luck. I am about to give up and kind of not sure I should post this question. Anyways, I give it a try and hope for some suggestions. I realize that the problem that I have is listed on perl.apache.org. There is some suggestions there too. Yet I can't do what it is suggested. Anyways, please take a little more momement to read my problem/situation: Problem: Can't load ' ../auto/DBI/DBI.so for module DBI. Suggestion: Perl reinstallation with some ld flag. We are using Solaris and when I do perl -V, it doesn't have the ld flag of -XLinker --export-dynamic Linker and Libraries: ld='gcc', ldflags =' ' libpth=/usr/lib /usr/ccs/lib libs=-lsocket -lnsl -ldl -lm -lc perllibs=-lsocket -lnsl -ldl -lm -lc libc=/lib/libc.so, so=so, useshrplib=false, libperl=libperl.a Since perl is widely used in the company, it is impossible to have them re-install perl just for me. We install our own version of Apache under home directory. And almost everyone in my company are using FastCgi. Yet, there is a mod_perl enabled apache being run under the same machine, where I failed to install mod_perl. It was installed in 2001 and mod_perl version is 1.25. This makes me believe there might be a way to go around perl re-installation. Is there any suggestion how to get around this problem? Or should i give up on mod_perl? Thank you, Isarin __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweepstakes.yahoo.com/careermakeover -- Report problems: http://perl.apache.org/bugs/ Mail list info: http://perl.apache.org/maillist/modperl.html List etiquette: http://perl.apache.org/maillist/email-etiquette.html