I've sorted the problem, this is a bit obscure and is one of those
irritating obvious things... A bit more background is required....
The box mysql is running on used to be a linux box but was moved to freebsd
with the compatability libraries etc.
After this was done everything, including mysql (a linux version) worked
fine.
Then freebsd was reinstalled for various reasons without the compatability
libraries (though I didn't know this at the time). Mysqld, mysql and many
other parts of mysql where working fine so I didn't think the problem was
there, but it was. __errno_location comes from something like libc and
threading stuff in linux so mysql.so was failing on loading. So one correct
version of mysql, one data transfer with all the associated problems,
rebuild DBI and bingo, it all works.
Thanks for the various hints and sorry I missed the correct bit of
information.
>For kicks, why don't you try upgrading to the lastest version, I am
>running Msql-Mysql-modules-1.2215 and I can't seem to find
>__errno_location.
>
>On 14-Jun-01 Rich Caller wrote:
> > I'm reinstalling DBI/DBD (Msql-Mysql-modules-1.2204) in an odd
> > location after a system rebuild and am having a problem that I am
> > having difficulty in finding a solution to.
> >
> > Everything seems to build fine but when I make test the tests I
> > get.....
> >
> >
> > install_driver(mysql) failed: Can't load
> > '../blib/arch/auto/DBD/mysql/mysql.so' for module DBD::mysql:
> > ../blib/arch/auto/DBD/mysql/mysql.so: Undefined symbol
> > "__errno_location" at /usr/libdata/perl/5.00503/DynaLoader.pm line
> > 169.
> > Perhaps a required shared library or dll isn't installed where
> > expected
> >
> > I get the same error if I try using scripts that previously worked....
> >
> > I've tried all the usual places and searches for information without
> > much luck. I would be grateful if someone could give me some pointers
> > to how to work out what I'm doing wrong......
> >
> > I have also been advised that this may be due to certain mysql files not
> > being on path, I've made sure that the correct files are on path etc.
>but
> > nothing has changed. Any more ideas.
> >
> >
> > Heres perl -V for some platform and version information
> >
> > Summary of my perl5 (5.0 patchlevel 5 subversion 3) configuration:
> > Platform:
> > osname=freebsd, osvers=4.0-current, archname=i386-freebsd
> > uname='FreeBSD freefall.FreeBSD.org 4.0-current FreeBSD
> > 4.0-current #0: $Date$'
> > hint=recommended, useposix=true, d_sigaction=define
> > usethreads=undef useperlio=undef d_sfio=undef
> > Compiler:
> > cc='cc', optimize='undef', gccversion=2.95.2 19991024 (release)
> > cppflags=''
> > ccflags =''
> > stdchar='char', d_stdstdio=undef, usevfork=true
> > intsize=4, longsize=4, ptrsize=4, doublesize=8
> > d_longlong=define, longlongsize=8, d_longdbl=define,
> > longdblsize=12
> > alignbytes=4, usemymalloc=n, prototype=define
> > Linker and Libraries:
> > ld='cc', ldflags ='-Wl,-E -lperl -lm '
> > libpth=/usr/lib
> > libs=-lm -lc -lcrypt
> > libc=, so=so, useshrplib=true, libperl=libperl.so.3
> > Dynamic Linking:
> > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='
> > -Wl,-R/usr/lib'
> > cccdlflags='-DPIC -fpic', lddlflags='-Wl,-E -shared -lperl -lm '
> >
> >
> > Characteristics of this binary (from libperl):
> > Built under freebsd
> > Compiled at Apr 21 2001 08:25:58
> > @INC:
> > /usr/libdata/perl/5.00503/mach
> > /usr/libdata/perl/5.00503
> > /usr/local/lib/perl5/site_perl/5.005/i386-freebsd
> > /usr/local/lib/perl5/site_perl/5.005
> > .
> >
> >
>_________________________________________________________________________
> > Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com.
> >
>
>----------------------------------
>E-Mail: Scott T. Hildreth <[EMAIL PROTECTED]>
>Date: 14-Jun-01
>Time: 10:33:01
>----------------------------------
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
