topic Re: localDB Indicators Not Displaying in General Topics

localDB Indicators Not Displaying

jt1025 — Sat, 29 Jun 2019 21:33:19 GMT

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.

Re: localDB Indicators Not Displaying

lmori — Wed, 03 Jul 2019 10:54:07 GMT

Hi @jt1025,

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

Luigi

Re: localDB Indicators Not Displaying

jt1025 — Wed, 03 Jul 2019 14:04:01 GMT

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/

Re: localDB Indicators Not Displaying

lmori — Wed, 03 Jul 2019 14:18:54 GMT

Hi @jt1025,

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

Luigi

Re: localDB Indicators Not Displaying

jt1025 — Wed, 03 Jul 2019 14:33:34 GMT

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

Re: localDB Indicators Not Displaying

jt1025 — Mon, 08 Jul 2019 12:22:28 GMT

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!