Page 1 of 1

Sqlite command line problem

PostPosted: 25. March 2005 23:55
by johnmcginnis
First kudos for the Xampp team. A very slick platform well executed.

To my problem:

I notice that the variant of Xampp I downloaded has support for SQLite. Yet if I attempt to run SQLite from commandline (@ /opt/lampp/bin/sqlite) it comes back with 'command not found'.

Now I have checked permissions (755) so they are ok. Even an attempt at root level comes back with the same error so I have ruled out group rights as the issue. Odd thing is the preinstlled PHP demo program that uses SQLite works fine :?

Anyone have a clue was the problem is of running SQLite at command line from the Xampp installation?

Thanks in advance.

PostPosted: 27. March 2005 19:11
by Oswald
Dear John!

Are you absolutely sure you call /opt/lampp/bin/sqlite and made no typo? If you are sure please call the following two commands. What do them output?

file /opt/lampp/bin/sqlite
ldd /opt/lampp/bin/sqlite


Many greetings
Oswald

Re: Sqlite command line not launching

PostPosted: 01. April 2005 16:37
by johnmcginnis
Oswald,

Hallo von Dallas!

Below is the output from your request. Does SQLite work? Yes. I had attempted the SQLite launch from /opt/lampp/bin the directory, not /opt/lampp/bin/sqlite. As you suggested works quite fine, which of course makes me feel like an idiot.

Will have to determine why the following does not work:

cd /opt/lampp/bin
sqlite
bash: sqlite: command not found

Most likely I will just set up a BASH alias and leave it at that. but I do appreciate your help. (Now time for me to stand in a corner and have a Homer Simpson moment....)

John McGinnis

root@testbox:/opt/lampp/bin # file /opt/lampp/bin/sqlite
/opt/lampp/bin/sqlite: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), for GNU/Linux 2.0.0, dynamically linked (uses shared libs), stripped

root@testbox:/opt/lampp/bin # ldd /opt/lampp/bin/sqlite
libsqlite.so.0 => /opt/lampp/lib/libsqlite.so.0 (0x40017000)
libc.so.6 => /lib/tls/i686/cmov/libc.so.6 (0x4006e000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

PostPosted: 01. April 2005 17:44
by Wiedmann
cd /opt/lampp/bin
sqlite
bash: sqlite: command not found

That's normal on *nix...

You must prepend a "./":
Code: Select all
cd /opt/lampp/bin/
./sqlite


(or add "." to your (search) PATH)