Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

2006-01-03 Thread Lloyd Thomas
The precompiled version did work. I was just trying to compile it myself to 
get experience building a linux box.


Lloyd

- Original Message - 
From: <[EMAIL PROTECTED]>

To: <sqlite-users@sqlite.org>
Sent: Tuesday, January 03, 2006 1:29 PM
Subject: Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)


"Lloyd Thomas" <[EMAIL PROTECTED]> wrote:

Thanks Kimball
Your right about having a little experience. I am
just running into error after error installing apps, but I'm learnoing
slowly. Anyway, I was trying to install the sqlite support for another
application I want to use and as a side issue it seems to have installed
sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at
the prompt and it would just start.



Did the precompiled binary on the website not work for you?
http://www.sqlite.org/download.html

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



Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

2006-01-03 Thread drh
"Lloyd Thomas" <[EMAIL PROTECTED]> wrote:
> Thanks Kimball
> Your right about having a little experience. I am 
> just running into error after error installing apps, but I'm learnoing 
> slowly. Anyway, I was trying to install the sqlite support for another 
> application I want to use and as a side issue it seems to have installed 
> sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at 
> the prompt and it would just start.
> 

Did the precompiled binary on the website not work for you?
http://www.sqlite.org/download.html

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



Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

2006-01-03 Thread Arjen Markus
Lloyd Thomas wrote:
> 
> Thanks Kimball
> Your right about having a little experience. I am
> just running into error after error installing apps, but I'm learnoing
> slowly. Anyway, I was trying to install the sqlite support for another
> application I want to use and as a side issue it seems to have installed
> sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at
> the prompt and it would just start.
> 

Hello Lloyd,

you mean the sqlite3 command-line utility? Well, if all else fails,
try it with a small script that you can put in a directory within
your path:

---
# Run command-line utility sqlite3
#
export LD_LIBRARY_PATH=/your/install/dir/lib:$LD_LIBRARY_PATH
export PATH=/your/install/dir/bin:$PATH

sqlite3
---

(Store this in a convenient file like "mysqlite" and use:

chmod +x mysqlite

to make it executable)

The environment variables LD_LIBRARY_PATH and PATH are 
changed locally. So as soon as you leave the utility 
and thus the script, you go back to the original environment.

Regards,

Arjen



Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)

2006-01-03 Thread Lloyd Thomas

Thanks Kimball
   Your right about having a little experience. I am 
just running into error after error installing apps, but I'm learnoing 
slowly. Anyway, I was trying to install the sqlite support for another 
application I want to use and as a side issue it seems to have installed 
sqlite 3.2.8 correctly for me. It would be good if I could type sqlite3 at 
the prompt and it would just start.


Lloyd


- Original Message - 
From: "Arjen Markus" <[EMAIL PROTECTED]>

To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 03, 2006 7:51 AM
Subject: Re: [sqlite] Building sqlite 3.2.8 on redhat 9 (off list)



Lloyd Thomas wrote:


There does not seem to be a library file in /usr/lib/  called
libsqlite3.so.0. would that be the problem. Please bear with me I am a 
linux

newbie.



Hello Lloyd,

my reply may be a bit too detailed, but I assume you have very little
experience with Linux/UNIX. So bare with me if the explanations are
too basic.

What about /usr/local/lib? That is the usual place for
packages/libraries that
are not part of the operating system.

You can print the current setting of LD_LIBRARY_PATH by typing:

echo $LD_LIBRARY_PATH

on the prompt.

It is a list of directories that the loader/linker will look at in
search
of shared objects. The sqlite3 library must be contained in any of
these.

If you find it in a different directory not listed there, you need to
set LD_LIBRARY_PATH:

export LD_LIBRARY_PATH=/your/new/directory:$LD_LIBRARY_PATH

or:

setenv LD_LIBRARY_PATH /your/new/directory:$LD_LIBRARY_PATH

(Presumably the first, the second form is specific to the C-shell, and
you probably have "bash".)

What directory (the prefix option) did you use for installing
SQLite? That is the directory where the library will live in (or in
the subdirectory "lib" of that directory).

Hope this helps.

Regards,

Arjen