SMATDB – To Encrypt or not?

[Greg Tataryn]

We are on Cloverleaf 6.1.1 and have been using unencrypted SMATDB thus far. After an evaluation from Infor, it was recommended to use encrypted SMATDB files. I can understand the possible security concerns addressed by encryption, however it seems to make support more difficult.

With unencrypted SMAT, we are able to use SQLite to access the messages, run queries, etc. So far I have not been able to do that with encrypted SMAT, and can only access the files from within the GUI. Using the GUI is nice, but being able to directly access through SQLite gives some extra flexibility in querying the data.

So my question to those using SMATDB, do you encrypt or not? In either case what is your reasoning for doing so or not doing so? If you are using encryption, do you have a way to access the data through SQLite?

Topic

[Elisha Gould]

The key is the site name by default.

When you open the database, use the following to decrypt the database (where $smatdbKey is the site name).

PRAGMA KEY=$smatdbKey;

[Author]

Replies