Project

General

Profile

Mysql: Encryption of passwords in tig_users table

Pratap Patil
Added about 4 years ago

How to ensure that the tig_users table in tigasedb (MySQL) the passwords are hashed and not the direct strings? Is there some setting or flag that goes in the init.properties file to achieve this?


Replies (1)

Added by Wojciech Kapcia TigaseTeam about 4 years ago

One option, that would require using SASL-PLAIN would be enabling MD5 password hashing in the database:

call TigPutDBProperty('password-encoding', <hashing>);

where <hashing> can be one of the following: @'MD5-PASSWORD'@, @'MD5-USERID-PASSWORD'@, @'MD5-USERNAME-PASSWORD'@.

An alternative would be using SCRAM.

    (1-1/1)