From owner-freebsd-questions Sat Jun 23 17:23:49 2001 Delivered-To: freebsd-questions@freebsd.org Received: from mta4-rme.xtra.co.nz (mta4-rme.xtra.co.nz [203.96.92.15]) by hub.freebsd.org (Postfix) with ESMTP id BCAE337B401 for ; Sat, 23 Jun 2001 17:23:44 -0700 (PDT) (envelope-from webmaster@open2view.com) Received: from sparlak ([210.54.115.71]) by mta4-rme.xtra.co.nz with ESMTP id <20010624003045.NCVJ1819863.mta4-rme.xtra.co.nz@sparlak>; Sun, 24 Jun 2001 12:30:45 +1200 Message-ID: <006601c0fc44$9d51bfd0$0100a8c0@sparlak> From: "Philip Murray" To: "Ryan Thompson" Cc: References: Subject: Re: Mysql module in Perl refuses to load Date: Sun, 24 Jun 2001 12:28:38 +1200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG When you compile PHP4, make sure you specify the location of the MySQL installation at the --with-mysql=/usr/local/mysql/ If you don't specify it, PHP uses it's built in libmysql and breaks compatibility with any other mysql using feature compiled in apache. -------------------------------- - -- - - - Philip Murray - me@philth.net.nz ------------ - -- - - ----- Original Message ----- From: "Ryan Thompson" To: Sent: Friday, June 22, 2001 5:20 PM Subject: Mysql module in Perl refuses to load > > Hey everybody, > > Doing some testing here--from sources I compiled/installed Apache 1.3.20, > mod_perl 1.25 and php 4.0.5 (all as DSO), and Apache reports that all > modules are loaded. This was done over top of an Apache 1.3.9/mod_perl > 1.21/php 3.0.15 installation to the same prefix directory > (/usr/local/apache). That part appears to have worked fine--PHP4 and > mod_perl are so far working as expected. I compiled PHP --with-mysql > > However, during that process, I appear to have broken the Mysql module in > Perl. Any Perl CGI that uses Mysql dies and reports the following in the > apache error log: > > [Thu Jun 21 23:11:56 2001] [notice] SIGUSR1 received. Doing graceful > restart > [Thu Jun 21 23:11:58 2001] [notice] Apache/1.3.20 (Unix) PHP/4.0.5 > mod_perl/1.25 configured -- resuming normal operations > [Thu Jun 21 23:11:59 2001] [error] [client 207.195.92.134] File does not > exist: /www/data/none > [Thu Jun 21 23:12:03 2001] [error] Can't load > '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI/DBI.so' for > module > DBI: /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI/DBI.so: Undefined > symbol "PL_dowarn" at /usr/libdata/perl/5.00503/DynaLoader.pm line 169. > > at /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/DBI.pm line 158 > BEGIN failed--compilation aborted at > /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/DBI.pm line 158. > > > It's the missing PL_dowarn that looks to be the culprit. Can anybody help > me out, here? I tried a make deinstall/reinstall in > /usr/ports/databases/p5-Mysql, but that did not solve the problem. > > And, it should be said that Perl Mysql was working before the apache > recompile and upgrade. > > - Ryan > > -- > Ryan Thompson > Network Administrator, Accounts > > SaskNow Technologies - http://www.sasknow.com > #106-380 3120 8th St E - Saskatoon, SK - S7H 0W2 > > Tel: 306-664-3600 Fax: 306-664-1161 Saskatoon > Toll-Free: 877-727-5669 (877-SASKNOW) North America > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message