From owner-freebsd-questions Sat Apr 15 16:10:38 2000 Delivered-To: freebsd-questions@freebsd.org Received: from ren.sasknow.com (ren.sasknow.com [207.195.92.131]) by hub.freebsd.org (Postfix) with ESMTP id D733D37B827 for ; Sat, 15 Apr 2000 16:10:34 -0700 (PDT) (envelope-from ryan@sasknow.com) Received: from localhost (ryan@localhost) by ren.sasknow.com (8.9.3/8.9.3) with ESMTP id RAA04396 for ; Sat, 15 Apr 2000 17:11:15 -0600 (CST) (envelope-from ryan@sasknow.com) Date: Sat, 15 Apr 2000 17:11:15 -0600 (CST) From: Ryan Thompson To: freebsd-questions@freebsd.org Subject: Sudden Apache DBD troubles after reboot Message-ID: Organization: SaskNow Technologies [www.sasknow.com] MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Hi all, After a reboot (due to hardware upgrades, of course :-), my Perl scripts that use mySQL refuse to run (generate 500 errors). Helpful outputs (Apologies for the long lines): # cat /var/log/httpd/error.log | tail -10 [Sat Apr 15 17:00:56 2000] [notice] SIGUSR1 received. Doing graceful restart [Sat Apr 15 17:00:56 2000] [notice] Apache/1.3.12 (Unix) PHP/3.0.15 mod_perl/1.21 configured -- resuming normal operations [Sat Apr 15 17:00:59 2000] [error] Can't load '/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBD/mysql/mysql.so' for module DBD::mysql: Shared object "libmysqlclient.so.6" not found at /usr/libdata/perl/5.00503/DynaLoader.pm line 169. at /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/Mysql.pm line 13 BEGIN failed--compilation aborted at /www/perl//DBHandle.pm line 26. BEGIN failed--compilation aborted at /www/perl/riverbend/Query.pm line 22. BEGIN failed--compilation aborted at /www/perl/riverbend/Product.pm line 22. BEGIN failed--compilation aborted at /home/riverbend/cgi-bin/product.pl line 27. # ldconfig -r | grep mysql search directories: /usr/lib:/usr/lib/compat:/usr/X11R6/lib:/usr/local/lib:/usr/local/lib/m3/FreeBSD2:/usr/local/lib/mysql 174:-lmysqlclient.6 => /usr/local/lib/mysql/libmysqlclient.so.6 # ps -ax | grep mysql 4205 p1 S+ 0:00.01 grep mysql 3864 p2 I 0:00.02 /bin/sh /usr/local/bin/safe_mysqld --user=mysql 3873 p2 S 0:00.10 /usr/local/libexec/mysqld --basedir=/usr/local --data # ll /usr/local/lib/mysql/* -rw-r--r-- 1 root 10050 Mar 1 10:22 /usr/local/lib/mysql/libdbug.a -rw-r--r-- 1 root 33104 Mar 1 10:22 /usr/local/lib/mysql/libheap.a -rw-r--r-- 1 root 14408 Mar 1 10:22 /usr/local/lib/mysql/libmerge.a -rw-r--r-- 1 root 128836 Dec 4 21:48 /usr/local/lib/mysql/libmysqlclient.a lrwxr-xr-x 1 root 19 Dec 4 21:48 /usr/local/lib/mysql/libmysqlclient.so -> libmysqlclient.so.6* -rwxr-xr-x 1 root 84018 Dec 4 21:48 /usr/local/lib/mysql/libmysqlclient.so.6 -rw-r--r-- 1 root 35016 Mar 1 10:22 /usr/local/lib/mysql/libmystrings.a -rw-r--r-- 1 root 148782 Mar 1 10:22 /usr/local/lib/mysql/libmysys.a -rw-r--r-- 1 root 95084 Mar 1 10:22 /usr/local/lib/mysql/libnisam.a And, I can connect to the mySQL server with the `mysql` client and perform queries as usual. The DBD stuff seems not to be working. As I mentioned, I *think* this happened after the reboot I did a few minutes ago. Running 3.4-STABLE (last buildworld about 45 days ago), and mysql 3.22.32. Apache 1.3.12 and mod_perl 1.21 are being used as well. Any suggestions? This is affecting a lot of clients! -- Ryan Thompson Systems Administrator, Accounts Phone: +1 (306) 664-1161 SaskNow Technologies http://www.sasknow.com #106-380 3120 8th St E Saskatoon, SK S7H 0W2 To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message