Version: 6.2.4 SMATdb – Turning off encryption

This topic has 5 replies, 2 voices, and was last updated 3 years, 6 months ago by Lawrence Nelson.

Creator

Topic
May 24, 2021 at 6:30 pm #118888
Lawrence Nelson
Participant
I have turned off decryption on our SMATdb files. (no need to discuss the whys)

Only the SMATdb files from the point of turning off encryption are not encrypted, all files to until that point in time are still encrypted.

Are there any known methods to have the encryption turned “off” on the still encrypted files? In particular in one mass process – turning off/on all the processes is very tedious.

Additionally – I’ve tried this command without success –

hcidbcrypt -I -d -p <sitename> <smatdbfile.smatdb>

which only returns –

hcidbcrypt -I -d -p <sitename> <smatdbfile.smatdb>
dbd /quovadx/cis6.2/integrator/<sitename>/exec/databases, dbf /quovadx/cis6.2/integrator/<sitename>/exec/databases

Database Encryption Utility
RDM Embedded 9.2 [05-Apr-2013]http://www.raima.com/
Copyright (c) 1992-2013 Raima, Inc. All Rights Reserved.

dbcrypt: Error (-44) failed to open database icldb
Fail to decrypt icl db.

Lawrence Nelson
System Architect - MaineHealth IT
Creator

Topic

Viewing 3 reply threads

Author

Replies
- May 24, 2021 at 11:29 pm #118889
  Charlie Bursell
  Participant
  Try this for the encrypted files
  
  hcicrypt decyrpt -f file name
  
  I suppose you could write a shell script to do every file.
- June 1, 2021 at 3:36 pm #118914
  Lawrence Nelson
  Participant
  Charlie –
  
  I didn’t catch it right off but I’m gathering there’s a misspelling of “decrypt” in your response above. Also, want to repeat we are on 6.2.4 (not version 19 or 20)
  
  That being said – when I run the command provided I get this response back and file is not decrypted. Due to word wrapping below I’ve also attached a screen shot. Side note – When issued the command there was messaging around having to stop processes as the previous commands required.
  
  cloproda.mmc.org::hci> hcicrypt decrypt -f to_SCC_orders_outQ.20201107000340.smatdb
  ^▒)#2k▒QR▒▒K▒_Q▒▒▒G▒▒▒▒@L▒9▒u▒F▒!▒_▒c7▒▒▒2*
  ▒D$lf▒▒)▒4▒▒▒▒X▒▒2Z▒▒Ml▒A$\▒:▒d▒▒6▒;▒A▒,▒▒
  ▒▒▒5▒)▒ߎ^T▒8T▒$}▒▒/▒@”▒\▒▒▒Vq▒▒7▒S▒▒츯▒▒毰ũ▒$m▒Qa▒b▒A▒▒▒
  POw▒uInvalid encrypted data
  
  cloproda.mmc.org::hci> hcicrypt decrypt -f to_SCC_orders_outQ.20201108000331.smatdb
  Invalid encrypted data
  ▒▒8▒▒#▒▒▒O▒▒▒H▒▒8▒䞻▒▒mW$▒n▒GD[▒▒(▒▒j▒▒
  ▒▒N ▒R▒▒▒▒z▒C▒▒M▒Ui▒▒▒]_▒▒▒▒▒▒▒Tα▒
  ▒▒▒ʣ▒▒A▒ ▒▒X▒<ϑ/▒R▒▒▒▒= [▒▒b▒.▒▒▒ľ6(▒▒▒▒,▒▒▒E▒▒▒▒bn[▒YΫ▒▒▒:3V▒▒▒~▒▒▒ໝ▒
  ޿▒f▒▒#▒kQ▒▒I7▒▒▒▒
  j>▒▒ױ{UL▒B2~▒▒ί▒A▒▒_▒#▒▒▒S▒C▒g;2▒+▒▒v▒▒?W-▒▒▒D▒▒^▒▒2炈RO▒U▒/B▒▒
  9L\▒▒BT2gq▒▒▒c▒o▒垻▒w+(PuTTYPuTTYPuTTYsGԦ▒;▒▒I<▒1X▒▒▒g▒¯
  
  Attachments:
  You must be logged in to view attached files.
  Lawrence Nelson
  System Architect - MaineHealth IT
- June 1, 2021 at 10:09 pm #118916
  Charlie Bursell
  Participant
  Time to contact Cloverleaf Support
  - June 2, 2021 at 10:41 am #118917
    Lawrence Nelson
    Participant
    Did that at the same time I posted. Thanks again.
    
    Lawrence Nelson
    System Architect - MaineHealth IT
- June 3, 2021 at 3:28 pm #118922
  Lawrence Nelson
  Participant
  Hi Charlie –
  
  Figured it out.
  
  hcismatcrypt rekey <sitename> <key(sitename)> <file(smatfilename)> <newKey(”)>
  
  (2 single quotes sets the key to blank or off)
  
  Thank you for your assistance.
  
  Lawrence Nelson
  System Architect - MaineHealth IT
Author

Replies

Viewing 3 reply threads

You must be logged in to reply to this topic.

Version: 6.2.4 SMATdb – Turning off encryption

Attachments: