Date: Sat, 15 Apr 2000 17:11:15 -0600 (CST) From: Ryan Thompson <ryan@sasknow.com> To: freebsd-questions@freebsd.org Subject: Sudden Apache DBD troubles after reboot Message-ID: <Pine.BSF.4.21.0004151706080.4286-100000@ren.sasknow.com>
next in thread | raw e-mail | index | archive | help
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 <ryan@sasknow.com> 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.21.0004151706080.4286-100000>