Skip site navigation (1)Skip section navigation (2)
Date:      Sat, 15 Apr 2000 17:26:15 -0600 (CST)
From:      Ryan Thompson <ryan@sasknow.com>
To:        Steve Hovey <shovey@buffnet.net>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Sudden Apache DBD troubles after reboot
Message-ID:  <Pine.BSF.4.21.0004151725300.949-100000@ren.sasknow.com>
In-Reply-To: <Pine.BSF.4.05.10004151917480.27072-100000@buffnet11.buffnet.net>

next in thread | previous in thread | raw e-mail | index | archive | help
Steve Hovey wrote to Ryan Thompson:

> Looks to me like it wants to find libmysqlclient.so.6 in that perl
> directory and isnt lookin in the mysql lib area

How, then, might I entice the loader to look in the proper directory as it
did before?

- Ryan

> On Sat, 15 Apr 2000, Ryan Thompson wrote:
> 
> > 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
> > 
> 
> 

-- 
  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.0004151725300.949-100000>