DBD::SQLite FreeBSD install

I wanted to do a quick install of DBI and DBD::SQLite on a pretty new
FreeBSD machine. DBI went fine. But when I got DBD::SQLite, the link
fails with a reference to pthread_create. Looking on the web, I found -
pthread, CFLAGS=-pthread and link with -lpthread. I set an env var,
failure, I then edited the Makefile by hand, but still, the make
works, but the tests fail because "Cant load xxx/SQLite.so - Undefined
symbol pthread_create".

I do not want to install ports.. This is not my machine, and I am not
an admin. I just want a Lite DBI module to do some testing with ...

Please advise, thanks

Re: DBD::SQLite FreeBSD install

brian.darkblueb@gmail.com writes:

> works, but the tests fail because "Cant load xxx/SQLite.so - Undefined
> symbol pthread_create".

Did you try force install? Usually not recommended but I did it several
times to install DBD::SQLite and it has worked without issues.

--
Radek

Re: DBD::SQLite FreeBSD install

On Aug 31, 11:04 am, rahed wrote:
> brian.darkbl...@gmail.com writes:
> > works, but the tests fail because "Cant load xxx/SQLite.so - Undefined
> > symbol pthread_create".
>
> Did you try force install? Usually not recommended but I did it several
> times to install DBD::SQLite and it has worked without issues.
>

well, force install made the Module show up as 'installed', but
actually running it gets the same error..

/libexec/ld-elf.so.1: /usr/local/lib/libsqlite3.so.8: Undefined symbol
"pthread_create"

Re: DBD::SQLite FreeBSD install

On Aug 31, 1:58 pm, brian.darkbl...@gmail.com wrote:
> On Aug 31, 11:04 am, rahed wrote:
>
> > brian.darkbl...@gmail.com writes:
> > > works, but the tests fail because "Cant load xxx/SQLite.so - Undefined
> > > symbol pthread_create".
>
> > Did you try force install? Usually not recommended but I did it several
> > times to install DBD::SQLite and it has worked without issues.
>
> well, force install made the Module show up as 'installed', but
> actually running it gets the same error..
>
> /libexec/ld-elf.so.1: /usr/local/lib/libsqlite3.so.8: Undefined symbol
> "pthread_create"

I hand edited the Makefile. added -pthread to CCFLAGS, added -lpthread
to both EXTRALIBS and LDLOADLIBS

now it works...

Re: DBD::SQLite FreeBSD install

On Aug 31, 3:21 pm, brian.darkbl...@gmail.com wrote:
> On Aug 31, 1:58 pm, brian.darkbl...@gmail.com wrote:
>
> > On Aug 31, 11:04 am, rahed wrote:
>
> > > brian.darkbl...@gmail.com writes:
> > > > works, but the tests fail because "Cant load xxx/SQLite.so - Undefined
> > > > symbol pthread_create".
>
> > > Did you try force install? Usually not recommended but I did it several
> > > times to install DBD::SQLite and it has worked without issues.
>
> > well, force install made the Module show up as 'installed', but
> > actually running it gets the same error..
>
> > /libexec/ld-elf.so.1: /usr/local/lib/libsqlite3.so.8: Undefined symbol
> > "pthread_create"
>
> I hand edited the Makefile. added -pthread to CCFLAGS, added -lpthread
> to both EXTRALIBS and LDLOADLIBS
>
> now it works...

well, I *think* it works.. the tests run, except one file will fail,
in the middle, in three test runs it has been the same one twice and
another the third time. I ran a sample program that I wrote myself..
pretty sure it should work unmodified, but ...

now trying another example.. got "out of memory" at an odd place..
weird
is this really that screwy?