UNIX for Advanced & Expert Users

Hi all

I'm hoping this is just me being a muppet, has anyone come across this problem before?

I am writing an application that uses sqlite3 and I have created a database using it -

Code:

sqlite3 muse.db
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
alarm                muse_hosts           suite
groups               runtime_environment  timer
job                  state
msgs                 state_machine_flags
sqlite> .q

If I run sqlite3 from the same directory as the database file all is well - as above.

But if I try to use a fully qualified path -

Code:

[brad@dev01o .muse_dev]$ /opt/brad/sqlite3 muse.db
-bash: /opt/brad/sqlite3: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory

Googling around would suggest that this is a problem with trying to run a 32 bit version of an executable on a 64 bit Centos server. I don't understand though why it is happy running without a fully qualified path in that case.

Can anyone provide any insight into what the problem is?

Thanks advance

Brad

What does this show:

Code:

which sqlite3

Hi Bartus

Sorry I didn't get back to you. I posted an edit earlier saying I had tried that , but the edit doesn't show here.

Yes, good guess. It finally dawned on me to try 'which' and the problem was that someone has already installed it in /usr/bin.

I say a problem, I just switched to using that and now everything works.

Thanks

Brad