Re: [sqlite] libsqlite3.so.0 not found

2007-10-30 Thread dsb
> $ ldconfig -v
> search for libsqlite3.so.0 in the list..  is it available

Thanks.  It's in /usr/local/lib, and the sqlite3 interface is working
now.  It didn't create the .db file when I exited though.  Is it supposed
to create an empty file, or do I have to add data first?

> are you running a 64bit OS version?
no

--Dan Bensen
www.prairienet.org/~dsb/



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] libsqlite3.so.0 not found

2007-10-30 Thread Filip Jonckers

if you do 

$ ldconfig -v

or 

$ ldconfig -v | grep libsqlite3

search for libsqlite3.so.0 in the list..  is it available

are you running a 64bit OS version?
if yes - depending on the client app - you need the 32bit version if client app 
is 32bit

Filip



[EMAIL PROTECTED] wrote: -

To: sqlite-users@sqlite.org
From: [EMAIL PROTECTED]
Date: 10/30/2007 13:21
Subject: [sqlite] libsqlite3.so.0 not found

I downloaded the source tarball for 3.5.1 and followed the instructions in
README.  The build dir is sqlite-3.5.1/../bld.
Then cd'd into a subdir of ~ and tried to create a db:
$ sqlite3 mysite.db
sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot
open shared object file: No such file or directory

The machine is running Zenwalk 2.6, which is an offshoot of Slackware.

--Dan Bensen
www.prairienet.org/~dsb/



-
To unsubscribe, send email to [EMAIL PROTECTED]
-




[sqlite] libsqlite3.so.0 not found

2007-10-30 Thread dsb
I downloaded the source tarball for 3.5.1 and followed the instructions in
README.  The build dir is sqlite-3.5.1/../bld.
Then cd'd into a subdir of ~ and tried to create a db:
$ sqlite3 mysite.db
sqlite3: error while loading shared libraries: libsqlite3.so.0: cannot
open shared object file: No such file or directory

The machine is running Zenwalk 2.6, which is an offshoot of Slackware.

--Dan Bensen
www.prairienet.org/~dsb/



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] libsqlite3.so

2006-08-22 Thread Laura Longo

"Laura Longo" <[EMAIL PROTECTED]> wrote:


Hi Richard,
I've tried with mkso.sh but an error has immediately stopped me:

make: *** No rule to make target `target_source'.  Stop.



You need to make a copy of Makefile.linux-gcc into your
build directory, change the name to just "Makefile", and
edit the macros at the top to suite your particular
setup.  Or, you can run "configure" at let it build a
Makefile for you.  Either way should work to generate a
Makefile that understands the "target_source" target.




but I don't gave up! I've tried with sqlite-3_3_7-tea.tar.gz as you 
have
suggested... but the result is not very good, already in the 
'configure'...


checking for correct TEA configuration... ok (TEA 3.5)
checking for Tcl configuration... configure: WARNING: Can't find Tcl
configuration definitions




Install Tcl.  http://www.tcl.tk/
Shame on CentOS for not installing it by default!
--
D. Richard Hipp   <[EMAIL PROTECTED]>


Ok, with your help I have installed Tcl and I have built sqlite-3_3_7-tea, 
whith the shared library! Now I can begin to study the source code to try 
solve my problem in this way!


Thank you very much!

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] libsqlite3.so

2006-08-22 Thread drh
"Laura Longo" <[EMAIL PROTECTED]> wrote:
> 
> Hi Richard,
> I've tried with mkso.sh but an error has immediately stopped me:
> 
> make: *** No rule to make target `target_source'.  Stop.

You need to make a copy of Makefile.linux-gcc into your
build directory, change the name to just "Makefile", and
edit the macros at the top to suite your particular
setup.  Or, you can run "configure" at let it build a
Makefile for you.  Either way should work to generate a
Makefile that understands the "target_source" target.

> 
> but I don't gave up! I've tried with sqlite-3_3_7-tea.tar.gz as you have 
> suggested... but the result is not very good, already in the 'configure'...
> 
> checking for correct TEA configuration... ok (TEA 3.5)
> checking for Tcl configuration... configure: WARNING: Can't find Tcl 
> configuration definitions
> 

Install Tcl.  http://www.tcl.tk/  
Shame on CentOS for not installing it by default!
--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] libsqlite3.so

2006-08-22 Thread Laura Longo

Hi Clay,
I'm workink under Linux (CentOS), kernel 2.6.16...


That's the right file.

It might be helpful to know what platform you're building on, and if that
platform supports shared libraries.  Shared libraries are usually built by
default on platforms that support them.

As for the source to sqlite3_get_table, it will be visible in your source.
You will probably have to go through the configure process first, because
a lot of the source files aren't built until after the configure process.

Clay Dowling


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] libsqlite3.so

2006-08-22 Thread drh
"Laura Longo" <[EMAIL PROTECTED]> wrote:
> Hi all,
> I would like to view the source code of libsqlite3.so because of a problem 
> with sqlite3_get_table function... I have a question: in the file 
> sqlite-3.3.7.tar.gz that I find at http://www.sqlite.org/download.html, are 
> there also the source code of the library? If the answer is no, where can I 
> find them? Instead, if the answer is yes, what is the option of the 
> 'configure' command to build the shared library? (I've tried with 
> './configure --enable-shared' but without any result... I only build the 
> binary sqlite3)
> 

All of the sources are available in that tarball.

The shared library building mechanism in autoconf is really
goofy and hardly works.  The libsqlite3.so library that appears
on the SQLite website is built by first manually configuring
the makefile Makefile.linux-gcc then running the shell script
"mkso.sh".

The configure script and makefile in the TEA version of the
source code (sqlite-3_3_7-tea.tar.gz) also works pretty well.
That's the version I used to build shared libraries on OS X.

--
D. Richard Hipp   <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] libsqlite3.so

2006-08-22 Thread Clay Dowling
That's the right file.

It might be helpful to know what platform you're building on, and if that
platform supports shared libraries.  Shared libraries are usually built by
default on platforms that support them.

As for the source to sqlite3_get_table, it will be visible in your source.
 You will probably have to go through the configure process first, because
a lot of the source files aren't built until after the configure process.

Clay Dowling

Laura Longo said:
> Hi all,
> I would like to view the source code of libsqlite3.so because of a problem
> with sqlite3_get_table function... I have a question: in the file
> sqlite-3.3.7.tar.gz that I find at http://www.sqlite.org/download.html,
> are
> there also the source code of the library? If the answer is no, where can
> I
> find them? Instead, if the answer is yes, what is the option of the
> 'configure' command to build the shared library? (I've tried with
> './configure --enable-shared' but without any result... I only build the
> binary sqlite3)
>
> Laura
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>


-- 
Simple Content Management
http://www.ceamus.com


-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] libsqlite3.so

2006-08-22 Thread Laura Longo

Hi all,
I would like to view the source code of libsqlite3.so because of a problem 
with sqlite3_get_table function... I have a question: in the file 
sqlite-3.3.7.tar.gz that I find at http://www.sqlite.org/download.html, are 
there also the source code of the library? If the answer is no, where can I 
find them? Instead, if the answer is yes, what is the option of the 
'configure' command to build the shared library? (I've tried with 
'./configure --enable-shared' but without any result... I only build the 
binary sqlite3)


Laura

-
To unsubscribe, send email to [EMAIL PROTECTED]
-