installing "pysqlite"

[Nader]

On Mar 1, 11:46 am, "Paul Boddie" <p... at boddie.org.uk> wrote:
> On 1 Mar, 10:34, "Nader" <n.em... at gmail.com> wrote:
>
>
>
> > I have expanded the LD_LIBRARY_PATH to my home lib (export
> > LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/people/emami/lib).
> > I have built and installed the 'pysqlite-2.3.3' with the next
> > 'setup.cfg' :
>
> > [build_ext]
> > define=
> > include_dirs=/usr/people/emami/include
> > library_dirs=/usr/people/emami/lib
> > #libraries=/usr/people/emami/lib/libsqlite3.so  (this line as a
> > comment)
>
> This looks alright. Be sure to verify that libsqlite3.so is in /usr/
> people/emami/lib, although I suppose you've done this, looking at your
> comment.
>
> > The resutl of this process was:
>
> > running install_lib
> > copying build/lib.linux-i686-2.4/pysqlite2/_sqlite.so -> /usr/people/
> > emami/lib/python2.4/site-packages/pysqlite2
> > running install_data
>
> > This message had given after installing. I have controll the '/usr/
> > people/emami/lib/python2.4/site-packages/pysqlite2' whether the
> > '_sqlite.so' has copied there. Yes it has. Okay!
>
> So pysqlite2 has installed properly at least.
>
> > I go to python and I give the next command:
>
> > >>> from pysqlite import test
>
> > and Unfortunately I get the next error message:
>
> [...]
>
> > ImportError: /usr/people/emami/lib/python2.4/site-packages/pysqlite2/
> > _sqlite.so: undefined symbol: sqlite3_set_authorizer
>
> I'm running out of ideas here, but you could try doing this:
>
> ldd /usr/people/emami/lib/python2.4/site-packages/pysqlite2/_sqlite.so
>
> This should show a list of references to libraries, but if one of them
> is missing in some way then it means that it isn't found by the linker
> and it's not on the LD_LIBRARY_PATH. Another thought is that
> sqlite3_set_authorizer isn't found in the SQLite library - you can
> test this by doing the following:
>
> nm /usr/people/emami/lib/libsqlite3.so
>
> I get something like this in response:
>
> 00000000000110b0 T sqlite3_set_authorizer
>
> If you don't get anything in response or if you see "U" instead of
> "T", then this might indicate an problem with the way SQLite has been
> configured.
>
> > Do you know what option I have to give to if I want to use the
> > 'easy_install" tool?
> > %easy_install pysqlite (with some optione with which it cab find the
> > installed 'libsqlite.so')
>
> I'm no easy_install expert, I'm afraid. You might want to talk to the
> pysqlite people directly if what I've suggested doesn't help you
> further:
>
> http://www.initd.org/tracker/pysqlite/wiki/pysqlite
>
> Paul

Hello

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)

and the 'nm' gives this:

nm usr/people/emami/lib/libsqlite3.so | grep  sqlite3_set_authorize
0000ce40 T sqlite3_set_authorizer


        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)