[SR-Users] msilo

[Daniel-Constantin Mierla]

I expect the encryption/decryption can be done with some triggers in
mysql server.

In kamailio config you can use crypto module to encrypt a text and store
it in a variable:

  - https://www.kamailio.org/docs/modules/stable/modules/crypto.html

Then you can use sqlops to insert into the database. The issue comes
when dumping stored messages... probably you can just replace msilo with
sqlops+uac at the expense of a more complex configuration file.

On the other hand, probably adds some privacy to the local platform
operators, which have access only to the mysql, because the key will be
in kamailio.cfg. For full privacy, the endpoints should do the
encryption/decryption with a key they agreed before, without being known
by the server.

Cheers,
Daniel

On 24/11/2016 05:28, Slava Bendersky wrote:
> Sent message to mailing list
>
> ------------------------------------------------------------------------
> *From: *"volga629" <volga629 at skillsearch.ca>
> *To: *miconda at gmail.com
> *Sent: *Thursday, 24 November, 2016 00:25:30
> *Subject: *Re: [SR-Users] msilo
>
> Hello Everyone,
> I want to ask about another improvement for MSILO module. If possible
> encrypt BODY column in database. That will improve some privacy
> concerns for storing body in plain text.
>
> Slava. 
>

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, Nov 28-30, 2016 - http://www.asipto.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20161124/a44d2afb/attachment.html>