installing "pysqlite"

[Nader]

On Mar 1, 2:40 pm, "Paul Boddie" <p... at boddie.org.uk> wrote:
> On 1 Mar, 12:46, "Nader" <n.em... at gmail.com> wrote:
>
>
>
> > ldd returens the next result:
> > ldd /usr/people/emami/lib/python2.4/site-packages/pysqlite2/_sqlite.so
> >     linux-gate.so.1 =>  (0xffffe000)
> >     libpthread.so.0 => /lib/tls/libpthread.so.0 (0x40040000)
> >     libc.so.6 => /lib/tls/libc.so.6 (0x40050000)
>
> I think you pasted the nm result in here, but you seem to be missing
> libsqlite3.so.0 (from what I see myself). From what I've just read
> about linux-gate.so, the linker can't seem to find the SQLite
> libraries. More on linux-gate.so here:
>
> http://www.trilithium.com/johan/2005/08/linux-gate/
>
> > and the 'nm' gives this:
>
> > nm usr/people/emami/lib/libsqlite3.so | grep  sqlite3_set_authorize
> > 0000ce40 T sqlite3_set_authorizer
>
> That looks alright.
>
> >         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)
>
> I guess this was the end of the ldd result.
>
> I'm out of ideas, unfortunately. I think you should experiment with
> LD_LIBRARY_PATH and run ldd again to see if you can get it to show
> libsqlite3.so.0. The pysqlite mailing list might be the best place to
> ask for help if that doesn't work. Sorry!
>
> Paul

Hello Paul,

I have returnd to the begining and have installed everthing again.
Fortunately now I have the 'pysqlite2' module, because the test.test()
workd after importing of 'pysqlite2'

 >>> from pysqlite2 import test
>>> test.test
<function test at 0x404727d4>
>>> test.test()
.............................................................................................................................................................................
----------------------------------------------------------------------
Ran 173 tests in 0.585s

OK
>>>

And the result of running of 'ldd' is :
emami at bcw009:~> ldd lib/python2.4/site-packages/pysqlite2/_sqlite.so
        linux-gate.so.1 =>  (0xffffe000)
        libsqlite3.so.0 => /usr/people/emami/lib/libsqlite3.so.0
(0x40010000)
        libpthread.so.0 => /lib/tls/libpthread.so.0 (0x40096000)
        libc.so.6 => /lib/tls/libc.so.6 (0x400a7000)

Now I can ggo on with TurboGears! I have at home a Laptop and I have
installed the 'gentoo' on it, and have no problem. But I would like to
experiment with TurboGears at my work and It was a problem that I had
no 'root' password.
However I appreciate well your help in this case. I you like Indian or
oriental music I can send you some!

With regards,

Nader