VectorLinux

Please login or register.

Login with username, password and session length
Advanced search  

News:

Visit our home page for VL info. For support and documentation, visit the Vector Linux Knowledge Center or search the Knowledge Center and this Forum using the search box above.

Author Topic: Help with sqlite3 please.  (Read 13053 times)

Locator

  • Vectorian
  • ****
  • Posts: 821
Help with sqlite3 please.
« on: November 18, 2014, 05:33:19 pm »

Where do I find the TCL bindings for SQLite3? I am trying to install a TCL program written in TCL To view videos played on an analog VCR), and it is indicating that it can't find them. The output in question is:

checking dependencies

Tk *** OK
ivtv-tune *** OK
v4l2-ctl *** OK
mplayer *** OK
xdg-email *** OK
xdg-open *** OK
xdg-screensaver *** OK
sqlite3 *** OK
sqlite3 Tcl extension *** FAILED

Thanks in advance.
« Last Edit: November 19, 2014, 09:22:51 pm by Locator »
Logged

M0E-lnx

  • Administrator
  • Vectorian
  • *****
  • Posts: 3482
Re: Help with sqlite3 please.
« Reply #1 on: November 19, 2014, 01:34:03 pm »

Locator

  • Vectorian
  • ****
  • Posts: 821
Re: Help with sqlite3 please.
« Reply #2 on: November 19, 2014, 09:24:17 pm »

Sorry, but I checked out that link, and I don't see how that helps :(.
Logged

polaris96

  • Member
  • *
  • Posts: 16
Re: Help with sqlite3 please.
« Reply #3 on: February 24, 2015, 05:02:10 pm »

EDIT:  This entire reply doesn't provide an answer to the OP.  I'm leaving it because there's a lot of background that may be useful to help understand the situation.  Please read the next reply for my best advice.





Here's the lib https://www.sqlite.org/download.html

You may need to add the lib to your TCLLIBPATH (brief explanation, here http://wiki.tcl.tk/1787)
if you get me the link to the tcl source I will fiddle with it a bit for you.  I'm a tcl developer and always looking for interesting widgets...

do a search for ./libtclsqlite3.so  If it exists, we just need to put it in the right place.  A quick search on my VL platform shows
Code: [Select]
polaris:$ tclsh
% puts $auto_path
/usr/lib/tcl8.5 /usr/lib
%

This tells me tcl will look for packages in /usr/lib and /usr/lib/tcl8.5

Let's see if we have libtclsqlite3.so :
Code: [Select]
find /usr -name *sqlite* -type freturns lots of stuff but not what we want, so back to the URL above.

hmmm.  about 3/4 down this page http://www.sqlite.org/howtocompile.html We see how to compile the tcl interface from a TEA tarball and A download link as above

download the tarball and then extract it
Code: [Select]
tar -xvf sqlite-autoconf-3080802.tar.gz
cd sqlite-autoconf-3080802
ls -l

hmmm.  the documentation isn't great.  go to the tea directory.  They're incorrect about simply compiling.  You WILL need make.
Code: [Select]
cd tea
./configure
make

if you need more info cat README

here's the binary
Code: [Select]
ls -l
libsqlite3.8.8.2.so
cp libsqlite3.8.8.2.so /usr/lib/tcl8.5
#you must be root for the last
#Then back to tcl
exit
$tclsh
%package require sqlite3
3.7.5
#EDIT: actually a problem.  the package doesn't match the build (3.8.8) this is bad because
1. sqlite is ALREADY bundled in VL's tcl core.  The issue may be in your tcl script
2. The package index wasn't updated.  I will look into this but it's late now
« Last Edit: February 26, 2015, 08:30:42 am by polaris96 »
Logged

polaris96

  • Member
  • *
  • Posts: 16
Re: Help with sqlite3 please.
« Reply #4 on: February 26, 2015, 09:08:54 am »

I think the problem lies with the TCL script (application) that you're trying to run.  You can manually check the availability of sqlite3 support from the TCL shell as follows:
Code: [Select]
~$tclsh
%package require sqlite 3
3.7.5
My VL platform returns the numbers 3.7.5, which is version info for the sqlite3 package.  It's part of the core bundle for VL's tcl suite.  Unless "package require" returns a variation of "can't find package sqlite3..."  the issue is with the tcl script not with sqlite3 or tcl, itself.

Logged