Unable to get count of number of messages in smatDB in 6.2

I ran into the same issue. Here is my work-around. If you are using the default database, sqlite, you can do the following from the command line in linux. Go to the directory where your smat file is and do the following:

SmatHistory$ sqlite tcpresults_data.20180920234713.smatdb ‘select count(1) from smat_msgs’

5000

If you cycle the smat files daily and want a monthly count, you can do this:

for i in {01..31}; do sqlite tcpresults_data.201808$i*.smatdb ‘select count(1) from smat_msgs’; done

You’ll get a line for each day.

Hope this helps,

Jeff

Varun,

The default encryption key for SMATDB is the site name. Normally, we use this command to specify the key.

PRAGMA key=’yourkeyhere’;

Unfortunately, our firewall won’t let me post the command that worked here. It thinks I am attempting a SQL injection hack. But what I did in Windows was put the PRAGMA command before the SELECT command. I surrounded the PRAGMA;SELECT commands in double-quotes instead of the single quotes since the PRAGMA command really wants the key surrounded by single quotes. I’m not sure if you can make the same substitution in Linux.

Bill