Page 1 of 1
Forum

Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!

Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.

Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!




QNAP - Location of ...
 
Share:
Notifications
Clear all

QNAP - Location of sqlite3 ...? Where can I find sqlite3?

1 Posts
1 Users
0 Likes
1,377 Views
 Hans
(@hans)
Famed Member Admin
Joined: 10 years ago
Posts: 2506
Topic starter  

It seems that sqlite3 (standard command line tool to work with SQLite databases), is nowhere to be found in the default search path of your QNAP.
However, I found it to be install several times ...

With SSH, go to your QNAP and cd to the root and do a search for sqlite3:

cd /
find -name sqlite3  

 

Depending on the storage capacity on your QNAP this may take a while, and possibly produce a list, something like this:

[/] # find -name sqlite3                                                                  
./share/CACHEDEV1_DATA/.qpkg/CloudLink/python/lib/python2.7/sqlite3
./share/CACHEDEV1_DATA/.qpkg/CodexPack/usr/lib/python3.6/sqlite3
./share/CACHEDEV1_DATA/.qpkg/Qmono/bin/sqlite3

 

Many many more were listed - caution hower: some of these are directories and not executable, so verify that before linking!
You could make a link in the directory you're working in (just an example - you may not have mono installed):

ln -s /share/CACHEDEV1_DATA/.qpkg/Qmono/bin/sqlite3 .

 

Or even better, in a location that is found in (or added to) the PATH environment variable.
I did notice that "/opt/bin" seems common, but I did not have that directory so I had to create it and it to the env variable.

mkdir /opt/bin
export PATH=/opt/bin:$PATH
cd /opt/bin
ln -s /share/CACHEDEV1_DATA/.qpkg/Qmono/bin/sqlite3 .

 

You'll have "sqlite3" now available no matter where you're at 😁 


   
ReplyQuote

Like what you see and you'd like to help out? 

The best way to help is of course by assisting others with their questions here in the forum, but you can also help us out in other ways:

- Do your shopping at Amazon, it will not cost you anything extra but may generate a small commission for us,
- send a cup of coffee through PayPal ($5, $10, $20, or custom amount),
- become a Patreon,
- donate BitCoin (BTC), or BitCoinCash (BCH).

Share: