Problems with SQLite on cRIO 9057

[StevenHowell]

Good evening,

I had posted a similar post on the Real Time forum not knowing this forum existed.

In short I am trying to get SQLite installed on my cRIO target. I downloaded the IPK files from OpenWRT and followed the instructions to unpack the tar into the /usr/lib folder.

The files libsqlite3.so and libsqlite3.so.0.8.6 are in this folder.

When I try to connect to the library using the SQLite library I keep getting an error 7 stating that it cannot find the shared library at this location.

Not sure what I missed but help would be greatly appreciated. 

TIA

[drjdpowell]

I'm not using RT Linux, but suggestions:

• I've only heard of people using OPKG to install SQLite, not whatever you have done (example: https://forums.ni.com/t5/LabVIEW/SQLite-on-sbRIO9637/td-p/3615653).  I did try that once on RT and it worked for me, no problem.
• There is an "SQLite Library Path" input to Open.vi, that you can try.  Though the default location is in /usr/lib already, so I wouldn't expect that to work
• You could try downloading the Precompiled Binaries for Linux directly from SQLite.org and try pointing "SQLite Library Path" to that

[StevenHowell]

Thank you for your reply.

Unfortunately for some reason I cannot get my cRIO to connect to the internet. I am developing on a VMware virtual machine and I have the network for the vm as well as the cRIO setup on the same subnet as my network that is connected to the internet. 

When I run the opkg update command I keep getting an error that it cannot find the feeds for download.ni.com. If I try and ping download.ni.com I keep getting a timeout. I am positive it is a network issue but I know very little about network stuff.

[StevenHowell]

drdjpowell,

Ok I was finally able to get the feeds connected to the cRIO.

I go to the terminal and type opkg update and update packages.

I then type opkg install sqlite3 it says it is installing to root.

I go into the directory /usr/lib and find that the files are there but when I run the SQLite toolkit it does not find the libraries. 

Not sure what I am doing wrong at this point. I also made sure to chown to lvuser for the libraries. 

[StevenHowell]

I dont get it, the freakin files are right there and the SQLite toolkit keeps saying it can't find them. 

Error 7 

[drjdpowell]

Here is a link to teh discussion where we were getting teh library to find the SQLite file on RT: https://lavag.org/topic/15857-cr-sqlite-library/?do=findComment&comment=114658

I know multiple people have gotten this working, and I'm not sure what is going on.   I mostly work on Windows, and there my first guess would be Windows "Blocking" the dll (happens when you download from the internet; one can manually unblock), but I don't know about Linux.

[drjdpowell]

You could try asking on that LAVA conversation, where more SQLite-on-RT Users might see it.

[StevenHowell]

Thank you I appreciate your responses!

[StevenHowell]

The problem has been solved! 

I wiped out and reimaged the cRIO chassis and then loaded SQLite fresh from the opkg package manager.

All is well, I am guessing that somehow the library got corrupted.