localDB Indicators Not Displaying

[jt1025]

Hello,

I'm having an issue with the localDB prototype since upgrading to 0.9.62.  If I manually add indicators or add them via the bulk uploads script they immediately disappear.  They don't even show up in the logs for the nodes.  Any help would be appreciated.

[jt1025 · Accepted solution]

I was able to get back up and running by installing sqlite3-devel and recompiling python with ./var/tmp/Python-2.7.15/configure --enable-loadable-sqlite-extensions && make && sudo make install.  Thanks @lmori!

[lmori]

Hi @jt1025,

which version of the bulk upload script are you using? do you specify a ttl somewhere?

Luigi

[jt1025]

Thanks @lmori. I'm using version 0.1.3 of the script.  No ttl is specified.  I don't even see indicators when I add them manually through the GUI.  I dug in a little more and the database isn't even being created in my /opt/minemeld/local/config directory when the localDB miner is created.
I should note I upgraded to 0.9.62 on RHEL 7.6 using Ansible. The minemeld-engine and minemeld-web wouldn't start due to an "ImportError: No module named _sqlite3" error. So I copied _sqlite3.so to get past that issue using sudo cp /usr/lib64/python2.7/lib-dynload/_sqlite3.so /usr/local/lib/python2.7/sqlite3/

[lmori]

Hi @jt1025,

is sqlite3-devel or sqlite-devel package installed in your system?

Luigi

[jt1025]

Thanks again @lmori.  Neither sqlite3-devel nor sqlite-devel are installed.  Only sqlite.x86_64.

[jt1025 · Accepted solution]

I was able to get back up and running by installing sqlite3-devel and recompiling python with ./var/tmp/Python-2.7.15/configure --enable-loadable-sqlite-extensions && make && sudo make install.  Thanks @lmori!